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.
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
This sounds like a Ballot Item!
Being to copy a cluster, with or without the physical data.
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.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.