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

[dubya]

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?

[Reeza]

Did you use the ID option in proc transpose? 

Can you post your code?

[dubya]

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;

[Reeza · Accepted solution]

Fix your proc transpose:

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