Copy a cluster table in spds

[jagadeesh_2907]

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.

[AhmedAl_Attar]

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

[SylviaPowell]

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.

[LinusH]

This sounds like a Ballot Item!

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

[AhmedAl_Attar]

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

Just a thought?
Ahmed

[SylviaPowell]

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.