Hi i need help in extracting data using below set of rules/instructions.    I need to skip a day before the actual date of extracting the data  , for example todays date is "2022-01-17", so  the program should  extract data for process_date "2022-01-13", skipping the process_date "2022-01-14". Note that when we skip the dates we exclude or we do not take into consideration Saturday and Sunday, we only focus on weekdays(monday to friday). So in this instance the could should neglect saturday(2022-01-15) & sunday(2022-01-16) then skip the process_date "2022-01-14" and extract the data on process_date "2022-01-13"   Again if i wanted to extract the data on date 2022-01-14, the code should skip the process_date "2022-13-01" and extract the data on the process_date "2022-01-12".   Lastly, if we need to extract the data on date "2022-01-12", the code should run from process_date "2022-01-08" which is saturday & process_date "2022-01-09" which is Sunday up to "2022-01-10" which is monday because some transactions runs on a weekend(saturday and sunday)..kindly Note that this condition only applies if  the code is ran on wednesdays for monday process_date which is "2022-01-12" in this instance.   Kindly note that the reason for all of above is because I need to schedule the code to run automatically during weekdays(monday to friday), your help will be highly appreciated!                                                         Data HAVE   data leave; input process_date :yymmdd10. amount reference &:$50.; format process_date yymmdd10.; datalines; 2022-01-08 100 trn01 2022-01-09 200 trn02 2022-01-10 300 trn03 2022-01-11 400 trn04 2021-01-12 500 trn05 2022-01-13 600 trn06 2022-01-14 700 trn07 2022-01-15 800 trn08 2022-01-16 900 trn09 2022-01-17 1000 trn10 ;     Data Want - for process date  "2022-01-13" which is thursday (First bullet point on the rules/instructions)   process_date   amount   reference 2022-01-13        600        trn06                 Data Want - for process date  "2022-01-12" which is wednesday (Second bullet point on the rules/instructions)   process_date   amount   reference 2022-01-12        500        trn05     Data Want - for process date  "2022-01-10" which is Monday (3rd bullet point on the rules/instructions)   process_date   amount   reference 2022-01-08        100        trn01 2022-01-09        200        trn02 2022-01-10        300        trn03 ... View more

Hi I need help in combining the below two proc sql statements into 1     data HAVE; input user_type : $20. Saved policy_no username : $20.; datalines; R 1 1 ALUPIYA R 1 1 ALUPIYA R 0 2 ALUPIYA R 1 3 ALUPIYA I 0 5 DLOUIS I 1 4 DLOUIS I 1 4 DLOUIS O 1 6 DMORAKE O 1 7 DMORAKE O 1 8 DMORAKE O 0 9 DMORAKE ; data WANT; input user_type : $20. Total_Saved Total_policies username : $20.; datalines; R 2 3 ALUPIYA I 1 2 DLOUIS O 3 4 DMORAKE ; proc sql; create table Saves as select user_type, username, count(distinct policy_no) as total_saved from HAVE where saved = 1 group by 1,2 order by 2 ;quit; proc sql; create table policies_total as select user_type, username, count(distinct policy_no) as Total_Policies from HAVE group by 1,2 order by 2; quit;   ... View more

Hi I need help in counting the distinct policy_no, where saved=1 as well as counting number of all distinct policies..see below data HAVE and WANT     data HAVE; input Saved policy_no user : $20.; datalines; 1 1 ALUPIYA 1 1 ALUPIYA 0 2 ALUPIYA 1 3 ALUPIYA 0 5 DLOUIS 1 4 DLOUIS 1 4 DLOUIS 1 6 DMORAKE 1 7 DMORAKE 1 8 DMORAKE 0 9 DMORAKE ; data WANT; input Total_Saved Total_policies user : $20.; datalines; 2 3 ALUPIYA 1 2 DLOUIS 3 4 DMORAKE ;   ... View more

Hi, i need help in translating the below excel code into SAS code..please note that the M = final_score(Contains 7 rows with scores from 0 to 5) and N2 = Total_Amount( 40 000)   (IF(M2>=3,$N$2/SUMIF($M$1:$M$7,">=3")*M2,0)   Looking forward to your help. ... View more