Turn SAS dataset intro excel with each excel sheet as unique id

[daszlosek]

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

[Reeza]

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

---