1 The SAS System 15:40 Thursday, October 24, 2019 1 ;*';*";*/;quit;run; 2 OPTIONS PAGENO=MIN; 3 %LET _CLIENTTASKLABEL='importRawData'; 4 %LET _CLIENTPROCESSFLOWNAME='Process Flow'; 5 %LET _CLIENTPROJECTPATH='C:\Users\3684003\OneDrive - MyEEEE\ModularPMCode.egp'; 6 %LET _CLIENTPROJECTPATHHOST='WHQ-3684003'; 7 %LET _CLIENTPROJECTNAME='ModularPMCode.egp'; 8 %LET _SASPROGRAMFILE=''; 9 %LET _SASPROGRAMFILEHOST=''; 10 11 ODS _ALL_ CLOSE; 12 OPTIONS DEV=PNG; _________________________________ 49 NOTE 49-169: The meaning of an identifier after a quoted string might change in a future SAS release. Inserting white space between a quoted string and the succeeding identifier is recommended. 13 GOPTIONS XPIXELS=0 YPIXELS=0; 14 FILENAME EGSR TEMP; 15 ODS tagsets.sasreport13(ID=EGSR) FILE=EGSR 16 STYLE=HTMLBlue 17 STYLESHEET=(URL="file:///C:/Program%20Files/SASHome/SASEnterpriseGuide/7.1/Styles/HTMLBlue.css") 17 STYLESHEET=(URL="file:///C:/Program%20Files/SASHome/SASEnterpriseGuide/7.1/Styles/HTMLBlue.css" ___________________________________________________________________________________________ 49 17 ! ) NOTE 49-169: The meaning of an identifier after a quoted string might change in a future SAS release. Inserting white space between a quoted string and the succeeding identifier is recommended. 18 NOGTITLE 19 NOGFOOTNOTE 20 GPATH=&sasworklocation 21 ENCODING=UTF8 22 options(rolap="on") 23 ; 24 25 GOPTIONS ACCESSIBLE; 26 27 28 %macro importRawData( 29 forecast_input_table = , 30 equipment_code_table = , 31 uld_standards_table = , 32 aircraft_standards_table = , 33 outlib= 34 ); 35 36 37 /* Import Equipment Code. */ 38 39 proc sql; 40 create table &outlib..equip_code as 41 select equip_cd, brief_equip_desc NOTE: The quoted string currently being processed has become more than 262 characters long. You might have unbalanced quotation marks. 42 from &equipment_code_table.; 2 The SAS System 15:40 Thursday, October 24, 2019 43 44 45 46 /* Import ULD Standards. */ 47 proc sql; 48 create table &outlib..uld_stndrds as 49 select * 50 from &uld_standards_table.; 51 52 /* Import Aircraft Offload Standards. */ 53 proc sql; 54 create table &outlib..ac_stndrds as 55 select * 56 from &aircraft_standards_table.; 57 58 59 60 /*Import Forecast Data*/ 61 62 proc sql; 63 create table &outlib..in_forecast as 64 select *, 65 1 as counter, 66 t2.brief_equip_desc as equip_type 67 from &forecast_input_table. t1 68 69 left outer join 70 (select equip_cd, brief_equip_desc from &outlib..equip_code) as t2 71 on t1.equip_cd = t2.equip_cd 72 73 order by sched_local; 74 75 76 77 %mend importRawData; 78 79 80 81 82 83 84 85 86 87 88 89 GOPTIONS NOACCESSIBLE; 90 %LET _CLIENTTASKLABEL=; 91 %LET _CLIENTPROCESSFLOWNAME=; 92 %LET _CLIENTPROJECTPATH=; 93 %LET _CLIENTPROJECTPATHHOST=; 94 %LET _CLIENTPROJECTNAME=; 95 %LET _SASPROGRAMFILE=; 96 %LET _SASPROGRAMFILEHOST=; 97 98 ;*';*";*/;quit;run; 99 ODS _ALL_ CLOSE; 100 3 The SAS System 15:40 Thursday, October 24, 2019 101 102 QUIT; RUN; 103     This error keeps popping up. The code works sometimes, and sometimes it doesn't work! Very irritating. ... View more

I have a table available_dates which has row of date values, like this:-    Table: available_dates date_value 05MAR19 06MAR19 07MAR19 08MAR19   I have a huge 5000+ lines of code that uses a macro_variable called &start_date. This macro-variable is used multiple times throughout the code.     Now, I want that entire code to run n times, where n is number of rows of date in table available_dates (n = 4 in this case) For every iteration, I want &start_date to be a specific date from the table available_dates   Essentially, the code will first have &start_date = 05MAR19, then run all 5000 lines, then &start_date = 06MAR19, then run all 5000 lines, then &start_date = 07MAR19, then run all 5000 lines and so on.    How do I this looping? I see a lot of posts to loop over strings, but this is a date value, so its getting a little tricky.    ... View more

I have a table that looks like this Time  Books 16:01  3 16:02  5 16:03  4 16:09  3 16:11  2 16:12  5 16:55  8     I want to group by 10 min time windows so that I get a table that looks like this Time                Avg(Books) 16:01 - 16:10   3.75 16:11 - 16:20   3.5 16:51 - 17:00   8 ... View more