Dear All,   I use SAS DDE to generate hundred of excel reports for different cities. Currently, company rule applied, that each excel file should be labeled before saving. Originally, it is a totally auto process.  Currently, I have to click on Label-"Internal" for each file. suffering.  Can anyone guide me how to solve this? say add code in DDE to auto select excel label as "internal".   Thanks a lot. Regards， Dawn       ... View more

Hi All, I usually access HIVE data via SAS through below ODBC access: libname rbana odbc user=XXXXXXX password="XXXXXXXX." datasrc=prod schema=my_schema; (user and password is my staff_id and password.)   This hard coding method disallowed due to some reason. Any other solutions to connenct to the HIVE data via SAS? Say connect first, then let me to input my user-id and password? Thanks & Regards, Dawn     ... View more

Morning!   I have transcoding problem.   A CSV(contain English and Chinese character) to be imported to SAS format.   1. workable code data &filename ; ; infile "&filepath" delimiter = ',' ENCODING="UTF-8" MISSOVER DSD lrecl=32767 firstobs=2 ;   2.failure code libname dw "..." Inencoding=any; data dw.&filename ; ; infile "&filepath" delimiter = ',' ENCODING="UTF-8" MISSOVER DSD lrecl=32767 firstobs=2 ;   3. error log ERROR: Some character data was lost during transcoding in the dataset DW.TRANSACTIONS_HIST_TABLE_20200325. Either the data contains characters that are not representable in the new encoding or truncation occurred during transcoding.   As you can see, if import to work, code runs OK without error;(English/number/Chinese are imported correctly) while import to libname DW, code runs with error. (English/number are imported correctly, Chinese character not imported)   SAS 9.3/EG 5.1 used. Chinese language supported.   Can anyone give a solution?   Thanks and Regards, Dawn ... View more