Emailing Data From a Dataset 1

[AlboMrsP]

Hi, I've been asked if I can auto email data from a SAS data set. If it is possible, I'd need to send the data as text in the email rather than an attachment so it can be read on a Blackberry. Does anyone know how to do this? (or if it's even possible?) - I could really do with some help!!
Thanks Loads
Lyndsey

 

[mdieckman]

Yes, it's in possible. It depends on how many observations you have, but if it's only 1 or you know which (you could use firstobs = n obs = n to get the one you want. Use symput:

data _null_;
CALL SYMPUT ('var1',var1);
run;

and then use the macro variable (&var1) in your e-mail statement.

Do you know how to send an e-mail from SAS? There's code for that too if you need it.

 

[mdieckman]

Oops, sorry-

Should be:

data _null_;
set data1 (firstobs=2 obs=2);
CALL SYMPUT ('var1',var1);
run;

 

[AlboMrsP]

Thank you loads, I'll give it a go.

Think we have some code for sending an email done by a previous coder so I'll use that.

Thanks again
Lyndsey