Keeping value from procedure as a macro/parameter?

[DangIT]

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.

[DangIT · Accepted solution]

SOLVED:

using Proc SQL

PROC SQL NOPRINT ;

SELECT MEAN(Sales)

INTO :meanSales

FROM Table1

; QUIT ;

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