08-04-2011 10:28 AM
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
select max(keyid) into :max_keyid
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.
Need further help from the community? Please ask a new question.