topic Re: How to add new rows in SAS Programming

How to add new rows

sasuser123123 — Thu, 07 Nov 2019 06:41:21 GMT

Data new;
Input id Stat $ ;
datalines;
01 yes
02 yes
03 yes
04 yes
;

Now If id=yes ,I want to add three values(high, medium,low) per subject .
Output should like...

Id result
01 High
01 medium
01 low
02 high
02 medium
02 low

Could you please help me how to do this one

Thank you!

Re: How to add new rows

sasuser123123 — Thu, 07 Nov 2019 06:42:33 GMT

If stat=yes ..not I'd
Sorry for the mistake

Re: How to add new rows

PeterClemmensen — Thu, 07 Nov 2019 06:52:17 GMT

Here is a way

Data new;
Input id Stat $ ;
datalines;
01 yes
02 yes
03 yes
04 yes
;

data want;
    set new;
    length result $ 10;
    if stat='yes' then do result='High', 'Medium', 'Low';
        output;
    end;
    drop Stat;
run;

Result:

Id  Result
1   High
1   Medium
1   Low
2   High
2   Medium
2   Low
3   High
3   Medium
3   Low
4   High
4   Medium
4   Low

Re: How to add new rows

sustagens — Thu, 07 Nov 2019 06:56:56 GMT

This is a more novice approach but does it:

data result_table;
input stat $ result $;
datalines;
yes High
yes Medium
yes Low
;

proc sql;
create table want as
select t1.id, t2.result 
from new t1 left join result_table t2 on t1.Stat=t2.Stat
order by t1.id, t2.result
;
quit;

Re: How to add new rows

sasuser123123 — Thu, 07 Nov 2019 07:12:23 GMT

@PeterClemmensen thank you so much for your help.
It's perfectly fine.
But how to do if we want to add 3 values to one subject and 4 values to another subject.

Re: How to add new rows

PeterClemmensen — Thu, 07 Nov 2019 07:14:09 GMT

What logic determines when to add 3 or 4 rows?

Re: How to add new rows

sasuser123123 — Thu, 07 Nov 2019 07:19:10 GMT

Oh okay .. exactly. I got your point , it depends on logic or the condition.

Thank you so much !!!

Re: How to add new rows

PeterClemmensen — Thu, 07 Nov 2019 07:21:58 GMT

Anytime 🙂