TRANSPOSE an entire table

ismahero2 — Fri, 24 Oct 2014 15:14:25 GMT

Hi,

I am trying to use PROC TRANSPOSE to transpose from wide to narrow and entire dataset.

This is what I have.

ID	SALARY	NAME	HIRE_DATE	BONUS	DEPT
001001	100,000	JONES SMITH	01012010	10,000	ADMIN
001002	58,362	HARRY WIZARD	02052005	5,600	SALES
001003	85,254	JOHN ADAMS	10102009	3,055	SALES

This is the expected outcome I need.

ID	001001	001002	001003
SALARY	100,000	58,362	85,254
NAME	JONES SMITH	HARRY WIZARD	JOHN ADAMS
HIRE_DATE	01012010	02052005	10102009
BONUS	10,000	5,600	3,055
DEP	ADMIN	SALES	SALES

I am trying to use PROC TRANSPOSE, but I havent been able to obtain the expected result. Any help?

Re: TRANSPOSE an entire table

data_null__ — Fri, 24 Oct 2014 15:28:57 GMT

data id;
   infile cards firstobs=2 dsd dlm='|'; 
   input ID :$4. SALARY:comma. NAME:$16. HIRE_DATE:mmddyy. BONUS:comma. DEPT :$8.; 
   format salary bonus comma12. hire_date mmddyy10.; 
   cards; 
ID,SALARY,NAME,HIRE_DATE,BONUS,DEPT
1001|100,000|JONES SMITH|1012010|10,000|ADMIN
1002|58,362|HARRY WIZARD|2052005|5,600|SALES
1003|85,254|JOHN ADAMS|10102009|3,055|SALES
;;;;
proc print; 
   run; 
proc transpose data=id out=id2 name=ID;
   id id;
   var salary--dept;
   run; 
proc print; 
   run;

topic TRANSPOSE an entire table in SAS Enterprise Guide

TRANSPOSE an entire table

Re: TRANSPOSE an entire table