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.
SOLVED:
using Proc SQL
PROC SQL NOPRINT ;
SELECT MEAN(Sales)
INTO :meanSales
FROM Table1
; QUIT ;
Proc print data=table1 ; where Sales LE &meanSales; run ;
SOLVED:
using Proc SQL
PROC SQL NOPRINT ;
SELECT MEAN(Sales)
INTO :meanSales
FROM Table1
; QUIT ;
Proc print data=table1 ; where Sales LE &meanSales; run ;
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.