Hi,
First time installation of SAS Universal Viewer on my laptop. (Windows 10 Pro, x64 system) I confirmed that I have the correct JRE and .NET versions installed.
Problem: SAS dataset (dm.sas7bdat) provided by contracted vendor will not open using SAS viewer. Error:
Vendor says the tables are opening fine for them (with full SAS install).
I downloaded a sample dataset from another source (alcohol.sas7bdat) and was able to open it with no problem.
Any thoughts?
Thank you!
The error message says that the file is indexed, but the index is missing. SAS stores the index in a separate file. So:
Do you have a file with the extension sas7bdat and another file with the same name but extension sas7bndx?
The version of the Universal Viewer that shipped with SAS 9.4.4 is 1.42, so I don't know what version Universal Viewer 9.2 might be. If it is the viewer that shipped with SAS 9.2 you may be having an issue related to the header information change in data files from SAS 9.3 to 9.4. One of the variables in the header was increased to record more records and unless the data sets are saved with an option to disable that larger range of values then older versions of SAS cannot read the header portion of the data set.
You might request your contractor to set:
Options EXTENDOBSCOUNTER=no;
OR use the dataset option of the same name such as:
data want (extendobscounter=no); set have; run;
and recreate one of the data sets or even just a one record data set, then try opening that. If you can open the file that is the cause and all your sets from the contractor should use the option OR you need to update to a newer viewer.
I had this error, and it turns out that my SAS Universal Viewer is too old. After updating to the latest version, the error is gone. This way I don't need to do anything to the dataset. But if you only have access to an old version, then this can be a solution.
The error message says that the file is indexed, but the index is missing. SAS stores the index in a separate file. So:
Do you have a file with the extension sas7bdat and another file with the same name but extension sas7bndx?
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!
SAS' Charu Shankar shares her PROC SQL expertise by showing you how to master the WHERE clause using real winter weather data.
Find more tutorials on the SAS Users YouTube channel.