Andre,

From the documentation:  "Note: For PROC SQL tables, SAS deletes the data in
the rows but retains the space in the table."

Art
-------
On Thu, 19 Nov 2009 14:20:11 -0800, Andre <andre.dalet@GMAIL.COM> wrote:

>On Nov 20, 3:31 am, 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
>
>Protection
>Compressed            NO
>                 Data Set
>Type
>Sorted                NO
>
> File Size (bytes)           17260544
>=================
>
>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
>
>Protection
>Compressed            NO
>                 Data Set Type
>
>Sorted                NO
>    File Size (bytes)           17260544
>
>===============================
>
>Thanks for your time everyone.
>
>
>
>
>Andre

On Nov 20, 11:40=A0am, art...@NETSCAPE.NET (Arthur Tabachneck) wrote:
> Andre,
>
> From the documentation: =A0"Note: For PROC SQL tables, SAS deletes the da=
ta in
> the rows but retains the space in the table."
>
> Art
> -------
>

Thanks Art.
I'll scratch that one from my list of 'How To Save Space' tricks.


Andre

On Nov 19, 7:54=A0pm, Andre <andre.da...@gmail.com> wrote:
> On Nov 20, 11:40=A0am, art...@NETSCAPE.NET (Arthur Tabachneck) wrote:
>
> > Andre,
>
> > From the documentation: =A0"Note: For PROC SQL tables, SAS deletes the =
data in
> > the rows but retains the space in the table."
>
> > Art
> > -------
>
> Thanks Art.
> I'll scratch that one from my list of 'How To Save Space' tricks.
>
> Andre

Andre,

I am going to walk on a few eggshells here but you need to recreate
the dataset to reflect the changes. Marking something is one thing but
recreating metadata and layout is entirely separate. What you see is
entirely reasonable IMO.

Alan
http://www.savian.net