05-09-2014 03:57 PM
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.
input name stockrate;
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
Need further help from the community? Please ask a new question.