topic Re: export to multiple excel sheets based on variable in SAS Procedures

export to multiple excel sheets based on variable

felicity1212 — Wed, 20 Jun 2012 15:12:52 GMT

hi- i have a dataset "allproviders"

i would like to export the data in allproviders to multiple tabs based on change in "providername". So for every group of "providername" i would like a new excel worksheet. I found this thread https://communities.sas.com/message/13594#13594, but not sure how to use the code. Can someone help me with code using my dataset names so that I can undestand it? I am completely new to SAS programmaing.

Thank you kindly

Re: export to multiple excel sheets based on variable

Cynthia_sas — Wed, 20 Jun 2012 19:48:46 GMT

Hi:

I just posted a simple example to your other forum posting. I am teaching today and not on a computer where I can do downloads. However, SASHELP.CLASS has 19 observations and 5 variables. You should be able to run my code posted in your other forum post and figure out how to use your dataset name and variable names with my code.

https://communities.sas.com/message/130211#130211

But run the code first and see if you can figure out what's what. SASHELP.CLASS is the name of the dataset and AGE is the name of the BY variable. So if your variable is called PROVIDERNAME or PROVNAME, then where I have BY AGE, you would have BY PROVNAME or BY PROVIDERNAME in your code.

Then where I have a VAR statement, you would use your other variables instead of NAME, AGE, SEX, HEIGHT and WEIGHT.

cynthia

Re: export to multiple excel sheets based on variable

felicity1212 — Thu, 21 Jun 2012 21:53:57 GMT

thank you cynthia!