DATA Step, Macro, Functions and more

How to make a new variable using ouput value

Reply
Contributor
Posts: 29

How to make a new variable using ouput value

Hi,

I used proc means to calculate mean values of a variable. And now I want to use the mean values to calculate other variables.

How can I make the mean values a new variable in SAS statement?

 

 

Thanks!

Super User
Posts: 12,994

Re: How to make a new variable using ouput value

It will help to provide an example of what you are doing for some example start data, the proc means code and how you want to actually use the resulting values from proc means.

 

Proc means supports an output statement to create a data set with the requested statistics.

Or learn about ODS output to capture data from table output.

 

 

Contributor
Posts: 29

Re: How to make a new variable using ouput value

Thanks

 

So I used

proc means data=have;

var new;

run;

 

Then in the output, I have

Variable    n         mean     std error

new       1176       3.6       0.97

 

Then I want to use the mean value of 3.6 to calculate another variable called MP;

MP=mean* proportion

 

this is possible to do?

 

 

 

 

Super User
Posts: 12,994

Re: How to make a new variable using ouput value

Where is "proportion" from? If it is in your data set HAVE then better is to show us what the data set looks like.

Best is to provide data step code to create your data set and an example of the result(s).

Super User
Posts: 6,524

Re: How to make a new variable using ouput value

I would guess this is what you are referring to:

 

proc mean data=have1 noprint;

var amount;

output out=stats mean=mean_amount;

run;

 

data want;

set have2;

if _n_=1 then set stats (keep=mean_amount);

*** do some calculations here;

run;

 

The data set STATS has one observation, which includes the variable MEAN_AMOUNT.  Its value will become part of every observation in the data set WANT.

Ask a Question
Discussion stats
  • 4 replies
  • 115 views
  • 0 likes
  • 3 in conversation