Architecting, installing and maintaining your SAS environment

How do I move tables objects en masse to another metadata folder?

Reply
Super Contributor
Posts: 376

How do I move tables objects en masse to another metadata folder?

Hi,

SAS 9.2 on Windows...

From the Data Library Manager plugin, I RMB'd on one of the library objects, selected Register Tables, then Next.  I didn't pay attention to the metadata folder location (Note to SAS:  it would be nice if you asked me to confirm the folder location, rather than silently assuming I want them in /Shared).

So now I have a bunch of table objects in /Shared.  How do I move them en masse to my desired metadata folder?  From the Folders tab, doing them one by via via properties will take forever, selecting multiple items doesn't work, and neither does drag and drop.

Thanks,

Scott

Super User
Posts: 5,256

How do I move tables objects en masse to another metadata folder?

It seems when i SMC, you could from the Folder Tab, copy a bulk of objects to another folder, and then you have to manually delete the original ones.

In DI Studio, you have the option "Move to folder..." which would be nice to have in SMC as well.

Haven't checked 9.3, maybe this functionalty has been upgraded?

/Linus

Data never sleeps
Super Contributor
Posts: 376

How do I move tables objects en masse to another metadata folder?

Hi,

Just to clarify, we are DIS-interested in using DIS, so we don't have it.  I'm using SMC.

Copying them to a new folder would create new metadata object ID's, which in DIS would break the jobs.  However, since they are 1) new tables not yet references elsewhere, and 2) only there so they show up in EG, your suggestion could work for me.  Or I guess I could just delete the tables and reimport them, paying attention to that silent, grayed out option setting to select the metadata folder.

But moving en masse via SMC in an obvious way via the user interface would be nice.

Scott

Super Contributor
Posts: 356

How do I move tables objects en masse to another metadata folder?

A warning with the copy, and then deleting the old objects.  The copy creates new object ID's so any thing using those old tables objects will break.

Another example of where the interfaces are different between the SAS Clients, why isn't there a Move to folder in SMC like there is in DIS.

Barry

Ask a Question
Discussion stats
  • 3 replies
  • 296 views
  • 0 likes
  • 3 in conversation