Date:         Thu, 18 Apr 2002 12:54:54 -0400
Reply-To:     James Blaha <jblaha@PACE.EDU>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         James Blaha <jblaha@PACE.EDU>
Organization: Pace University
Subject:      PROC SQL and Compressing a field to create another field
Content-Type: text/plain; charset="iso-8859-1"

Hello Everyone:



I'm looking for some help with PROC SQL and compressing a field to create
another field.



Current Table has one field called 'CODES'



CODES is Character with a length of 8



CODES

000 0100

000 0227

000 0300

000 0930



Desired result is a table with 2 variables having the same observation
without the space in column2 for the variable 'CODES2'.



Obs            CODES     CODES2

1          000 0100   0000100

2          000 0227   0000227

3          000 0300   0000300

4          000 0930   0000930



Thanks,

James Blaha