02-23-2016 06:25 PM
I have an excel .csv file that looks like this:
Time 1:00 pm
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?
02-23-2016 06:39 PM
The only code I've used is
proc import datafile="C:levels.csv"
proc transpose data=ndb103232015 out=ndb103232015_transpose; var type value; run;
Need further help from the community? Please ask a new question.