topic Re: Help with SAS code which is in a loop in SAS Procedures

Help with SAS code which is in a loop

pp2014 — Fri, 26 Aug 2016 18:09:04 GMT

I am trying to read the email_list file and output only email addresses separated by semi-column. But my code goes into a loop.

Can anybody help me in this??

email_file.txt has following records:

Doe, John <john.doe@abc.com>;Smith, Jeff <jeff.smith@abc.com>; lever, dave <dave.lever@abc.com>

Below is my code:

data test;
length text $32767;

infile 'c\email_file.txt' lrecl=32767 dsd dlm='09'x truncover;

input text $;

run;

data t1;
set test;
length tx3 $500;
tx3="";
tx1=text;
do until (length(cats(tx1))=0);
space_position = INDEX(tx1, '<');
slash_position = INDEX(tx1, '>');
space_to_slash = slash_position - space_position;
tx2 = substr(tx1, space_position+1, space_to_slash-1);
tx3=cats(tx3,tx2,";");
tx4=substr(tx1,find(tx1,";")+1);
tx1=tx4;
end;
run;

Re: Help with SAS code which is in a loop

Jagadishkatam — Fri, 26 Aug 2016 18:34:58 GMT

data want;
i=1;
set have;
do until(scan(text,i,';') eq '');
new=scan(text,i,';');
i+1;
output;
end;
run;

Re: Help with SAS code which is in a loop

Ksharp — Sat, 27 Aug 2016 01:49:48 GMT

filename x temp; data _null_; file x; input; put _infile_; cards4; Doe, John ;Smith, Jeff ; lever, dave ;;;; run; data want; infile x dlm='>'; input @'<' email : $100. @@; run;

Re: Help with SAS code which is in a loop

Ksharp — Sat, 27 Aug 2016 01:55:26 GMT


filename x temp;
data _null_;
file x;
input;
put _infile_;
cards4;
Doe, John ;Smith, Jeff ; lever, dave 
;;;;
run;





data want;
 infile x  dlm='>' lrecl=32767;
 input @'<' email : $100. @@;
run;

Re: Help with SAS code which is in a loop

Jagadishkatam — Sat, 27 Aug 2016 03:52:47 GMT

if only the email id has to be retrieved then please try

data want;
i=1;
set have;
do until(scan(text,i,';') eq '');
new=compress(scan(scan(text,i,';'),2,'<'),'>');
i+1;
output;
end;
run;

Re: Help with SAS code which is in a loop

Tom — Sat, 27 Aug 2016 14:51:16 GMT

Looks like you want to take the parts inside of the <>. This code will do that and also take values that only have the email address without the name and so do not have any <>s.

You can scan the original list using ';' as the delimiter and then within each sub-string look for the values between the <> using scan function again, this time using both < and > as the delimiters.

data want;
  set test ;
  length want $32767 ;
  do i=1 to countw(text,';');
     want = catx(';',want,scan(scan(text,i,';'),-1,'<>'));
  end;
run;