topic Re: Copy a cluster table in spds in SAS Programming

Copy a cluster table in spds

jagadeesh_2907 — Thu, 23 Nov 2017 13:50:08 GMT

Hi ,

I am trying to copy a cluster table which has around 60 members. I need to copy this cluster table from one library to another with both in same SPDS server. Is there a way as most of the articles I have read about it does not give any hint on to copy a cluster as a cluster itself.

if I copy it with a data step I will be able to read only the data and have to create the members again.

Thank you.

Re: Copy a cluster table in spds

AhmedAl_Attar — Fri, 24 Nov 2017 13:43:36 GMT

Hi,

Not sure if you had seen this or not Managing Large Data with SAS ® Dynamic Cluster Table Transactions

Most likely you'll have to undo the Cluster in order to get access to its members, copy the members to your destination library, then declare new cluster in your destination library.

Ahmed

Re: Copy a cluster table in spds

SylviaPowell — Mon, 27 Nov 2017 19:45:24 GMT

Development confirms that if you want to make an exact copy of a dynamic cluster table, then you need to undo the cluster, copy the members, and recreate the cluster.

Re: Copy a cluster table in spds

LinusH — Mon, 27 Nov 2017 20:31:07 GMT

This sounds like a Ballot Item!

Being to copy a cluster, with or without the physical data.

Re: Copy a cluster table in spds

AhmedAl_Attar — Mon, 27 Nov 2017 20:44:10 GMT

Hi,
Wouldn't creating a view on top of the Cluster Table substitute for "copying a Cluster without physical data"?

Just a thought?
Ahmed

Re: Copy a cluster table in spds

SylviaPowell — Mon, 27 Nov 2017 21:43:09 GMT

A view is going to make the cluster look like a single table. I asssumed the previous question on how to copy a cluster was to determine how to replicate the cluster so it is still split into individual members. If you just want to access the data, then you can also create a single table from the cluster via PROC COPY or DATA step.