BookmarkSubscribeRSS Feed
deleted_user
Not applicable
Is there a way to take the results from proc means for a certain varible of interest and insert them into the data set?

If not how would i go about calculating it with out proc means
1 REPLY 1
darrylovia
Quartz | Level 8
Assuming you had no class variables. You can this with proc summary or proc sql. Basically you output the results of a procedure as a SAS data set and merge back to your original dataset. The tricky part is merging the results back, see my simple examples below.

data mydataset;
input myvar;
datalines;
1
2
3
4
5
6
7
8
99
1000
;
run;

proc summary data=mydataset;
var myvar;
output out=summary_data (drop=_freq_ _type_)
mean(myvar)=mean_myvar;
run;

data newdata;
x=1;
set mydataset;
set summary_data point=x;
run;

* or use proc sql;
proc sql;
create table newdata as
select *, mean(myvar) as mean_myvar
from mydataset
;
quit;



Good Luck
-Darryl

hackathon24-white-horiz.png

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 1068 views
  • 0 likes
  • 2 in conversation