topic Re: How to move specific word to new column in sas in SAS Enterprise Guide

How to move specific word to new column in sas

jati — Fri, 21 Oct 2022 06:25:14 GMT

I'm new in sas, I need help how to move specific word to new column in sas, with the data below :

address :

TEGALASEM RT 005 RW 003 KEL SUMBERGONDO KEC BUMIAJI

CEMARA BARU III F 512 RT 009 RW 017 KEL JATIMULYA KEC TAMBUN SELATAN

JL LIGAR TIMUR 1 NO 1 RT 01/13 KEL CIBEUNYING

result :

KEL : KEC :

SUMBERGONDO BUMIAJI

JATIMULYA TAMBUN SELATAN

CIBEUNYING

Re: How to move specific word to new column in sas

PeterClemmensen — Fri, 21 Oct 2022 06:39:23 GMT

What is the logic here?

Re: How to move specific word to new column in sas

jati — Fri, 21 Oct 2022 07:20:16 GMT

if "KEL" in the address then move to the KEL column

if the "KEC" in the address then move to the KEL column

Data :

no	address
1	TEGALASEM RT 005 RW 003 KEL SUMBERGONDO KEC BUMIAJI
2	CEMARA BARU III F 512 RT 009 RW 017 KEL JATIMULYA KEC TAMBUN SELATAN
3	JL LIGAR TIMUR 1 NO 1 RT 01/13 KEL CIBEUNYING

Result

NO	KEL	KEC
1	SUMBERGONDO	BUMIAJI
2	JATIMULYA	TAMBUN SELATAN
3	CIBEUNYING

Re: How to move specific word to new column in sas

Kurt_Bremser — Fri, 21 Oct 2022 07:31:57 GMT

Use the FINDW Function with the "e" modifier to see if the KEL or KEC is present, then extract the following word with SCAN.

Re: How to move specific word to new column in sas

Ksharp — Fri, 21 Oct 2022 11:46:14 GMT

data have;
input have $80.;
cards;
TEGALASEM RT 005 RW 003 KEL SUMBERGONDO KEC BUMIAJI
CEMARA BARU III F 512 RT 009 RW 017 KEL JATIMULYA KEC TAMBUN SELATAN
JL LIGAR TIMUR 1 NO 1 RT 01/13 KEL CIBEUNYING
;
data want;
 set have;
 pid=prxparse('/(KEL\s+\w+\s+)(KEC[\w\s]+)?/i');
 if prxmatch(pid,have) then do;
   kel=left(substr(prxposn(pid,1,have),4));
   kec=left(substr(prxposn(pid,2,have),4));
 end;
drop pid;
run;

Re: How to move specific word to new column in sas

jati — Tue, 25 Oct 2022 06:27:39 GMT

thank you its working