topic Convert macro variable to numeric in SAS Programming

Convert macro variable to numeric

mgorripati — Tue, 12 Jul 2016 16:15:00 GMT

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,

Re: Convert macro variable to numeric

sh0e — Tue, 12 Jul 2016 16:15:38 GMT

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

Re: Convert macro variable to numeric

Astounding — Tue, 12 Jul 2016 16:36:04 GMT

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.;

Re: Convert macro variable to numeric

mgorripati — Tue, 12 Jul 2016 16:39:43 GMT

Thanks HTH,

INPUT("&ID".,8.) has worked.