topic Re: Proc Transpose from Long to Wide in SAS Programming

Proc Transpose from Long to Wide

SASnewbiee — Tue, 05 Nov 2019 02:57:37 GMT

Hello,

I am having trouble going from long to wide using Proc transpose.
It seems like it should be really simple but I'm not getting it correct:

Trying to go from:

ID grade

1 grade1

1 grade2

1 grade3

2 grade1

2 grade2

2 grade3

3 grade1

3 grade2

3 grade3

to:

ID grade1 grade2 grade3
1 88 82 89

2 76 87 90

3 99 94 89

I tried

**proc transpose from long to wide;

proc transpose data=long out=wide (drop=_NAME) prefix=grade;
by ID;
id grade1-grade3;

run;

Proc print data=wide;
title ' Transpose from Long to Wide';
run;

Re: Proc Transpose from Long to Wide

Astounding — Tue, 05 Nov 2019 03:24:33 GMT

You're missing a variable from your program. Where do the numbers like 88, 82, and 89 come from?

Whatever the name of the variable is, it should go in a VAR statement within PROC TRANSPOSE.

The ID statement must refer to an existing variable, in this case GRADE.

Re: Proc Transpose from Long to Wide

Reeza — Tue, 05 Nov 2019 03:23:24 GMT

Transposing data tutorials:
Long to Wide:
https://stats.idre.ucla.edu/sas/modules/how-to-reshape-data-long-to-wide-using-proc-transpose/

https://stats.idre.ucla.edu/sas/modules/reshaping-data-long-to-wide-using-the-data-step/

You are referring to ID as grade1-grade3 which are not variables that exist. You need to refer just to grade.

See the first example in the first link above.

@SASnewbiee wrote:

Hello,

I am having trouble going from long to wide using Proc transpose.
It seems like it should be really simple but I'm not getting it correct:

Trying to go from:

ID grade

1 grade1

1 grade2

1 grade3

2 grade1

2 grade2

2 grade3

3 grade1

3 grade2

3 grade3

to:

ID grade1 grade2 grade3
1 88 82 89

2 76 87 90

3 99 94 89

I tried

**proc transpose from long to wide;

proc transpose data=long out=wide (drop=_NAME) prefix=grade;
by ID;
id grade1-grade3;

run;

Proc print data=wide;
title ' Transpose from Long to Wide';
run;

Re: Proc Transpose from Long to Wide

SASnewbiee — Tue, 05 Nov 2019 04:13:49 GMT

sorry I was inconsistent with describing it...the values 88, 90 etc are the values for the grade

I looked at tutorials and tried it and it just wouldn't work. It's not even multiple variables and I can't seem to get it

Re: Proc Transpose from Long to Wide

SASnewbiee — Tue, 05 Nov 2019 04:21:13 GMT

I have


1	99 (grade1)
1	80 (grade2)
1	78 (grade3)
2	89 (grade1)
2	76 (grade2)
2	88 (grade3)

I'm trying to get to:

ID	Grade1	Grade2	Grade
1	99	80	78
2	89	76	88
etc

Re: Proc Transpose from Long to Wide

Astounding — Tue, 05 Nov 2019 04:31:16 GMT

PROC TRANSPOSE is not the easiest thing to learn. What you are looking for might be as simple as this:

proc transpose data=long out=wide (drop=_NAME_) prefix=grade;
  by ID;
  var grade;
run;

Re: Proc Transpose from Long to Wide

SASnewbiee — Tue, 05 Nov 2019 04:38:48 GMT

I had actually just entered this and it worked after trying so many combinations.

I was over-complicating something so simple.

Thanks!!