11-23-2017 08:50 AM
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.
11-24-2017 08:43 AM
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.
11-27-2017 02:45 PM
11-27-2017 04:43 PM
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.