Hi All, I have a query below for which I am looking for a solution through sas and proc sql both.Could anyone please help here: We have a sample data for a year with customers having transaction for different products. Customers may have multiple transaction in a month or no transaction in a month. We are require to fetch customers list who is having at least one transaction each month:   Sample Data: Customer_ID Transaction_Date Transaction_Amount 123                  01/01/2020           100 909                   02/01/2020           250 123                   02/01/2020           45 900                   03/02/2020          789 123                    05/02/2020           950 : : : and so on    ... View more

Please someone could help with below scenario to code through Proc SQL:   Scenario: we have a dataset with column : Paitent_Id, Name, Appointment_date and Amount_Paid. I need to fetch report for top 10 Patient for each_month who paid the maximum Bill. Below is the dummy data: Patient_Id  Patient_Name  Appointment_date Bill_Paid 1                  A                      01/01/2000            250 2                  B                      21/02/2000            350 3                  C                     15/01/2000             400 4                  D                     17/02/2000             430 5                  E                      01/03/2000            500       Following is the code i've tried but i want to replicate same scenario through proc sql or if any other optimized solution someone could suggest, will be appreciated.   Code: format date yymmn6.;   proc sort data=dummy out=sorted_op; by date descending bill_paid; run;   data final; set sorted_op; by date; if first.date then n=1; else n+1; if n<=10; run;       ... View more

How is SAS production environment different from development and testing? ... View more