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
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);
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;
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.
Find more tutorials on the SAS Users YouTube channel.