r*****n
发帖数: 92 | 1 用sas/access 读excel 文档， 文档第一行是内容提要， 第二行才是virable names
怎么让SAS默认第二行是headers? 网上没找到合适的答案。 谢谢！ |
s*r
发帖数: 2757 | 2 give me 100 if this works
DATAROW=n;
starts reading data from row number n in the external file.
Default: 1 when GETNAMES=NO
2 when GETNAMES=YES (default for GETNAMES=)
Interaction: When GETNAMES=YES, DATAROW= must be equal to or greater than 2. When GETNAMES=NO, DATAROW must be equal to or greater than 1. |
c*******o
发帖数: 8869 | 3 delete the first line, hehe
【在 r*****n 的大作中提到】
: 用sas/access 读excel 文档， 文档第一行是内容提要， 第二行才是virable names
: 怎么让SAS默认第二行是headers? 网上没找到合适的答案。 谢谢！
|
p********a
发帖数: 5352 | 4 datarow is good, or use range option
proc import ...;
sheet="xxx";
range="a2:c65536";
getnames=yes;
run; |
r*****n
发帖数: 92 | 5 Thanks for all the answers.but I was thinking of
using 'libname aaa excel ....' instead of proc import.
wondering if there's any options for reading from the
second row as header.
Thanks |
