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
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.