topic Re: Apply value of one row to multiple rows in SAS Programming

Apply value of one row to multiple rows

laplanca — Mon, 17 Jan 2022 16:27:44 GMT

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

Here is an idea of the result i need

Re: Apply value of one row to multiple rows

PaigeMiller — Mon, 17 Jan 2022 11:24:16 GMT

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.

Re: Apply value of one row to multiple rows

Ksharp — Mon, 17 Jan 2022 12:22:10 GMT

UNTESTED CODE

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