proc transpose with some records missing

[ywon111]

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

[PeterClemmensen · Accepted solution]

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;

[ywon111]

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.

[ywon111]

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
;