topic Re: proc univariate, output columns to existing database in SAS Procedures

proc univariate, output columns to existing database

peer — Thu, 14 Aug 2014 16:12:36 GMT

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.

Re: proc univariate, output columns to existing database

stat_sas — Thu, 14 Aug 2014 16:33:47 GMT

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;