topic Re: Reduce size table in New SAS User

Reduce size table

jorquec — Fri, 20 Sep 2019 15:39:57 GMT

Hi,

Could anyone please help?

It is a simple code to delete rows from a sas table, however my objective with this is to decrease the size of table because I will use the size later as a schedule on SAS Management.

However despite of this code delete rows the size table keeps always the same .

Many thanks in advance .

proc sql;
delete from  sasmf.TRIGGERPAYTEST;
  quit;

Re: Reduce size table

tomrvincent — Fri, 20 Sep 2019 15:43:12 GMT

your code will delete all records. Use compress to lower the size (not guaranteed).

Re: Reduce size table

jorquec — Fri, 20 Sep 2019 15:44:36 GMT

Compress?
How?
proc sql;
delete from sasmf.TRIGGERPAYTEST;
compress;
quit;

Re: Reduce size table

Tom — Fri, 20 Sep 2019 15:48:38 GMT

All you did was mark the observations as deleted.

Why not just re-create the dataset?

Re: Reduce size table

jorquec — Fri, 20 Sep 2019 15:55:19 GMT

Sorry I can not re create the file because I lost the rights . My only option is change the size.

Re: Reduce size table

SASKiwi — Sun, 22 Sep 2019 01:55:47 GMT

Using this DATA step with the COMPRESS option will compress your dataset and remove all rows:

data sasmf.TRIGGERPAYTEST (compress = yes);
  sasmf.TRIGGERPAYTEST (obs= 0);
run;

BTW does sasmf mean this a mainframe SAS data library? What OS does SAS run on?

Re: Reduce size table

Ksharp — Sat, 21 Sep 2019 11:47:08 GMT

data sasmf.TRIGGERPAYTEST;
 set sasmf.TRIGGERPAYTEST;
 stop;
run;