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
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.