BookmarkSubscribeRSS Feed
MarkRoberts
Calcite | Level 5

I'm running SAS 9.3 and Excel 2007 on Windows XP  - and have recently encountered a problem.

I have a number of overnight jobs that creates simple output for various members of the business - and have traditionally out put this to an excel file that is then sent to the relevant parties as part of the SAS job.

Recently a number of people have complained that the file is corrupt - however I can open the file no problems and have been copying the output into another file and emailing it to them once I get into work.

Its not a valid long term solution as its a painful task for me and relies on me being in work to be able to do this.

After some searching around - it appeared to be a problem with other members running Windows 7 and some issue with Excel 2007.

The solution seemed to be to uninstall and install SAS PC server - I did this to no avail - also from a recent test I did with a colleague (non SAS literate) they could open the file and they are running Windows 7.

Does anyone have any experience or help that might shed light on this?

Thanks in advance

5 REPLIES 5
mfisher
Fluorite | Level 6

I've not encountered any problems, either.

Given that you can open the file, could it be that SAS is exporting it as .xlsx, but the others can only read .xls?

MarkRoberts
Calcite | Level 5

I don't think so - the file is saved on my machine as .xls and we are all using Office 2007 - the only difference is my machine hasn't been upgraged to Windows 7 yet and is still running on XP.

OS2Rules
Obsidian | Level 7

Are you using the ExcelXP tagset to write the Excel report?  Remember that the tagset writes the output as .xml, not as .xls no matter which extension you specify on your output.  The Windoze 7 machines may have a problem with the xml.

You could try converting the xml file to a real xls file before you send them using this trick: 43496 - Convert files created using an ODS destination to native Excel files

At least you won't have to do the conversion manually.

newbie_ari
Fluorite | Level 6

Hi,

We also generally have to output our sas data, and then share with other people. We export it in csv. If we have consolidate all the outputs & create a report, then we have vba macros to do that. This way we generally bypass the issues you mentioned. Not a exact answer to your question, but just tried to give an option.

Rgds,

MarkRoberts
Calcite | Level 5

I ended up just using a CSV file.

Thanks for the suggestions

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 5 replies
  • 2885 views
  • 0 likes
  • 4 in conversation