topic Re: dynamic call in SAS Procedures

dynamic call

sam369 — Fri, 09 May 2014 19:57:41 GMT

Hi All,

I am having following dataset with stock values.daily the values will change , i need to find dynamically , values less than .5 and create a macro variable.

data have;

input name stockrate;

datalines;

xyz 0.015

abc 0.9

fxy .86

tdf .02

boa .76

wfd .005

;

run;

in the above case there are 3 companies less than .5(xyz,tdf,wfd). latest data may change to other companies. right no i am enter manually like checking stockrate and enter the company names.

like %let stat=xyz tdf wfd

i am looking for dynamic approach to check the values , and pick the company names and fill the %let stat = (what ever the companies <.5)

Any insight on this

Thanks

sam

Re: dynamic call

DBailey — Fri, 09 May 2014 19:58:36 GMT

proc sql;

select name

into :Stat separated by ' '

from have

where stockrate < .5;

quit;

Re: dynamic call

sam369 — Fri, 09 May 2014 20:22:43 GMT

Thank you DBailey,

This is what i am looking for

Thank you once again

Sam

Re: dynamic call

naveen20jan — Wed, 18 Jun 2014 15:16:48 GMT

Hi ,

We can also do the same through the sasdataset .

%macro low ;

data low_&sysdate ;

set have ;

where stockrate < 0.5 ;

run;

%mend ;

%low ;