Multiple response problem in SAS

#1
Hi
I am a beginner in SAS and I request for your help.
I think this is called a multiple response data and how to I go about it.

given data:

Name psy1 psy2
A can white
B can,top Missing
C can Missing
D Missing Missing
E cup Missing
F cup,top sugar
G top sugar
H Missing Missing
i salt Missing
J Missing Missing


required data output so that it is easy for grouping.

Name Psy
A can
A white
B can
B top
C can
C Missing
D Missing
D Missing
E cup
F cup
F top
F sugar
G top
G sugar
H Missing
H Missing
I salt
J Missing
J Missing
I request for your help please.. !
 
Last edited: