topic Re: how to use proc transpose transfer A to B? in SAS Programming

how to use proc transpose transfer A to B?

walterwang — Sun, 11 Oct 2020 05:55:46 GMT

A is:

course1 course 2 course3 course4

school1: 3 2 4 1

school2: 2 1 0 3

school3: 4 6 3 2

B is

school1 course1 3

school1 course2 2

school1 course2 4

school1 course2 1

school2 course2 2

school2 course2 1

school2 course2 0

school2 course2 3

school3 course2 4

school3 course2 6

school3 course2 3

school3 course2 2

Re: how to use proc transpose transfer A to B?

novinosrin — Sun, 11 Oct 2020 06:17:45 GMT


data a;
input school $    course1  course2 course3 course4 ;
cards;
school1  3   2   4   1

school2 2 1 0 3

school3 4 6 3 2
;

proc transpose data=a out=b;
by school;
var course1-course4;
run;

Re: how to use proc transpose transfer A to B?

walterwang — Sun, 11 Oct 2020 06:20:34 GMT

thanks,
But course1 -course4 are math, english etc

.

Re: how to use proc transpose transfer A to B?

novinosrin — Sun, 11 Oct 2020 06:22:25 GMT

Okay in that case you can explicitly type those names or use var1--varN (double dash variable list)

Re: how to use proc transpose transfer A to B?

walterwang — Sun, 11 Oct 2020 06:42:16 GMT

course names look like:

CPC10108 (11) CPC10111 (11) CPC20111 (11) CPC20112 (11) CPC20211 (11) CPC20712 (11) CPC20812 (11) CPC30111 (11) CPC30116 (11) CPC30211 (11) CPC30216 (11) CPC30313 (11) CPC30318 (11) CPC30411 (11) CPC30413 (11) CPC30508 (11) CPC30511 (11) CPC30611 (11) CPC30708 (11) CPC30711 (11)
and there are more than 100 courses.
how to write variable?
Many thanks.