Date:         Mon, 24 Oct 2005 07:27:57 -0400
Reply-To:     "Richard A. DeVenezia" <radevenz@IX.NETCOM.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Richard A. DeVenezia" <radevenz@IX.NETCOM.COM>
Subject:      Re: SAS data file - Number of Cases
Comments: To: sas-l@uga.edu

Hari wrote:
> Hi,
>
> I downloaded a data file from UCLA web-site
> "http://www.ats.ucla.edu/stat/sas/webbooks/reg/elemapi2.sas7bdat" and
> when I loaded it in to SAS and looked up the number of rows it
> displays as 406 (another time it said 388). On the other hand Proc
> Contents and proc Univariate say that there are 400 rows.
>
> I opened the same file in SPSS and it was showing 400 rows only.
>
> Why is there a difference between View table option in SAS and the
> rest?

I find the same peculiar traits!  In VIEWTABLE I see a last row with row
label "403".  In FSVIEW it is either 403 or 374.  The same behavior is
observed when accessing the data through engine V7.

While in view table, scrolling down to the last row causes it to 'lose the
rows'.  There must be a byte or two out of place somewhere in the file.
Create a copy of the data using a data step and the issue should disappear.
You might want to notify UCLA, or provide the table to SAS technical support
for a more thorough examination -- the symptons indicate some bug fix or
check could/should eventually be made.

--
Richard A. DeVenezia
http://www.devenezia.com/