Date: Tue, 26 Nov 2002 01:23:39 GMT
Reply-To: Mark Brinkley <nospam@ABC.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Mark Brinkley <nospam@ABC.COM>
Organization: Cox Communications
Subject: Macro variables and X command
I use a macro variable to identify the name of the Excel file. For
example,
%LET XLSFILE = c:\myfile.xls;
I use the following command to start Excel from within SAS:
X "START &XLSFILE";
As is, these statements work fine.
I would like to modify the xls filename to include spaces, like so:
%LET XLSFILE = c:\my file.xls;
But now
X "START &XLSFILE";
doesn't work.
Any ideas on how to get this to work? I've tried quotes around my macro
variable
but this doesn't work.
I'm running Win2000 and sas 8.2
Thanks.