Hi, If counting the number of duplicate row in a table can help you then please try it. It will generate an output column that shows how many times each row occurs. Proc SQL; select * , count (*) as count from DSN group by var1, var2 having count (*) >1; quit; Regards Uma Shanker Saini ... View more

Hi Tushar, Thank you so much for updating us. It would be add-on note into my bucket. thank you again. Regards Uma Shanker Saini ... View more

Hi Tushar, Try to check this one as well... You can only perform four functions on a dynamic cluster table: creating a cluster, undoing a cluster, adding tables, and listing member tables. To perform any function other than these four, you must first undo the cluster with the CLUSTER UNDO command. Then, any changes must be made to all individual tables in the cluster. Once changes are made, you can re-create the cluster using the CLUSTER CREATE command. All member SAS SPD Server tables in a cluster must be identical; that is, they must have the same definitions for columns names, column widths, table indexes, formats on the columns, partition size, compression ON/OFF, and so forth. You cannot change table names, column names, column formats, indexes, or anything else about any member table, including the cluster name. The owner of all member tables must be the same. To create a cluster, the owner of the cluster must be the same user that owns the member table. For example, suppose USER1 creates a table, and USER2 also creates a table. These tables cannot be members of the same cluster, regardless of what ACL permissions are granted on the tables Regards Uma Shanker Saini ... View more

Hi tushar, yes, it is necessary to use compression when writting to SPD server table. Regards Uma Shanker Saini ... View more

Hi Tushar, When you are quering SPDS tables, always try to use these LIBNAME options: 1. IP=yes If the ANSI Standard SQL submitted to SPD server would run faster in Pass-through sql, the query will be converted to pass through SQL. 2. LIBGEN=yes Required when SAS Marketing Automation uses SPD Server tables. 3. DISCONNECT=yes Kills the SPD server proxy server when the libname is cleared. 4. COMPRESS=yes Ensure compression is used when writing to SPD Server table Regards Uma shanker Saini ... View more

Hi Tushar, I know, you are already done with your homework but may be this one could help. 1.When loading a SPD server table always sort the table by the variable used to join that SPD server table to other SPD server tables 2.When ordering the "Where, aggregations and counts" variables in the sort routine go from lowest to highest. 3.Always use compression on SPD server domain. 4.You can use the LIBNAME options  COMPRESS=Yes or the SPD server macro SPDSDCMP=yes to ensure all tables written to an SPD server domain are compressed. 5.Always replace DATA STEP modify code with PROC APPEND using the SPD Server option UNIQUESAVE=REP 6. To use PROC APPEND with UNIQUESAVE=REP the SPD Server table must have a unique index. Regards Uma Shanker Saini ... View more

Hi, Try to some more options - including macro and system (hardware related) to decrease the size of your log. NOMPRINT       -Removes SAS statements that are generated by macro execution ERROR=1         -Minimize the number of error to be shown in log to one by default it is 20 NOECHOAUTO  -No autoexec code in Log MSGLEVEL     - Set to N - It will display notes, warning and errors in log MSGLEVEL     - Set to I - It will display additional notes like index, merge, sort utility and all NONOTES      - Suppress the notes in log NOSOURCE /NOSOURCE2     - Supress the primary and secondary source information in SAS log NODTRESET     - Suppress the date and time in the SAS Log NOWARNING     - Suppress the warning messages in the SAS Log you can try more options like : NOMTRACE, NOMLOGIC, NOMACROGEN, NOSYMBOLGEN, NOCPUID, NOECHOAUTO,NOOVP, Pageno=min you can also try to run Proc options first the search for all the options which are containig log and try to use NO with that options (use only if exists) Kindly use as per your convenient because use of every options suppressess the different things in log. Regards Uma Shanker Saini ... View more

Hi Anna, Thank you so much for your reply. This would be really helpful at any stage from bottom to top. If i would get stuck at any stage, i will come back to you ..... for sure. Regards Uma Shanker Saini ... View more