Below is the dataset and I have to pick customer_id who have submitted ADDRESS and ID proof but not submitted INCOME proof. How can I choose those obs? For example, Custome_id 3 is the only one who have not submitted income proof. Thanks.   customer_id     proof     1                     income     1                      id     1                      id     2                     address     2                      income    2                         id    3                       address     3                      address     3                        id   ... View more

If I have a SAS dataset with the following values. I want to create a new variable and assign value"A" if cust_id is there 2 times in the table and assign value "B" if cust_id is there 3 times. For ex. For cust_id=1113, I want new variable value to be A and for cust_id=1115, I want new variable value to be B.  Thanks.   cust_id   month 1112       Mar 1113       apr 1113       feb 1114        feb 1115        mar 1115       apr 1115        feb ... View more

The code and example result are below. How can I get the sum in descending order? Thanks for your help.   data disc; set sales (keep=sub_category sales order_date); saleyear=year(order_date); run; proc means data=disc sum ; class sub_category; var sales; where saleyear in (2012,2013,2014); run;   Means Procedure Sub_category  N obs    sum a                         20       20006.56 b                        39      114309.658 c                        200     12657.98 d                        98        876000.765 e                        256      9860         ... View more

Hi, Below is the dataset that I have.  i want to calculate sum of weekday 1&7(10450+34876) and sum of weekday 2 to 6(5670+78201+..) How can I do that? Thanks for all your help   weekday      sum 1               10450 2                5670 3                78201 4                8723 5                60981 6                8921 7                34876   ... View more