Special characters in names

[RameshReddy]

Hi,

can any one help me out on this

one datastet is there with names column

names

ramesh S/o bhoomareddy

w/o ramesh

sony d/o suresh

ramesh alias don

so from this i want to  retrive name  before special characters like S/o, W/o, alias

Thanks in advance

[kassimorra]

Hello,

For you use special names, you have to put it inside single commas and N at the end.

Ex:  'rammesh S/o bhoomareddy'n.

Here is an example with your names.

data teste;

        'ramesh S/o bhoomareddy'n = 1;

        'w/o ramesh'n = 2;

        'sony d/o suresh'n = 3;

        'ramesh alias don'n = 4;

run;

proc sql;

    select 'w/o ramesh'n from teste;

quit;

Tell me if it works !

Regards,

Kassim

[art297]

It would help if you provide the way you want the resulting file to look.