topic Reg:Deleting the obs (Any Tuncate in SAS) in SAS Programming

Reg:Deleting the obs (Any Tuncate in SAS)

sas_Forum — Mon, 09 Jan 2012 06:57:38 GMT

deleteing the obs

Hi I am having 5 crores obs obs with 80 variables i want to delete the obs.I have tryed
delete * from but it was taking more time.

I have tryed

data want;
set want(obs=0);
run;

it works but is there any alternate to delete the obs from the table at once
as truncate table.

Is there any thing like truncate table in sas

Reg:Deleting the obs (Any Tuncate in SAS)

Ksharp — Mon, 09 Jan 2012 09:03:19 GMT

Did you want to create a null table without any one obs?

proc sql;

create table want like sashelp.class;

quit;

Ksharp

Reg:Deleting the obs (Any Tuncate in SAS)

sas_Forum — Mon, 09 Jan 2012 09:55:59 GMT

No Actually is there any thing to delete all the observations in a table .in a tabale i am having 5 crores of data

so i want to delete them at once how can i do .

Reg:Deleting the obs (Any Tuncate in SAS)

FriedEgg — Mon, 09 Jan 2012 15:09:04 GMT

So, you want to delete all 50 million rows from the dataset, leaving the same dataset containing no rows?

data foo;

input foo;

cards;

;

run;

proc sql;

create table foo like foo;

quit;

Re: Reg:Deleting the obs (Any Tuncate in SAS)

Patrick — Tue, 10 Jan 2012 03:28:19 GMT

Your data step code looks o.k. to me. You could also code it like:

data want;
stop;

set want;
run;

The SQL delete * takes more time because it's actually not truncating the table but only marking rows for deletion - so it has to process all rows AND the table keeps its size.

Re: Reg:Deleting the obs (Any Tuncate in SAS)

Linlin — Tue, 10 Jan 2012 04:13:42 GMT

data foo;

if _n_=0 then set foo;

stop;

run;

Linlin

Re: Reg:Deleting the obs (Any Tuncate in SAS)

Ksharp — Tue, 10 Jan 2012 05:21:42 GMT

As Patrick said. It will waste you lots of time.

But there is another statement to delete all obs in a table.

data class;
 set sashelp.class;
 label sex='gender';
 format weight dollar12.;
run;

proc sql;
 delete * from class;
quit;

Ksharp