topic Re: SAS-EG Convert/Copy table to server library in SAS Enterprise Guide

SAS-EG Convert/Copy table to server library

RandyW — Wed, 14 Nov 2018 18:23:26 GMT

Newer SAS-EG user with no coding experience.

I utilize the point-and-click features within the query builder to create queries. Once I have my final table in the project, I want it to show as a table within a library on the SASApp server so that I don't have to run the project every time I want to use that table.

I've tried exporting the .sas7bdat file as a step in the project.

I've also tried copying the code and pasting into a new program.

Thoughts?

Thanks in advance, I appreciate any non-coding solutions.

Re: SAS-EG Convert/Copy table to server library

SuryaKiran — Wed, 14 Nov 2018 18:40:42 GMT

You have to point the Output table to be created in the Library you wish (access required). You can do that by giving a two level name for the output in the query builder.

In below screenshot "MYWORK" is the library where my output will be created.

Re: SAS-EG Convert/Copy table to server library

RandyW — Wed, 14 Nov 2018 22:30:21 GMT

Thank you, that makes sense. However I receive an error message: "ERROR: You cannot create or delete datasets, views or indexes in this mode. Try the option METAOUT=DATA."

I found a solution for that error but it references SAS Management Console, which I do not have access to.

Do you know of any additional workarounds for this error?

Re: SAS-EG Convert/Copy table to server library

SASKiwi — Thu, 15 Nov 2018 03:46:31 GMT

Talk to your SAS administrator. It is likely that the library you are trying to write to has been set up in SAS Management Console and you don't have the right metadata permissions to allow this. Your SAS administrator should be able to fix this.

Re: SAS-EG Convert/Copy table to server library

RandyW — Thu, 15 Nov 2018 21:19:39 GMT

Thank you