topic Re: Scan Function in SAS Programming

Scan Function

sarahsasuser — Mon, 17 Jun 2013 20:49:49 GMT

Hi All,

I have a data field that I need to split into two new fields. The field is a building code and then name of that building. Example: ID_Number= 1 Bond Street Building

I've been using this code to extract the ID_number:

do while(scan(ID_Number, i, " "));

new_id=scan(LID_Number, i, " ");

output;

i+1;

end;

That code gives me a new_id field of 1. How do I get "Bond Street Building" into another field?

Thanks,

Sarah

Re: Scan Function

LinusH — Mon, 17 Jun 2013 20:57:43 GMT

There have been plenty of questions of this sort on the forum. Pls use the search facility to get your answer.

Re: Scan Function

Reeza — Mon, 17 Jun 2013 21:09:33 GMT

Look at the scan function modifiers, specifically 'ka'

SAS(R) 9.2 Language Reference: Dictionary, Fourth Edition

Re: Scan Function

sarahsasuser — Tue, 18 Jun 2013 14:09:58 GMT

Thanks Reeza, I'm unable to get that to work either. Is there a second step I'm missing? I've tried the following and the field NewName is not populated.

NewName=compress(ID_Number,,'ka');

NewName=scan(LDMS_ID_Number,2," ","ka");

NewName=scan(ID_Number," ","ka");

NewName = PRXCHANGE('s/[^a-zA-Z]//o',-1,ID_Number);

Re: Scan Function

Astounding — Tue, 18 Jun 2013 14:41:52 GMT

One possibility:

field1 = scan(id_number, 1, ' ');

field2 = substr(id_number, 2 + length(field1));

Scan is good for getting the first field, but not as good at getting the second field because that one contains multiple words.

Good luck.

Re: Scan Function

sarahsasuser — Tue, 18 Jun 2013 14:44:06 GMT

Thank you, that was exactly what I was looking for.