Date:         Mon, 10 Jul 2006 18:13:17 +0000
Reply-To:     toby dunn <tobydunn@HOTMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         toby dunn <tobydunn@HOTMAIL.COM>
Subject:      Re: A DATA MANUPULATION QUESTION WITH SPACE ISSUE
Comments: To: mehedisas@YAHOO.COM
In-Reply-To:  <200607101808.k6AI1o4u006017@mailgw.cc.uga.edu>
Content-Type: text/plain; format=flowed

Covert one from Numeric to Character or you could try the opposite and
convert those that should be numeric but are held as character to numeric.





Toby Dunn





From: Rathindronath <mehedisas@YAHOO.COM>
Reply-To: Rathindronath <mehedisas@YAHOO.COM>
To: SAS-L@LISTSERV.UGA.EDU
Subject: A DATA MANUPULATION QUESTION WITH SPACE ISSUE
Date: Mon, 10 Jul 2006 14:08:19 -0400

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