국민노후보장패널조사에서는 1~7차년도 개인 데이터를 횡으로 머지한 데이터(KReISPW)를 제공하고 있다. 이 경우 각 차수 별로 필요한 변수를 추출한 후 pid를 기준변수로 정렬한 뒤 merge 한다.
예를 들어 1~7차년도 개인자료를 횡으로 머지하는 경우, 다음과 같은 절차를 따른다.
① 1~7차년도 가구자료에서 각각 필요한 변수를 추출한다.
② 기준변수 개인번호(pid)로 정렬한다.
③ 개인번호(pid)를 기준으로 merge한다.
/* sas Merge문 활용 */
data p01; set k.kreisp01;
keep pid p01a001 p01a002 p01a003;
run;
proc sort; by pid; run;
data p02; set k.kreisp02;
keep pid p02a001 p02a002 p02a003;
run;
proc sort; by pid; run;
data p03; set k.kreisp03;
keep pid p03a001 p03a002 p03a003; run;
proc sort; by pid; run;
data p04; set k.kreisp04;
keep pid p04a001 p04a002 p04a003; run;
proc sort; by pid; run;
data p05; set k.kreisp05;
keep pid p05a001 p05a002 p05a003; run;
proc sort; by pid; run;
data p06; set k.kreisp06;
keep pid p06a001 p06a002 p06a003; run;
proc sort; by pid; run;
data p07; set k.kreisp07;
keep hid w01hid w02hid w03hid w04hid w05hid w06hid w07hid pid hos pos pent w01psvy w02psvy w03psvy w04psvy w05psvy w06psvy w07psvy p07a001 p07a002 p07a003; run;
proc sort; by pid; run;
data pw;
retain hid w01hid w02hid w03hid w04hid w05hid w06hid w07hid pid hos pos pent w01psvy w02psvy w03psvy w04psvy w05psvy w06psvy w07psvy p01a001 p01a002 p01a003 p02a001 p02a002 p02a003 p03a001 p03a002 p03a003 p04a001 p04a002 p04a003 p05a001 p05a002 p05a003 p06a001 p06a002 p06a003 p07a001 p07a002 p07a003;
merge p01 p02 p03 p04 p05 p06 p07;
by pid; run;
/* spss Match문 활용 */
get file='D:\KReIS\SPSS\kreisp01.sav'
/keep=pid p01a001 p01a002 p01a003.
sort cases by pid.
save out ='D:\KReIS\SPSS\p01.sav'.
get file='D:\KReIS\SPSS\kreisp02.sav'
/keep=pid p02a001 p02a002 p02a003.
sort cases by pid.
save out ='D:\KReIS\SPSS\p02.sav'.
get file='D:\KReIS\SPSS\kreisp03.sav'
/keep=pid p03a001 p03a002 p03a003.
sort cases by pid.
save out ='D:\KReIS\SPSS\p03.sav'.
get file='D:\KReIS\SPSS\kreisp04.sav'
/keep=pid p04a001 p04a002 p04a003.
sort cases by pid.
save out ='D:\KReIS\SPSS\p04.sav'.
get file='D:\KReIS\SPSS\kreisp05.sav'
/keep=pid p05a001 p05a002 p05a003.
sort cases by pid.
save out ='D:\KReIS\SPSS\p05.sav'.
get file='D:\KReIS\SPSS\kreisp06.sav'
/keep=pid p06a001 p06a002 p06a003.
sort cases by pid.
save out ='D:\KReIS\SPSS\p06.sav'.
get file='D:\KReIS\SPSS\kreisp07.sav'
/keep=hid w01hid w02hid w03hid w04hid w05hid w06hid w07hid pid hos pos pent w01psvy w02psvy w03psvy w04psvy w05psvy w06psvy w07psvy p07a001 p07a002 p07a003.
sort cases by pid.
save out ='D:\KReIS\SPSS\p07.sav'.
match files /file='D:\KReIS\SPSS\p01.sav'
/file='D:\KReIS\SPSS\p02.sav'
/file='D:\KReIS\SPSS\p03.sav’
/file=’D:\KReIS\SPSS\p04.sav’
/file=’D:\KReIS\SPSS\p05.sav’
/file=’D:\KReIS\SPSS\p06.sav’
/file=’D:\KReIS\SPSS\p07.sav’
/by pid.
save out ='D:\KReIS\SPSS\pw.sav'.
get file='D:\KReIS\SPSS\pw.sav'
/keep=hid w01hid w02hid w03hid w04hid w05hid w06hid w07hid pid hos pos pent w01psvy w02psvy w03psvy w04psvy w05psvy w06psvy w07psvy p01a001 p01a002 p01a003 p02a001 p02a002 p02a003 p03a001 p03a002 p03a003 p04a001 p04a002 p04a003 p05a001 p05a002 p05a003 p06a001 p06a002 p06a003 p07a001 p07a002 p07a003.
save out ='D:\KReIS\SPSS\pw.sav'.
/* stata Merge문 활용 */
use "D:\KReIS\STATA\kreisp01.dta", clear
keep pid p01a001 p01a002 p01a003
sort pid
save "D:\KReIS\STATA\p01.dta", replace
use "D:\KReIS\STATA\kreisp02.dta", clear
keep pid p02a001 p02a002 p02a003
sort pid
save "D:\KReIS\STATA\p02.dta", replace
use "D:\KReIS\STATA\kreisp03.dta", clear
keep pid p03a001 p03a002 p03a003
sort pid
save "D:\KReIS\STATA\p03.dta", replace
use "D:\KReIS\STATA\kreisp04.dta", clear
keep pid p04a001 p04a002 p04a003
sort pid
save "D:\KReIS\STATA\p04.dta", replace
use "D:\KReIS\STATA\kreisp05.dta", clear
keep pid p05a001 p05a002 p05a003
sort pid
save "D:\KReIS\STATA\p05.dta", replace
use "D:\KReIS\STATA\kreisp06.dta", clear
keep pid p06a001 p06a002 p06a003
sort pid
save "D:\KReIS\STATA\p06.dta", replace
use "D:\KReIS\STATA\kreisp07.dta", clear
keep hid w01hid w02hid w03hid w04hid w05hid w06hid w07hid pid hos pos pent w01psvy w02psvy w03psvy w04psvy w05psvy w06psvy w07psvy p07a001 p07a002 p07a003
sort pid
save "D:\KReIS\STATA\p07.dta", replace
use "D:\KReIS\STATA\p01.dta", clear
merge pid using "D:\KReIS\STATA\p02.dta" "D:\KReIS\STATA\p03.dta" "D:\KReIS\STATA\p04.dta" "D:\KReIS\STATA\p05.dta" "D:\KReIS\STATA\p06.dta" "D:\KReIS\STATA\p07.dta", unique sort
keep hid w01hid w02hid w03hid w04hid w05hid w06hid w07hid pid hos pos pent w01psvy w02psvy w03psvy w04psvy w05psvy w06psvy w07psvy p01a001 p01a002 p01a003 p02a001 p02a002 p02a003 p03a001 p03a002 p03a003 p04a001 p04a002 p04a003 p05a001 p05a002 p05a003 p06a001 p06a002 p06a003 p07a001 p07a002 p07a003
order hid w01hid w02hid w03hid w04hid w05hid w06hid w07hid pid hos pos pent w01psvy w02psvy w03psvy w04psvy w05psvy w06psvy w07psvy p01a001 p01a002 p01a003 p02a001 p02a002 p02a003 p03a001 p03a002 p03a003 p04a001 p04a002 p04a003 p05a001 p05a002 p05a003 p06a001 p06a002 p06a003 p07a001 p07a002 p07a003
save "D:\KReIS\STATA\pw.dta", replace