BookmarkSubscribeRSS Feed
laplanca
Calcite | Level 5

I made a data base combining the answers to 4 questionnaires for each ID. So I have 4 lines per subjid,
one for each questionnaire (different visit times). From the answers I created a new variable giving the
number of Cures for each person. Only to carry out my analyses I would need the value to appear on the 4
lines for each id. I don't know how to do this...

 

Here is my table for a better idea


Capture d’écran 2022-01-17 114819.png
Here is an idea of the result i need


Capture d’écran 2022-01-17 1819.png

2 REPLIES 2
PaigeMiller
Diamond | Level 26

UNTESTED CODE

proc sql;
    create table want as select *,max(nbcure) as max_nbcure from have
    group by subjid;
quit;

From now on, do not provide data as screen captures, we can't work with data that is in a screen capture. The way to provide data in the future, without exception, is as SAS data step code (instructions) and not in any other format.

--
Paige Miller
Ksharp
Super User

UNTESTED CODE

 

data want;
 merge have(drop=nbcure) 
       have(keep=subjid nbcure where=(nbcure is not missing));
 by subjid;
run;

hackathon24-white-horiz.png

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 1629 views
  • 0 likes
  • 3 in conversation