DATA Step, Macro, Functions and more

Look up values

Accepted Solution Solved
Reply
Contributor
Posts: 53
Accepted Solution

Look up values

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)


Accepted Solutions
Solution
‎05-16-2014 02:28 PM
Super Contributor
Posts: 1,636

Re: Look up values

example:

proc sql noprint;

  select max(weight) , min(weight) into

        :max_wt,:min_wt

   from sashelp.class;

quit;

%put &max_wt;

%put &min_wt;

View solution in original post


All Replies
Solution
‎05-16-2014 02:28 PM
Super Contributor
Posts: 1,636

Re: Look up values

example:

proc sql noprint;

  select max(weight) , min(weight) into

        :max_wt,:min_wt

   from sashelp.class;

quit;

%put &max_wt;

%put &min_wt;

New Contributor
Posts: 3

Re: Look up values

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.

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 219 views
  • 1 like
  • 3 in conversation