Hi,
Sorry to dig up an old topic, but I was trying to do the same and this came up in my search results. I eventually found a workaround that I thought was worth sharing.
If you were to run
proc spdo library=<LIB>;
cluster list <TABLE>;
quit;
then if <TABLE> is a cluster, the macro &spdslist will be populated with a list of the members. If <TABLE> is NOT a cluster, &spdslist is still created but will be blank, but unfortunately the procedure will error. What I did was to redirect the log with proc printto statements immediately before and after proc spdo, to mask the error, then test the value of &spdslist to determine what to do next. It's not the cleanest solution, but it worked for me!
Thank you. That certainly sounds a neater way, although when I tried it I got the message that dictionary.clusters was not a valid dictionary table name. Perhaps that's an issue with my current client's setup, but I'll certainly try it in future.
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 the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.