topic Getting/creating new summary variables longitudinal data in SAS Programming

Getting/creating new summary variables longitudinal data

Jest — Thu, 06 Apr 2017 21:39:59 GMT

Hello,

I have a longitudinal dataset with various features. I want to create a newdataset that is not longitudinal and has new variables that represent the mean, median, and variance measures for each feature by ID!

Data Have:

ID feature1 feature2 feature3

1 7.72 5.43 4.35

1 5.54 2.25 8.22

1 4.43 6.75 2.22

1 3.22 3.21 7.31

2 6.72 2.86 6.11

2 5.89 4.25 5.25

2 3.43 7.30 8.21

2 1.22 3.55 6.55

Data Want:

ID Meanfeature1 Medianfeature1 variancefeature1 Meanfeature2 Medianfeature2 variancefeature2.........

Any advice on the code?

Thanks!

Re: Getting/creating new summary variables longitudinal data

Reeza — Thu, 06 Apr 2017 21:58:13 GMT

PROC MEANS

Re: Getting/creating new summary variables longitudinal data

Jest — Thu, 06 Apr 2017 22:02:53 GMT

thanks, yes I know proc means gives you the summary statistics and you can get the mean, median and variance.

but I want to generate a whole new dataset showcasing the mean, median, and variance for each feature by ID...

Re: Getting/creating new summary variables longitudinal data

Reeza — Thu, 06 Apr 2017 22:11:21 GMT

PROC MEANS

What part of PROC MEANS doesn't do what you want?

Re: Getting/creating new summary variables longitudinal data

Reeza — Thu, 06 Apr 2017 22:40:48 GMT

I wasn't being snarky by the way (though I often am :)).

PROC MEANS is really what you seem to be asking for based on the output. You can merge this back in with your main dataset if you want. You could also use SQL if you wanted this in a single dataset with your original data but MEDIAN wasn't supported in SQL until SAS 9.4 and not everyone is on that system. Plus it generates warnings in the logs that users don't seem to like.

Re: Getting/creating new summary variables longitudinal data

Jest — Fri, 07 Apr 2017 02:41:59 GMT

Thanks! no worries. you just answered my question. I was wondering if there was another way of getting the median etc and variance directly....

Re: Getting/creating new summary variables longitudinal data

ballardw — Fri, 07 Apr 2017 15:50:50 GMT

@Jest wrote:

Thanks! no worries. you just answered my question. I was wondering if there was another way of getting the median etc and variance directly....

What would "directly" mean in this context? Just curious but I see a number of cases where people try to do in a data step what the SAS procedures are intended to accomplish. Often there is much anguish (and often ugly code) trying to replace a 3 or 4 line call to proc means/ summary /univariate or other proc.

Re: Getting/creating new summary variables longitudinal data

Peter_C — Fri, 07 Apr 2017 21:46:06 GMT

Would the Univariate Procedure offer another way?