topic Re: proc transpose with some records missing in SAS Programming

proc transpose with some records missing

ywon111 — Fri, 28 Jan 2022 13:04:30 GMT

Hi, how do I transpose a dataset when there is blank data?

ID	Type
1	Apple
2	Orange
3
4	Lemon

This is what I want:

ID	1	2	3	4
Type	Apple	Orange		Lemon

Re: proc transpose with some records missing

PeterClemmensen — Fri, 28 Jan 2022 13:07:14 GMT

data have;
input ID Type $;
infile datalines missover;
datalines;
1 Apple  
2 Orange 
3        
4 Lemon  
;

proc transpose data=have out=want;
    id ID;
    var Type;
run;

Re: proc transpose with some records missing

ywon111 — Sat, 29 Jan 2022 07:50:07 GMT

Your code works fine. Trying to adapt to my dataset, are there reasons why it will show no records? Log is empty too.
Thanks in advance.

Re: proc transpose with some records missing

ywon111 — Sat, 29 Jan 2022 07:53:36 GMT

Figured it is due to duplicated IDs. Dataset is more like this...

data have;
input ID Type $;
infile datalines missover;
datalines;
1 Apple
2 Orange
3
3 Apple
3 Apple
4 Apple
4 Lemon
;