Regression 问题

fhr19

3121

收藏 2012-03-06

final data.xls
大小:(1.28 MB)

马上下载

请教各位大牛,我的worksheet 在附件中，为什么我用这些变量做regression ：

proc reg data=a;

model controlpremium= totaltransactionvalue priorcap percentsought totalcommonequity time sic beta gdp;

run;

会报错那？

扫码加我拉你入群

请注明：姓名-公司-职位

以便审核进群资格，未注明则拒绝

全部回复

fhr19

2012-3-6 03:01:05

ERROR: Variable totaltransactionvalue in list does not match type prescribed for this list.
ERROR: Variable priorcap in list does not match type prescribed for this list.
ERROR: Variable percentsought in list does not match type prescribed for this list.
ERROR: Variable totalcommonequity in list does not match type prescribed for this list.
ERROR: Variable beta in list does not match type prescribed for this list.
这样的错误是不是变量类型有问题那?谢谢

扫码加我拉你入群

请注明：姓名-公司-职位

以便审核进群资格，未注明则拒绝

jingju11

2012-3-6 04:47:22

You are right. REG only takes numbers, not ones like numbers, '123', but true numbers, 123.
Jingju

扫码加我拉你入群

请注明：姓名-公司-职位

以便审核进群资格，未注明则拒绝

fhr19

2012-3-6 04:52:07

jingju11 发表于 2012-3-6 04:47
You are right. REG only takes numbers, not ones like numbers, '123', but true numbers, 123.
Jingju

then how could i change the currently numbers into the form i need? is there any command to do so? could u please do me a favor to give out some codes to fulfill that? Thanks so much for your help.

扫码加我拉你入群

请注明：姓名-公司-职位

以便审核进群资格，未注明则拒绝

fhr19

2012-3-6 05:02:07

jingju11 发表于 2012-3-6 04:47
You are right. REG only takes numbers, not ones like numbers, '123', but true numbers, 123.
Jingju

another question is that the numbers like, '123', can be calculated but cant do the regression right? cus i conducted calculation on the same dataset. it works, but when i wanna do regression it stuck there.

扫码加我拉你入群

请注明：姓名-公司-职位

以便审核进群资格，未注明则拒绝

jingju11

2012-3-6 05:24:22

Please google how to check and change variable types.
JingJu

扫码加我拉你入群

请注明：姓名-公司-职位

以便审核进群资格，未注明则拒绝

点击查看更多内容…

fhr19

2012-3-6 05:36:06

jingju11 发表于 2012-3-6 05:24
Please google how to check and change variable types.
JingJu

could the char numbers be calculated? thx:)

扫码加我拉你入群

请注明：姓名-公司-职位

以便审核进群资格，未注明则拒绝

jingju11

2012-3-6 05:40:35

what about thinking like that:
before REG fitting the model, it will check if the model was set correctly or not. one the checking rules is, all variables in the model statement have to be numeric type. but your code cannot pass the check-up.
for example,
age ='35'; *age is string;
age1 =input(age, best.); *age1 is numeric;
jingu

扫码加我拉你入群

请注明：姓名-公司-职位

以便审核进群资格，未注明则拒绝

fhr19

2012-3-6 05:51:02

jingju11 发表于 2012-3-6 05:24
Please google how to check and change variable types.
JingJu

data a;
set 'D:\a';
totaltransactionvalue1=put(totaltransactionvalue, 66.);
put totaltransactionvalue1;
run;
is this the code for transfering the data format? but why it doesnot work? plz give me some suggestions.

扫码加我拉你入群

请注明：姓名-公司-职位

以便审核进群资格，未注明则拒绝

491987939

2012-3-6 05:56:51

dddddddddddd

扫码加我拉你入群

请注明：姓名-公司-职位

以便审核进群资格，未注明则拒绝

jingju11

2012-3-6 06:01:05

a way to do..
Jingju

扫码加我拉你入群

请注明：姓名-公司-职位

以便审核进群资格，未注明则拒绝

fhr19

2012-3-6 06:21:55

jingju11 发表于 2012-3-6 06:01
hehe.
open the data table--->right click the variable you want check the type --->choose Column Att ...

hi prof. jingju, i have done that, i really appreciate!

扫码加我拉你入群

请注明：姓名-公司-职位

以便审核进群资格，未注明则拒绝

sunset1986

2012-3-6 09:05:11

Jingju's comments make much sense. You should follow that and technically, you'll get what you want.
input function can do you a favor in changing data format.
Google how to change data format from char to numeric and you'll see.

扫码加我拉你入群

请注明：姓名-公司-职位

以便审核进群资格，未注明则拒绝

扫码加我 拉你入群

扫码加我 拉你入群

扫码加我 拉你入群

扫码加我 拉你入群

扫码加我 拉你入群

扫码加我 拉你入群

扫码加我 拉你入群

扫码加我 拉你入群

扫码加我 拉你入群

扫码加我 拉你入群

扫码加我 拉你入群

扫码加我 拉你入群

扫码加我 拉你入群

分享

扫码加好友，拉您进群

扫码加我拉你入群

扫码加我拉你入群

扫码加我拉你入群

扫码加我拉你入群

扫码加我拉你入群

扫码加我拉你入群

扫码加我拉你入群

扫码加我拉你入群

扫码加我拉你入群

扫码加我拉你入群

扫码加我拉你入群

扫码加我拉你入群

扫码加我拉你入群