This may be simple or may not be simple .
%let ID=1000 ;
PROC SQL;
SELECT * FROM TABLE WHERE FORMULARY_ID = INPUT(&ID. ,8.);
QUIT;
the conversion is not working.
in the TABLE the FORMULARY_ID is a Number , how can i convert Macro variable to number ?
any help would be highly appreciated.
Thanks,
M
The INPUT function is expecting a string. So, try this:
%let ID=1000 ; PROC SQL; SELECT * FROM TABLE WHERE FORMULARY_ID = INPUT("&ID". ,8.); QUIT;
Of course, you don't need to do that. This should work as well.
%let ID=1000 ; PROC SQL; SELECT * FROM TABLE WHERE FORMULARY_ID = &ID.; QUIT;
HTH
Thanks HTH,
INPUT("&ID".,8.) has worked.
When a macro variable gets passed to a SAS program, it is up to the SAS program to determine whether the value is character or numeric. You could simply use:
where formulary_id=&id.;
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.