BookmarkSubscribeRSS Feed
Fluorite | Level 6

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;

Super User

Let's try a simper test.

Run this code:

data test1;

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;

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.



Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.

If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website. 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Get the $99 certification deal.jpg



Back in the Classroom!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 1 reply
  • 2 in conversation