topic Re: Macro to change variable values in SAS Procedures

Macro to change variable values

deleted_user — Tue, 26 Jan 2010 20:13:27 GMT

Hi Folks,
I have a dataset with 30 different variables with each cell being either a ONE or a . ( missing numeric value, Now I would like to change the . ( numeric blank) to ZERO. I don't want to use proc format. I just need a physical ZERO in place of that . (BLANK). I can use a if..then 30 times to do that .. but can someone suggest a better way.

Thanks

Matt

Re: Macro to change variable values

sbb — Tue, 26 Jan 2010 20:33:09 GMT

Use a DATA step with an ARRAY, as coded below:

ARRAY ANUMVARS (*) _NUMERIC_;
DO I=1 TO DIM(ANUMVARS);
IF ANUMVARS(I) = . THEN ANUMVARS(I) = 0;
END;

Scott Barry
SBBWorks, Inc.

Re: Macro to change variable values

data_null__ — Tue, 26 Jan 2010 23:44:38 GMT

With SAS/Stat procedure STDIZE you can easily replace all those missing values with any value you like including zero.

Re: Macro to change variable values

Peter_C — Thu, 28 Jan 2010 11:08:56 GMT

If you only want to see missings as physical zero in reporting, then change no data! All you need - only before the reporting procedure, just set [pre] option missing= '0' ;[/pre]