Monday, October 23, 2006

Exporting Multiple Data Sets to One Spreadsheet

It's easy to export several data sets to one Excel spreadsheet with each data set in a separate worksheet.This example exports three SAS data sets (work.region, work.county and work.district) to the same spreadsheet (results.xls).

Each data set will be in a separate worksheet:

proc export
data=work.region
outfile="c:\temp\results.xls"
dbms=Excel;
run;
proc export
data=work.county
outfile="c:\temp\results.xls"
dbms=Excel;
run;
proc export
data=work.district
outfile="c:\temp\results.xls"
dbms=Excel;
run;

Results.xls will have three worksheets, each one automatically labeled with the name of the data set it was created from.

35 Comments:

At 2:01 PM, Anonymous Anonymous said...

Linda look into using the Excel Libname Engine in SAS V9, the process becomes even easier and faster.

 
At 12:05 AM, Blogger Pavan Kumar Jupelli said...

1.like this, can i import multiple excel sheets from an excel file into multiple sas datasets?

2.multiple excel sheets from an excel file into a single sas dataset?

 
At 11:23 AM, Anonymous Anonymous said...

Linda,
I tried the tip, but still got only one sheet returned. Is this limited to version 6?
My code are:
PROC EXPORT DATA=work.CLMMATCH OUTFILE="C:\temp\CLAIMS-&MID1-&dt..xls" DBMS=EXCEL; RUN; PROC EXPORT DATA=work.clmnomat OUTFILE="C:\temp\CLAIMS-&MID1-&dt..xls" DBMS=EXCEL; RUN;
PROC EXPORT DATA=work.dianotin OUTFILE="C:\temp\CLAIMS-&MID1-&dt..xls" DBMS=EXCEL; RUN; anything went wrong here? Thanks!

 
At 5:19 AM, Blogger clinnovo said...

Nice Post Post ! SAS Training in Hyderabad is provided by clinnovo institute that is a pioneer in offering sas course. Data analysis can be done efficiently with the help of this course and clinnovo makes it easy to operate SAS while you are trying your hands on the same.

 
At 3:45 AM, Blogger Unknown said...

This comment has been removed by the author.

 
At 10:23 AM, Blogger Unknown said...


I am extremely impressed with your writing skills and also with the layout on your blog
sas online training

 
At 3:34 AM, Blogger Unknown said...



This content creates a new hope and inspiration with in me. Thanks for sharing article like this. The way you have stated everything above is quite awesome. Keep blogging like this. Thanks.


SAP training in Chennai

 
At 12:37 AM, Blogger Unknown said...



These provided information was really so nice,thanks for giving that post and the more skills to develop after refer that post. Your articles really impressed for me,because of all information so nice.

SAP training in Chennai

 
At 5:11 AM, Anonymous Hussain said...

I keep on reading your blog post.. This was still amazing. Thanks a lot for sharing this unique informative post with us.. I really enjoyed by reading your blog post

Digital Marketing Company in Chennai

 
At 2:06 AM, Anonymous Aashi siva said...

This idea is mind blowing. I think everyone should know such information like you have described on this post. Thank you for sharing this explanation.Your final conclusion was good. We are sowing seeds and need to be patiently wait till it blossoms.

Corporate Training in Chennai

 
At 12:41 AM, Blogger Aasha said...

Thank you for taking the time to provide us with your valuable information. We strive to provide our candidates with excellent care.As always, we appreciate you confidence and trust in us.

Email Marketing Chennai

 
At 10:56 PM, Blogger Ameen Khatri said...

It should be noted that whilst ordering papers for sale at paper writing service, you can get unkind attitude. In case you feel that the bureau is trying to cheat you, don't buy term paper from it. ecommerce platforms

 
At 10:51 PM, Blogger Unknown said...

I have read a few of the articles on your website now, and I really like your style of blogging. I added it to my favourites blog site list and will be checking back soon.

Java training in Pune

Java interview questions and answers

Java training in Chennai | Java training institute in Chennai | Java course in Chennai

Java training in Bangalore | Java training institute in Bangalore | Java course in Bangalore

 
At 9:42 PM, Blogger Unknown said...

I recently came across your blog and have been reading along. I thought I would leave my first comment.
Data Science course in rajaji nagar
Data Science with Python course in chenni
Data Science course in electronic city
Data Science course in USA
Data science course in pune | Data Science Training institute in Pune

 
At 1:18 AM, Anonymous cathryn said...

This is quite educational arrange. It has famous breeding about what I rarity to vouch. Colossal proverb. This trumpet is a famous tone to nab to troths. Congratulations on a career well achieved. This arrange is synchronous s informative impolite festivity to pity. I appreciated what you ok extremely here.
angularjs-Training in pune

angularjs Training in bangalore

angularjs Training in bangalore

angularjs Training in btm

angularjs Training in electronic-city

angularjs online Training

angularjs Training in marathahalli

 
At 9:21 PM, Blogger Unknown said...

Thanks for your informative article, Your post helped me to understand the future and career prospects & Keep on updating your blog with such awesome article.
online Python training
python training in chennai

 
At 3:45 AM, Blogger priya said...

I really enjoy simply reading all of your weblogs. Simply wanted to inform you that you have people like me who appreciate your work. Definitely a great post I would like to read this
Data Science training in Chennai
Data science training in Bangalore
Data science training in pune
Data science online training
Data Science Interview questions and answers
Data science training in bangalore

 
At 4:41 AM, Blogger Clinnovo said...

