topic using string text with macro variables in Statistical Procedures

using string text with macro variables

Ardaneth — Tue, 05 Jul 2016 09:48:50 GMT

Hi there,

i want to use the export funtion while doing regression analyses as follows:

    ODS TAGSETS.EXCELXP
    file='H:\Bildung_&x._mitAbi.xls'
    STYLE=minimal
    OPTIONS ( Orientation = 'landscape'
    FitToPage = 'yes'
    Pages_FitWidth = '1'
    Pages_FitHeight = '100' );

It is part of an big analysis macro. Is there a way that i can tell SAS that the "&x." in "file='H:\Bildung_&x._mitAbi.xls'" is actualy a macro variable? Its going to be a realy big number of regression analyses and i realy dont want to name the files manualy.

Best regards,

Tom

Re: using string text with macro variables

Astounding — Tue, 05 Jul 2016 12:25:06 GMT

Your program is nearly fine as is.

Single quotes suppress all macro activity. Use double quotes instead of single quotes around the file path.

Re: using string text with macro variables

MC1985 — Tue, 05 Jul 2016 12:41:29 GMT

something like that:

/*1st SOLUTION: using double quote*/
file="H:\Bildung_&x._mitAbi.xls"
    STYLE=minimal
    OPTIONS ( Orientation = 'landscape'
    FitToPage = 'yes'
    Pages_FitWidth = '1'
    Pages_FitHeight = '100' );

/*2nd SOLUTION: resolve the macrovars before*/
%LET X                          =file_xls_name;
%LET FILE_AND_PATH =H:\Bildung_&X._mitAbi.xls;
%PUT &X.;
%PUT &FILE_AND_PATH.;
file="&FILE_AND_PATH."
    STYLE=minimal
    OPTIONS ( Orientation = 'landscape'
    FitToPage = 'yes'
    Pages_FitWidth = '1'
    Pages_FitHeight = '100' );

???

Re: using string text with macro variables

Ardaneth — Tue, 05 Jul 2016 14:04:28 GMT

Thanks. That was an easy solution, which spares me from a lot of work. 🙂