Hello,
I have a dataset in sas that I would like converted to excel, where each sheet in the excel file contained the data for a unique id by visit.
Data have:
Unique_ID | Visit | Model | Type | Speed | Viscocity | Date |
cat1 | 1 | |||||
cat1 | 2 | |||||
cat1 | 3 | |||||
cat1 | 4 | |||||
cat1 | 5 | |||||
cat2 | 1 | |||||
cat2 | 2 | |||||
cat2 | 3 | |||||
cat3 | 1 | |||||
cat3 | 2 | |||||
cat3 | 3 | |||||
cat3 | 4 |
data want
I have never had to do anything like this before!
Thank you all in advance!
Best
https://support.sas.com/rnd/base/ods/odsmarkup/excelxp_demo.html#data
Except, use ODS EXCEL, not TAGSETS.
There are tons and tons of paper on how to do this on LexJansen.com
Good Luck 🙂
@daszlosek wrote:
Hello,
I have a dataset in sas that I would like converted to excel, where each sheet in the excel file contained the data for a unique id by visit.
Data have:
Unique_ID Visit Model Type Speed Viscocity Date cat1 1 cat1 2 cat1 3 cat1 4 cat1 5 cat2 1 cat2 2 cat2 3 cat3 1 cat3 2 cat3 3 cat3 4
data want
I have never had to do anything like this before!
Thank you all in advance!
Best
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.