What can I possibly be doing wrong?  Again no error, but the file still is not created.  Any other suggestions?   306 proc sort data=FinalData; 307 by descending total descending rule_nm; 308 309 ods tagsets.excelxp file="c:\users\ssbuechl\FinalData.xml"; NOTE: Writing TAGSETS.EXCELXP Body file: c:\users\ssbuechl\FinalData.xml NOTE: This is the Excel XP tagset (Compatible with SAS 9.1.3 and above, v1.122, 01/04/2011). Add options(doc='help') to the ods statement for more information. NOTE: There were 40 observations read from the data set WORK.FINALDATA. NOTE: The data set WORK.FINALDATA has 40 observations and 25 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.16 seconds cpu time 0.08 seconds 310 proc print data=FinalData; 311 format Rule_Order best6.; 312 run; NOTE: There were 40 observations read from the data set WORK.FINALDATA. NOTE: The PROCEDURE PRINT printed pages 10-11. NOTE: PROCEDURE PRINT used (Total process time): real time 0.22 seconds cpu time 0.13 seconds 313 ods tagsets.excelxp close; 314   The output is still going to the Results Viewer...   RULE_ _04_01_ _04_05_ _04_06_ _04_08_ _03_28_ _03_31_ _03_26_ _04_02_ Obs RULE_NM ORDER TOTAL 2016 2016 2016 2016 2016 2016 2016 2016 1 TOTAL BIDS VOLUME SAMPLED 999.3 54504 23024 1092 493 143 2210 2157 1171 13883 2 VOLUME MATCHING 999.2 35176 21393 68 44 9 1457 1745 1092 4244 3 PREP TYPE CODE MISMATCH 337 15588 395 908 396 110 54 227 11 9196 4 EXCLUDED IN IV INCLUDED IN BIDS 999.4 870 430 18 1 . 12 52 13 152 5 CRITICAL ENTRY TIME MISMATCH 6 751 . . . . 670 3 60 . 6 ACTUAL ENTRY DATETIME MISSING IN I 3.5 746 363 22 1 . 4 41 4 133 7 FSS SCAN INDICATOR MISMATCH 328 725 430 4 3 . . 93 . 25 8 CONTAINER LEVEL CODE MISMATCH 336 411 10 60 42 16 3 14 . 139 9 INCLUDED IN IV EXCLUDED IN BIDS 999.5 247 33 4 . . 2 . . 30 10 ACTUAL DELIVERY DATE MISMATCH 2 205 9 3 3 . . . . 3 11 ACTUAL DELIVERY DATE MISSING IN IV 1 123 26 . . . 5 4 . 3 12 LAST SCAN DATETIME LATER IN BIDS 3 104 85 4 1 . . 3 . 3 13 ACTUAL DELIVERY DATE LATER IN IV 1.5 95 68 . . 1 1 11 1 4 14 FIRST SCAN DATETIME MISMATCH 300 92 26 2 . . 1 1 . 14 15 ACTUAL ENTRY DATETIME MISMATCH 4 92 41 8 1 . . 2 . 26 16 PIECES MISSING IN IV 999.1 73 26 1 . . 7 . 3 25 _04_04_ _04_09_ _03_30_ _04_07_ _04_11_ _03_14_ _03_19_ _03_29_ _03_25_ _03_21_ _03_22_ _03_23_ _03_24_ Obs 2016 2016 2016 2016 2016 NULL 2016 2016 2016 2016 2016 2016 2016 2016 1 4707 124 725 222 17 3303 1 3 875 252 4 4 2 92 2 512 7 554 14 3 3022 . 1 665 246 3 3 2 92 3 3975 90 11 184 4 3 . . 23 1 . . . . 4 75 1 49 2 . . 1 2 62 . . . . . 5 . . . . . 2 . . 15 1 . . . . 6 73 1 23 2 . 68 . . 11 . . . . . 7 10 . 65 . . . . . 93 2 . . . . 8 92 12 2 20 1 . . . . . . . . . 9 7 . . . . 169 . . 2 . . . . . 10 2 4 1 1 5 174 . . . . . . . . 11 1 . 28 . . . 1 2 53 . . . . . 12 1 4 1 1 . . . . . 1 . . . . 13 4 5 . . . . . . . . . . . . 14 3 . 30 . . . . . 13 . 1 1 . . 15 5 1 . . . 8 . . . . . . . . 16 6 . 1 . . 3 . . . 1 . . . .   ... View more

