Re: [問題] SAS proc sql的問題
用了
proc contents data=p91p1.d003 position;
run;
Engine/Host Dependent Information
Data Set Page Size 16384
Number of Data Set Pages 16
First Data Page 1
Max Obs per Page 49
Obs in First Data Page 34
Number of Data Set Repairs 0
File Name D:\my PAPER91_P1\d003.sas7bdat
Release Created 9.0101M3
Host Created XP_PRO
Alphabetic List of Variables and
Attributes
# Variable Type Len Label
1 F1 Num 8 F1
2 F2 Num 8 F2
3 F3 Num 8 F3
然後再用
proc contents data=p91p1.d004 position;
run;
Engine/Host Dependent Information
Data Set Page Size 16384
Number of Data Set Pages 65
First Data Page 2
Max Obs per Page 12
Obs in First Data Page 12
Number of Data Set Repairs 0
File Name D:\my PAPER91_P1\d004.sas7bdat
Release Created 9.0101M3
Host Created XP_PRO
Alphabetic List of Variables and
Attributes
# Variable Type Len Label
1 F1 Num 8 F1
2 F2 Num 8 F2
3 F3 Num 8 F3
d003和d004第一個變數f1是同一個觀察值
而d003和d004的f2和f3都分別是不同的問項
因為這些問項分處在不同的表格中
所以才想要抓到另一個新的表格把他merge在一起
用了proc contents後
覺得兩張表格的結構應該是沒有問題才對
當然我也有把這兩張表格讀到work這個檔案夾中
照版友的指示去做
但也還是失敗了
謝謝解答
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 140.115.165.142
→
04/10 17:13, , 1F
04/10 17:13, 1F
→
04/10 17:14, , 2F
04/10 17:14, 2F
→
04/10 17:14, , 3F
04/10 17:14, 3F
→
04/10 17:15, , 4F
04/10 17:15, 4F
討論串 (同標題文章)
完整討論串 (本文為第 5 之 7 篇)：