topic Re: How to display dataset record in email template in SAS Programming

How to display dataset record in email template

Abraham — Mon, 07 Aug 2017 15:54:01 GMT

Hi Expert,

I want to display total records available for particular dataset in the email template. If not available, it should display zero. Can you please help me. I tried with macro but it is not displaying.

data class;
set sashelp.class;
run;

data school;
input stud_id;
cards;
;
run;

FILENAME myemail2 EMAIL  to=("abc@yahoo.com" )
 Subject = "count check";

data _null_;
file myemail2;
Put "Total number of records in dataset class=" & 19;
Put "Total number of records in dataset school=" & 0;
run;

Re: How to display dataset record in email template

Quentin — Mon, 07 Aug 2017 16:34:37 GMT

Can you show how yout tried, with macros?

I would expect the sample code you posted to throw an error, caused by the & outside of the quoted text. But if you put the counts inside the quotes it should work fine, e.g.:

9    data _null_;
10   Put "Total number of records in dataset class=19";
11   Put "Total number of records in dataset school=0";
12   run;

Total number of records in dataset class=19
Total number of records in dataset school=0

Re: How to display dataset record in email template

Abraham — Mon, 07 Aug 2017 17:01:04 GMT

This is just an example I have given. I don't want to write manually. How to write the code such that it will display the exact line in email template.

Re: How to display dataset record in email template

Quentin — Mon, 07 Aug 2017 17:42:57 GMT

So you have the emailing part working like you want?

If so, then I would probably use a function-style macro that returns a count of the number of records in a dataset, see e.g. http://www2.sas.com/proceedings/sugi26/p095-26.pdf .

With that, you should be able to get what you want with something like:

data _null_ ;
  file myemail2 ;
  put "Total number of records in dataset class= %countobs(class)" ;
  put "Total number of records in dataset school=%countobs(school)" ;
run ;

Re: How to display dataset record in email template

Abraham — Wed, 09 Aug 2017 04:31:52 GMT

Thanks for the information.

I use the suggested code but the email body do not resolve the code. It displays like below

Total number of records in dataset class= %countobs(class) Total number of records in dataset school=%countobs(school)

Re: How to display dataset record in email template

Quentin — Wed, 09 Aug 2017 10:27:09 GMT

Did you define a macro named %countobs() before you ran that code? That is the first step. The paper I linked to has an example. You need to compile the macro first.

Re: How to display dataset record in email template

DaveHorne — Wed, 09 Aug 2017 18:45:12 GMT

Using the original code, add a check for the automatic variable &sysnobs (which captures the number of obs processed in that data step). I tweaked the subject so you can also see the counts in the subject without opening the message:

data class;                                                                                                                             
set sashelp.class;                                                                                                                      
run;                                                                                                                                    
%let obs_class=&sysnobs;                                                                                                                
                                                                                                                                        
data school;                                                                                                                            
input stud_id;                                                                                                                          
cards;                                                                                                                                  
;                                                                                                                                       
run;                                                                                                                                    
%let obs_school=&sysnobs;                                                                                                               
                                                                                                                                        
FILENAME myemail2 EMAIL  to=("abc@yahoo.com" )                                                                                          
 Subject = "count check: class=&obs_class school=&obs_school";                                                                          
                                                                                                                                        
data _null_;                                                                                                                            
file myemail2;                                                                                                                          
Put "Total number of records in dataset class=&obs_class";                                                                              
Put "Total number of records in dataset school=&obs_school";                                                                            
run;

Re: How to display dataset record in email template

Abraham — Fri, 11 Aug 2017 07:00:22 GMT

Thanks for the solution