Desktop productivity for business analysts and programmers

Special characters in names

Reply
Contributor
Posts: 31

Special characters in names

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

Occasional Contributor
Posts: 6

Special characters in names

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

PROC Star
Posts: 7,427

Special characters in names

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

Ask a Question
Discussion stats
  • 2 replies
  • 201 views
  • 0 likes
  • 3 in conversation