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
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.