topic Re: URGENT - Need to split and arrenge in required format - in SAS in SAS Programming

URGENT - Need to split and arrenge in required format - in SAS

sas_lak — Wed, 23 Dec 2015 06:31:33 GMT

Hi Everyone,

I need help on below requirement.

I have list of Names in dataset, Name contains multiple tokens separated by space.

Need to split name field and arrenge in proper format.

Ex- Input data.

Sl No	Company Name
1	NSDL PVT LTD
2	CIBIL INDIA LIMITED
3	EQUIFAX INTERNATIONAL LTD
4	HIGMMARK PRIVATE LIMITED
5	EXPERIAN LTD

Out put should be :-

Sl No	TOKEN
1	NSDL
1	PVT
1	LTD
2	CIBIL
2	INDIA
2	LIMITED
3	EQUIFAX
3	INTERNATIONAL
3	LTD
4	HIGHMARK
4	PRIVATE
4	LIMITED
5	EXPERIAN
5	LTD

Thanks in Advance...!

Re: URGENT - Need to split and arrenge in required format - in SAS

Ksharp — Wed, 23 Dec 2015 07:02:21 GMT

data have;
infile cards truncover expandtabs;
input SlNo	CompanyName $40.;
cards;
1	NSDL PVT LTD
2	CIBIL INDIA LIMITED
3	EQUIFAX INTERNATIONAL LTD
4	HIGMMARK PRIVATE LIMITED
5	EXPERIAN LTD
;
run;
data want;
 set have;
 do i=1 to countw(CompanyName,' ');
  token=scan(CompanyName,i);output;
 end;
 drop i;
run;

Re: URGENT - Need to split and arrenge in required format - in SAS

sas_lak — Mon, 28 Dec 2015 03:57:01 GMT

Thank you..!