After deleting rows, how am i going to compress the dataset? It is still 17GB albeit more than 500k rows were deleted.    I've tried this,   proc sql; create table tmp  ( COMPRESS=YES ) as ***then delete rows**** ; quit;   It worked. However, it is in work library. I want to do it directly to the dataset where I am going to delete rows/data.   Thanks, brutal3239 ... View more

Hi Tom,   Would it be okay if I message/email you our sample data?   Regards, brutal3239 ... View more

Looks like this but again, the party_key count will reset to 0,1,2,3 so on so forth. I want to retain the party_key index.   proc sql; create table tmp as select * from core.transaction_table where month_key <= 201201 ; quit;     ... View more

As mentioned, it is a sas dataset.  I would like to know how to delete rows w/o affecting the indexes? ... View more

Let say I have this kind of data. Take note that account party is auto increment. ACCOUNT_PARTY NAME DATE 1 ALPHA 2017 2 BETA 2016 3 CHARLIE 2018 4 DELTA 2015 5 FOXTROT 2016 I would like to select all data where year > 2016. So that output should be like this ACCOUNT_PARTY NAME DATE 1 ALPHA 2017 3 CHARLIE 2018 However, upon opening the temporary dataset in work library, the output is like this. ACCOUNT_PARTY NAME DATE 1 ALPHA 2017 2 CHARLIE 2018 The account party resets to normal count. ... View more