BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
LGrau
Calcite | Level 5

Hi everyone,

 

I have a data set in long format (varied number of observations per subject) with 5 outcome variables. However, not all outcome variables are measures in each observations. I want to get means for each outcome variable the first time it is observed. 

 

Therefore, using first.id does not work (the first observation per subject doesn't necessarily have the first measure of that outcome).

 

Any ideas? 

 

doing

 

IF first.id AND first.outcome then output 

 

does not work either. 

1 ACCEPTED SOLUTION
4 REPLIES 4
LGrau
Calcite | Level 5

Hi everyone,

 

I have a data set in long format (varied number of observations per subject) with 5 outcome variables. However, not all outcome variables are measures in each observations. I want to get means for each outcome variable the first time it is observed across subjects. 

 

Therefore, using first.id does not work (the first observation per subject doesn't necessarily have the first measure of that outcome).

 

Any ideas? 

 

doing

 

IF first.id AND first.outcome then output 

 

does not work either. 

Reeza
Super User

Relatively trivial to accomplish this, here are the steps.

 

1. Create flags for each measure, set to 0

2. If this is the first non missing and flag is not set, store it to a new variable and set flag

3. At first iteration of each group set flags and values back to missing. 

 

If you need further help, provide data in a data step so that we can work with data. It doesn't need to exactly your data but needs to reflect what you have. 

 


@LGrau wrote:

Hi everyone,

 

I have a data set in long format (varied number of observations per subject) with 5 outcome variables. However, not all outcome variables are measures in each observations. I want to get means for each outcome variable the first time it is observed across subjects. 

 

Therefore, using first.id does not work (the first observation per subject doesn't necessarily have the first measure of that outcome).

 

Any ideas? 

 

doing

 

IF first.id AND first.outcome then output 

 

does not work either. 


 

LGrau
Calcite | Level 5

I'm sorry, I'm not sure what you mean by flags. Here's a sample data set. As you can see, some outcomes are missing until the third observation on the same person. I would need to find the means each outcome the first time it is recorded in each individual.

 

DATA WORK.SOURCE;
INFILE DATALINES DELIMITER= ',' DSD MISSOVER;
INPUT
SubjID
TxGrp :$5.
SexCd :$1.
EthCd
Outcome1
Outcome2
Outcome3;
DATALINES;
101,Arm A,F,1,45,,
101,Arm A,F,1,,3,2
101,Arm A,F,1,43,4,
102,Arm C,M,1,,5,,
102,Arm C,M,1,,4,3
102,Arm B,M,2,32,2,5
;

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 4 replies
  • 1548 views
  • 0 likes
  • 2 in conversation