It should be producing the file c:\FinalData.xml?  No file is being created. We are running SAS 9.3 on Windows 7.  My results are still outputing to the Results Viewer window.   9248 9249 proc sort data=FinalData; 9250 by descending total descending rule_nm; 9251 9252 ods tagsets.excelxp file="c:\FinalData.xml"; NOTE: Writing TAGSETS.EXCELXP Body file: c:\FinalData.xml NOTE: This is the Excel XP tagset (Compatible with SAS 9.1.3 and above, v1.122, 01/04/2011). Add options(doc='help') to the ods statement for more information. NOTE: There were 38 observations read from the data set WORK.FINALDATA. NOTE: The data set WORK.FINALDATA has 38 observations and 24 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.09 seconds cpu time 0.07 seconds 9253 proc print data=FinalData; 9254 format Rule_Order best6.; 9255 run; NOTE: There were 38 observations read from the data set WORK.FINALDATA. NOTE: The PROCEDURE PRINT printed pages 377-378. NOTE: PROCEDURE PRINT used (Total process time): real time 0.21 seconds cpu time 0.12 seconds 9256 ods tagsets.excelxp close; 9257   ... View more

ODS tagsets.ExcelXP to generate an Excel compliant XML document sounds great.  How do I specify this for my Proc Print? ... View more

umm, I'm not specifying anything, it's just appearing in the Results Viewer window. ... View more

Awesome help. Ty. ... View more

Maybe I'm using this wrong, but I'm still getting Proc Tabulate output and no longer getting my Proc Print.     proc sort data=FinalData force; by rule_order ad_dt; run; ods exclude FinalData; Proc tabulate data=FinalData missing out=FinalData; class Rule_Order ad_dt; table rule_order*(ad_dt all)*n; run; ods select FinalData; The SAS System ---------------------------------------------------------------------------------------------------------------------- | RULE_ORDER | |--------------------------------------------------------------------------------------------------------------------| | 1.5 | |--------------------------------------------------------------------------------------------------------------------| | AD_DT | |--------------------------------------------------------------------------------------------------------------------| |15MAR2016:0-|17MAR2016:0-|18MAR2016:0-|19MAR2016:0-|21MAR2016:0-|22MAR2016:0-|23MAR2016:0-|24MAR2016:0-|25MAR2016:0-| | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 | |------------+------------+------------+------------+------------+------------+------------+------------+------------| | N | N | N | N | N | N | N | N | N | |------------+------------+------------+------------+------------+------------+------------+------------+------------| | 1.00| 1.00| 2.00| 6.00| 12.00| 4.00| 7.00| 18.00| 110.00| ---------------------------------------------------------------------------------------------------------------------- (Continued) ... View more

And this will not suppress the Proc Print? How do I turn it back on? ... View more

  I'm stuck here where I'm trying to filter FinalData to keep only records where rule_order is < 997.1 before the merge actually happens.   1378 data FinalData; 1379 merge QueryData (in=a) FinalData_2(in=b) (where= (rule_order < 997.1)); - 22 76 ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, ;, END, _DATA_, _LAST_, _NULL_. ERROR 76-322: Syntax error, statement will be ignored. 1380 by imb_code; 1381 if a and not b; 1382 run; NOTE: The SAS System stopped processing this step because of errors. WARNING: The data set WORK.FINALDATA may be incomplete. When this step was stopped there were 0 observations and 0 variables. WARNING: Data set WORK.FINALDATA was not replaced because this step was stopped. NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.01 seconds   ... View more