Hi All, I have a dataset with variables Rank1-Rank10. and each Rank variables may varies from 1-5, and there is lots of missing values here. id Rank1 Rank2 Rank3 Rank4 Rank5 Rank6 Rank7 Rank8 Rank9 Rank10 1 3 . . . . . 4 . . . 2 3 . 3 . . . . . . . 3 1 . . . . 1 4 . . . 4 3 . . . . . 2 . . . 5 3 . 3 . . . . . . 2 6 . . . . . . 4 . 1 .   what I want is to figure out if there is any same values from Rank1-Rank10 within same row. For example, there is same values for ID 2 ,3 and 5. For those IDs have same values, I want to create a variable called SAME, let same =1. otherwise same= 0   can anyone help with this?? Thanks so much!! ... View more

Hi all,   I have a dataset looks like this:   ID Rank1 Rank2 Rank3 Rank4 Rank5 Rank 6 1 3 4 4 3 1 5 2 5 4 3 6 1 2 3 1 6 6 3 6 6 4 5 6 4 1 2 6 5 3 1 3 2 1 6 6 2 3 6 3 4 1 7 6 2 2 2 2 6 8 2 2 1 4 5 5 9 1 2 5 1 1 5 10 1 4 4 1 6 6   The Rank1- Rank6 may contain values from 1-6.   So within the same ID, what I want is:   1. Create a flag variable SAME, if there is same value from Rank1-Rank6 for each ID, then SAME=1 otherwise SAME = 0. for example , ID2 doesn't have the same value from Rank1-Rank6, then SAME =0. 2.   I want to know how many Ranks are the same as Rank1, Rank2... etc. For example, across total ID, there is 1 Rank2 is the same as Rank1( ID=8), 1 Rank3 is the same as Rank1(ID=5), 3 Rank4 are the same as Rank1 (ID =1,9,10). So the result data will be like this:     Rank1 Rank2 Rank3 Rank4 Rank5 Rank6 Rank1 N/A 1 1 3 1 1 Rank2   N/A  X  X  X  X Rank3     N/A  X  X  X Rank4       N/A  X  X Rank5         N/A  X Rank6           N/A   Thanks for any help!!! ... View more

Here I have the dataset and code like the following, and since there is only 4 datapoints of x, the output table will contain only 4 prediced value of y. What I want is the predicted values of y when x varies from 1 to 40, is that possible to generate the table in SAS? I know it's convenient to use the regression model to generate the results in EXCEL ,but I wonder if it's ok that I complete all of the steps in SAS.  THank you!!! data a; input x y; cards; 1 0.992010835 2 0.966176685 3 0.955358056 4 0.941511026 ; run; proc glm data= a; model y= x; output out= outa p=predy r=resid; run;      ... View more

  I had a database like this:   Account_Number Month Payment_Method 1 0   1 1 PI 1 2 PI 2 0   2 1   2 2   2 3     For some data record error reason, for example, as the account number = 1, when month =0, the payment method should be PI instead of missing. but the account number 2 is fine. Since all of its months should be missing. So the correct database would be :all of the months should be PI or all of the months should be missing for the same account. So my question is: for the account like 1, is that possible to let payment method = PI when month = 0? The problem only occur when month = 0 in the problem account. I try  CASE WHEN MONTH = 1 AND Payment_method= 'PI' THEN (CASE WHEN MONTH =0 THEN PAYMENT_METHOD = 'P' END) end group by Account_number   It doesn't work at all...   Thanks in advance ... View more