嗯 谢谢楼上的解答 有没有办法 可以不手动添加第一行观测吗？

在excel里把空值替换掉。。。CTRL+H

You have to specify the type of all the variables you are worried might be imported incorrectly, but you won't have to specify the type of every variable you're importing.


LIBNAME mylibname EXCEL "mypath.xlsx";

data dataset_name;

set mylibname.excelrange (dbSasType=(myVar1=NUMERIC myVar2=NUMERIC myVar3=NUMERIC));

run;

LIBNAME mylibname CLEAR;

try guessingrows

I used a substitute function in Excel to fill any blank cells to ., which is numeric missing in SAS.

谢谢大家的帮忙，小弟十分感激~