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>
Content-Type: text/plain; charset="iso-8859-1"
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.