I think you are close Joe, but i accidentally left out one other scenario that this needs to accomodate.

v43.12 join to v43.12

I think converting these to numbers caused errors with the alpha based codes.

Any other work around?

-----Original Message----- From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Joe Matise Sent: Wednesday, September 21, 2011 12:51 PM To: SAS-L@LISTSERV.UGA.EDU Subject: Re: Join function

You mean join records that have 170.0 to 170?

proc sql; create table c as select * from a,b where input(a,BEST12.) = input(b,BEST12.); quit;

should work... just convert them to numbers on the fly.

-Joe

On Wed, Sep 21, 2011 at 11:24 AM, Adams, Nicholas <NRAdams@cvty.com> wrote:

> Is there a function I can use in Proc SQL that will allow me to join > these character values together? I think I need something to get rid > of any trailing or leading zeros. > > 170.0 join to 170 > 041.12 join to 41.12 > 363.40 join to 363.4 > > > Thank you! > > Nick > > > Email Confidentiality Notice: The information contained in this > transmission is confidential, proprietary or privileged and may be > subject to protection under the law, including the Health Insurance > Portability and Accountability Act (HIPAA). > > The message is intended for the sole use of the individual or entity > to whom it is addressed. If you are not the intended recipient, you > are notified that any use, distribution or copying of the message is > strictly prohibited and may subject you to criminal or civil > penalties. If you received this transmission in error, please contact

> the sender immediately by replying to this email and delete the material from any computer. >

Email Confidentiality Notice: The information contained in this transmission is confidential, proprietary or privileged and may be subject to protection under the law, including the Health Insurance Portability and Accountability Act (HIPAA).

The message is intended for the sole use of the individual or entity to whom it is addressed. If you are not the intended recipient, you are notified that any use, distribution or copying of the message is strictly prohibited and may subject you to criminal or civil penalties. If you received this transmission in error, please contact the sender immediately by replying to this email and delete the material from any computer.