Hi Daniel, I have tested the above technique: Finally, MP (4 Parts) Proc Sort (by one var) and datastep without piping parallelism: Only first dataset is getting sorted which contains obs from 1 to 50000000 C7_1. Other datasets are not getting sorted by MP4. Can you expalin it why..? Even in the log it says that 50000000 observations are sorted but when i combine C7_1 to C7_4. Only C7_1 is sorted, is there anything i need to modify in the code. Thanks in Advance... ... View more

Hi Linush, Thanks for your suggestions. I will use this spdssev1 option and will set it to 2. I have one more problem, which might be helpful from your side. Hi, I have a table that should be partioned as 256M. But since in spdsserv.parm file MINPARTSIZE is defined as 512M. While creating a new dataset, I m using macrovariable %let spdssize=256; But still partinoning is done as 512M.  I am not sure why it is happening in SPDS.... But when i am giving the upper limit %let spdssize=1048. It is overwriting the MINPARTSIZE.... Why the partition size is not reduced to 256M....Any suggestions Sample Code: %let spdssize=256; data test(partitionsize=256); set abc; run; Above code is working fine but partitioning is done at 512M rather than 256...????? I dn knw why ... View more

Hi Linush, We have a couple of tables in which there is a index on particular column. How to improve the Where clause on these tables... There are certain macrovariables in SPDS that can help in improving the performance. So need to improve the Where clause and compression and IO activit....? ... View more

Thanks for your wonderful comments... We have 16 Processors\CPU\cores as of now...But planning to move to 24 cores\processors\CPU in next month... Pls advice in that case. Yes, we do have some concurrent users too that are hitting the server on a regular basis. ... View more

Hi Linush, Data is not on SAN, but yes the new file systems are on SAN, and by increasing the datapaths should increase the performance. Parrallelism would be achieved in that case. Once all these file systems have been increased, Is there any other way for faster retrieval(access) of data from these datapaths. Yes, i do agree with your index paths. There it will not improve any performance. ... View more

Above code is not working...It gives as ERROR: Invalid MEMNUM value specified for cluster member open. How to use MINMAXVARLIST on a particular column from a table..Can you send me some pseudo code for it... Thanks in advance. ... View more

Thanks Tom..Yes will have a look at it... Do you know how to access two clusters from a cluster table at a time in SPDS using MEMNUM option.. Like for e.g out of 8 clusters..i need to access 4th and 5th cluster..How to do that.. ... View more