I realize this is an old thread and the op already came up with a solution, but for future reference and my own development would the "distinct" keyword not have worked to remove all observations that were identical across all variables in proc sql? For instance,    proc sql;      create table x as      select DISTINCT (variable1),               variable2,               variable3,               variable4,               etc....       from old_table; quit;   ... View more

45 ... View more

proc sql; create table res as ( select dt from hello where input(substr(dt,length(dt)-1),2.) >10 ); run; ... View more

1) Look at where you end statements are. 2) Take a look at the condition that makes you enter the loop, first do and then the lines after that. Those conditions will never be true. I suggest getting the code working for one variable then moving on to implementing with an array. ... View more

No. The code for Cluster is very simple . You can take suggestion from FriedEgg . Check the documentation, there are already lots of sample code you can reference . The number of cluster is hard to decide , but you can specify it by yourself . 2 or 4 or 6 or anything else. Component Analysis can help you understand the pattern of data which can help you decide which number of cluster is the best. ... View more

thank you Doc, it actually worked. PROC MEANS DATA=data(where=(people^='Jim' ));var item1; Run; ... View more

Tom already replied to this in a duplicate posting you made.  I have to ask: "did you really intend on having duplicate if-then-else statements?  The first four lines, under your do loop, recode the values.  What, if any, was the purpose of the second and third groups of if-then-else statements? ... View more

You appear to be missing some ELSE keywords. The first block of IF/THEN/ELSE clauses will convert the value to 0,1,2, or 3. The second block will then flip those into 2 or 0.  The 0's will be come 1's and the higher numbers will be 0's. The third block will then flip the 1/0 values. Perhaps you are trying to create three new variables from each existing variable? Or perhaps you really wanted to do some type of aggregation over the values? If so did you want to aggregate horizontally across the variables in a particular observation or vertically across the observations in your dataset? ... View more

Thank you ... View more

-  You should define your libname statement before you use it. I also would use some other name for the libref than LIB (which is a keyword). LIBNAME LIB 'c:\temp'; proc format LIBRARY=LIB; value R4C 1 =1 8,98 =8 9,99 =9 other=0 ; value R2C 2=1 8,98 =8 9,99 =9 other=0 ; RUN; -  You don't need a 'run;' statement after a SAS global command. You should use 'append;' to not overwrite existing definitions. OPTIONS APPEND=(FMTSEARCH=LIB) ; -  Assigning a format to a variable doesn't change the value of the variable (no recoding). It only changes how the variable values will be printed. As a format statement doesn't create new variables, the variables will still be of the same type (numeric in your case). The format statement just changes the format attribute of these variables. dATA LIB.SUBSET_BK5_6try;   SET LIB.GRADE8A ;   format M022043 R4C. M022049 R2C.; run; ... View more