Date:         Mon, 10 Jul 2006 14:24:34 -0400
Reply-To:     Sigurd Hermansen <HERMANS1@WESTAT.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Sigurd Hermansen <HERMANS1@WESTAT.COM>
Subject:      Re: A DATA MANUPULATION QUESTION WITH SPACE ISSUE
Comments: To: Rathindronath <mehedisas@YAHOO.COM>
In-Reply-To:  <200607101808.k6AI1o4u006017@mailgw.cc.uga.edu>
Content-Type: text/plain; charset="us-ascii"

Rathindronath:
The LEFT() function will eliminate leading blanks in a column variable
of character type. For example,
x=LEFT(x);

Sig

-----Original Message-----
From: owner-sas-l@listserv.uga.edu [mailto:owner-sas-l@listserv.uga.edu]
On Behalf Of Rathindronath
Sent: Monday, July 10, 2006 2:08 PM
To: SAS-L@LISTSERV.UGA.EDU
Cc: Md Alam
Subject: A DATA MANUPULATION QUESTION WITH SPACE ISSUE


I have  a following SAS dataset ( so no input statement, I will use only
set statement to read the dataset ) :

var1         var2            varr3
____         ____           ______
MISSING        YES             0
   MISSING        NO         1
NOT MISSING       YES             5
      MISSING  NO              2


I need a result  where all the values of variables starts
at the begining of the column so when later on I use Proc compare it has
n0 error.


Result
-------
var1         var2            varr3
____         ____           ______
MISSING      YES            0
MISSING      NO             1
NOT MISSING  YES            5
MISSING      NO             2