Try this. I'm not sure it works but it should.
WHERE (MONAT EQ EDIT(&MONAT)) OR (MONAT EQ EDIT(&MONAT1))
The simple EDIT() (with no mask) turns numeric to character and vice-versa. Not sure if it works with ¶meters.
Try this in a fex when you sart a session or at any time in a focexec when you need it :
SQL SQLODBC SET USER ODBC1
SQL SQLODBC SET USER ODBC2
SQL SQLODBC SET USER ODBC3
-RUN;
where THE ODBC1/2/3 are DSNAMES implemented via Control Panel / Data Source(odbc) in Windows
1/ Save them in HTMLTABLE format
1ST REPORT "ON TABLE HOLD AS 'XXX' FORMAT HTMLTABLE"
2nd REPORT "ON TABLE HOLD AS 'YYY' FORMAT HTMLTABLE"
2/ AT THE END PUT THESE LINES WHERE abcdef IS AN HTML FILE NAMED abcdef.htm
END
-RUN;
-HTMLFORM abcdef
abcdef.htm is a usual html...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.