Date:         Mon, 20 Oct 2008 17:45:09 -0500
Reply-To:     Mary <mlhoward@avalon.net>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Mary <mlhoward@AVALON.NET>
Subject:      Re: Which Function to use
Comments: To: Pareen Patel <mditconsult@GMAIL.COM>
Content-Type: text/plain; format=flowed; charset="iso-8859-1";
              reply-type=original

I'm not sure how UK postal codes go, but you could certainly split the
fields using the scan function:

  part1 = scan(postcode, 1, ' ') ;
  part2     = scan(postcode, 2, ' ') ;

Then you'd want to work on finding the number in the part2 variable.

-Mary



----- Original Message -----
From: Pareen Patel
To: SAS-L@LISTSERV.UGA.EDU
Sent: Monday, October 20, 2008 5:18 PM
Subject: Which Function to use


Suppose i have UK post codes like this ....

For e.g. Ist part of code is HA3 and 2nd part of Code is 9SF.

HA3 9SF
NW10 1UV
A10 7EU
N9 14UX

Which function i could use so i get the Whole 1st part and Numeric from the
2nd part like below

HA3 9
NW10 1
A10 7
N9 14....

Thanks
Pareen