Help using Base SAS procedures

use DDE save excel file and give the file a name

Reply
Regular Contributor
Posts: 222

use DDE save excel file and give the file a name


Hello everyone,

When I use DDE to create and save an excel file,the default name is book1 and location is c:\My Document.

Could anyone telll me how to change the name and change the location?

Thanks

Mike

filename cmds dde 'excel|system';

data _null_;
   file cmds;
   put '[SELECT("R1C1:R20C3")]';
   put '[SORT(1,"R1C1",1)]';
   put '[SAVE()]'; /*  This will save the new excel file to an excel file named  "book1.xls",I want the saved file 's name is myfile.xls*/
   put '[QUIT()]';
run;

PROC Star
Posts: 7,468

Re: use DDE save excel file and give the file a name

Posted in reply to Mike_Davis

Have you tried changing your put save statement to something like?:

put '[save.as ("c:\OtherFolder\DifferentFileName.xls")]';

Regular Contributor
Posts: 222

Re: use DDE save excel file and give the file a name

Thank you Art!

I tried "save as" didn't work,but as your advice use "save.as" will works !

Ask a Question
Discussion stats
  • 2 replies
  • 262 views
  • 3 likes
  • 2 in conversation