topic Re: need a help in sas function in SAS Programming

need a help in sas function

Ashwini — Tue, 27 Mar 2012 10:09:14 GMT

how to split a variable with sas function

var=hello,how r you,I am fime

I have to code like this

var1=sasfunction(var,'delemiter',position)

Kindly help me which function I have to use.

Regards,
Ashwini

manojinpec — Tue, 27 Mar 2012 11:18:51 GMT

you can use scan function.

Haikuo — Tue, 27 Mar 2012 11:27:45 GMT

If you don't mind (var,position,'dlm') instead of (var,'dlm', position), then scan() is your friend.

kuridisanjeev — Thu, 25 Oct 2012 13:42:43 GMT

Hi Ashwini..

In this way you can use Scan function.....

data test;

var="hello,how r you,I am fime";

var1=scan(var,1, ' , ');

var2=scan(var,2, ' , ');

var3=scan(var,3, ' , ');

run;

Thanks & Regards..

Sanjeev.K