y***6
发帖数: 46 | 1 The following is the problem incurred when I try to import excel data file
into sas. Hope someone can help.
SAS Code:
proc import out=Work.Edu
datafile="C:\Documents and Settings\smith\Desktop\education.xls"
dbms=excel replace;
getnames=yes;
mixed=yes;
scantext=yes;
usedate=yes;
scantime=yes;
run;
The excel file have 25 variables and 1272 observation with some missing
values. In addition, the first row in excel f | c*******o
发帖数: 8869 | 2 mixed=yes拉.
【在 y***6 的大作中提到】
: The following is the problem incurred when I try to import excel data file
: into sas. Hope someone can help.
: SAS Code:
: proc import out=Work.Edu
: datafile="C:\Documents and Settings\smith\Desktop\education.xls"
: dbms=excel replace;
: getnames=yes;
: mixed=yes;
: scantext=yes;
: usedate=yes;
| y***6
发帖数: 46 | 3 Thanks comeandgo, I try to reset mixed=yes, the result is the same. Anyway,
thanks! | A*********u
发帖数: 8976 | 4 把excel里那些有内容的部分copy and paste到一个新的file里
除此之外的cells里不要做任何操作
然后再import
Thanks comeandgo, I try to reset mixed=yes, the result is the same. Anyway,
thanks!
【在 y***6 的大作中提到】
: Thanks comeandgo, I try to reset mixed=yes, the result is the same. Anyway,
: thanks!
|
|
