We Recommend

Version Control with Subversion
Written by members of the Subversion open source development team, Version Control with Subversion introduces the powerful new versioning tool designed to be the successor to the Concurrent Version System or CVS. CVS users will find the "look and feel" Subversion comfortably familiar, but under the surface it's far more flexible, robust, and usable, and more importantly, it improves on CVS's more notable flaws.

Ballyhoo

Posted By

webonomic on 04/08/08

Tagged

data dataset shaping

Versions (?)

Create one response from "check all that apply" variables

Published in: SAS

URL: http://jaredprins.squarespace.com/blog/2008/4/8/create-one-response-from-check-all-that-apply-variables.html

Below is some code written for creating one response from survey questions where the respondent checks all that apply.

Plain TextExpand

proc format;
  value respfmt
   0='jim'
   2='joe'
   4='jon'
   8='jan'
   6='jake'
  10='jack'
  12='jill'
  14='josh';
run;
 
data have;
  input response1-response3;
  cards;
0 0 0
1 0 0
0 1 0
0 0 1
1 1 0
1 0 1
0 1 1
1 1 1
;
 
data want (drop=i);
  set have;
  array resp(*) response1-response3;
  format responses respfmt.;
  responses=0;
  do i=1 to 3;
    if resp(i) eq 1 then
     responses+2**i;
  end;
run;
 
proc print data=want;
run;

Report this snippet

Comment:

You need to login to post a comment.