proc univariate data=existing;
var a b c;
output out=existing sum=Asum Bsum Csum N=Act Bct Cct;
run;
I already have an existing dataset with 10 variables. I want to add the additional 6 variables from the proc univariate procedure but when I use the output statement, it overwrites all the existing variables instead of adding additional columns.
How can I make so it so that the outputs I want (sum and N) are added to an existing dataset?
Thank you very much.
Hi,
Your syntax will replace your existing dataset with calculated summary stats. To add stats in your original data set save stats to another dataset (want) and merge back to original one to get desired dataset (final).
proc univariate data=existing;
var a b c;
output out=want sum=Asum Bsum Csum N=Act Bct Cct;
run;
data final;
if _n_=1 then set want;
set have;
run;
Hi,
Your syntax will replace your existing dataset with calculated summary stats. To add stats in your original data set save stats to another dataset (want) and merge back to original one to get desired dataset (final).
proc univariate data=existing;
var a b c;
output out=want sum=Asum Bsum Csum N=Act Bct Cct;
run;
data final;
if _n_=1 then set want;
set have;
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 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.