The objective was to create an excel work book for each row on Projects List.xls
it is working fine but because some columns contains ALT+ENTER character the files that comes out from such rows will not have the extention xls when i check that with the DOS command DIR/P/W
How can i force the system to save them as EXCEL WITHOUT MANUAL INTERACTION????????????????????????
Okay, now please explain the exact problem symptom you are experiencing and also what you are expecting the outcome to be. Also, provide information about your SAS environment, such as OS, version, remote or local SAS execution. And if you have any warnings/errors being generated, listing those diagnostics would be most useful.
> Okay, now please explain the exact problem symptom
> you are experiencing and also what you are expecting
> the outcome to be. Also, provide information about
> your SAS environment, such as OS, version, remote or
> local SAS execution. And if you have any
> warnings/errors being generated, listing those
> diagnostics would be most useful.
> Scott Barry
> SBBWorks, Inc.
> SAS/Access Interface to PC Files: Reference,
> Microsoft Excel Workbook Files
> Overview of Microsoft Excel Files Essentials
It is a PC SAS 9.2 on XP_PRO platform
The log is clean there is no Warning or error messages
Now I suspect the problem to be due to DOS and not SAS because during the execution Excel gets created and once it reaches the phase of renaming files things gets screwed i have refreshed the contents of "Path2" the location where files gets dumped continously and i noticed that when the loop reaches for example at 6 where xls extention did not occur i see that project000000000006.xls gets initially created and then later renaming it based on the contents of certain excel cell leads to a file with no extention DMFY2010CustomerRequirements