Good afternoon.   I am attempting to execute SAS code using a return value from a macro. I need to check to see if a user has flipped a switch from NO to YES and if YES then execute the code which will document tables contained in the code. The complicating issue is I'm attempting to "bracket" the code using proc scaproc. That means the proc must run at the beginning and the reporting documentation must run after the code. Also, after the reporting documentation a process runs that reads and parses out the particular data I want from the resulting proc scaproc text file. If the flag remains as NO the code should simply run without creating the text file or running the proc scaproc.    Changing the flag to YES (and attempting to invoke proc scaproc) doesn't seem to have any effect and I suspect including proc scaproc in its own macro(s) doesn't allow it to consider the code between the macros.   I know there are probably better ways to do this and I certainly look forward to hearing what people have to say.   %let document_flag = 'YES'; %macro document_table1; %if document_flag = 'YES' %then %do; proc scaproc; record '<<path to create the text file.txt'>>; run; %end; %mend; %document_table1;     <<SAS Code and ODS Excel creation>>     %macro document_table2; %if document_flag = 'YES' %then %do; proc scaproc; write; run; filename sca_rec ' <<path back to the initial text file>>; data myinfo; infile sca_rec truncover; input @1 scaline $256.; length type myinfo $100; keep type myinfo; retain prxifile prxofile prxidata prxodata prxoother; if _n_ = 1 then do; prxifile = prxparse("!\bJOBSPLIT: FILE INPUT (\b.*\b) \*/!"); prxofile = prxparse("!\bJOBSPLIT: FILE OUTPUT (\b.*\b) \*/!"); prxidata = prxparse("!\bJOBSPLIT: DATASET INPUT (\b.*\b) \*/!"); prxodata = prxparse("!\bJOBSPLIT: DATASET OUTPUT (\b.*\b) \*/!"); end; if prxmatch (prxifile,scaline) > 0 then do; myinfo = prxposn(prxifile,1,scaline); type = 'Input File'; output myinfo; end; else if prxmatch (prxofile,scaline) > 0 then do; myinfo = prxposn(prxofile,1,scaline); type = 'Output File'; output myinfo; end; if prxmatch (prxidata,scaline) > 0 then do; myinfo = prxposn(prxidata,1,scaline); type = 'Input Dataset'; output myinfo; end; else if prxmatch (prxodata,scaline) > 0 then do; myinfo = prxposn(prxodata,1,scaline); type = 'Output Dataset'; output myinfo; end; run; %end; %mend; %document_table2;     ... View more

Good morning. I would very much appreciate any help someone might give me.   We have a process that runs on the 15th of each month. There is code that is contained within this process and I only want the code to run on the 15th day after the end of each quarter of the year. Our shop can set the code to run on the 15th of each month, or each day, but the code itself must check the date to determine if it is April 15th, July 15th, October 15th or January 15th and only run on those dates.   Attached is the current date definition portion of the code. You can see it does determine the dates (today, current quarter, etc.). However, I guess what I need is for the code to decide if it is the 15th day after the quarter. I could accomplish it with hard coding the month or day but I was hoping someone had a better answer?   Thanks for any help someone could give me.   data params; attrib run_date length=8 format = mmddyy10. beginqtr length=8 format = mmddyy10. endingqtr length=8 format = mmddyy10. rep_start_date length=$10 rep_end_date length=$10 file_name_qtr length=$6; run_date = today(); beginqtr=intnx('qtr',run_date,-1,"BEGIN"); endingqtr=intnx('qtr',run_date,-1,"END"); rep_start_date=put(beginqtr, mmddyy10.); rep_end_date=put(endingqtr, mmddyy10.); file_name_qtr=put(beginqtr, yyq6.); call symput("run_date",run_date); call symput("beginqtr",beginqtr); call symput("endingqtr",endingqtr); call symput("rep_start_date",rep_start_date); call symput("rep_end_date",rep_end_date); call symput("file_name_qtr",file_name_qtr); call symput("file_name_qtr",file_name_qtr); run; ... View more

Good afternoon.   I would appreciate any help someone could offer.   Basically I need to have an older program run for data for the 28th day of each month on the first of the subsequent month. So on May 1 the beginmonth variable needs to allow me to run for data from March 28th to April 28th. I can do the report programming piece but what I can't get correct is to shift the date each month to the correct 28th day.    Here's the old section that will create the variables as they were before. I need to change these to find the 28th of each month, not the beginning or end of the time period as shown.   Any help would be greatly appreciated.   data params; attrib run_date length=8 format = mmddyy10. beginmonth length=8 format = mmddyy10. endingmonth length=8 format = mmddyy10. rep_start_date length=$10 rep_end_date length=$10; today = put(date(),worddate18.); run_date = today(); beginmonth=intnx('month',run_date,-2, "BEGIN"); endingmonth=intnx('month',run_date,-1, "END"); rep_start_date=put(beginmonth, mmddyy10.); rep_end_date=put(endingmonth, mmddyy10.); call symput("run_date",run_date); call symput("beginmonth",beginmonth); call symput("endingmonth",endingmonth); call symput("rep_start_date",rep_start_date); call symput("rep_end_date",rep_end_date); call symput('today',today); run; ... View more

Good morning. I would sure appreciate any help I could get. I'm pretty new to working with dictionary tables.   I attempted to create a simple list of members in our library called VIEWSDT (all members in the library are VIEWS) using the proc SQL below. However, I come up with the error message (also below) and I'm unsure what it means or how to track the issue down and solve it. I know there are evidently some misspellings in some of the variable names, etc., however, I'm not sure how to determine what particular members contain the misspellings and/or variable type mismatches. SAS tells me they are there but not where they are. Also, the VIEWSDT.ACRS02A dataset doesn't appear to exist but SAS still thinks it does and I'm unsure how to work with this error as well. I tried looking for answers but most of what I can find is helpful on how to work with dictionary tables but not how to troubleshoot and fix them (if that's what's going on here).   I'd really appreciate some advice if someone has the time.   Thank you.   **SQL** proc sql; create table tables_01 as select * from dictionary.tables where upcase(libname) in ('VIEWSDT') order by libname, memname; quit;   **ERROR MESSAGE** WARNING: The variable creae_datae2 in the DROP, KEEP, or RENAME list has never been referenced. ERROR: File VIEWSDT.ACRS02A.DATA does not exist. ERROR: File VIEWSDT.ACRS02A.DATA does not exist. ERROR: Function DATEPART requires a numeric expression as argument 1. ERROR: Character expression requires a character format. ERROR: Function TIMEPART requires a numeric expression as argument 1. ERROR: Character expression requires a character format. ERROR: Character expression requires a character format. ERROR: Character expression requires a character format. ERROR: The following columns were not found in the contributing tables: last_updated_when. ERROR: File VIEWSDT.ACRS02A.DATA does not exist. ERROR: File VIEWSDT.ACRS02A.DATA does not exist. NOTE: Table WORK.TABLES_01 created, with 384 rows and 41 columns                     ... View more