topic Re: Get deleted information in SAS Programming

Get deleted information

BrahmanandaRao — Wed, 14 Apr 2021 08:39:00 GMT

how to get deleted information which observation is deleted and which variable is deleted in a library

proc sql;
delete from work.sashelp.class
where name='Alfred'
;
quit;

Re: Get deleted information

andreas_lds — Wed, 14 Apr 2021 09:09:22 GMT

By selecting the obs with a separate select-statement before the delete-statement.

Re: Get deleted information

Kurt_Bremser — Wed, 14 Apr 2021 09:59:45 GMT

Or you do

data
  kept
  deleted
;
set have;
if <condition>
then output kept;
else output deleted;
run;

Re: Get deleted information

sbxkoenk — Wed, 14 Apr 2021 10:58:20 GMT

Ah OK, @Kurt_Bremser ,

I thought the questioner was after finding out how many and which observations were logically deleted (and NOT physically deleted).

But I guess you're program is offering what (s)he is looking for.

Cheers,

Koen

Re: Get deleted information

Kurt_Bremser — Wed, 14 Apr 2021 11:02:12 GMT

Since (s)he provided garbage as example (untested code that can never run), and not a "have" vs. "want" dataset, it's hard to get what the question is about.

Re: Get deleted information

BrahmanandaRao — Wed, 14 Apr 2021 12:57:42 GMT

I want deleted information in a library
Which obs and which var deleted for each dataset

Re: Get deleted information

Kurt_Bremser — Wed, 14 Apr 2021 13:03:55 GMT

The deleted observations in a dataset can be found in DICTIONARY.TABLES.

To find out if a variable is not present in a dataset, you have to compare it with another dataset. The data for both can be found in DICTIONARY.COLUMNS.

Re: Get deleted information

ballardw — Wed, 14 Apr 2021 17:19:47 GMT

@Kurt_Bremser wrote:

The deleted number of observations in a dataset can be found in DICTIONARY.TABLES.

To find out if a variable is not present in a dataset, you have to compare it with another dataset. The data for both can be found in DICTIONARY.COLUMNS.

I believe my correction above is what was intended.

Re: Get deleted information

ballardw — Wed, 14 Apr 2021 17:22:45 GMT

@BrahmanandaRao wrote:
I want deleted information in a library
Which obs and which var deleted for each dataset

Will only be possible if you have a "before" and "after" data set or if using data set generations(essentially a before and after for the same named data set)

Proc Compare might be the tool but you will have to tell the procedure which data sets to compare. The data sets should be in the same sort order as well.