[程式] SAS logistic regression資料處理問題
[軟體程式類別]:
SAS
[程式問題]:
logistic regression的資料處理
[軟體熟悉度]:
低(1~3個月)
[問題敘述]:
我有一個a檔： 資料筆數有6500多筆，變數有13個、
dummy變數有26個(產業別21個、年度5個)，這個檔裡沒有任何missing
問題：但是proc means時，最後面的7個dummy variable皆顯示為N=0 mean=.
讀取不到任何資料，請問是否是因為變數太多資料太多造成的?
NOTE: 6533 records were read from the infile 'H:\0321\output\datamerge.txt'.
The minimum record length was 102.
The maximum record length was 118.
One or more lines were truncated.
NOTE: The data set WORK.A has 6533 observations and 39 variables.
NOTE: DATA statement used (Total process time):
real time 0.03 seconds
cpu time 0.01 seconds
和b、c檔merge之後，繼續跑logistic regeression
ERROR: There are no valid observations.
NOTE: The SAS System stopped processing this step because of errors.
NOTE: There were 6241 observations read from the data set WORK.TOTAL1.
NOTE: PROCEDURE LOGISTIC used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds
我找了好久也有把error的敘述去搜尋了，可是一直找不到原因
請大家幫忙一下，謝謝!
[程式範例]:
data a;
infile 'H:\0321\output\datamerge.txt' expandtabs firstobs=2 truncover;
input CODE LNTA GROWTH ROA LEV ARINV YEAR CLISTB CLISTH CLISTF OPINION INDE
OWN ind2 ind3 ind4 ind5 ind6 ind7 ind8 ind9 ind10 ind11 ind12
ind13 ind14 ind15 ind16 ind17 ind18 ind19 ind20 ind21 ind22
yr2 yr3 yr4 yr5 yr6;
proc sort; by CODE YEAR ;
proc means ;
.
.
.
.(中間是merge的過程，這部分已經確認沒有錯誤)
.
.
.
.
data total1;set total;
proc logistic descending ;
model BIG4=PRETRADE LNTA GROWTH ROA LEV ARINV CLISTB CLISTH CLISTF OPINION
INDE OWN ind2 ind3 ind4 ind5 ind6 ind7 ind8 ind9 ind10 ind11
ind12 ind13 ind14 ind15 ind16 ind17 ind18 ind19 ind20 ind21 ind22
yr2 yr3 yr4 yr5 yr6;
run;
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 122.122.220.188