Date:         Fri, 30 Aug 2002 09:29:53 -0400
Reply-To:     Asheber Sewalem <sewalem@CDN.CA>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Asheber Sewalem <sewalem@CDN.CA>
Subject:      Diagnosis
Comments: To: SAS-L@LISTSERV.VT.EDU
Content-Type: text/plain; charset="iso-8859-1"

Hi all,

In one data set there are  more than two million records ( has unique
id) with different record length.
 the minimum record length is 70
 the maximum record length is 1115
 the number of variables are 138

Some records may have 100 variables others may have 150  and so on.
There is a missing variable (.) in one ore more of the records as
complained by another program.

How can I find out those missing records in this data set?

To give  you an example,
Assume that record 1 has three variables and record 2 has five variables

id    v1  v2 v3  v4  v5
123   25  26 27
124   32  36 37  .  35

I just want to find the missing value(. for v4)) in record 2(id=124). In
record  1 (id=123) since it has only three variables the remaining
variables will have blank space.

Any help is highly appreciated.

Asheber