I thought it was running OK it runs once then on the second try I get the error again.  Another colleague in my group is also having the same problem. code DATA ICETRANS; INFILE modcum2 TRUNCOVER ignoredoseof; INPUT  @17  INDSOUM       $2.            @19  DTNLOT         8. ; IF ( DTNLOT >= &WDI_Month_FirstDay. AND dtnlot <= &WDI_Month_LastDay.);     INPUT  @1   CIE           $1.            @3   PTVENTE        $5.            @8   NOSCTR        $3.            @16  BRANCHE       $1.            @27  NOPOLICE      $8.            @35  NOSOUM        $8.            @43  INDICATEUR    $1.            @49  RAISON        $2.            @51  FINALITE      $2.      @53  MARQUE        $1.;      IF MARQUE='C';      IF PTVENTE >=8400 AND PTVENTE <=8698;      IF INDSOUM='NA' THEN NBVENTP=1;      IF INDSOUM NE 'NA' THEN NBVENTP=0; LENGTH CODEFILD $35; IF NOSOUM='' THEN NOSOUM=NOPOLICE; CODEFIELD=TRIM(DTNLOT||NOSOUM||NOSCTR||NBVENTP); RUN; ERROR              _              49 1        ! ;*";*/;quit;run; 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. 2          OPTIONS PAGENO=MIN; 3          %LET _CLIENTTASKLABEL='WDI_transactions_agent_broker'                                                                ___________________________                                                                49 3        ! ; 4          %LET 4        ! _CLIENTPROJECTPATH='S:\actu\_sas_eg\_MIS_Mississauga\_JIRA_Requests\EVO-3336_WDI_Transactions_Agent_Broker\EVO-3336_WDI_t 4        ! ransactions_agent_broker.egp'                                        ___________________________                                        49 4        ! ; 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. 5          %LET _CLIENTPROJECTNAME='EVO-3336_WDI_transactions_agent_broker.egp'; 6          %LET _SASPROGRAMFILE=; 7          8          ODS _ALL_ CLOSE; 9          OPTIONS DEV=ACTXIMG; 10         FILENAME EGSR TEMP; 11         ODS tagsets.sasreport13(ID=EGSR) FILE=EGSR STYLE=HtmlBlue 11       ! STYLESHEET=(URL="file:///c:/Program%20Files/SASHOME/SASEnterpriseGuide/5.1/Styles/HtmlBlue.css") NOGTITLE NOGFOOTNOTE 11       ! GPATH=&sasworklocation ENCODING=UTF8 options(rolap="on"); WARNING: The quoted string currently being processed has become more than 262 characters long.  You might have unbalanced quotation          marks. 12         13         14         DATA ICETRANS; 15          INFILE modcum2 TRUNCOVER ignoredoseof; 16          INPUT  @17  INDSOUM       $2. 17                    @19  DTNLOT         8. ; 18         19          IF ( DTNLOT >= &WDI_Month_FirstDay. AND dtnlot <= &WDI_Month_LastDay.); 20         21             INPUT  @1   CIE           $1. 22                    @3   PTVENTE        $5. 23                    @8   NOSCTR        $3. 24                    @16  BRANCHE       $1. 25                    @27  NOPOLICE      $8. 26                    @35  NOSOUM        $8. 27                    @43  INDICATEUR    $1. 5          %LET _CLIENTPROJECTNAME='EVO-3336_WDI_transactions_agent_broker.egp';                                                                               __                                                                               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. 28                    @49  RAISON        $2. 29                    @51  FINALITE      $2. 30              @53  MARQUE        $1.; 31         32              IF MARQUE='C'; 2                                                          The SAS System                           12:24 Tuesday, September 9, 2014 33              IF PTVENTE >=8400 AND PTVENTE <=8698; 34              IF INDSOUM='NA' THEN NBVENTP=1; 35              IF INDSOUM NE 'NA' THEN NBVENTP=0; 36          LENGTH CODEFILD $35; 37         IF NOSOUM='' THEN NOSOUM=NOPOLICE; 38          CODEFIELD=TRIM(DTNLOT||NOSOUM||NOSCTR||NBVENTP); 39         40         RUN; 41                                       ... View more

Believe it or not I turned off my machine completely waited for 10 min and it ran fine there must have been something hanging or being picked up. Thank you for your response ... View more

This if very confusing because these programs have run for at least 2 months before without any changes and it does not create any datasets It does run on other peoples machines without the error ... View more

libname test pcfiles path=\\{your info here}\TEST.XLSX;            (this has to be a different name else it is an error) proc export data=sashelp.cars outfile='\\{your info}\test.xlsx'         dbms=xlsx; sheet=cars;                                                             (first dbms=xlsx log will tell you not created ..... overwritted .....) run;       proc export data=sashelp.class outfile='\\{your info}\test7_delete.xlsx' dbms=excelcs; sheet=class ;                                                     (all other dbms=EXCELCS and it seems to work very well)????? run; proc export data=sashelp.classfit outfile='\\{your info}\test7_delete.xlsx' dbms=excelcs; sheet=classfit ; run; proc export data=sashelp.deskact outfile='\\{your info}\test7_delete.xlsx' dbms=excelcs; sheet=deskact ; run; libname test clear; ... View more

I have been reading up on tagsets.msoffice2k_x would this also work with formating the excel spreadsheet ... View more

Thank you this helped now all I have to do is figure out how to format it the way people want to see it without having to do it manually ... View more