Getting possible combinations

angeliquec — Thu, 13 Oct 2016 10:46:03 GMT

Hi,

I would like to produce this want dataset from have. It's like affecting only name = COUPLE, but name = SINGLE should not be edited.

data have;
input id name $;
cards;
1 SINGLE
2 COUPLE
3 COUPLE
;
run;

data want;
input id name $;
cards;
1 SINGLE
2 MAN
2 WOMAN
3 MAN
3 WOMAN
;
run;

Thank you

Re: Getting possible combinations

Reeza — Thu, 13 Oct 2016 10:50:02 GMT

Use an explicit OUTPUT statement to override default.

If name='COUPLE' then do;

name='MAN'; output;

Name='WOMAN'; output;

end;

else output;