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
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.