topic ods html file = compound name with macro variable in SAS Enterprise Guide

ods html file = compound name with macro variable

need_some_help — Mon, 19 Mar 2012 15:21:54 GMT

Hi!

My target is to put my everyday report to a certain folder, but the name of that html-file should include today-date - and here is some problem:

my code is:

%let cur_date_4=%sysfunc(putn(%sysfunc(today()), DDMMYYN4.));

/*%let report_name = %str(%')Sales report &cur_date_4.html%str(%');*/

%let report_name1=%str(Sales report);
%let report_name2=&cur_date_4;
%let report_name3=%str(.html);
%let reportname=%sysfunc(cat(&report_name1,&report_name2,&report_name3));

ods html path='C:\Users\U111\Documents\' file=&report_name style=minimal;

%my_report;

But it gives errors, and I don't know how to make it correct. Could anyone help me?

ods html file = compound name with macro variable

Tom — Mon, 19 Mar 2012 16:02:54 GMT

You should not need to use the CAT function to concatenate macro variables. Just reference them where you need them.

%let reportname=&report_name1.&report_name2.&report_name3;

Shouldn't the FILE= option on the ODS statement use a quoted string?

file="&report_name"

ods html file = compound name with macro variable

Tim_SAS — Mon, 19 Mar 2012 16:03:40 GMT

I don't know what errors it gives, but I notice that you assigned the report name to reportname but spelled the macro variable as report_name in the ODS statement.

ods html file = compound name with macro variable

need_some_help — Tue, 20 Mar 2012 14:01:34 GMT

I'm sorry - when copied (by parts - because of useless comments), missed one string (-->):

%let cur_date_4=%sysfunc(putn(%sysfunc(today()), DDMMYYN4.));

/*%let report_name = %str(%')Sales report &cur_date_4.html%str(%');*/

%let report_name1=%str(Sales report);
%let report_name2=&cur_date_4;
%let report_name3=%str(.html);
%let reportname=%sysfunc(cat(&report_name1,&report_name2,&report_name3));

--> %let report_name = %str(%')&reportname%str(%');

ods html path='C:\Users\U111\Documents\' file=&report_name style=minimal;

%my_report;

and this code gives such error:

16 ods html path='C:\Users\U111\Documents\' file=&report_name style=minimal;

_____

ERROR 22-322: Syntax error, expecting one of the following: DYNAMIC, INCLUDE, NO_BOTTOM_MATTER, NO_TOP_MATTER, TITLE, URL.

ERROR 76-322: Syntax error, statement will be ignored.

200

ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string.

ERROR 200-322: The symbol is not recognized and will be ignored.

17 %my_report;

ods html file = compound name with macro variable

need_some_help — Tue, 20 Mar 2012 14:06:34 GMT

Some text displaying problems:

in first case 'style' is underlined, in second - 'ods' (the beginning of ods-string) is.

ods html file = compound name with macro variable

art297 — Tue, 20 Mar 2012 14:15:32 GMT

Use double quotes on the line that is causing the error. With single quotes the macro variable won't resolve.

ods html file = compound name with macro variable

need_some_help — Tue, 20 Mar 2012 14:25:30 GMT

Thanks - that method gave exactly the result I needed. Didn't met it (such joining macro variables - by '.') before...

Re: ods html file = compound name with macro variable

Tom — Tue, 20 Mar 2012 14:36:17 GMT

The periods don't join the variables. They assist SAS in telling where the variable name ends. It is not strictly needed in this case.

I better example for when you need to insert the period is when you want to have static characters right after the expanded macro variable, but the static characters could be interpretted as part of the macro variable's name. For example if you wanted to append _SORTED to the end of dataset name.

%let dsname=source;

proc sort data=&dsname out=&dsname._sorted;

Without the period SAS would look for macro variable named DSNAME_SORTED.

ods html file = compound name with macro variable

need_some_help — Tue, 20 Mar 2012 14:39:40 GMT

Yes, I've tried new way of applying to macro variables and then used double quotes - and it worked just like I wanted. Thanks!

Maybe you know where can I find documentation with description of simple macro variables using (like manipulating with char,number macro variables, right macro variables resolving) for SAS EG? Primarily I met some too advanced articles mostly for SAS (base)....

ods html file = compound name with macro variable

need_some_help — Tue, 20 Mar 2012 14:44:42 GMT

Oh, now I've got it - '.' is just separator for SAS to read it right. Thanks for that remark - it's important)

ods html file = compound name with macro variable

Cynthia_sas — Wed, 21 Mar 2012 15:59:13 GMT

Hi:

This is a good place to start:

http://www2.sas.com/proceedings/sugi28/056-28.pdf

Also, if you search (Google) or go to support.sas.com and search or go to lexjansen.com and search for user group papers about using the SAS Macro facility, you should find a LOT of papers, tutorials and information about how the SAS Macro Facility works (including, but not limited to &macvar references and %macpgm invocations).

cynthia

ods html file = compound name with macro variable

need_some_help — Thu, 22 Mar 2012 14:42:53 GMT

Thank you, Cynthia!