topic SAS Viewer shows less records than the SAS file has. in SAS Data Management

SAS Viewer shows less records than the SAS file has.

AndrasJonas — Thu, 17 Nov 2022 12:12:56 GMT

Dear SAS Community,

We are having an odd issue. One of the formats exported is SAS.

SAS Viewer will show displaying records 1-279 of 305 but the 26 records are never to be found.

As the data table is growing, this missing set of records is always there in the count but not viewable.
It is not due to paging, and we went through the data and could not find anything special about those.

Here is the specific example:

No matter what, that 26 difference will remain. And those records are missing from the SAS file. But oddly, it says the number of records is 305.

Any idea what could be the issue here please?

All the Best,
András

Re: SAS Viewer shows less records than the SAS file has.

AllanBowe — Thu, 17 Nov 2022 12:22:50 GMT

Perhaps they are deleted records? In datasets, deleted observations are simply marked as such, they are not physically removed unless the dataset is rebuilt.

You can test if this is the case by compiling this macro: https://core.sasjs.io/mf__getattrn_8sas_source.html

And running the following code:

%put All Observations=%mf_getattrn(YOURDATASET,NOBS);
%put Non-Deleted (Logical) Observations=%mf_getattrn(YOURDATASET,NLOBS);

Re: SAS Viewer shows less records than the SAS file has.

SASKiwi — Thu, 17 Nov 2022 20:39:13 GMT

Try running a simple DATA step to recreate the dataset. Test first by writing to a new dataset. If that fixes your problem overwrite the original dataset

data MyLib.new;
  set MyLib.old;
run;

data MyLib.old;
  set MyLib.old;
run;