topic Add one observation (sample mean) to existing SAS dataset in SAS Procedures

Add one observation (sample mean) to existing SAS dataset

SAS_user_n — Thu, 19 Aug 2010 15:41:53 GMT

I want to add one more observation to the exisiting SAS dataset and could not find a good resolution ....

I have two variables called X,Y with 1000 observations each.

X represents categories (ranging from 0 to 1000 but numbers themselves have no meaning), and Y represents each category's score.

I want to add a 1001st row for X that denotes a category that does not appear between 0 and 1000, and assign it the value of sample average of 1000 Y values.

So the 1001st row will have: X = 9999, Y=sample average of Y's
Thank you!

Re: Add one observation (sample mean) to existing SAS dataset

ArtC — Thu, 19 Aug 2010 16:53:59 GMT

There are multiple ways to do this. With your small data sets, a variation of the following should work for you.
[pre]proc summary data=sashelp.class;
var height;
output out=sumry mean=height;
run;

data extra(keep=name height);
set sashelp.class(keep=height name) end=eof;
output extra;
if eof then do;
name='Xxxxx';
set sumry;
output extra;
end;
run;[/pre]

Re: Add one observation (sample mean) to existing SAS dataset

SAS_user_n — Thu, 19 Aug 2010 17:38:28 GMT

Thank you!