BookmarkSubscribeRSS Feed
Not applicable

Have anyone had any experience of using the cluster table created by the SPDS table members?

I managed to create the cluster and also know how undo it. However, the question is, is that a way I can reference to the specific member of the cluster table?

Each of the A, B and C is a SPDS table that make up the test cluster table. Once I have created the test cluster table, how do I reference, says, only the A or B or C or the combination of that?

Example, user might be interested in using A only, so:
DATA abc;
SET test;
*** can i use a where statement to say where mem=a? (tried this before and it didn't work)***;

*** Creating the cluster table ***;
PROC SPDO library = mydomain;
Not applicable
Did I post this at the correct forum? Should I not post it at the Optimization and Operations Research? 🙂
SAS Employee
Yes, I think you might be at the wrong forum.
Not applicable
Err........where should I post the question then?

Also, I really like to see there are more specific topics available for the forum such as SAS Management Console, DI Studio and etc......
The challenge with this idea, as I see it, is that EVERYBODY has their own installation and configuration. Nobody is running the same BI installation. So usage questions are not just usage questions, as in "How do I suppress the titles in my output."

For example, you want to know something about a workspace server. You have a pooled workspace server. Somebody answers your questions, they don't use pooling AND they're not specific about that in their answer. You try something they suggest and mess up your configuration. Someone has a question about authorization -- they are NOT using LDAP, somebody else is. Neither person qualifies their answer. Confusion ensues.

When you have to qualify either your question or your answer with so many "it depends" and "this is my configuration" -- it seems to me to just slow down the process. If you have Management Console or DI Studio questions and went straight to Tech Support, they can collect the qualifying information that affects your question and get you an answer -- probably quicker than from the forum.

That's my .02,
Not applicable
Jason - this Optimization and OR forum is for customers who are modeling with SAS/OR. Many people are unfamiliar with this field of applied math and management science - so let me clarify that just because this forum has the word "operations" in the title -- it is not the proper place to post questions on your experiences implementing any one of the many SAS offerings in real world organizations.

the more appropriate web site I recommend for you to go to is Enjoy. Also remember -- there is no fee to contact tech support with your specific questions - SAS is eager to help you get rock'n and rolling.

At the SAS Global Users Group meeting in April 2007 - the Executive Board is announced, a collaborative online SAS community for SAS users worldwide. covers topics that any SAS user world-wide can go to in order to find any and all resources that might be of value to them in their use of SAS software and its related technologies.

if you'd like to suggest your own discussion topic that doesn't relate to SAS/OR or optimization -- i encourage you to enter your topic here.
Tourmaline | Level 20
Even if this is in the wrong forum, I would like to answer.

No, you cannot reference a specific member directly, but you might do it indirectly. If you set the MINMAXVARLIST data set option to column(s) that you use for partition your data, you can access specific members by using WHERE. See documentaion for syntax and examples of MINMAXVARLIST.
Data never sleeps



Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.

If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website. 

Register now!

Multiple Linear Regression in SAS

Learn how to run multiple linear regression models with and without interactions, presented by SAS user Alex Chaplin.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 6 replies
  • 4 in conversation