topic Re: Look up values in SAS Programming

Look up values

dsbihill — Fri, 16 May 2014 18:15:32 GMT

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 — Fri, 16 May 2014 18:28:20 GMT

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 — Sat, 17 May 2014 03:41:52 GMT

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.