DATA Step, Macro, Functions and more

Keeping value from procedure as a macro/parameter?

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 81
Accepted Solution

Keeping value from procedure as a macro/parameter?

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.


Accepted Solutions
Solution
‎08-11-2014 11:13 AM
Frequent Contributor
Posts: 81

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

SOLVED:

using Proc SQL

PROC SQL NOPRINT ;

SELECT MEAN(Sales)

INTO :meanSales

FROM Table1

; QUIT ;

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

View solution in original post


All Replies
Solution
‎08-11-2014 11:13 AM
Frequent Contributor
Posts: 81

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

SOLVED:

using Proc SQL

PROC SQL NOPRINT ;

SELECT MEAN(Sales)

INTO :meanSales

FROM Table1

; QUIT ;

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

🔒 This topic is solved and locked.

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

Discussion stats
  • 1 reply
  • 155 views
  • 0 likes
  • 1 in conversation