DATA Step, Macro, Functions and more

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

Reply
Frequent Contributor
Posts: 76

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

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

test.png

 

I have never had to do anything like this before! 

 

Thank you all in advance!

Best

Super User
Posts: 19,861

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

Posted in reply to daszlosek

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 Smiley Happy

 


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

test.png

 

I have never had to do anything like this before! 

 

Thank you all in advance!

Best


 

Ask a Question
Discussion stats
  • 1 reply
  • 107 views
  • 0 likes
  • 2 in conversation