I need help with my monthly report sas code below: Firstly the code takes too long to run while the data is relatively small. When it completes a message that reads: The contents of log is too large. Please can you check what the issue which my code? %MACRO monthly_schedule; %let flag=n; %do %until(&flag=y); proc sql noprint; select count(update_flag) into:flag_cnt from work.schedule_dt where update_flag = 1 and Business in ('Spain' 'England') ; quit; %PUT &flag_cnt.; %if &end_date. > &lastest_refrsh_dt. %then %do; /*Execute vbt status rpt and email to recipients */ %if %eval(&flag_cnt)=9 %then %do; %let flag_cnt=Y; %put The flags are updated.; %vbt_status_rpt; %send_vbt_email; /*update Config table*/ proc sql noprint; delete from config table where location ='abc' AND SUB ='cde' and value ='31-Mar-22'd; quit; proc sql noprint; INSERT INTO config table (Location, SUB, Value) VALUES ( "abc", "cde", '30-Apr-22'd); quit; %end; %end; %end; %mend vbt_monthly_schedule; %vbt_monthly_schedule; %else %do; %put The flags are not updated; /* Send email if data is not available after the 6th Day */ %macro send_sixthdy_email; %let today = %sysfunc(today() ); %if( %sysfunc(intnx(month, &today., 0, B) ) NE &lastest_refrsh_dt. AND %sysfunc(day(&today.) ) GE 3 AND 2 LE %sysfunc(weekday(&today.) ) LE 3 ) %then %do; %put lastest_refrsh_dt is &lastest_refrsh_dt.; /* send email if data not ready by the 6th */ %emailnotification(ctnt=%str(data not available), subj=%str(data not available ), mailist ="j@yah"); %end; %mend send_sixthdy_email; %end; %end; %mend monthly_schedule; ... View more

I have an existing report and need  to write a conditional scheduling for the report.    The report is a monthly report. For every new month we need to generate report for the previous Month ended. for instance in beginning of February 2022, we need to generate the report for EOM 31st January 2022.    Additional Information: Step 1:   For every latest report published/generated, we need to save the Report date of the report in a table called the Config table; for instance, for December report 31/12/2021, we need to save the latest report date 31/12/2021 in a Config table. Hence for every Month we generate a report we need to update/refresh the report date saved in the Config table with the latest date.  then, every Month, we need to compare the report date saved in the config table with the expected report Date (Previous Month date) the report was to be generated. If both dates matches then exit, else if both dates doesn't match then proceed to step2.     Step 2:  The query should check through Table A and Table B. If both conditions below are True, then generate/publish the report but if any of the condition is false we need to wait the next day to check the conditions again.   Conditions:  If data/variable "A" is available in table A on end of previous Month for instance 31st January 2022 then publish. and If data/variable "B" is available in table B on end of previous Month for instance 31st January 2022, then publish/generate  the report   that is; If the two conditions above are TRUE then publish / generate the report else wait till the next day and check again.  A   Date  variable  31/01/2022 A 30/01/2022   29/01/2022 A   B   Date  Variable  31/01/2022 B 30/01/2022 B 29/01/2022 B   ... View more

i have two table, (Standard Mapping Table) containing "Mapped To" column and "ID" column. One "ID" can have multiple "Mapped To" values. The second table is the (Sales table) containing "Mapped To" column and "ID" column. The "Mapped To" and "ID" vales in the Sales table must match/follow the order in the Standard Mapping Table.    Note: All "ID" in the Sales table already exist in the Standard Mapping Table. There can be new "Mapped To" value created in the Sales table that does not have a matching "ID" in the Standard Mapping Table.  The "Mapped To" value in the Sales table was assigned wrong "ID"   Target: I would like to Join the (Sales table) to the (Standard Mapping Table) on Mapped To and ID. Then, identify and exclude all values in the (Sales table) that do not match the order in the Standard Mapping Table.  Also, Identify the New "Mapped To" values created in the Sales table that are not yet recognized in the Standard Mapping Table   Standard Mapping Table Mapped To                            ID                                          AB                                        D20   BC                                        D20 CA                                        D20 DE                                       A30 EF                                       A30   Sales Table  Mapped To                           ID AB                                      D20 BC                                      A30 DE                                      A30 JK                                       JK   Desired Result:   Sales Table1 (Error Mapping) Mapped To                           ID BC                                      A30   Sales Table 2 (New Mapped To and ID created) Mapped To                           ID JK                                       JK   Please can you help?             ... View more