LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (November 2002, week 4)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
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.


Back to: Top of message | Previous page | Main SAS-L page