topic Re: How to send email using SAS in SAS Programming

How to supress Macro variable resolve to put " "; in SAS Email

ManoharNath — Wed, 02 Nov 2022 09:07:41 GMT

Hi Everyone,

I need one help related to macro variables which have null or no values which is resolving to " ".

I want to remove or supress " " this in output in SAS Email.

put "&segment1_Desc. "; /*have no values*/
put "&segment1_link. "; /*have no values*/

but in output getting " " " ". any ideas how to supress this " ".

Regards,

Manohar

Re: How to supress Macro variable resolve to put " "; in SAS Email

Kurt_Bremser — Wed, 02 Nov 2022 09:14:06 GMT

Please post the complete code, from the definition of the macro variables to the final RUN or ODS statement of the mail.

Post your code into a code box opened with the "little running man" button, right next to the one indicated here:

The indicated button is for logs and other textual data where a non-porportional font and preserving horizontal positions and special characters is important.

Re: How to send email using SAS

ManoharNath — Wed, 02 Nov 2022 11:07:39 GMT

How to remove missing values from email.

for below example:

put " ";
 put "&segment1_Desc. "; /*no values and coming as " " in log and output */
 put "&segment1_link. "; /*no values and coming as " " in log and output */
 put "&segment2_Desc. "; /*no values and coming as " " in log and output */
 put "&segment2_link. "; /*no values and coming as " " in log and output */
 put "&segment3_Desc. "; /*no values and coming as " " in log and output */
 put "&segment3_link. "; /*no values and coming as " " in log and output */
 put "&segment4_Desc. ";
 put "&segment4_link. ";
 put "&segment5_Desc. ";
 put "&segment5_link. ";
 put "&segment6_Desc. "; /*no values and coming as " " in log and output */
 put "&segment6_link. "; /*no values and coming as " " in log and output */
 put " ";

for this I am getting " " in sas log and in sas test outlook email

below is log:

SYMBOLGEN: Macro variable SEGMENT2_DESC resolves to
MPRINT(EMAILHV): put " ";

in output it coming as

" " " " " " Video desc

video link

" "

I am trying to supress this " " to coming in mail.

Regards,

Manohar

Re: How to send email using SAS

Kurt_Bremser — Wed, 02 Nov 2022 12:25:42 GMT

Please do not spam library articles with questions. Questions belong here.

I requested that you post your whole code. DO SO.

Re: How to send email using SAS

Quentin — Wed, 02 Nov 2022 13:39:09 GMT

You'll need to add some conditional processing (probably via %IF). Is it the case that either all macro vars will be null or all will have a value? Or will you need to test each one individually? Do you have a way to know when the macro vars will be null (other than checking them)?

Re: How to send email using SAS

ManoharNath — Fri, 25 Nov 2022 19:38:10 GMT

Sorry for delay in response and thank you everyone for your revert.

I was able to solve the prolem by using %if and %len method.

This resolved the problem.

%if %length(Video_segment1) > 0 %then %do;

%put &Video_segment1.;

%put &Video_Desc.;

end;

Re: How to send email using SAS

ManoharNath — Fri, 25 Nov 2022 19:37:07 GMT

Thank you for your revert.