Andre,

Just out of curiosity, can you post the code you used to delete the
observations?

Art
--------
On Wed, 18 Nov 2009 19:12:56 -0800, Andre <andre.dalet@GMAIL.COM> wrote:

>On Nov 19, 12:30 pm, Tom Abernathy <tom.aberna...@gmail.com> wrote:
>> Did you remove enough observations to make a difference in the size?
>
>Yep. Reduced it from 17mb to 6mb.
>
>> SAS allocates the space in blocks that could contain multiple
>> observations.  I believe that information is included in the
>> information printed by PROC CONTENTS.
>>
>> Otherwise when you ran PROC SORT did it actually sort or did it say to
>> the effect "data already sorted so doing nothing"?  Try sorting to a
>> NEW dataset name and check the size.
>
>No. I sorted it by a different var to what it had been sorted on.
>>
>> Are you running on an IBM Mainframe?
>
>Nope. Running EG 9.1 on a dedicated server.
>
>
>
>cheers
>Andre

On Nov 20, 3:31=A0am, art...@NETSCAPE.NET (Arthur Tabachneck) wrote:
> Andre,
>
> Just out of curiosity, can you post the code you used to delete the
> observations?
>
> Art
> --------

Be warned, it's quite sophisticated...

"Proc SQL;
	Delete from save.Basedata2
	Where PIN Not in (Select distinct PIN
			        	From Step1);"

----------------

Proc Contents output prior to Delete:

                 Data Set Name
SAVE.BASEDATA2                                   Observations
164076
                 Member Type
DATA                                             Variables
17
                 Engine
V9                                               Indexes
0
                 Created              Friday, November 20, 2009
09:12:03 AM            Observation Length    104
                 Last Modified        Friday, November 20, 2009
09:12:03 AM            Deleted Observations  0
=20
Protection
Compressed            NO
                 Data Set
Type
Sorted                NO

 File Size (bytes)           17260544
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D

Proc Contents output after Delete:

                 Data Set Name
SAVE.BASEDATA2                                   Observations
44086
                 Member Type
DATA                                             Variables
17
                 Engine
V9                                               Indexes
0
                 Created              Friday, November 20, 2009
09:12:03 AM            Observation Length    104
                 Last Modified        Friday, November 20, 2009
09:17:05 AM            Deleted Observations  119990
=20
Protection
Compressed            NO
                 Data Set Type
=20
Sorted                NO
    File Size (bytes)           17260544

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D

Thanks for your time everyone.




Andre