Proc import : numeric values are imported as character

SASdevAnneMarie — Tue, 17 Jan 2023 14:33:15 GMT

Hello Experts,

I'm wondering how to import correctly the values while proc import.

My code is :

	proc import out= ZC20_test
		datafile = 'XXXX\Test_VL.xlsx'
		dbms = xlsx;
		sheet = "ZC20";
		getnames = yes;
	run;

I would like to have the values from the row=7 (in attached file) in numeric format, but all the values are on character.

Thank you for your help.

I joined the file.

Re: Proc import : numeric values are imported as character

Kurt_Bremser — Tue, 17 Jan 2023 14:50:37 GMT