unable to open any dataset in SAS Studio

Ajayvit — Mon, 14 Aug 2023 04:41:16 GMT

Hi Team,

I have couple of datasets and they are appearing in SAS Studio library "A". But they are not opening.

While opening I am getting error message.

ERROR: Tables with 0 columns are not supported bu this object.

My code is:

libname a 'path\SDTM datasets';

options nofmterr;

data test;
set a.ae(encoding=ascii);
run;

Re: unable to open any dataset in SAS Studio

ballardw — Mon, 14 Aug 2023 05:14:31 GMT

Let's try a simper test.

Run this code:

data test1;
   a=1;
run;

You should get a log that looks like this (line numbers will vary)

153  data test1;
154     a=1;
155  run;

NOTE: The data set WORK.TEST1 has 1 observations and 1 variables.
NOTE: DATA statement used (Total process time):
      real time           0.01 seconds
      cpu time            0.01 seconds

Now try this:

data test2;
   set test1;
run;

If that runs okay then the system is working and will access a properly formed data set.

So I would go back to your source for those data sets. They may be corrupted or not actually SAS data sets at all. The message you are seeing about "0 columns" means that when SAS is attempting to use the data set it reads header information about the contents of the data set such as the names and types of variables. 0 columns means that no variables are found. I downloaded all 4 of those files and none of them show having any variables or observations (rows)in them. The file size in my Windows setting of 5K is just about the minimum for a text file with only one character in it. Interesting is that they also all show a creation/modified date of 14Aug 2008.

I strongly suggest going back to what ever source of these files and examine things like the file size as they appear to have been corrupted/empty for a very long time.

topic unable to open any dataset in SAS Studio in SAS Programming

unable to open any dataset in SAS Studio

Re: unable to open any dataset in SAS Studio