I have Table1 attached file in detail. I want using Proc Transpose function, have new table called Table2.
---------------------------------------------------------------------------------------------------------------------------------
Table1: Month, ENROLLMENT, MAJOR_MEDICAL, PBM, Pharmacy, LB, DENTAL
_ 2018-01_ 212,400 10,962 2,890 12,344 483 1,868
---------------------------------------------------------------------------------------------------------------------------------
I want this transpose become table 2 as :
---------------------------------------------------------------
Table2: OHI_Plan, _2018-01_
ENROLLMENT 212,400
MAJOR_MEDICAL 10,962
PBM 2,890
Pharmacy 12,344
LB 483
DENTAL 1,868
--------------------------------------------------------------------------------
SAS code:
Proc sort data = table1;
By Month;
Run;
Proc Transpose data = table1 out=table2;
name = OHI_PLan;
ID Month;
run;
After the SAS ode run, got result table 2 only has column names, without data.
OHI_Plan , _201801_
Do not know why.
Post your code AND log.
Does your log have errors?
@JHE wrote:
I have Table1 attached file in detail. I want using Proc Transpose function, have new table called Table2.
---------------------------------------------------------------------------------------------------------------------------------
Table1: Month, ENROLLMENT, MAJOR_MEDICAL, PBM, Pharmacy, LB, DENTAL
_ 2018-01_ 212,400 10,962 2,890 12,344 483 1,868
---------------------------------------------------------------------------------------------------------------------------------
I want this transpose become table 2 as :
---------------------------------------------------------------
Table2: OHI_Plan, _2018-01_
ENROLLMENT 212,400
MAJOR_MEDICAL 10,962
PBM 2,890
Pharmacy 12,344
LB 483
DENTAL 1,868
--------------------------------------------------------------------------------
SAS code:
Proc sort data = table1;
By Month;
Run;
Proc Transpose data = table1 out=table2;
name = OHI_PLan;
ID Month;
run;
After the SAS ode run, got result table 2 only has column names, without data.
OHI_Plan , _201801_
Do not know why.
Thank you for rely to me. There is no error.
Log file attached .
this is the log
disregards the previous log file.
1. This log doesn't match the code you posted in your first post
2. The log doesn't have errors but there are some notes that tell you what's wrong.
3. I don't know which log/code you're using and what to say beyond this because its not clear what you're doing.
transpose Table1 to tabl2 2 format.
log attached, and table detail atatched
SAS code:
proc sort data=WORK.Table1 ;
by month;
run;
proc transpose data=WORK.Table1 out=WORK.Table2 name=OHI_Plan;
id month;
run;
run the SAS code, having result as Tbale2, only have two columns without data.
Note: No variables to transpose
Maybe you missed the note above.
Try adding your variables to the VAR statement.
Thank you, this is worked.
proc transpose data=WORK.Table1 out=WORK.Table2 (drop= _name_) label=OHI_Plan ;
id month;
var enrollment major_medical pbm Pharmacy lb dental;
run;
Interesting! I'd have thought, from your example, that you wanted:
proc transpose data=WORK.Table1 out=WORK.Table2 ; var Month ENROLLMENT MAJOR_MEDICAL PBM Pharmacy LB DENTAL; run;
Art, CEO, AnalystFinder.com
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.