topic Imported a table into SAS Enterprise, getting _0000 at the end of table name. in SAS Programming

Imported a table into SAS Enterprise, getting _0000 at the end of table name.

GN0001 — Sun, 20 Jun 2021 21:58:36 GMT

Hello all,

I imported a dataset into SAS with SAS import wizard, I created a libname for that table.

The name of the table was BBB_2020 in my local. But SAS gave _0000 to the end of the table name when I wanted to use the table name.

Even I can see the data set name is: BBB_2020; SAS doesn't allow me to use the data set by that name. I saw somewhere in SAS in code window, the name of table is: BBB_2020_0000. I used dataset by that name.

What is the reason that SAS has added _0000 as suffix?

Respectfully,

Blue Blue

Re: Imported a table into SAS Enterprise, getting _0000 at the end of table name.

ChrisNZ — Sun, 20 Jun 2021 22:16:38 GMT

Show us the log report where the code is please.

Re: Imported a table into SAS Enterprise, getting _0000 at the end of table name.

SASKiwi — Sun, 20 Jun 2021 22:52:45 GMT

I've seen this type of behaviour when the dataset you are trying to import to already exists. The suffix is added to avoid overwriting the original dataset. Are you writing this dataset to a permanent SAS library? If so that could explain what is going on. As a test, close EG, reopen it and import to the SAS WORK library just once. The name of the imported dataset should be as you have specified.

Re: Imported a table into SAS Enterprise, getting _0000 at the end of table name.

GN0001 — Mon, 21 Jun 2021 16:31:45 GMT

Thanks for the response.

I am writing to SAS permanent library.
I have opened it at least so many times and closed it.
Regards,
Blue Blue