| 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 |
|---|
|
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
|
