Solved: How to resolve the macro variable in html message

SASdevAnneMarie · Posted 06-30-2020 05:58 AM

Hello!

I have a question.

In my table SAS, the column CODE_PRODUIT hase the values: CD1, CD2, CD3, CD4. This values can change.

I would like that this values appear in my e-mail, like this:

FILENAME outmail EMAIL
SUBJECT= "PRODUCT"
type='text/html'

FROM= ‘XXXX’

TO= (‘XXXX’‘XXXX’)

CC=(‘XXXX’)

data _null_;

file outmail;

if _N_=1 then

do;

PUT '<html>'"Hello,"'</html>';

PUT '<html>'"The values are:"'</html>';

PUT '<html>'"-CD1"'</html>'; /***new line***/

PUT '<html>'"-CD2"'</html>'; /***new line***/

PUT '<html>'"-CD3"'</html>'; /***new line***/

PUT '<html> </html>';

end;

run;

My question is: do you know some option to resolve the macro variable in html message?

My code doesn't work: I can't resolve the macro variable &liste_PRODUIT2. in my e-mail:

data CODE_PRODUIT2;

set CODE_PRODUIT;

code_1="PUT'<html>'";

code_2=quote('A0'x||'A0'x||'A0'x||("-")||(CODE_PRODUIT));

code_3="'</html>';";

CODE_PRODUIT_2=compress(code_1||code_2||code_3);

run;

proc sql noprint;

select distinct strip(CODE_PRODUIT_2) into :liste_PRODUIT2 separated by ''

from CODE_PRODUIT2;

quit;

%put "&liste_PRODUIT2.";

data _null_;
file outmail;

if _N_=1 then
do;

PUT '<html>'"Hello,"'</html>';

PUT '<html>'"The values are:"'</html>';

PUT '<html> </html>';
%put &liste_PRODUIT2.
PUT '<html> </html>';
PUT '<html> </html>';
PUT '<html> </html>';

end;
run;

Thank ypu for you help!

Kurt_Bremser · Posted 06-30-2020 06:40 AM

Don't use a %PUT macro statement to output data to the FILE destination. %PUT writes only to the log.

data _null_;
file outmail;
if _N_=1 then
do;
  PUT '<html>'"Hello,"'</html>';
  PUT '<html>'"The values are:"'</html>';
  PUT '<html><br></html>';
  put "&liste_PRODUIT2.";
  PUT '<html><br></html>';
  PUT '<html><br></html>';
  PUT '<html><br></html>';
end;
run;

Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
The macro for direct download as ZIP
How to post code
Please vote for Provide Sequential Search Capability for Hash Objects
How to deal with locked files on UNIX

View solution in original post

Kurt_Bremser · Posted 06-30-2020 06:40 AM

Don't use a %PUT macro statement to output data to the FILE destination. %PUT writes only to the log.

data _null_;
file outmail;
if _N_=1 then
do;
  PUT '<html>'"Hello,"'</html>';
  PUT '<html>'"The values are:"'</html>';
  PUT '<html><br></html>';
  put "&liste_PRODUIT2.";
  PUT '<html><br></html>';
  PUT '<html><br></html>';
  PUT '<html><br></html>';
end;
run;

Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
The macro for direct download as ZIP
How to post code
Please vote for Provide Sequential Search Capability for Hash Objects
How to deal with locked files on UNIX

SASdevAnneMarie · Posted 06-30-2020 07:39 AM

Thank you very much Kurt!
It works!
Marie

SASdevAnneMarie · Posted 06-30-2020 08:51 AM

I have a little problem with my macro variable, I receive this in my e-mail (via html message):

. -T340GB

-T341GB

-T387GB

I try to delete the dot on the first line, but I suppose it is an html issue.

Do you have please some options for that?

Thank you very much!

ballardw · Posted 06-30-2020 10:27 AM

@SASdevAnneMarie wrote:

I have a little problem with my macro variable, I receive this in my e-mail (via html message):

. -T340GB

-T341GB

-T387GB

I try to delete the dot on the first line, but I suppose it is an html issue.

Do you have please some options for that?

Thank you very much!

One strongly suspects that your code is Putting a missing value. You may resolve that by placing this line before the data step that writes to the file:

options missing=' '; (yes that is a single space between the quotes).

Then any missing value will display as a blank.

You should reset the option back to the dot after the step. Otherwise you may get confused when you no longer see dots for missing values.

SASdevAnneMarie · Posted 06-30-2020 10:34 AM

Hello,

Thank you very much, that works!

Best regards,

Marie

How to resolve the macro variable in html message

Re: How to resolve the macro variable in html message

Re: How to resolve the macro variable in html message

Re: How to resolve the macro variable in html message

Re: How to resolve the macro variable in html message

Re: How to resolve the macro variable in html message

Re: How to resolve the macro variable in html message

Ready to join fellow brilliant minds for the SAS Hackathon?

Classroom Training Available!