Dear SAS folks, I have more than 400 variables and want check the distribution of data for each of them. I developed a piece of code and found that it didn't work. The code is as following:   %macro test; %array abc{406} &var.; %do i=1 %to 406; proc sql; create table abc{i} as select abc{i} from monthend.final_201509 ; quit; %end; %mend; Any suggestions? Thanks, Harry ... View more

Dear SAS EG users, I met a trouble last week and cannot figure it out. The problem is that the output of SAS program looks good, but the visizulation (bar graph, the frequency of a column named READ_DT) of result obveriously wrong. I had two tables, both of them had a column named READ_DT. Both cloumn shared the same format and informat, ie date9.. To my surprise, the frequency distribution of one table looks correct (Bar chart 2), but not the another one (Bar Chart 5). I don't know why and how to solve it. For deails please see attachments. Thanks, Harry ... View more

Hi SAS Users, I have a road block in conduct a project. The problem is how to compare observations within groups. My data set has a column named STORE_ID, which is the ID number of each store in a city. Another column is customer_id, obveriously it is ID of each consumed customer. I want to know the list of Customer_id that consumed not only in store A, but also in store B. I think correlated sub-query might be a possible solution, but don't know how to develop code. Any suggestions and sample codes are highly appreciated. Thanks, Harry    ... View more

Dear SAS Folks, I have a question on comparing two columns from two data sets named past_evt and fut_evt. Both data sets were sorted by city. I need to compare the column named ‘city’ within each area + ship_time group between past_evt with fut_evt. Flag any ‘city’ that appeared in past_evt but not in fut_evt. Please keep in mind that the comparison should be conducted only within groups (ie. Area+ship_time), not across group. My thought is using first_variableNme and last_variableNme is a possible method for this question, but I don’t know how to do it. Is anybody can give me some suggestions? Thanks, Best regards, Harry   The following is a sample of my data sets. data past_evt; input city $ area $ ship_time TIME8.; cards; Brookf TX 21:37:55 Cherok CA 9:36:18 CHILLI TX 23:50:14 FRN WA 18:45:23 FRN WA 13:21:11 FRN WA 4:30:24 GALVES CO 21:38:18 MARCEL IL 13:38:06 NEEDLE FL 12:24:40 Ravena NJ 3:25:48 Ravena NJ 6:23:10 SEATTL NY 9:19:13 SEATTL NY 10:56:02 STCOI TX 21:37:55 STJOMO TX 9:36:18 ; RUN;   data FUT_evt; input city $ area $ ship_time TIME8.; cards; Brookf TX 21:37:55 Cherok CA 9:36:18 CHILLI TX 23:50:14 LAFAYE CO 6:32:51 MARCEL IL 19:32:16 MARCEL IL 2:19:37 Ravena NJ 3:25:48 Ravena NJ 6:23:10 STJOMO TX 9:36:18 ; RUN;   ... View more

Dear SAS users, I have a data set that has more than 100 columns and over 10000 rows. I want select rows that have the same value among three consecqtive columns. For example I have the following table Obs st1 st2 st3 st4 st5 st6 st7 1 1 2 4 4 5 6 6 2 8 9 10 10 10 13 14 3 15 16 17 17 19 21 21 4 22 23 25 24 24 24 26 5 40 41 42 42 42 43 46 My result should be like this obs  st_numb 2     st3 st4 st5 4     st4 st5 st6 5     st3 st4 st5   I think combining do loop and array is a potential method, but I don't know how to write code. Thanks in advance for help! Harry           ... View more