topic Re: How to save a zero observations data set (Template) from Work to a server. in SAS Enterprise Guide

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

alepage — Tue, 14 Aug 2018 14:11:08 GMT

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,

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

RW9 — Tue, 14 Aug 2018 14:25:11 GMT

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.

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

alepage — Tue, 14 Aug 2018 14:33:21 GMT

hello,

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

Regards,

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

alepage — Tue, 14 Aug 2018 16:56:54 GMT

Hello,

I have reported this issue to SAS.

Thanks for your help.

Regards,

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

ballardw — Tue, 14 Aug 2018 20:24:24 GMT

@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?