topic Re: Transpose qusetion in SAS Programming

Transpose qusetion

jordenlam — Mon, 06 Jan 2020 19:14:42 GMT

Hi,

I think it can be solved by using proc transpose but not sure. Any ideas are welcome. Many thanks!

Now I have from CSV,

Class	Student	Phy	Che	Phy	Che	Phy	Che
A	1	95	95
A	2			85	90
A	3					80	80
B	1	88	86
B	2			95	100

And what I want is,

Class	Student	Phy	Che
A	1	95	95
A	2	85	90
A	3	80	80
B	1	88	86
B	2	95	100

I guess first of all, we need to deal with the same-name column issue.

Thanks again for any suggestion!

Re: Transpose qusetion

Kurt_Bremser — Mon, 06 Jan 2020 19:21:16 GMT

This can be handled immediately when reading the csv file. Please post a few example lines of the csv file, using the {i} button.

Re: Transpose qusetion

jordenlam — Mon, 06 Jan 2020 19:27:17 GMT

Thanks!

This is the data from CSV,

Class	Student	Phy	Che	Phy	Che	Phy	Che
A	1	95	95				
A	2			85	90		
A	3					80	80
B	1	88	86				
B	2			95	100

Re: Transpose qusetion

novinosrin — Mon, 06 Jan 2020 19:38:48 GMT

HI @jordenlam Plz try replicating this



data extract;
infile 'your_file' dsd truncover;
input Class	$ student @;
do _n_=1 to 3;
input 	phy che @ ;
if not missing(phy) and not missing(che) then output;
end;
run;

The loop can also be written as

do until(not missing(phy) and not missing(che)) ;
 input 	phy che @ ;
 if not missing(phy) and not missing(che) then output;
end;

Re: Transpose qusetion

Kurt_Bremser — Mon, 06 Jan 2020 19:58:38 GMT

There's no delimiter in there, so it's not a csv file.

Re: Transpose qusetion

ChrisNZ — Tue, 07 Jan 2020 02:39:28 GMT

Did you transpose the e and s in qusetion ? 🙂