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