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?
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.