topic Re: Need help in SAS query in SAS Programming

Need help in SAS query

srdhoble — Wed, 10 May 2017 13:30:29 GMT

I need to change data in my numeric columns named NUM1-NUM90 (90 columns).

Whereever its '.' i need to replace it with '0'

Also tthere is a where clause to select model_type.

For example..the query should be: In a dataset for model_type='Business' set all '.' values to '0' for columns(WRA1-WRA90) .

Please help me have a query or suggestion,how to take care of this.Thanks!

Re: Need help in SAS query

PeterClemmensen — Wed, 10 May 2017 13:36:23 GMT

Apply this simple example of 3 columns to your 90 and add a where clause where needed

data have;
input WRA1-WRA3;
datalines;
1 2 .
. 4 6
4 . 9
;

data want(drop = i);
	set have;
	array wras[*] WRA1-WRA3;

	do i = 1 to dim(wras);
		if wras[i] = . then wras[i] = 0;
	end;
run;

Re: Need help in SAS query

Shmuel — Wed, 10 May 2017 13:38:25 GMT

data want;

set have;

array wr {90} wra1-wra90;

do i=1 to 90; if wr(i)=. then wr(i)=0; end;

run;

Re: Need help in SAS query

srdhoble — Wed, 10 May 2017 13:55:38 GMT

Where will i have Where clause for Model_type= Business ?

Re: Need help in SAS query

art297 — Wed, 10 May 2017 14:19:46 GMT

data want;
   set have;
   array wr {90} wra1-wra90;
   id model_type eq 'Business' then do;
      do i=1 to 90;
        if missing(wr(i)) then wr(i)=0;
     end;
  end;
run;

Art, CEO, AnalystFinder.com

Re: Need help in SAS query

novinosrin — Wed, 10 May 2017 14:21:52 GMT

You have got your answers from the others, you should attempt a little to make the discussion interesting. Anyway, here you go:

data want(drop = i);
set have;
array wras[*] WRA1-WRA90;
if upcase(model_type)='BUSINESS' then do;
do i = 1 to dim(wras);
if wras[i] = . then wras[i] = 0;
end;

end;
run;