topic Re: Help on SAS Functions in SAS Programming

Help on SAS Functions

KannanBaskar — Thu, 23 Oct 2014 14:43:19 GMT

Hi All,

Hope everyone doing good.

I would like to have some idea on the below situtaion which i have come accross recently. I have dataset called Hospitals which contain the hospital_name variable and it is having the data as mentioned below. I need to remove the country name in the every records. Please find the example below.

Obs Hopspital_Name

1 INDIA - ABC HEALTHCARE

2 CHINA - EFF HEALTHCARE

3 USA - GHI HEALTHCARE

4 UK - KLK HEALTHCARE

5 -

6 -

210 SPAIN-XYZ Healthcare.

Can you please help me how to trim the country name for 210 countries

Thanks,

Kannan

Re: Help on SAS Functions

RW9 — Thu, 23 Oct 2014 14:46:00 GMT

Hi,

data want;

set have;

name_of_hospital=substr(hospital_name,index(hospital_name,"-")+1);

run;

Re: Help on SAS Functions

stat_sas — Thu, 23 Oct 2014 14:55:47 GMT

data want;

set have;

Hopspital_Name=scan(Hopspital_Name,2,'-');

run;

Re: Help on SAS Functions

GeorgeT — Fri, 24 Oct 2014 07:59:04 GMT

Despite there already being two perfectly good answers, here is a third, possibly slighlty more cryptic and possibly slightly more flexible.

data want

set have;

Hospital_Name=prxchange('s/^.+-\s//'1,Hospital_Name);

run;

I think prxchange was introduced in SAS9.

Re: Help on SAS Functions

KannanBaskar — Tue, 04 Nov 2014 12:04:35 GMT

Thanks George for your answers,

I have another query on the same issues. I just need to remove '-' if hospital name contain any country name. Please see the dataset below.

Obs Hopspital_Name

1 INDIA - ABC HEALTHCARE

2 CHINA - EFF HEALTHCARE

3 USA - GHI HEALTHCARE

4 UK - KLK HEALTHCARE

5 HAPPY - HEALTHCARE

6 WELL - HEALTHCARE

7 WEALTH - HEALTHCARE

8 FREE - HEALTHCARE

. .

1800 AUS - HEALTHCARE

i look forwared hear from you.

Thanks in Advance,

Kannan B.

Re: Help on SAS Functions

RamKumar — Tue, 04 Nov 2014 12:45:39 GMT

you can use compress function to remove '-'.

Re: Help on SAS Functions

RW9 — Tue, 04 Nov 2014 13:12:01 GMT

Hi,

To clarify, what do you want the output to be as whilst you can use the compress function as RamKumar has mentioned you also need to know if a country is in the first part. Do you have some kind of list in place to identify all different spellings of country? If so then:

proc sql;

create table WANT as

select OBS,

case when scan(HOSPITAL_NAME,2,'-') in (select distinct COUNTRY from WORK.LIST_OF_COUNTRIES) then

compress(HOSPITAL_NAME,"-")

else HOSPITAL_NAME end as HOSPITAL_NAME

from HAVE;

quit;

Re: Help on SAS Functions

art297 — Tue, 04 Nov 2014 14:59:05 GMT

Are you just trying to do something like?:

data have;

format Hospital_Name $80.;

input Hospital_Name 1-80;

if countw(scan(Hospital_Name,2,'-')) eq 1 then

Hospital_Name=compress(Hospital_Name,'-');

else Hospital_Name=scan(Hospital_Name,2,'-');

cards;

INDIA - ABC HEALTHCARE

CHINA - EFF HEALTHCARE

USA - GHI HEALTHCARE

UK - KLK HEALTHCARE

HAPPY - HEALTHCARE

WELL - HEALTHCARE

WEALTH - HEALTHCARE

FREE - HEALTHCARE

AUS - HEALTHCARE

;