DATA Step, Macro, Functions and more

Copy a cluster table in spds

Reply
Occasional Contributor
Posts: 6

Copy a cluster table in spds

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.

Super Contributor
Posts: 285

Re: Copy a cluster table in spds

Posted in reply to jagadeesh_2907

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

SAS Employee
Posts: 8

Re: Copy a cluster table in spds

Posted in reply to AhmedAl_Attar
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.
Super User
Posts: 5,914

Re: Copy a cluster table in spds

Posted in reply to SylviaPowell

This sounds like a Ballot Item!

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

Data never sleeps
Super Contributor
Posts: 285

Re: Copy a cluster table in spds

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

Just a thought?
Ahmed
SAS Employee
Posts: 8

Re: Copy a cluster table in spds

Posted in reply to AhmedAl_Attar

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.

Ask a Question
Discussion stats
  • 5 replies
  • 213 views
  • 2 likes
  • 4 in conversation