topic Re: Create Multiple Files Conditionally in SAS Programming

Create Multiple Files Conditionally

sasmaverick — Thu, 05 Mar 2015 11:24:05 GMT

I have the below dataset:

Name

Jack Chirikjian

Dean Rosenthal

John Adams

I need a code which will conditionally create text (tab delimited files), each containing the names.

E.g: File1.txt

Jack Chirikjian

File2.txt

Dean Rosenthal

File3.txt

John Adams

Also, I need to email these files as attachments to their respective emails. Eg Jack will get an email with file1.txt, Dean will get with File2.txt and so on. (assume I have the emails addresses)

Greatly appreciate the inputs.

Re: Create Multiple Files Conditionally

Kurt_Bremser — Thu, 05 Mar 2015 11:48:46 GMT

data _null_;

file "filex.txt" filevar=filnam; * filex.txt is just a placeholder;

set have;

by name;

retain counter 0;

if first.name

then do;

counter + 1;

filnam = 'file' !! trim(put(counter,3.)) !! '.txt';

end;

put name;

run;

Re: Create Multiple Files Conditionally

Jagadishkatam — Thu, 05 Mar 2015 13:03:41 GMT

consider that you have the email address as well in the dataset. Then this code should be helpful

data have;

input Name &$30. email :$20.;

cards;

Jack Chirikjian jag@gmail.com

Dean Rosenthal de@gmail.com

John Adams jo@gmail.com

;

proc sql;

select distinct name, email into : name1-:name&sysmaxlong, :email1-:email&sysmaxlong from have;

quit;

%put &name1 &name2 &email2;

%macro email;

%do i = 1 to 3;

DATA _NULL_;

set have;

where name="&&name&i";

FILE '~\&&file&i.txt';

PUT name;

RUN;

FILENAME MailBox EMAIL "&&email&i"

SUBJECT='Mail message with txt attachment'

attach="~\&&file&i.txt";

data _null_;

file mailbox;

put 'hi';

run;

%end;

%mend;

%email;

Thanks,

Jag

Re: Create Multiple Files Conditionally

RamKumar — Thu, 05 Mar 2015 13:20:17 GMT

Little correction on Jag's code.

It should be

%do i = 1 %to 3; *percentage symbol was missing in initial code.

Re: Create Multiple Files Conditionally

Jagadishkatam — Thu, 05 Mar 2015 13:29:06 GMT

Thanks for the correction, Ram

Re: Create Multiple Files Conditionally

sasmaverick — Thu, 05 Mar 2015 14:05:47 GMT

Thanks a lot Jagadish! Works for me!