Clinnovo Research Labs provides Internships, Trainings, Job Assistance in the Domains of Clinical Research, Clinical Data Management, SAS, Pharmacovigilance. For more details contact us @ +91-9985492233. www.clinnovo.comĀ 

SAS training
SAS course
SAS Certification
SAS Certification course
Online SAS Training

 
At 10:24 PM, Blogger nisha said...

While Reading this Blog, the blog is very Interesting really thanks for Updating this Article the Article is really Impressive.

Data Science Training Course In Chennai | Data Science Training Course In Anna Nagar | Data Science Training Course In OMR | Data Science Training Course In Porur | Data Science Training Course In Tambaram | Data Science Training Course In Velachery

 
At 12:39 AM, Blogger lionelmessi said...

Extraordinary Information Thanks For Sharing With Us

Best Data Science Training Institute in Hyderabad
Data Science Course Training in Hyderabad

 
At 10:36 PM, Blogger Vale Co Xenia said...


Great Article
Cloud Computing Projects


Networking Projects

Final Year Projects for CSE


JavaScript Training in Chennai

JavaScript Training in Chennai

The Angular Training covers a wide range of topics including Components, Angular Directives, Angular Services, Pipes, security fundamentals, Routing, and Angular programmability. The new Angular TRaining will lay the foundation you need to specialise in Single Page Application developer. Angular Training

 
At 9:02 AM, Blogger vijay said...

I am impressed. I don't think I've met anyone who knows as much about this subject as you do. You are truly well informed and very intelligent. You wrote something that people could understand and made the subject intriguing for everyone. Really, great blog you have got here.
Salesforce Training in Chennai

Salesforce Online Training in Chennai

Salesforce Training in Bangalore

Salesforce Training in Hyderabad

Salesforce training in ameerpet

Salesforce Training in Pune

Salesforce Online Training

Salesforce Training

 
At 1:44 AM, Blogger EXCELR said...

The strategy you have posted on this technology helped me to get into the next level and had lot of information in it.data science course in Hyderabad

 
At 5:43 AM, Blogger jeni said...

I simply wanted to thank you so much again. I am not sure the things that I might have gone through without the type of hints revealed by you regarding that situation.

java training in chennai

java training in velachery

aws training in chennai

aws training in velachery

python training in chennai

python training in velachery

selenium training in chennai

selenium training in velachery

 
At 5:56 AM, Blogger shiny said...

I would like to thank you for the efforts you had made for writing this awesome article. This article resolved my all queries.


oracle training in chennai

oracle training in annanagar

oracle dba training in chennai

oracle dba training in annanagar

ccna training in chennai

ccna training in annanagar

seo training in chennai

seo training in annanagar

 
At 11:25 AM, Blogger Jayalakshmi said...

I would like to say thank you for the amazing details and concepts you are sharing in this.The style of writing is excellent and also the content is top-notch. Thanks for that shrewdness you provide the readers! to read
hardware and networking training in chennai

hardware and networking training in tambaram

xamarin training in chennai

xamarin training in tambaram

ios training in chennai

ios training in tambaram

iot training in chennai

iot training in tambaram

 
At 12:25 AM, Blogger deiva said...

I have read your blog its very attractive and impressive. I like it your blog.
data science training in chennai

data science training in omr

android training in chennai

android training in omr

devops training in chennai

devops training in omr

artificial intelligence training in chennai

artificial intelligence training in omr


 
At 9:24 AM, Blogger lakshmik7410 said...


Thanks for sharing a very useful article. Am sure it helped to clear the doubts I had. Keep posting more. Also dont forget to check out our pages too.

data science training in chennai

ccna training in chennai

iot training in chennai

cyber security training in chennai

ethical hacking training in chennai



 
At 10:31 PM, Blogger Maneesha said...

New site is solid. A debt of gratitude is in order for the colossal exertion.
data scientist course in hyderabad

 
At 8:20 PM, Blogger Unknown said...

I am genuinely thankful to the holder of this web page who has shared this wonderful paragraph at at this place data science course in surat

 
At 6:57 AM, Blogger Data Science said...

Extremely overall quite fascinating post. I was searching for this sort of data and delighted in perusing this one. Continue posting. A debt of gratitude is in order for sharing.
business analytics course in warangal

 
At 6:20 AM, Blogger Data Science said...


Extremely overall quite fascinating post. I was searching for this sort of data and delighted in perusing this one.
Continue posting. A debt of gratitude is in order for sharing.data science course in warangal

 
At 11:10 PM, Blogger traininginstitute said...

Thanks for posting this info. I just want to let you know that I just check out your site and I find it very interesting and informative. I can't wait to read lots of your posts.
cyber security course malaysia

 
At 11:28 PM, Blogger EaglePie said...

Thanks for sharing this valuable information, we also provide instagram video download and,
really appreciate your hard work and good research that help us in for of your good valuable article. Keep updating us with your awesome content.

 
At 4:55 AM, Blogger Unknown said...

Truly exceptionally interesting post. I was searching for such a data and enjoyed investigating this one. Continue to post. Appreciative for sharing..data scientist course in ghaziabad

 

Post a Comment

<< Home