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

daszlosek — Wed, 04 Oct 2017 18:30:13 GMT

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

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

Reeza — Wed, 04 Oct 2017 18:43:04 GMT

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

topic Turn SAS dataset intro excel with each excel sheet as unique id in SAS Programming

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

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