topic Re: Variable value does not appear in Email in SAS Programming

Variable value does not appear in Email

SaschaD — Thu, 17 Mar 2022 09:39:03 GMT

Hello,

My code below runs successfully, but only shows the text of the two variables count_NO_contract and count_NO_sales.

How do I have to change the code?

filename REPORT "%sysfunc(pathname(work))\output.html"; 
filename SEND 
	email to		= "XXX@XXX.com"
	SUBJECT 		= "Test Subject"
        content_type 	        = "text/html"
	ATTACH 			= "&PATHNAME";

ods html file	= REPORT
         style	= HTMLBlue;

PROC REPORT DATA=APPG.AZL_NG_BESTAND;
	COLUMN workday workvalue;
	DEFINE workday / GROUP;
	DEFINE workvalue / F = COMMAX10.;
	RBREAK AFTER / SUMMARIZE;
	WHERE workday >= 20220201;
RUN;

ods html close;

data _null_;
  infile REPORT;
  file SEND;
  input;
  if _infile_ ne '</html>' then put _infile_;
  else do;
	PUT 'Process finished';
	PUT 'unknown contracts: &count_NO_contract';
	PUT 'unknown sales: &count_NO_sales';
  end;
run;

Thanks

Sascha

Re: Variable value does not appear in Email

japelin — Thu, 17 Mar 2022 09:44:34 GMT

Use double quotes instead of single quotes when you want to expand macro variables.

	PUT "unknown contracts: &count_NO_contract";
	PUT "unknown sales: &count_NO_sales";

Re: Variable value does not appear in Email

Kurt_Bremser — Thu, 17 Mar 2022 10:57:20 GMT

The solution has already been given, but do you really store your dates like this:

WHERE workday >= 20220201;

If yes, it's a VERY BAD IDEA, as it deprives you of the use of all the nice tools SAS provides for dealing with dates, makes date calculations very hard, and on top you have to use at least 5 numeric bytes to store them. SAS date values need only 4.