Look up values

[dsbihill]

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)

[Linlin · Accepted solution]

example:

proc sql noprint;

  select max(weight) , min(weight) into

        :max_wt,:min_wt

   from sashelp.class;

quit;

%put &max_wt;

%put &min_wt;

[DataMatt]

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.