I am struggling to find a way to look up 2 values in a table. In access i would have used a dlookup function.
I want to set macro 2 macro variables to give me the min and max date of a field. Is there something comparible to dlookup in SAS?
%let date_min = ? (min date of Record set date field)
%let date_max = ? (Max date of Record set date field)
example:
proc sql noprint;
select max(weight) , min(weight) into
:max_wt,:min_wt
from sashelp.class;
quit;
%put &max_wt;
%put &min_wt;
example:
proc sql noprint;
select max(weight) , min(weight) into
:max_wt,:min_wt
from sashelp.class;
quit;
%put &max_wt;
%put &min_wt;
That bit of code is very helpful. I could only think of methods using multiple procedures, like PROC MEANS and the PROC SQL. Very useful. Thanks.
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 how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.