Greetings. If it is the Cobol programming language. There is a sas code that creates a .dat file, this program comes from SAS 9.3 (AIX) and the client migrated to SAS 9.4 (Linux). On AIX the value shown in the .dat file is 4=▒ On linux the value displayed in the .dat file is 4=Ç Simulate your sas program: 27 28 data _null_; 29 x = '4=▒' ; 30 put x= $quote. / x= $hex.; 31 run; x="4=▒" x=343DE29692 Thank ... View more

The Result: CREATE TABLE "##WYQXD98" ("ETLS_KEY" NOT NULL ,"ETLS_CLSDATE" ) ... View more

Good morning.   The SCD2 transformation generates a proc dataset code that deletes the table before creating it, this process does not fail.   MPRINT(ETLS_SCDLOADER): LIBNAME etlstmp SQLSVR READBUFF=32767 INSERTBUFF=32767 Datasrc=XXXXXX CONNECTION=GLOBAL SCHEMA=dbo USER=xxxx PASSWORD="XXXXXXXXXXX" DBMSTEMP=YES; NOTE: Libref ETLSTMP was successfully assigned as follows: Engine: SQLSVR Physical Name: XXXXXXXXXXXXXX NOTE: Dropping table ... MPRINT(ETLS_PUSHTODBMS): proc datasets lib = etlstmp nolist nowarn memtype = (data view); MPRINT(ETLS_PUSHTODBMS): delete WP9SZD4; MPRINT(ETLS_PUSHTODBMS): quit; NOTE: PROCEDURE DATASETS used (Total process time): 18 The SAS System 19:45 Friday, October 28, 2022 real time 0.05 seconds cpu time 0.00 seconds MPRINT(ETLS_PUSHTODBMS): ; MPRINT(ETLS_PUSHTODBMS): data etlstmp.WP9SZD4 (dbnull = ( ETLS_KEY = NO ETLS_CLSDATE = YES)); MPRINT(ETLS_PUSHTODBMS): attrib ETLS_KEY length = 8; MPRINT(ETLS_PUSHTODBMS): attrib ETLS_CLSDATE length = 8 format = DATETIME22.3 informat = DATETIME22.3 label = 'VALID_TO_DTTM'; MPRINT(ETLS_PUSHTODBMS): call missing(of _all_); MPRINT(ETLS_PUSHTODBMS): stop; MPRINT(ETLS_PUSHTODBMS): run; NOTE: SAS variable labels, formats, and lengths are not written to DBMS tables. ERROR: Error attempting to CREATE a DBMS table. . NOTE: The DATA step has been abnormally terminated. NOTE: The SAS System stopped processing this step because of errors. NOTE: Due to ERROR(s) above, SAS set option OBS=0, enabling syntax check mode. This prevents execution of subsequent data modification statements. WARNING: The data set ETLSTMP.WP9SZD4 may be incomplete. When this step was stopped there were 0 observations and 2 variables. ERROR: ROLLBACK issued due to errors for data set ETLSTMP.WP9SZD4.DATA. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.01 seconds ... View more

Execution log sample: MPRINT(ETLS_PUSHTODBMS): ; MPRINT(ETLS_PUSHTODBMS): data etlstmp.WP9SZD4 (dbnull = ( ETLS_KEY = NO ETLS_CLSDATE = YES)); MPRINT(ETLS_PUSHTODBMS): attrib ETLS_KEY length = 8; MPRINT(ETLS_PUSHTODBMS): attrib ETLS_CLSDATE length = 8 format = DATETIME22.3 informat = DATETIME22.3 label = 'VALID_TO_DTTM'; MPRINT(ETLS_PUSHTODBMS): call missing(of _all_); MPRINT(ETLS_PUSHTODBMS): stop; MPRINT(ETLS_PUSHTODBMS): run; NOTE: SAS variable labels, formats, and lengths are not written to DBMS tables. ERROR: Error attempting to CREATE a DBMS table. . NOTE: The DATA step has been abnormally terminated. NOTE: The SAS System stopped processing this step because of errors. NOTE: Due to ERROR(s) above, SAS set option OBS=0, enabling syntax check mode. This prevents execution of subsequent data modification statements. WARNING: The data set ETLSTMP.WP9SZD4 may be incomplete. When this step was stopped there were 0 observations and 2 variables. ERROR: ROLLBACK issued due to errors for data set ETLSTMP.WP9SZD4.DATA. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.01 seconds ... View more