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
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.