topic Special characters in names in SAS Enterprise Guide

Special characters in names

RameshReddy — Tue, 27 Sep 2011 07:55:20 GMT

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 — Tue, 27 Sep 2011 13:12:12 GMT

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 — Tue, 27 Sep 2011 13:17:05 GMT

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