topic Re: How to transpose multiple response data from long to wide and dummy code in SAS Programming

How to transpose multiple response data from long to wide and dummy code

lapetitemaman — Tue, 07 Jun 2022 18:31:12 GMT

Greetings everyone,

I have an exam dataset for multiple response items but need to separate each option and transpose the dataset from long to wide then dummy code each option. Not all examinees answered all questions. Item1 and Item2 have 5 options (2 correct answers) while Item3 has 6 options (3 correct answers). How do I achieve this? Any help is much appreciated.

data exam;
input ID $ ItemID $ Response $;
cards;
1 Item1 BC
1 Item3 ACD
2 Item1 CD
2 Item2 AC
2 Item3 BCD
3 Item1 AB
3 Item2 BD
4 Item2 CE
4 Item3 ABF
5 Item1 AE
5 Item2 BD
5 Item3 BEF
;

data need;
input ID $ Item1A Item1B Item1C Item1D Item1E Item2A Item2B Item2C Item2D Item2E Item3A Item3B Item3C Item3D Item3E Item3F;
cards;
1 0 1 1 0 0 . . . . . 1 0 1 1 0 0
2 0 0 1 1 0 1 0 1 0 0 0 1 1 1 0 0
3 1 1 0 0 0 0 1 0 1 0 . . . . . .
4 0 0 1 0 1 . . . . . 1 1 0 0 0 1
5 1 0 0 0 1 0 1 0 1 0 0 1 0 0 1 1
;

Re: How to transpose multiple response data from long to wide and dummy code

data_null__ — Tue, 07 Jun 2022 19:21:50 GMT

Didn't we do this this the other day?

data exam;
   infile cards missover;
   input ID $ ItemID $ response $1. @;
   do while(not missing(Response));
      output;
      input response $1. @;
      end;
   cards;
1 Item1 BC
1 Item3 ACD
2 Item1 CD
2 Item2 AC
2 Item3 BCD
3 Item1 AB
3 Item2 BD
4 Item2 CE
4 Item3 ABF
5 Item1 AE
5 Item2 BD
5 Item3 BEF
;;;;
   run;
proc print;
   run;
data examv/view=examv;
   set exam(drop=id) exam;
   run;
proc sort data=examv out=exam2;
   by id itemid;
   run;
proc summary data=exam2 nway completetypes classdata=exam;
   by id itemid;
   class response;
   output out=exam3(drop=_type_);
   run;
proc transpose data=exam3 out=want(drop=_name_ where=(not missing(id)));
   by id;
   var _freq_;
   id itemid response;
   run;
proc print;
   run;

data want

data EXAM:

Re: How to transpose multiple response data from long to wide and dummy code

lapetitemaman — Tue, 07 Jun 2022 19:59:14 GMT

Thank you for sharing your code. Somehow I was not able to get the data as shown. My actual ItemIDs are longer, more like I45609, I46874, etc. and they are not in sequential order (could this be the problem?). Somehow I got the item IDs listed as I45609AB, I45609ABC, I45609ABD, I45609ABE, etc. and the dummy code did not work correctly.

Re: How to transpose multiple response data from long to wide and dummy code

data_null__ — Tue, 07 Jun 2022 20:30:47 GMT

Pay attention to the my EXAM data. It has one observation for each value of RESPONSE.