Help using Base SAS procedures

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

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 9
Accepted Solution

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

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?

 


Accepted Solutions
Solution
‎02-23-2016 06:52 PM
Super User
Posts: 17,750

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

Fix your proc transpose:

 

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

View solution in original post


All Replies
Super User
Posts: 17,750

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

Did you use the ID option in proc transpose? 

Can you post your code?

Occasional Contributor
Posts: 9

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

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;
Solution
‎02-23-2016 06:52 PM
Super User
Posts: 17,750

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

Fix your proc transpose:

 

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

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 274 views
  • 0 likes
  • 2 in conversation