Keeping value from procedure as a macro/parameter?

DangIT — Mon, 11 Aug 2014 14:45:54 GMT

Hi,

I would like to save a value from the MEANS procedure to use in a further datastep.

For example

Proc means data=table1 mean ; var Sales ; run ;

If the output was $200, I would like to save the value to use further along in my code, for example:

Proc print data=table1 ; where Sales LE &Sales_Mean ; run ;

Where Sales_Mean was generated from the proc means procedure.

Thanks for your help.

Re: Keeping value from procedure as a macro/parameter?

DangIT — Mon, 11 Aug 2014 15:13:32 GMT

SOLVED:

using Proc SQL

PROC SQL NOPRINT ;

SELECT MEAN(Sales)

INTO :meanSales

FROM Table1

; QUIT ;

Proc print data=table1 ; where Sales LE &meanSales; run ;