topic Re: Register the WORK dataset in SAS Data Management

Register the WORK dataset

Babloo — Wed, 17 Jan 2018 14:55:35 GMT

Where I can find the WORK library dataset in SAS DI Studio 4.2? Also can I register the WORK library dataset in DI Studio?

Re: Register the WORK dataset

LinusH — Wed, 17 Jan 2018 15:35:04 GMT

Usually, you shouldn't really use WORK in DIS for registering table objects.

In the past I have done so for work-arounds because I wanted to graphically show output helper data sets from certain transformations, like Validation (Validation have been fixed in later releases). Other scenarios than this, I can't see any use of using a registered WORK library.

If you still want to do it, just do ut - but mark it as pre-assigned by external configuration (otherwise DIS tries to issue a LIBNAME WORK statement). This can have side affects on EG users, so test it first outside production.

Re: Register the WORK dataset

Kurt_Bremser — Wed, 17 Jan 2018 17:10:59 GMT

Why would you want to register something that is transient and not there the next time a SAS process starts?

Re: Register the WORK dataset

Babloo — Thu, 18 Jan 2018 06:01:06 GMT

I've the SAS code which creates a permanent SAS dataset from a WORK dataset. Now I've to do the same work in SAS DI studio. Could you please tell me how can I achieve the same thing in DI studio?

Re: Register the WORK dataset

Kurt_Bremser — Thu, 18 Jan 2018 06:11:58 GMT

I don't think DI Studio lets you create tables in WORK, so how do you get a table there?

Re: Register the WORK dataset

Babloo — Thu, 18 Jan 2018 06:17:23 GMT

Let me rephrase the question. How can I create the new permanent dataset from other premanent dataset in DI studio?

Re: Register the WORK dataset

LinusH — Thu, 18 Jan 2018 10:42:40 GMT

You mean as a metadata object?

If it's just a one time thingy, just copy and paste...?

Re: Register the WORK dataset

Babloo — Thu, 18 Jan 2018 10:58:35 GMT

If I do a copy/paste then I no need to register the table in metadata?

Re: Register the WORK dataset

LinusH — Fri, 19 Jan 2018 07:31:38 GMT

If you that it will generate a table registration in metadata.
I don't really understand why you ask such questions?