I have a table that has a column called keyid. I need to get the min and max of this field into macro variables so I can use them in a where clause against different tables that also have this field.
I'm currently doing it like this
proc sql noprint ;
select min(keyid) into :min_keyid
from tblRaw
;
select max(keyid) into :max_keyid
from tblRaw;
quit ;
is there a better way to do this? I can't seem to get both variables assigned with just 1 proc sql.
Any help would be greatly appreciated.
Jerry
Jerry,
I think you are looking for:
proc sql noprint ;
select min(keyid),max(keyid) into :min_keyid,:max_keyid
from tblRaw
;
quit ;
Jerry,
I think you are looking for:
proc sql noprint ;
select min(keyid),max(keyid) into :min_keyid,:max_keyid
from tblRaw
;
quit ;
art,
Thank you that was it.
Jerry
Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!
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.
Ready to level-up your skills? Choose your own adventure.