topic Assign format to a MACRO value in SAS Programming

Assign format to a MACRO value

deleted_user — Wed, 25 Mar 2009 14:39:57 GMT

Would that be possible to assign a format to the value by using Symput (or similarly in PROC SQL).

Here is an example:
PROC SQL noprint;
select min(EN) into :minEN;
from test;
QUIT;

The minimum value of EN is 10.12345. The above program works perfectly to get the exact value but can I assign a format like COMMA8.2 to change it to 10.12?

Re: Assign format to a MACRO value

sbb — Wed, 25 Mar 2009 15:43:29 GMT

With the DATA step approach and SYMPUT, you would use the PUT function in the SYMPUT call to generate a "formatted" value. And with the PROC SQL approach, the FORMAT= keyword is added to the SELECT to generate a formatted value.

Scott Barry
SBBWorks, Inc.

Re: Assign format to a MACRO value

Flip — Wed, 25 Mar 2009 17:44:01 GMT

PROC SQL noprint;
select put(min(EN), comma8.2) into :minEN;
from test;
QUIT;