topic Quick way to choose max value in SAS Programming

Quick way to choose max value

Ivy — Wed, 23 Mar 2016 21:09:19 GMT

Hello,

I have a data set like this :

id d1 d2 d3 d4 .......................d100

Each id have mutiple rows, with mutiple values of d1, d2......

I would like to choose the max(d1), max(d2)...., for each ID .

Is there any quick way to do it without list all of the vairables from d1 to d100 ?

Thank you very much,

Ivy

Re: Quick way to choose max value

Reeza — Wed, 23 Mar 2016 21:33:00 GMT

Depends on what you want your output to look like. If your variables are sequential you can list them like that.

proc means data=havenoprint;
by id; *need to sort by ID first;
var d1-d100;
output out=want max= /autoname;
run;

Re: Quick way to choose max value

LinusH — Wed, 23 Mar 2016 22:26:39 GMT

Is it the flu or something, every second question has data with wide data sets.

Transpose it to long, then you can easily calculate/aggregate the data any way you want, and just need to refer to your analysis variable only once in your code.

Re: Quick way to choose max value

PGStats — Thu, 24 Mar 2016 02:51:55 GMT

Spring migration, from Excel to SAS