topic Re: Array in SAS Programming

Array

syam_india_kochi — Mon, 22 Feb 2010 08:01:39 GMT

Hi,

In one of my data set I have 37 numeric columns out which, one numeric column is in date format.

My requirement was to replace all the null values(.) from the data set with zeros and I had used the following array

data liab_asset1;
set liab_asset;
array v(*) _numeric_;
do i = 1 to dim(v);
if v(i) = . then v(i) = 0;
end;
drop i;
run;

But this statement replaces all the null fields from the date field also. If i dont want to do any action on the date field how should I write the query..?

Please help..!!

Re: Array

Patrick — Mon, 22 Feb 2010 09:29:43 GMT

From a performance point of view there will be better solutions but below approach means only small changes to your existing code.
Make sure to write the name of the var to exclude in capital letters.

data liab_asset1;
set liab_asset;
array v(*) _numeric_;
do i = 1 to dim(v);
if vname(v(i)) ne '' and v(i) = .
then v(i) = 0;
end;
drop i;
run;

SAS knows only 2 datatypes: Numeric and character. A SAS date is stored as a number in a numeric variable - and this number then "interpreted" by applying an appropriate date format.

HTH
Patrick

Re: Array

syam_india_kochi — Tue, 23 Feb 2010 05:19:37 GMT

Thank you very much Patrick...

Re: Array

syam_india_kochi — Tue, 23 Feb 2010 05:26:11 GMT

Thank you very much Patrick...

Re: Array

sbb — Tue, 23 Feb 2010 14:40:50 GMT

As a more direct alternative, consider using the VFORMAT function instead, presuming your SAS DATE variable has a SAS date-type output FORMAT associated.

Scott Barry
SBBWorks, Inc.