topic Re: Basic Help with PROC TRANSPOSE in SAS Procedures

Basic Help with PROC TRANSPOSE

GregG — Tue, 12 Feb 2019 17:55:19 GMT

I need what I think is some fairly basic help with proc transpose. I've read a few docs and guides, but can't seem to put everything together to make it work for my exact scenario.

How do I use a proc transpose to turn my DATA HAVE into my DATA WANT?

data have;
input stuid courseid facid qid qresponse $;
cards;
1 1 1 1 5
1 1 1 2 4
1 1 1 3 4
1 1 1 4 5
1 1 1 5 3
1 1 2 1 5
1 1 2 2 5
1 1 2 3 5
1 1 2 4 5
1 1 2 5 5
;
run;


data want;
input stuid courseid facid qid_1 qid_2 qid_3 qid_4 qid_5 $;
cards;
1 1 1 5 4 4 5 3
1 1 2 5 5 5 5 5
;
run;

Re: Basic Help with PROC TRANSPOSE

novinosrin — Tue, 12 Feb 2019 18:00:52 GMT

data have;
input stuid courseid facid qid qresponse $;
cards;
1 1 1 1 5
1 1 1 2 4
1 1 1 3 4
1 1 1 4 5
1 1 1 5 3
1 1 2 1 5
1 1 2 2 5
1 1 2 3 5
1 1 2 4 5
1 1 2 5 5
;
run;

proc transpose data=have out=want(drop=_:) prefix=qid_;
by stuid courseid facid;
id qid;
var qresponse;
run;

Re: Basic Help with PROC TRANSPOSE

andreas_lds — Wed, 13 Feb 2019 16:39:15 GMT

Please note, that for most procedures the structure of have is more useful, than that of want.

Re: Basic Help with PROC TRANSPOSE

novinosrin — Wed, 13 Feb 2019 16:46:20 GMT

Hi @andreas_lds Very good point. But I would like to bring to your attention one potential caveat. A lot of survey questionnaire data that's used by market research firms are usually in the wide form however transformed into 1's and 0's for regression modeling and so on.

There's a possibility the OP might have such requirement. And then of course even if there's a combination of continuous/non continuous variables, we could analyse interaction terms and so on and so forth.

At DePaul Uni, we play with such data a lot 🙂

Otherwise, I totally agree with you. Cheers!