topic Re: How to resolve the macro variable in html message in SAS Programming

How to resolve the macro variable in html message

SASdevAnneMarie — Tue, 30 Jun 2020 09:58:39 GMT

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!

Re: How to resolve the macro variable in html message

Kurt_Bremser — Tue, 30 Jun 2020 10:40:21 GMT

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;

Re: How to resolve the macro variable in html message

SASdevAnneMarie — Tue, 30 Jun 2020 11:39:43 GMT

Thank you very much Kurt!
It works!
Marie

Re: How to resolve the macro variable in html message

SASdevAnneMarie — Tue, 30 Jun 2020 12:51:53 GMT

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!

Re: How to resolve the macro variable in html message

ballardw — Tue, 30 Jun 2020 14:27:14 GMT

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

Re: How to resolve the macro variable in html message

SASdevAnneMarie — Tue, 30 Jun 2020 14:34:40 GMT

Hello,

Thank you very much, that works!

Best regards,

Marie