Proc import : numeric values are imported as character

[SASdevAnneMarie]

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.

[Kurt_Bremser]

• Define a named range starting in row 7, and use that in IMPORT
• Or save the whole thing to csv and read it with a DATA step and FIRSTOBS=8