Thank for suggesting Tagsets. It solved my problem. I wrotes the below code and I now achieve the desired results. ods tagsets.excelxp file="\\athena\Projects\Kenya EABL RA\Data Management\SAS Setup\Kenya EABL MRA Field Queries.xls" style=Statistical options(sheet_name="Channel Changes" ABSOLUTE_COLUMN_WIDTH='10' autofit_height ='on' wraptext='no' embedded_titles='yes'); Title j=l "CONFIRM WHICH IS THE CORRECT CHANNEL FOR EACH OUTLET IN A SEPERATE COLUMN: TRADECHANNEL OR CHANNEL_PREVIOUS"; proc REPORT data=results.TownChanges style(header)={just=l}; run; ods tagsets.excelxp options(sheet_name="Town Changes") style=Statistical; Title j=l "CONFIRM WHICH IS THE CORRECT TOWN FOR EACH OUTLET IN A SEPERATE COLUMN: TOWN OR TOWN_PREVIOUS"; proc REPORT data=results.TownChanges style(header)={just=l} style(column)={height=0.5cm}; run; ods tagsets.excelxp options(sheet_name="Duplicates") style=Statistical; Title j=l "REFER TO THE DUPLICATES BELOW AND PLEASE SPECIFY IN A SEPERATE COLUMN HOW THESE SHOULD BE TREATED: MERGE OR DELETE"; proc REPORT data=results.Duplicates style(header)={just=l} style(column)={height=0.5cm}; run; ods tagsets.excelxp options(sheet_name="Facings>Stock-Cold") style=Statistical; Title j=l "THE BELOW ARE INSTANCES WHERE COLD FACINGS ARE GREATER THAN FRIDGE STOCK. THERE CAN NEVER BE MORE FACINGS THAN STOCK PRESENT. PLEASE INDICATE THE CORRECT VALUE FOR TOTALSTOCK_FRIDGE AND/OR FACINGS_COLD IN A SEPERATE COLUMNS. "; proc REPORT data=results.FACINGSGREATERTHANSTOCK_COLD style(header)={just=l} style(column)={height=0.5cm}; run; ods tagsets.excelxp options(sheet_name="Facings>Stock-Warm") style=Statistical; Title j=l "THE BELOW ARE INSTANCES WHERE WARM FACINGS ARE GREATER THAN WARM STOCK. THERE CAN NEVER BE MORE FACINGS THAN STOCK PRESENT. PLEASE INDICATE THE CORRECT VALUE FOR TOTALSTOCK_WARM AND/OR FACINGS_WARM IN A SEPERATE COLUMNS. "; proc REPORT data=results.FACINGSGREATERTHANSTOCK_WARM style(header)={just=l} style(column)={height=0.5cm}; run; ods tagsets.excelxp options(sheet_name="Kegs with Case Information") style=Statistical; Title j=l "THE BELOW ARE INSTANCES WHERE KEGS/BARRELS HAVE CASE INFORMATION RECORDED. KEGS/BARRELS ARE NOT AVAILABLE IN CASES. PLEASE INDICATE THE CORRECT INFORMATION FOR THE BELOW INSTANCES IN A SEPERATE COLUMN. "; proc REPORT data=results.KEGSWITHCASESIZES style(header)={just=l} style(column)={height=0.5cm}; run; ods tagsets.excelxp options(sheet_name="Missing Case Size-Fridge") style=Statistical; Title j=l "THE BELOW ARE INSTANCES WHERE CASE INFORMATION WAS RECORDED FOR FRIDGE BUT THE CASE SIZE WAS NOT INDICATED. CASES INFORMATION NEEDS TO BE MULTIPLIED OUT TO SINGLE UNITS AND WE THEREFORE REQUIRE THE CASE SIZE FOR EACH CASE FIGURE RECORDED. PLEASE SPECIFY THE CASE SIZE FOR THE BELOW INSTANCES IN A SEPERATE COLUMN. "; proc REPORT data=results.MISSINGCASESIZE_FRIDGE style(header)={just=l} style(column)={height=0.5cm}; run; ods tagsets.excelxp options(sheet_name="Missing Case Size-Purchases") style=Statistical; Title j=l "THE BELOW ARE INSTANCES WHERE CASE INFORMATION WAS RECORDED FOR PURCHASES BUT THE CASE SIZE WAS NOT INDICATED. CASES INFORMATION NEEDS TO BE MULTIPLIED OUT TO SINGLE UNITS AND WE THEREFORE REQUIRE THE CASE SIZE FOR EACH CASE FIGURE RECORDED. PLEASE SPECIFY THE CASE SIZE FOR THE BELOW INSTANCES IN A SEPERATE COLUMN. "; proc REPORT data=results.MISSINGCASESIZE_PURCHASES style(header)={just=l} style(column)={height=0.5cm}; run; ods tagsets.excelxp options(sheet_name="Missing Case Size-Storeroom") style=Statistical; Title j=l "THE BELOW ARE INSTANCES WHERE CASE INFORMATION WAS RECORDED FOR STOREROOM BUT THE CASE SIZE WAS NOT INDICATED. CASES INFORMATION NEEDS TO BE MULTIPLIED OUT TO SINGLE UNITS AND WE THEREFORE REQUIRE THE CASE SIZE FOR EACH CASE FIGURE RECORDED. PLEASE SPECIFY THE CASE SIZE FOR THE BELOW INSTANCES IN A SEPERATE COLUMN. "; proc REPORT data=results.MISSINGCASESIZE_STOREROOM style(header)={just=l} style(column)={height=0.5cm}; run; ods tagsets.excelxp options(sheet_name="Missing Case Size-Warm") style=Statistical; Title j=l "THE BELOW ARE INSTANCES WHERE CASE INFORMATION WAS RECORDED FOR WARM BUT THE CASE SIZE WAS NOT INDICATED. CASES INFORMATION NEEDS TO BE MULTIPLIED OUT TO SINGLE UNITS AND WE THEREFORE REQUIRE THE CASE SIZE FOR EACH CASE FIGURE RECORDED. PLEASE SPECIFY THE CASE SIZE FOR THE BELOW INSTANCES IN A SEPERATE COLUMN. "; proc REPORT data=results.MISSINGCASESIZE_WARM style(header)={just=l} style(column)={height=0.5cm}; run; ods tagsets.excelxp options(sheet_name="Missing Diaries") style=Statistical; Title j=l "THE BELOW ARE INSTANCES WHERE OUTLETS HAVE BEEN REVISITED BUT NO PURCHASES WERE INDICATED. PLEASE SPECIFY THE MISSING PURCHASE INFORMATION IN A SEPERATE COLUMN OR OTHERWISE A REASON FOR THE MISSING PURCHASE INFORMATION."; proc REPORT data=results.MISSINGDIARIES style(header)={just=l} style(column)={height=0.5cm}; run; ods tagsets.excelxp options(sheet_name="Missing Keg Glass Sizes") style=Statistical; Title j=l "THE BELOW ARE INSTANCES SERVING PRICES INDICATED FOR KEGS/BARREL BUT NOT GLASS SIZE SPECIFIED. SERVINGS PRICES NEED TO BE MULTIPLIED OUT TO A FULL KEG PRICE AND WE THEREFORE NEED THE GLASS SIZE. PLEASE SPECIFY THE MISSING GLASS SIZE OR OTHERWISE SUPPLY A PRICE FOR THE FULL KEG/BARREL IN SEPERATE COLUMNS."; proc REPORT data=results.MISSINGGLASSSIZES_KEGS style(header)={just=l} style(column)={height=0.5cm}; run; ods tagsets.excelxp options(sheet_name="Missing Prices") style=Statistical; Title j=l "THE BELOW ARE INSTANCES WHERE THERE ARE STOCK AND/OR SALES INFORMATION BUT NO PRICE RECORDED. EVERY STOCK OR SALES INSTANCE REQUIRES A PRICE. PLEASE SPECIFY THE CORRECT PRICE AND SKU MEASURE ('SINGLE TOT', 'DOUBLE TOT', '250ML GLASS' OR 'FULL UNIT') FOR EACH OF THE BELOW INSTANCES IN SEPERATE COLUMNS"; proc REPORT data=results.MISSINGPRICES style(header)={just=l} style(column)={height=0.5cm}; run; ods tagsets.excelxp options(sheet_name="Missing Stock") style=Statistical; Title j=l "THE BELOW ARE INSTANCES WHERE THERE WAS NO STOCK RECORDED FOR THE WHOLE OUTLET. PLEASE SPECIFY THE MISSING STOCK INFORMATION IN A SEPERATE COLUMN OR OTHERWISE A REASON FOR THE MISSING STOCK INFORMATION"; proc REPORT data=results.MISSINGSTOCK style(header)={just=l} style(column)={height=0.5cm}; run; ods tagsets.excelxp options(sheet_name="Negative Sales") style=Statistical; Title j=l "THE BELOW ARE INSTANCES WHERE SALES CALCULATE TO NEGATIVES WHICH IS NOT POSSIBLE. THIS MEANS THAT THE PURCHASES AND/OR STOCK INFORMATION ARE INCORRECT. PLEASE SPECIFY THE CORRECT PURCHASES AND/OR STOCK INFORMATIONS IN SEPERATE COLUMNS."; proc REPORT data=results.NEGATIVESALES style(header)={just=l} style(column)={height=0.5cm}; run; ods tagsets.excelxp options(sheet_name="NonNafuu With Senator Keg") style=Statistical; Title j=l "THE BELOW ARE INSTANCES WHERE THE OUTLET STOCKS SENATOR KEG BUT ARE CLASIFIED AS A NON NAFUU OUTLET. PLEASE CONFIRM THE CHANNEL FOR EACH OF THE OUTLETS."; proc REPORT data=results.NONNAFUUWITHSENATORKEG style(header)={just=l} style(column)={height=0.5cm}; run; ods tagsets.excelxp options(sheet_name="Outlets Not In Quota") style=Statistical; Title j=l "THE BELOW OUTLETS WERE VISITED OUTSIDE OF THE AREAS REQUIRED IN THE QUOTA. THESE OUTLETS WILL BE EXCLUDED. PLEASE DO NOT REVISIT THESE OUTLETS NEXT READ."; proc REPORT data=results.OUTLETSNOTINQUOTA style(header)={just=l} style(column)={height=0.5cm}; run; ods tagsets.excelxp options(sheet_name="Auditspan Outside Range") style=Statistical; Title j=l "THE BELOW OUTLETS ARE INSTANCES WHERE THE ALLOWABLE AUDIT SPAN HAS NOT BEEN ADHERED TO. THESE OUTLETS WILL NOT BE ACCEPTED. STICK TO THE ALLOWABLE AUDIT SPAN OF 28-32 DAYS"; proc REPORT data=results.auditspanoutsiderange style(header)={just=l} style(column)={height=0.5cm}; run; ODS tagsets.ExcelXP CLOSE;
... View more
