Hi, I have a study trial summary which have alpha and Gamma characters in the data. i am trying to import the xlsx file but it is excluding the special character. can some one please elp me with a code to import these special characters in into SAS format. code i am using : filename name "C:\STATISTICS\ Trial Design_Specs.xlsx"; proc import datafile = name out = ts1 dbms = xlsx replace ; sheet = 'TS' ; run ; data tss; length STUDYID $200. DOMAIN $200. TSSEQ 8. TSPARMCD $200. TSPARM $200. TSVAL $200. TSVALNF $200. TSVALCD $200. TSVALCD $200. TSVCDREF $200.; TSVCDVER $200. ; set ts1; format _ALL_; informat _ALL_ ; run; data ts2 ; set tss(where=(studyid ne ''); TSVAL=strip(tranwrd(TSVAL, '0D0A'x, ' ')); run; I am getting the following warning in the log . NOTE: One or more variables were converted because the data type is not supported by the V9 engine. For more details, run with options MSGLEVEL=I. WARNING: Some character data was lost during transcoding in column: TSVAL at obs 26. NOTE: The import data set has 67 observations and 14 variables. NOTE: WORK.TS1 data set was successfully created. NOTE: PROCEDURE IMPORT used (Total process time): Thanks Neha
... View more