How to save a zero observations data set (Template) from Work to a server.

[alepage]

Hello,

I am using the code bellow to copy a template (zero observation data set) from Work to a server.  This operation works well but when I click on my template located on the server, I have this error message:

The opening of the data has failed.
The following error occurred.
BOF or EOF is equal to true.
The current record has been deleted.
The requested operation requires a current record.

Data test;

stop;

set sashelp.class;

run;

Libname Template '\\...\Documents\My SAS Files\Template';

proc sql;

create table Template.Test_Templ like work.Test;

quit;

Any idea how to correct this problem?

regards,

[RW9]

Sorry, bit confused, your creating an empty dataset in SAS, then your create a copy of this somewhere else?  I am not sure why.  You could take a describe of dataset, then run that code on the destination, however if the destination is a database, then surely a better idea to use the table building tools on the database?

The error you get seems to tell you then answer:

"The requested operation requires a current record."

Therefore have one row, and then delete that row:

proc sql;
  create table template.test_templ like sashelp.class;
  delete * from template.test_templ;
quit;

You can execute as many queries as you like.

[alepage]

hello,

I have try your code and I still have the same error.

Regards,

[alepage · Accepted solution]

Hello,

I have reported this issue to SAS.

Thanks for your help.

Regards,

[ballardw]

---

@alepage wrote:

Hello,

I am using the code bellow to copy a template (zero observation data set) from Work to a server.  This operation works well but when I click on my template located on the server, I have this error message:

The opening of the data has failed.
The following error occurred.
BOF or EOF is equal to true.
The current record has been deleted.
The requested operation requires a current record.

Data test;

stop;

set sashelp.class;

run;

Libname Template '\\...\Documents\My SAS Files\Template';

proc sql;

create table Template.Test_Templ like work.Test;

quit;

Any idea how to correct this problem?

regards,

---

It sounds like there is a missing piece somewhere. Nnte of the code shown looks like it creates a data set "on a server".

Do you click on the data set inside a SAS session running on the server? From another program like a data base file list? A simple file manager?