topic Importing Excel file in SAS having special character in SAS Programming

Importing Excel file in SAS having special character

surajmetha55 — Sat, 07 Sep 2019 04:16:22 GMT

Dear all,

I am trying to import Excel file using 2 different program and also tried using SAS import wizard but non of them help me out :

Program 1:

proc import datafile="W:\auto\Trial.xlsx"
		out = T dbms = xlsx ;
		sheet="TI";
		getnames=yes;	
run;

gives all observation but warning message in log :

WARNING: Some character data was lost during transcoding in column: IETEST at obs 3.

Program 2:

libname sur pcfiles path="W:\auto\Trial.xlsx" ;

data ag;
	set sur.'Ti$'n;
  run;

Both of the program are not able to read "β" (Beta-symbol) and superscript number come to base.

Can you please help me to deal with importing "xlsx" without changing special character.

Sample excel data

Re: Importing Excel file in SAS having special character

tomrvincent — Fri, 06 Sep 2019 11:46:57 GMT

Try 'getnames=no' to see if the data will come in at all. I often do this to bring data in as text that I can then manipulate more freely.

Re: Importing Excel file in SAS having special character

surajmetha55 — Sat, 07 Sep 2019 04:09:33 GMT

Thank you for replay. Trying 'getnames=no' just changed Variable name. Do you bring data text manually or programaticaly, if yes can you share program or give some hint.

Even I tried using SAS import wizard but it is also not helping me out.

Re: Importing Excel file in SAS having special character

tomrvincent — Mon, 09 Sep 2019 13:04:39 GMT

Yes, it does, but you can rename the variables based on whatever row you have the column names in. Also, since they all come in as text, you can test whether they successfully convert to numbers or dates.

Re: Importing Excel file in SAS having special character

tomrvincent — Mon, 09 Sep 2019 13:19:06 GMT

Also, this might help you:

https://communities.sas.com/t5/SAS-Programming/Import-data-from-MS-access-Excel-while-retaining-special/m-p/352237#M82077

Re: Importing Excel file in SAS having special character

DWilson — Mon, 09 Sep 2019 20:56:33 GMT

@surajmetha55 wrote:
Dear all,
I am trying to import Excel file using 2 different program and also tried using SAS import wizard but non of them help me out :
Program 1:
proc import datafile="W:\auto\Trial.xlsx"
		out = T dbms = xlsx ;
		sheet="TI";
		getnames=yes;	
run;
gives all observation but warning message in log :

WARNING: Some character data was lost during transcoding in column: IETEST at obs 3.

Program 2:
libname sur pcfiles path="W:\auto\Trial.xlsx" ;

data ag;
	set sur.'Ti$'n;
  run;
Both of the program are not able to read "β" (Beta-symbol) and superscript number come to base.

Can you please help me to deal with importing "xlsx" without changing special character.

Sample excel data

You might try changing your SAS session encoding to UTF-8. If your SAS session encoding is already UTF-8 then I'm not sure why you are having the issue unless proc import is somehow treating the file as having Latin encoding.