topic Re: How to add next content based on defined variable? in SAS Data Management

How to add next content based on defined variable?

ybz12003 — Tue, 12 Apr 2016 19:43:22 GMT

Hello, all:

My oringinal data set has "MSM" in variable "Risk" corespored to "Man" in variable "Race". Now, I would like to add one more "All" in variable "Race" when there are either "MSM" or "MSM-B" in variable "Risk". The final format example is shown below. How to approach this? Please help. Thanks.

Oringinal format:

Risk Race

MSM Man

MSM-B Man

Final format:

Risk Race

MSM All

MSM Man

MSM-B All

MSM-B Man

Re: How to add next content based on defined variable?

LinusH — Tue, 12 Apr 2016 20:02:53 GMT

Just a conditional assignment and an explicit output in a data step-

Re: How to add next content based on defined variable?

ybz12003 — Wed, 13 Apr 2016 13:35:52 GMT

I wrote the code below

Data A;

set B;

if RISK in ('MSM', 'MSM-B') then RACE='Man';

run;

I got the result for replacing the "All" with "Man". However, I couldn't get extra line for "All". How to get "All" and "Man" together to corresponded to "MSM" and "MSM-B"?

Oringinal format:

Risk Race

MSM All

MSM-B All

My SAS format:

Risk Race

MSM Man

MSM-B Man

The final format I would like to modify is:

Risk Race

MSM All

MSM Man

MSM-B All

MSM-B Man