07-27-2017 02:40 PM
I had a database like this:
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)
group by Account_number
It doesn't work at all...
Thanks in advance
07-27-2017 03:08 PM
You can use MAX/MIN with SQL.
proc sql; create table want as select *, max(payment_method) as payment_method_max from have; quit;