topic Parsing a file in SAS Procedures

Parsing a file

Logie — Wed, 07 Dec 2016 21:20:01 GMT

I have:

National_Code	National_Title	Superseded_By_Code
RVE20104	Diploma of Aeronotics	AZC20210, AZC20110
TTE30803	Diploma of Aeronotics	AZC30110, AZC32010

I want:

National_Code	National_Title	Superseded_By_Code
RVE20104	Diploma of Aeronotics	AZC20210
RVE20104	Diploma of Aeronotics	AZC20110
TTE30803	Diploma of Aeronotics	AZC30110
TTE30803	Diploma of Aeronotics	AZC32010

Can you please write me some code in SAS SQL or BASE SAS?

Many thanks

Gwin

Re: Parsing a file

ballardw — Wed, 07 Dec 2016 22:16:14 GMT

data want; 
   set have;
   temp=superseded_by_code;
   superseded_by_code= scan(temp,1);
   output;
   superseded_by_code= scan(temp,2);
   output;
   drop temp;
run;

@Astounding's approach is more flexible if you have more than 2 codes to split out.

Re: Parsing a file

Astounding — Wed, 07 Dec 2016 21:46:14 GMT

Within a DATA step:

data want;

set have;

do _n_=1 to countw(Superseded_by_Code);

new_code = scan(Superseded_by_Code, _n_);

output;

end;

drop Superseded_by_Code;

rename new_code=Superseded_by_Code;

run;

Re: Parsing a file

Logie — Fri, 09 Dec 2016 19:41:58 GMT

Thank you very much 🙂