Date:         Thu, 30 Mar 2000 09:55:18 +0200
Reply-To:     Jim Groeneveld <J.Groeneveld@ITGROUPS.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Jim Groeneveld <J.Groeneveld@ITGROUPS.COM>
Subject:      Re: HOW TO READ
Comments: To: "gspatel@pepco.com" <gspatel@pepco.com>
Content-Type: text/plain; charset="iso-8859-1"

Girish,

Still strange, how did you get those data? It does not seem impossible to
read the valid parts. Just specify the field(s) (variable(s)) you want to
read in a regular INPUT statement and that is all. After reading a record's
field the remaining of the record will be skipped and the next record will
be read automatically. And if even the field(s) that you read sometimes do
contain invalid data (for which you would have to test, using some invalid
patterns) you might assign those data a missing value (space) or delete the
entire record.

I hope this solves your problem.

Regards - Jim.
--
Y. Groeneveld, MSc            IMRO TRAMARKO       tel. +31 412 407 070
senior statistician,          P.O. Box 1          fax. +31 412 407 080
head IT department            5350 AA BERGHEM     IMRO TRAMARKO: a CRO
J.Groeneveld@ITGroups.com     the Netherlands     in clinical research

My computer seems more ²°°°-compatible than I am myself.


> -----Original Message-----
> From: gspatel@pepco.com [SMTP:gspatel@pepco.com]
> Sent: Wednesday, March 29, 2000 6:03 PM
> To:   Jim Groeneveld
> Cc:   SAS-L@LISTSERV.UGA.EDU
> Subject:      Re: HOW TO READ
>
>
> Thanks, Jim :
> I am using MVS TSO 6:09
> ((((
> Welcome to the SAS Information Delivery System!
>     ======  Version 6.09 Enhanced  ======   ))))
>
> Data has either ascii characters (e.g John Doe) OR  characters like shown
> below.
>
> THIS IS MY DATA LOOK LIKES....
>
> INITIAL          NAME
>
>   AXX               ( ( (
>   ADP       & & & &
>   ALL               ( ( (
>   CBY
>   CEA       & & & &
>   CIY
>   C         h ( d
>   DAP
>   DLL
>   DRJ       ! ! ! !
>   GW        & & & &
>   JTL       & & & &
>   NVA       & & & &
>   OEO       & & & &
>   PA0       K K K K
>
>
> SO, WHEN I USE HEX ON IT GIVES ME SCREEN LIKE
>
> -4----+----5----+----6----+---
> > -F----+----F----+----F----+---
> > -4----+----5----+----6----+---
> > ------------------------------
> >          ( ( (
> > 060606060404040044444444
> > 040404040D0D0D000000000
> > ------------------------------
>