请教 数据导入问题

高手 果然是高手 ！ 多谢指点 。

再请教一事， 刚才在处理数据时，又碰到如下问题：
165  data n.tab3_ba;
1166  set n.tab3;
1167  array dt{*} _:;
ERROR: All variables in array list must be the same type, i.e., all numeric or character.
ERROR: All variables in array list must be the same type, i.e., all numeric or character.
ERROR: All variables in array list must be the same type, i.e., all numeric or character.
ERROR: All variables in array list must be the same type, i.e., all numeric or character.
1168  do i=1 to dim(dt);
在处理 tab1, tab2都没有问题， 就处理到tab3， 出现了 。
变量必须相同格式吗？ 好像tab1 tab2里的格式 和tab3里的格式是一样的

怎么处理这种问题？ 谢谢！

变量必须相同格式吗？
Yeah. Elements in the  array have to be in the same type, either numeric or character. 好像tab1 tab2里的格式 和tab3里的格式是一样的
You can use proc contents to see the variable info, such as type, format, etc.

For tackling the problem you mentioned, it will spend much time on that.
if only few of them are different types, you could change the type one by one.
Of note, when you merge by differnt data set, the same-name variables have to be in the same type too.

I suggest, you can change the type in EXCEL before reading into SAS. For example, change all variables to text format.

你直接把五个excel打包贴上来得了 麻烦还得猜

其实， 你只要把每个表格的信息（从 proc contents 来）贴出就行了。我想许多人都可以帮助解决问题了。

23楼, the video is fun. Every time click "RUN", there is a black DOS window jump out. You have to close it every time. How that happens?

yongyitian 发表于 2009-8-19 01:19
23楼, the video is fun. Every time click "RUN", there is a black DOS window jump out. You have to close it every time. How that happens?

no ,not every time, i guess this macro programe may use  windows's cmd part.

sushe1527 发表于 2009-8-19 01:39

yongyitian 发表于 2009-8-19 01:19
23楼, the video is fun. Every time click "RUN", there is a black DOS window jump out. You have to close it every time. How that happens?

no ,not every time, i guess this macro programe may use  windows's cmd part.

Thanks for reply.

22# jingju11

用 proc contents 终于找到原因了 ：

128	_003_7_31	Num	8			2003-7-31
129	_003_8_29	Num	8			2003-8-29
130	_003_9_30	Num	8			2003-9-30
143	_004_10_29	Char	1	$1.	$1.	2004-10-29
144	_004_11_30	Char	1	$1.	$1.	2004-11-30
145	_004_12_31	Char	1	$1.	$1.	2004-12-31
134	_004_1_30	Num	8			2004-1-30
135	_004_2_27	Num	8			2004-2-27
136	_004_3_31	Num	8			2004-3-31
137	_004_4_30	Num	8			2004-4-30
138	_004_5_31	Num	8			2004-5-31
139	_004_6_30	Num	8			2004-6-30
140	_004_7_30	Num	8			2004-7-30
141	_004_8_31	Num	8			2004-8-31
142	_004_9_30	Num	8			2004-9-30
155	_005_10_31	Num	8			2005-10-31
156	_005_11_30	Num	8			2005-11-30
157	_005_12_30	Num	8			2005-12-30
146	_005_1_31	Char	1	$1.	$1.	2005-1-31
147	_005_2_28	Num	8			2005-2-28

有四个值 是char的

也把我原始excel表格附上，看是在excel上改方便？还是 用sas语句 更改这四个值的格式？
多谢各位 的帮助

28# funwin


data tab_;
set tab (rename=(_004_10_29=Dt_004_10_29
          _004_10_30=Dt_004_10_30
          _004_10_31=Dt_004_10_31
          _005_1_31=Dt_005_1_31
          ));
_004_10_29=input(Dt_004_10_29,1.); *change to numeric;
_004_10_30=input(Dt_004_10_30,1.);
_004_10_31=input(Dt_004_10_31,1.);
_005_1_31  =input(Dt_005_1_31,  1.);
array Dt{*} _:;
....
;
drop Dt_:;
run;

data tab_;
set tab (rename=(_004_10_29=Dt_004_10_29
          _004_11_30=Dt_004_11_30
          _004_12_31=Dt_004_12_31
          _005_1_31=Dt_005_1_31
          ));
_004_10_29=input(Dt_004_10_29,1.); *change to numeric;
_004_11_30=input(Dt_004_11_30,1.);
_004_12_31=input(Dt_004_12_31,1.);
_005_1_31  =input(Dt_005_1_31,  1.);
array Dt{*} _:;
....
;
drop Dt_:;
run;
*sorry, made the mistake on some dates;