proc transpose to more than one header

ernie86 — Mon, 18 Jun 2018 20:41:32 GMT

I have problem transposing to long to wide

Here is what i have:

COL1	Plan	target_code	Name	Question_ID	Parent Question	Child Question
Chicago	Plan A	1234	p1	Q001	address	city
IL	Plan A	1234	p1	Q002	address	state
Red	Plan A	1234	p1	Q003	Program	Color
2009	Plan A	1234	p1	Q004	Program	Start Year
New York	Plan A	1221	p2	Q001	address	city
NY	Plan A	1221	p2	Q002	address	state
Blue	Plan A	1221	p2	Q003	Program	Color
2009	Plan A	1221	p2	Q004	Program	Start Year

Here is what i want:

			address	address	Program	Program
			city	state	Color	Start Year
Plan	target_code	Name	Q001	Q002	Q003	Q004
Plan A	1234	p1	Chicago	IL	Red	2009
Plan A	1221	p2	New York	NY	Blue	2009

I have this code here, but the output is not what i want. It is combining Question_ID, 'Parent Question'n, and 'Child Question'n all into one column.

proc transpose data=prg_final2 out= final_report (drop=_NAME_);
by Plan target_code Name;
id Question_ID 'Parent Question'n 'Child Question'n;
var COL1;
run;

Re: proc transpose to more than one header

pau13rown — Mon, 18 Jun 2018 20:47:12 GMT

just edit id statement:

proc transpose data=prg_final2 out= final_report (drop=_NAME_) ;
by Plan target_code Name;
id Question_ID;
var COL1;
run;

and then:

data final_report2;

set final_report;

label Q001 ='address city' Q002='address state' .... etc;

run;

topic Re: proc transpose to more than one header in SAS Programming

proc transpose to more than one header

Re: proc transpose to more than one header