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 (May 2009, week 1)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:         Wed, 6 May 2009 13:25:04 -0400
Reply-To:     Ya Huang <ya.huang@AMYLIN.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Ya Huang <ya.huang@AMYLIN.COM>
Subject:      Re: How could I resovle the macro variable in the single quote
Comments: To: Terry He <he.terry@GMAIL.COM>

data _null_; file "&f_path\pivot_vb_click.vbs"; put 'Set XL = CreateObject("Excel.Application")'; put 'XL.Visible=True'; put 'XL.Workbooks.OpenText "' "&f_path\RawData.txt" '", 437, 1, 1, -4142, False, False, False, False, False, True, "|"'; run;

On Wed, 6 May 2009 13:13:05 -0400, Terry He <he.terry@GMAIL.COM> wrote:

>data _null_; >file "&f_path\pivot_vb_click.vbs"; >put 'Set XL = CreateObject("Excel.Application")' / 'XL.Visible=True' / >'XL.Workbooks.OpenText "&f_path\RawData.txt", 437, 1, 1, -4142, False, >False, False, False, False, True, "|"'; >run; > >How could I resovle the "&f_path on line 4? > >Thanks

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