topic Re: transpose in SAS Programming

transpose

JHE — Fri, 09 Feb 2018 17:00:37 GMT

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.

Re: transpose

Reeza — Fri, 09 Feb 2018 17:12:30 GMT

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.

Re: transpose

JHE — Fri, 09 Feb 2018 17:32:09 GMT

Thank you for rely to me. There is no error.

Log file attached .

Re: transpose

JHE — Fri, 09 Feb 2018 17:34:08 GMT

this is the log

Re: transpose

JHE — Fri, 09 Feb 2018 17:34:46 GMT

disregards the previous log file.

Re: transpose

Reeza — Fri, 09 Feb 2018 17:38:24 GMT

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.

Re: transpose

JHE — Fri, 09 Feb 2018 17:52:08 GMT

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.

Re: transpose

Reeza — Fri, 09 Feb 2018 18:01:38 GMT

Note: No variables to transpose

Maybe you missed the note above.

Try adding your variables to the VAR statement.

Re: transpose

JHE — Fri, 09 Feb 2018 18:09:08 GMT

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;

Re: transpose

art297 — Fri, 09 Feb 2018 18:12:28 GMT

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