Hi, I have two numbers one is fixed and one comes from a table that changes every time. I want to select number of obeservations based on the changing number. Instead of selecting the number everytime i am trying to find a permanent way to do this. Here is what i tried to give some idea...
This is the changing number....
Proc sql;
select Count (distinct MemberID) into: mbrs
From table1;
;quit;
%put &mbrs;
My fix number is 6600.
I am trying to get something like this
Option OBS=6600-&mbrs;
Any help would be greatly appreciated.
Thanks
A couple of easy ways. You could keep everything as is, except for the final statement:
options obs=%eval(6600 - &mbrs);
Alternatively, you could construct the number that you want originally, such as:
proc sql;
select 6600 - count(distinct MemberID) into : obs_needed from table1;
quit;
And then:
options obs=&obs_needed;
Good luck.
It worked. Thank you very much!
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.