topic Re: help in SAS Health and Life Sciences

help

deleted_user — Fri, 02 Feb 2007 16:38:28 GMT

I have a table that has the same id number in mulitple observations. There are 3 variables of interest that I want summed (separately) by unique id number. I'm having trouble writing this code. Where may I find help on this topic? Thanks in advance.

Re: help

deleted_user — Sat, 03 Feb 2007 03:44:54 GMT

you can sent part of them to me and I will sent the code to you

Re: help

Olivier — Mon, 05 Feb 2007 08:40:21 GMT

I think your program should look something like :

PROC MEANS DATA = yourDataSet NOPRINT NWAY ;
VAR yourInterestVariables ;
CLASS yourIDvariable ;
OUTPUT OUT = yourResultingDataSet
SUM = ;
RUN ;

You will create a new dataset, in which the sums of each of your interest variables will be included as a new variable (named after the interest variables), plus the ID variable.
Just copy and paste the previous program, leaving as it is the uppercase code, and replacing the rest by the correct names.

Regards.
Olivier

Re: help

deleted_user — Mon, 05 Feb 2007 09:25:56 GMT

you can try olivier's code.I think it's a smart one.