topic Combine two column with condition in SAS Programming

Combine two column with condition

Tejaswini3 — Fri, 10 Jun 2022 17:30:36 GMT

I want to combine two columns.

The dataset is

The final column should be

BODY AS A WHOLE - GENERAL DISORDERS

FATIGUE

FEVER

CENTRAL & PERIPHERAL NERVOUS SYSTEM DISORDERS

HEADACHE

Re: Combine two column with condition

Reeza — Fri, 10 Jun 2022 18:01:31 GMT

For a report? Or in a data set? This seem smore like a report structure than data set structure.

*assumes data is sorted correctly. If order is important as in the file structure, add the word NOTSORTED to the end of the BY statement;
*replace data set and variable names as needed;
data want;
set have;
by Col2 Col1;
if first.Col2 then do;
temp=col1;
col1=col2; 
output;
col1=temp;
output;
end;
else output;
keep col1;
run;