topic Merge multi columns in to single columns in SAS Programming

Merge multi columns in to single columns

sahoositaram555 — Thu, 22 Aug 2019 11:39:31 GMT

Table	1	2	3	4	5	6
1	.
1	No
2		.
2		Yes
2		No
3			.
3			No
4				Yes
5					No
5					Yes
6						.
6						Yes

My dataset looks like the sample table created above. I want to create a dataset like made below:, Any form of help will be appreciated.

F_table

Yes

Re: Merge multi columns in to single columns

novinosrin — Thu, 22 Aug 2019 11:52:52 GMT

try

want=coalescec(of col1-col6);

Re: Merge multi columns in to single columns

PeterClemmensen — Thu, 22 Aug 2019 11:53:29 GMT

Use Coalescec Function like this

data have;
input Table (var1-var6)(:$8.);
infile datalines dlm=',' dsd missover;
datalines;
1,.,,,,,
1,No,,,,,
2,,.,,,,
2,,Yes,,,,
2,,No,,,,
3,,,.,,,
3,,,No,,,
4,,,,Yes,
5,,,,,No,
5,,,,,Yes,
6,,,,,,.
6,,,,,,Yes
;

data want(keep=F_table);
    set have;
    F_table=coalescec(of var:);
run;