topic Making First Row in Excel File the Column Name When Using Proc Transpose in SAS Procedures

Making First Row in Excel File the Column Name When Using Proc Transpose

dubya — Tue, 23 Feb 2016 23:25:58 GMT

I have an excel .csv file that looks like this:

Type Value

Time 1:00 pm

Level1 52.3

Level2 52.3

Level3 52.3

Level4 52.3

I import it into SAS (version 9.4) and use proc transpose and get data that looks like this:

Name of Former Variable COL1 COL2 COL3 COL4 COL5

Type Time Level1 Level2 Level3 Level4

Value 52.3 52.3 52.3 52.3 52.3

My goal is to turn the second row into the actual variable name: COL1 = Time; COL2 = Level1, etc.

I'm so stumped. Does anyone have any sugestions on appropriate code?

Re: Making First Row in Excel File the Column Name When Using Proc Transpose

Reeza — Tue, 23 Feb 2016 23:33:23 GMT

Did you use the ID option in proc transpose?

Can you post your code?

Re: Making First Row in Excel File the Column Name When Using Proc Transpose

dubya — Tue, 23 Feb 2016 23:39:45 GMT

The only code I've used is

proc import datafile="C:levels.csv"
     out=ndb103232015 
     dbms=csv
     replace;
     getnames=yes;
run;

proc transpose data=ndb103232015  out=ndb103232015_transpose;
var type value;
run;

Re: Making First Row in Excel File the Column Name When Using Proc Transpose

Reeza — Tue, 23 Feb 2016 23:42:08 GMT

Fix your proc transpose:

proc transpose data=have out=want;
var value;
id type;
run;