l**********8 发帖数: 305 | 1 为啥log总是报错,说找不到file work.cartemp
%let dataloc = /disk/agedisk1/medicare/data/20pct/car;
libname bworkhos "/disk/agebulk5/medicare.work/lbaker-DUA23466/ausmita/temp"
;
libname temp "/disk/agebulk5/medicare.work/lbaker-DUA23466/lbaker/data/xw";
ods listing file = "/disk/agebulk5/medicare.work/lbaker-DUA23466/ausmita/
temp/carrier_12212015.lst";
proc printto
log="/disk/agebulk5/medicare.work/lbaker-DUA23466/ausmita/temp/carrier_
12212015.log";
run;
*-----------------------------------------------------;
%macro process(year,yr,file,first,numobs);
data cartemp;
set loc.carl&year.
(firstobs=&first. obs=&numobs.
keep=expnsdt1 hcpcs_cd bene_id lalowchg lprvpmt linepmt mdfr_cd1 mdfr_
cd2 betos plcsrvc
prf_npi prf_upin);
snf = (plcsrvc in ('31', '32', '33'));
hha = (plcsrvc in ('12'));
inpt = (plcsrvc in ('21'));
hspc = (plcsrvc in ('34'));
run;
proc sort data=cartemp;
by bene_id;
*append datasets;
%if &file.=1 %then %do;
data all_files;
set cartemp;
%end;
%else %do;
data all_files;
set all_files cartemp;
%end;
run;
%mend process; | s*********h 发帖数: 6288 | 2 data step出错了吧?libname loc没定义?
temp"
【在 l**********8 的大作中提到】![](/moin_static193/solenoid/img/up.png) : 为啥log总是报错,说找不到file work.cartemp : %let dataloc = /disk/agedisk1/medicare/data/20pct/car; : libname bworkhos "/disk/agebulk5/medicare.work/lbaker-DUA23466/ausmita/temp" : ; : libname temp "/disk/agebulk5/medicare.work/lbaker-DUA23466/lbaker/data/xw"; : ods listing file = "/disk/agebulk5/medicare.work/lbaker-DUA23466/ausmita/ : temp/carrier_12212015.lst"; : proc printto : log="/disk/agebulk5/medicare.work/lbaker-DUA23466/ausmita/temp/carrier_ : 12212015.log";
| l**********8 发帖数: 305 | 3 就是debug不出来,大神们救我啊
******************* 完整的 CODE ***************
%let dataloc = /disk/agedisk1/medicare/data/20pct/car;
libname bworkhos "/disk/agebulk5/medicare.work/lbaker-DUA23466/ausmita/temp"
;
*libname temp "/disk/agebulk5/medicare.work/lbaker-DUA23466/lbaker/data/xw";
ods listing file = "/disk/agebulk5/medicare.work/lbaker-DUA23466/ausmita/
temp/carrier_12222015.lst";
proc printto
log="/disk/agebulk5/medicare.work/lbaker-DUA23466/ausmita/temp/carrier_
12222015.log";
run;
*-----------------------------------------------------;
%macro process(year,yr,file,first,numobs);
data cartemp;
set loc.carl&year.
(firstobs=&first. obs=&numobs.
keep=expnsdt1 hcpcs_cd bene_id lalowchg lprvpmt linepmt mdfr_cd1 mdfr_
cd2 betos plcsrvc
prf_npi prf_upin);
snf = (plcsrvc in ('31', '32', '33'));
hha = (plcsrvc in ('12'));
inpt = (plcsrvc in ('21'));
hspc = (plcsrvc in ('34'));
run;
proc sort data=cartemp;
by bene_id;
*append datasets;
%if &file.=1 %then %do;
data all_files;
set cartemp;
%end;
%else %do;
data all_files;
set all_files cartemp;
%end;
run;
%mend process;
*-----------------------------------------------------;
%macro readin0611(year,yr,numfiles);
libname loc "&dataloc./&year.";
%process(&year. , &yr. , 1 , 1 , 34999999);
%process(&year. , &yr. , 2 , 35000000 , 69999999);
/*
%process(&year. , &yr. , 3 , 70000000 , 104999999);
%process(&year. , &yr. , 4 , 105000000 , 139999999);
%process(&year. , &yr. , 5 , 140000000 , 174999999);
%process(&year. , &yr. , 6 , 175000000 , 209999999);
%process(&year. , &yr. , 7 , 210000000 , 244999999);
%process(&year. , &yr. , 8 , 245000000 , 279999999);
%process(&year. , &yr. , 9 , 280000000 , 314999999);
%process(&year. , &yr. , 10, 315000000 , MAX);
*/
data bworkhos.carclaimlist&year.;
set all_files;
run;
*date_new = input(expnsdt1, date9.);
input expnsdt1 date9.;
put expnsdt1;
run;
proc contents data=bworkhos.carclaimlist&year.;
title "&year.";
proc print data=bworkhos.carclaimlist&year. (obs=150);
title "&year.";
run;
data bworkhos.finderfile;
set bworkhos.car&year. (keep=bene_id indexdat);
indexdate=indexdat;
proc sort data=bworkhos.finderfile;
by bene_id;
run;
data bworkhos.carclaimlist&year.;
merge bworkhos.carclaimlist&year. (in=in1)
bworkhos.finderfile (in=in2);
by bene_id;
run;
days=datdif(expnsdt1,indexdate,'act/act');
if in1 and in2;
if days>=-365 and days<=365;
* if (date_new-indexdate)>=-365 and (date_new-indexdate)<=365;
* if (expnsdt1-indexdate)>=-365 and (expnsdt1-indexdate)<=365;
***Reconciling npi upin using crosswalk;
libname benexw "/disk/agebulk5/medicare.work/lbaker-DUA23466/lbaker/data/xw";
data bworkhos.npixwalk (keep=prf_npi xw_upin);
set benexw.npi_upin_xw_final;
prf_npi=npi;
xw_upin=upin;
proc sort data=bworkhos.npixwalk;
by prf_npi;
proc sort data=bworkhos.carclaimlist&year.;
by prf_npi;
data bworkhos.carclaimlist&year. (drop=xw_upin); *taxnumhhibase;
merge bworkhos.carclaimlist&year. (in=in1)
bworkhos.npixwalk;
by prf_npi;
if in1;
length prf_physid $10;
prf_physid="none";
if prf_upin ne "" and prf_upin ne "none" then prf_physid=prf_upin;
else if xw_upin ne "" then prf_physid=xw_upin;
else prf_physid=prf_npi;
%mend readin0611;
*-----------------------------------------------------;
%readin0611(2006,06,1);
/*
%readin0611(2007,07,1);
%readin0611(2008,08,1);
%readin0611(2009,09,1);
%readin0611(2010,10,1);
%readin0611(2011,11,1);
*/
run;
ods listing close;
*************** Log 报错信息 **************************
180: LINE and COLUMN cannot be determined.
NOTE: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the
LINE and
COLUMN where the error has occurred.
ERROR 180-322: Statement is not valid or it is used out of proper order.
180: LINE and COLUMN cannot be determined.
NOTE: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the
LINE and
COLUMN where the error has occurred.
ERROR 180-322: Statement is not valid or it is used out of proper order.
SYMBOLGEN: Macro variable YEAR resolves to 2006
SYMBOLGEN: Macro variable YEAR resolves to 2006
NOTE: SAS set option OBS=0 and will continue to check statements.
This might cause NOTE: No observations in data set.
NOTE: The PROCEDURE CONTENTS printed page 1.
NOTE: PROCEDURE CONTENTS used (Total process time):
real time 2.07 seconds
cpu time 0.01 seconds
SYMBOLGEN: Macro variable YEAR resolves to 2006
SYMBOLGEN: Macro variable YEAR resolves to 2006
NOTE: PROCEDURE PRINT used (Total process time):
real time 0.02 seconds
cpu time 0.00 seconds
SYMBOLGEN: Macro variable YEAR resolves to 2006
NOTE: The data set BWORKHOS.FINDERFILE has 0 observations and 3 variables.
WARNING: Data set BWORKHOS.FINDERFILE was not replaced because this step was
stopped.
NOTE: DATA statement used (Total process time):
real time 0.99 seconds
cpu time 0.01 seconds
NOTE: PROCEDURE SORT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
SYMBOLGEN: Macro variable YEAR resolves to 2006
SYMBOLGEN: Macro variable YEAR resolves to 2006
NOTE: The data set BWORKHOS.CARCLAIMLIST2006 has 0 observations and 18
variables. | l**********8 发帖数: 305 | 4 就是debug不出来,大神们救我啊
******************* 完整的 CODE ***************
%let dataloc = /disk/agedisk1/medicare/data/20pct/car;
libname bworkhos "/disk/agebulk5/medicare.work/lbaker-DUA23466/ausmita/temp"
;
*libname temp "/disk/agebulk5/medicare.work/lbaker-DUA23466/lbaker/data/xw";
ods listing file = "/disk/agebulk5/medicare.work/lbaker-DUA23466/ausmita/
temp/carrier_12222015.lst";
proc printto
log="/disk/agebulk5/medicare.work/lbaker-DUA23466/ausmita/temp/carrier_
12222015.log";
run;
*-----------------------------------------------------;
%macro process(year,yr,file,first,numobs);
data cartemp;
set loc.carl&year.
(firstobs=&first. obs=&numobs.
keep=expnsdt1 hcpcs_cd bene_id lalowchg lprvpmt linepmt mdfr_cd1 mdfr_
cd2 betos plcsrvc
prf_npi prf_upin);
snf = (plcsrvc in ('31', '32', '33'));
hha = (plcsrvc in ('12'));
inpt = (plcsrvc in ('21'));
hspc = (plcsrvc in ('34'));
run;
proc sort data=cartemp;
by bene_id;
*append datasets;
%if &file.=1 %then %do;
data all_files;
set cartemp;
%end;
%else %do;
data all_files;
set all_files cartemp;
%end;
run;
%mend process;
*-----------------------------------------------------;
%macro readin0611(year,yr,numfiles);
libname loc "&dataloc./&year.";
%process(&year. , &yr. , 1 , 1 , 34999999);
%process(&year. , &yr. , 2 , 35000000 , 69999999);
/*
%process(&year. , &yr. , 3 , 70000000 , 104999999);
%process(&year. , &yr. , 4 , 105000000 , 139999999);
%process(&year. , &yr. , 5 , 140000000 , 174999999);
%process(&year. , &yr. , 6 , 175000000 , 209999999);
%process(&year. , &yr. , 7 , 210000000 , 244999999);
%process(&year. , &yr. , 8 , 245000000 , 279999999);
%process(&year. , &yr. , 9 , 280000000 , 314999999);
%process(&year. , &yr. , 10, 315000000 , MAX);
*/
data bworkhos.carclaimlist&year.;
set all_files;
run;
*date_new = input(expnsdt1, date9.);
input expnsdt1 date9.;
put expnsdt1;
run;
proc contents data=bworkhos.carclaimlist&year.;
title "&year.";
proc print data=bworkhos.carclaimlist&year. (obs=150);
title "&year.";
run;
data bworkhos.finderfile;
set bworkhos.car&year. (keep=bene_id indexdat);
indexdate=indexdat;
proc sort data=bworkhos.finderfile;
by bene_id;
run;
data bworkhos.carclaimlist&year.;
merge bworkhos.carclaimlist&year. (in=in1)
bworkhos.finderfile (in=in2);
by bene_id;
run;
days=datdif(expnsdt1,indexdate,'act/act');
if in1 and in2;
if days>=-365 and days<=365;
* if (date_new-indexdate)>=-365 and (date_new-indexdate)<=365;
* if (expnsdt1-indexdate)>=-365 and (expnsdt1-indexdate)<=365;
***Reconciling npi upin using crosswalk;
libname benexw "/disk/agebulk5/medicare.work/lbaker-DUA23466/lbaker/data/xw";
data bworkhos.npixwalk (keep=prf_npi xw_upin);
set benexw.npi_upin_xw_final;
prf_npi=npi;
xw_upin=upin;
proc sort data=bworkhos.npixwalk;
by prf_npi;
proc sort data=bworkhos.carclaimlist&year.;
by prf_npi;
data bworkhos.carclaimlist&year. (drop=xw_upin); *taxnumhhibase;
merge bworkhos.carclaimlist&year. (in=in1)
bworkhos.npixwalk;
by prf_npi;
if in1;
length prf_physid $10;
prf_physid="none";
if prf_upin ne "" and prf_upin ne "none" then prf_physid=prf_upin;
else if xw_upin ne "" then prf_physid=xw_upin;
else prf_physid=prf_npi;
%mend readin0611;
*-----------------------------------------------------;
%readin0611(2006,06,1);
/*
%readin0611(2007,07,1);
%readin0611(2008,08,1);
%readin0611(2009,09,1);
%readin0611(2010,10,1);
%readin0611(2011,11,1);
*/
run;
ods listing close;
*************** Log 报错信息 **************************
180: LINE and COLUMN cannot be determined.
NOTE: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the
LINE and
COLUMN where the error has occurred.
ERROR 180-322: Statement is not valid or it is used out of proper order.
180: LINE and COLUMN cannot be determined.
NOTE: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the
LINE and
COLUMN where the error has occurred.
ERROR 180-322: Statement is not valid or it is used out of proper order.
SYMBOLGEN: Macro variable YEAR resolves to 2006
SYMBOLGEN: Macro variable YEAR resolves to 2006
NOTE: SAS set option OBS=0 and will continue to check statements.
This might cause NOTE: No observations in data set.
NOTE: The PROCEDURE CONTENTS printed page 1.
NOTE: PROCEDURE CONTENTS used (Total process time):
real time 2.07 seconds
cpu time 0.01 seconds
SYMBOLGEN: Macro variable YEAR resolves to 2006
SYMBOLGEN: Macro variable YEAR resolves to 2006
NOTE: PROCEDURE PRINT used (Total process time):
real time 0.02 seconds
cpu time 0.00 seconds
SYMBOLGEN: Macro variable YEAR resolves to 2006
NOTE: The data set BWORKHOS.FINDERFILE has 0 observations and 3 variables.
WARNING: Data set BWORKHOS.FINDERFILE was not replaced because this step was
stopped.
NOTE: DATA statement used (Total process time):
real time 0.99 seconds
cpu time 0.01 seconds
NOTE: PROCEDURE SORT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
SYMBOLGEN: Macro variable YEAR resolves to 2006
SYMBOLGEN: Macro variable YEAR resolves to 2006
NOTE: The data set BWORKHOS.CARCLAIMLIST2006 has 0 observations and 18
variables. | m*********6 发帖数: 482 | 5 cartemp没有被创建,要么没找到loc.carl&year.,要么data step里语句有问题。上个
完整的log吧,前面的cartemp和all_files为空,后面的dataset必须为空啊。现在显示
的log看不出来data cartemp那步发生了什么 | s******8 发帖数: 102 | 6 NOTE: SAS set option OBS=0 and will continue to check statements.
This might cause NOTE: No observations in data set. | l**********8 发帖数: 305 | 7
************************************************************
上个完整的LOG, 谢谢大家了
****************************************************************
NOTE: PROCEDURE PRINTTO used (Total process time):
real time 0.00 seconds
cpu time 0.01 seconds
25
26 *-----------------------------------------------------;
27 %macro process(year,yr,file,first,numobs);
28
29 data cartemp;
30 set loc.carl&year.
31 (firstobs=&first. obs=&numobs.
32 keep=expnsdt1 hcpcs_cd bene_id lalowchg lprvpmt linepmt mdfr
_cd1 mdfr_cd2
32 ! betos plcsrvc
33 prf_npi prf_upin);
34
35 snf = (plcsrvc in ('31', '32', '33'));
36 hha = (plcsrvc in ('12'));
37 inpt = (plcsrvc in ('21'));
38 hspc = (plcsrvc in ('34'));
39
40 run;
41
42
43 proc sort data=cartemp;
44 by bene_id;
45
46 *append datasets;
47
48 %if &file.=1 %then %do;
49 data all_files;
50 set cartemp;
51 %end;
52 %else %do;
53 data all_files;
54 set all_files cartemp;
55 %end;
56 run;
57
58
59 %mend process;
60
61
3 The SAS System 10:09 Tuesday,
December 22, 2015
62
63 *-----------------------------------------------------;
64 %macro readin0611(year,yr,numfiles);
65 libname loc "&dataloc./&year.";
66
67
68 %process(&year. , &yr. , 1 , 1 , 34999999);
69 %process(&year. , &yr. , 2 , 35000000 , 69999999);
70 %process(&year. , &yr. , 3 , 70000000 , 104999999);
71 %process(&year. , &yr. , 4 , 105000000 , 139999999);
72 %process(&year. , &yr. , 5 , 140000000 , 174999999);
73 %process(&year. , &yr. , 6 , 175000000 , 209999999);
74 %process(&year. , &yr. , 7 , 210000000 , 244999999);
75 %process(&year. , &yr. , 8 , 245000000 , 279999999);
76 %process(&year. , &yr. , 9 , 280000000 , 314999999);
77 %process(&year. , &yr. , 10, 315000000 , MAX);
78
79
80 data bworkhos.carclaimlist&year.;
81 set all_files;
82 run;
83
84 *date_new = input(expnsdt1, date9.);
85 input expnsdt1 date9.;
86 put expnsdt1;
87 run;
88
89
90
91 proc contents data=bworkhos.carclaimlist&year.;
92 title "&year.";
93 proc print data=bworkhos.carclaimlist&year. (obs=150);
94 title "&year.";
95 run;
96
97 data bworkhos.finderfile;
98 set bworkhos.car&year. (keep=bene_id indexdat);
99 indexdate=indexdat;
100 proc sort data=bworkhos.finderfile;
101 by bene_id;
102 run;
103
104 data bworkhos.carclaimlist&year.;
105 merge bworkhos.carclaimlist&year. (in=in1)
106 bworkhos.finderfile (in=in2);
107 by bene_id;
108 run;
109
110
111 days=datdif(expnsdt1,indexdate,'act/act');
112
113
114
115 if in1 and in2;
116
117 if days>=-365 and days<=365;
118
119 * if (date_new-indexdate)>=-365 and (date_new-indexdate)<=365;
4 The SAS System 10:09 Tuesday,
December 22, 2015
120
121 * if (expnsdt1-indexdate)>=-365 and (expnsdt1-indexdate)<=365;
122
123 ***Reconciling npi upin using crosswalk;
124 libname benexw "/disk/agebulk5/medicare.work/lbaker-DUA23466/
lbaker/data/xw";
125 data bworkhos.npixwalk (keep=prf_npi xw_upin);
126 set benexw.npi_upin_xw_final;
127
128 prf_npi=npi;
129 xw_upin=upin;
130
131 proc sort data=bworkhos.npixwalk;
132 by prf_npi;
133
134
135 proc sort data=bworkhos.carclaimlist&year.;
136 by prf_npi;
137
138
139 data bworkhos.carclaimlist&year. (drop=xw_upin); *taxnumhhibase;
140 merge bworkhos.carclaimlist&year. (in=in1)
141 bworkhos.npixwalk;
142 by prf_npi;
143 if in1;
144
145 length prf_physid $10;
146 prf_physid="none";
147 if prf_upin ne "" and prf_upin ne "none" then prf_physid=prf
_upin;
148 else if xw_upin ne "" then prf_physid=xw_upin;
149 else prf_physid=prf_npi;
150
151
152 %mend readin0611;
153 *-----------------------------------------------------;
154
155
156
157 %readin0611(2006,06,1);
SYMBOLGEN: Macro variable DATALOC resolves to /disk/agedisk1/medicare/data/
20pct/car
SYMBOLGEN: Macro variable YEAR resolves to 2006
NOTE: Libref LOC was successfully assigned as follows:
Engine: V9
Physical Name: /disk/agedisk1/medicare/data/20pct/car/2006
SYMBOLGEN: Macro variable YEAR resolves to 2006
SYMBOLGEN: Macro variable YR resolves to 06
SYMBOLGEN: Macro variable YEAR resolves to 2006
SYMBOLGEN: Macro variable FIRST resolves to 1
SYMBOLGEN: Macro variable NUMOBS resolves to 34999999
NOTE: There were 34999999 observations read from the data set LOC.CARL2006.
NOTE: The data set WORK.CARTEMP has 34999999 observations and 16 variables.
NOTE: DATA statement used (Total process time):
real time 30.39 seconds
cpu time 8.87 seconds
SYMBOLGEN: Macro variable FILE resolves to 1
5 The SAS System 10:09 Tuesday,
December 22, 2015
NOTE: There were 34999999 observations read from the data set WORK.CARTEMP.
NOTE: The data set WORK.CARTEMP has 34999999 observations and 16 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 17.66 seconds
cpu time 17.00 seconds
NOTE: There were 34999999 observations read from the data set WORK.CARTEMP.
NOTE: The data set WORK.ALL_FILES has 34999999 observations and 16 variables.
NOTE: DATA statement used (Total process time):
real time 4.46 seconds
cpu time 4.14 seconds
SYMBOLGEN: Macro variable YEAR resolves to 2006
SYMBOLGEN: Macro variable YR resolves to 06
SYMBOLGEN: Macro variable YEAR resolves to 2006
SYMBOLGEN: Macro variable FIRST resolves to 35000000
SYMBOLGEN: Macro variable NUMOBS resolves to 69999999
NOTE: There were 35000000 observations read from the data set LOC.CARL2006.
NOTE: The data set WORK.CARTEMP has 35000000 observations and 16 variables.
NOTE: DATA statement used (Total process time):
real time 24.13 seconds
cpu time 10.01 seconds
SYMBOLGEN: Macro variable FILE resolves to 2
NOTE: There were 35000000 observations read from the data set WORK.CARTEMP.
NOTE: The data set WORK.CARTEMP has 35000000 observations and 16 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 14.06 seconds
cpu time 16.90 seconds
NOTE: There were 34999999 observations read from the data set WORK.ALL_FILES.
NOTE: There were 35000000 observations read from the data set WORK.CARTEMP.
NOTE: The data set WORK.ALL_FILES has 69999999 observations and 16 variables.
NOTE: DATA statement used (Total process time):
real time 8.83 seconds
cpu time 8.71 seconds
SYMBOLGEN: Macro variable YEAR resolves to 2006
SYMBOLGEN: Macro variable YR resolves to 06
SYMBOLGEN: Macro variable YEAR resolves to 2006
SYMBOLGEN: Macro variable FIRST resolves to 70000000
SYMBOLGEN: Macro variable NUMOBS resolves to 104999999
NOTE: There were 35000000 observations read from the data set LOC.CARL2006.
NOTE: The data set WORK.CARTEMP has 35000000 observations and 16 variables.
NOTE: DATA statement used (Total process time):
real time 23.81 seconds
cpu time 11.08 seconds
6 The SAS System 10:09 Tuesday,
December 22, 2015
SYMBOLGEN: Macro variable FILE resolves to 3
NOTE: There were 35000000 observations read from the data set WORK.CARTEMP.
NOTE: The data set WORK.CARTEMP has 35000000 observations and 16 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 13.87 seconds
cpu time 16.90 seconds
NOTE: There were 69999999 observations read from the data set WORK.ALL_FILES.
NOTE: There were 35000000 observations read from the data set WORK.CARTEMP.
NOTE: The data set WORK.ALL_FILES has 104999999 observations and 16
variables.
NOTE: DATA statement used (Total process time):
real time 29.17 seconds
cpu time 13.67 seconds
SYMBOLGEN: Macro variable YEAR resolves to 2006
SYMBOLGEN: Macro variable YR resolves to 06
SYMBOLGEN: Macro variable YEAR resolves to 2006
SYMBOLGEN: Macro variable FIRST resolves to 105000000
SYMBOLGEN: Macro variable NUMOBS resolves to 139999999
NOTE: There were 35000000 observations read from the data set LOC.CARL2006.
NOTE: The data set WORK.CARTEMP has 35000000 observations and 16 variables.
NOTE: DATA statement used (Total process time):
real time 23.14 seconds
cpu time 10.26 seconds
SYMBOLGEN: Macro variable FILE resolves to 4
NOTE: There were 35000000 observations read from the data set WORK.CARTEMP.
NOTE: The data set WORK.CARTEMP has 35000000 observations and 16 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 13.23 seconds
cpu time 16.87 seconds
NOTE: There were 104999999 observations read from the data set WORK.ALL_
FILES.
NOTE: There were 35000000 observations read from the data set WORK.CARTEMP.
NOTE: The data set WORK.ALL_FILES has 139999999 observations and 16
variables.
NOTE: DATA statement used (Total process time):
real time 1:36.93
cpu time 19.84 seconds
SYMBOLGEN: Macro variable YEAR resolves to 2006
SYMBOLGEN: Macro variable YR resolves to 06
SYMBOLGEN: Macro variable YEAR resolves to 2006
SYMBOLGEN: Macro variable FIRST resolves to 140000000
SYMBOLGEN: Macro variable NUMOBS resolves to 174999999
NOTE: There were 35000000 observations read from the data set LOC.CARL2006.
NOTE: The data set WORK.CARTEMP has 35000000 observations and 16 variables.
7 The SAS System 10:09 Tuesday,
December 22, 2015
NOTE: DATA statement used (Total process time):
real time 33.87 seconds
cpu time 10.26 seconds
SYMBOLGEN: Macro variable FILE resolves to 5
NOTE: There were 35000000 observations read from the data set WORK.CARTEMP.
NOTE: The data set WORK.CARTEMP has 35000000 observations and 16 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 14.39 seconds
cpu time 17.05 seconds
NOTE: There were 139999999 observations read from the data set WORK.ALL_
FILES.
NOTE: There were 35000000 observations read from the data set WORK.CARTEMP.
NOTE: The data set WORK.ALL_FILES has 174999999 observations and 16
variables.
NOTE: DATA statement used (Total process time):
real time 2:04.61
cpu time 25.08 seconds
SYMBOLGEN: Macro variable YEAR resolves to 2006
SYMBOLGEN: Macro variable YR resolves to 06
SYMBOLGEN: Macro variable YEAR resolves to 2006
SYMBOLGEN: Macro variable FIRST resolves to 175000000
SYMBOLGEN: Macro variable NUMOBS resolves to 209999999
NOTE: There were 35000000 observations read from the data set LOC.CARL2006.
NOTE: The data set WORK.CARTEMP has 35000000 observations and 16 variables.
NOTE: DATA statement used (Total process time):
real time 26.00 seconds
cpu time 10.82 seconds
SYMBOLGEN: Macro variable FILE resolves to 6
NOTE: There were 35000000 observations read from the data set WORK.CARTEMP.
NOTE: The data set WORK.CARTEMP has 35000000 observations and 16 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 13.32 seconds
cpu time 17.48 seconds
NOTE: There were 174999999 observations read from the data set WORK.ALL_
FILES.
NOTE: There were 35000000 observations read from the data set WORK.CARTEMP.
NOTE: The data set WORK.ALL_FILES has 209999999 observations and 16
variables.
NOTE: DATA statement used (Total process time):
real time 2:32.97
cpu time 30.37 seconds
SYMBOLGEN: Macro variable YEAR resolves to 2006
SYMBOLGEN: Macro variable YR resolves to 06
SYMBOLGEN: Macro variable YEAR resolves to 2006
SYMBOLGEN: Macro variable FIRST resolves to 210000000
8 The SAS System 10:09 Tuesday,
December 22, 2015
SYMBOLGEN: Macro variable NUMOBS resolves to 244999999
NOTE: There were 35000000 observations read from the data set LOC.CARL2006.
NOTE: The data set WORK.CARTEMP has 35000000 observations and 16 variables.
NOTE: DATA statement used (Total process time):
real time 23.37 seconds
cpu time 10.69 seconds
SYMBOLGEN: Macro variable FILE resolves to 7
NOTE: There were 35000000 observations read from the data set WORK.CARTEMP.
NOTE: The data set WORK.CARTEMP has 35000000 observations and 16 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 13.30 seconds
cpu time 16.87 seconds
NOTE: There were 209999999 observations read from the data set WORK.ALL_
FILES.
NOTE: There were 35000000 observations read from the data set WORK.CARTEMP.
NOTE: The data set WORK.ALL_FILES has 244999999 observations and 16
variables.
NOTE: DATA statement used (Total process time):
real time 2:41.54
cpu time 35.14 seconds
SYMBOLGEN: Macro variable YEAR resolves to 2006
SYMBOLGEN: Macro variable YR resolves to 06
SYMBOLGEN: Macro variable YEAR resolves to 2006
SYMBOLGEN: Macro variable FIRST resolves to 245000000
SYMBOLGEN: Macro variable NUMOBS resolves to 279999999
NOTE: There were 35000000 observations read from the data set LOC.CARL2006.
NOTE: The data set WORK.CARTEMP has 35000000 observations and 16 variables.
NOTE: DATA statement used (Total process time):
real time 22.45 seconds
cpu time 10.91 seconds
SYMBOLGEN: Macro variable FILE resolves to 8
NOTE: There were 35000000 observations read from the data set WORK.CARTEMP.
NOTE: The data set WORK.CARTEMP has 35000000 observations and 16 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 13.37 seconds
cpu time 16.93 seconds
NOTE: There were 244999999 observations read from the data set WORK.ALL_
FILES.
NOTE: There were 35000000 observations read from the data set WORK.CARTEMP.
NOTE: The data set WORK.ALL_FILES has 279999999 observations and 16
variables.
NOTE: DATA statement used (Total process time):
real time 3:21.08
cpu time 39.93 seconds
9 The SAS System 10:09 Tuesday,
December 22, 2015
SYMBOLGEN: Macro variable YEAR resolves to 2006
SYMBOLGEN: Macro variable YR resolves to 06
SYMBOLGEN: Macro variable YEAR resolves to 2006
SYMBOLGEN: Macro variable FIRST resolves to 280000000
SYMBOLGEN: Macro variable NUMOBS resolves to 314999999
NOTE: There were 35000000 observations read from the data set LOC.CARL2006.
NOTE: The data set WORK.CARTEMP has 35000000 observations and 16 variables.
NOTE: DATA statement used (Total process time):
real time 30.01 seconds
cpu time 11.03 seconds
SYMBOLGEN: Macro variable FILE resolves to 9
NOTE: There were 35000000 observations read from the data set WORK.CARTEMP.
NOTE: The data set WORK.CARTEMP has 35000000 observations and 16 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 12.94 seconds
cpu time 17.35 seconds
NOTE: There were 279999999 observations read from the data set WORK.ALL_
FILES.
NOTE: There were 35000000 observations read from the data set WORK.CARTEMP.
NOTE: The data set WORK.ALL_FILES has 314999999 observations and 16
variables.
NOTE: DATA statement used (Total process time):
real time 3:43.62
cpu time 44.90 seconds
SYMBOLGEN: Macro variable YEAR resolves to 2006
SYMBOLGEN: Macro variable YR resolves to 06
SYMBOLGEN: Macro variable YEAR resolves to 2006
SYMBOLGEN: Macro variable FIRST resolves to 315000000
SYMBOLGEN: Macro variable NUMOBS resolves to MAX
NOTE: There were 33930417 observations read from the data set LOC.CARL2006.
NOTE: The data set WORK.CARTEMP has 33930417 observations and 16 variables.
NOTE: DATA statement used (Total process time):
real time 22.30 seconds
cpu time 10.43 seconds
SYMBOLGEN: Macro variable FILE resolves to 10
NOTE: There were 33930417 observations read from the data set WORK.CARTEMP.
NOTE: The data set WORK.CARTEMP has 33930417 observations and 16 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 12.21 seconds
cpu time 16.24 seconds
NOTE: There were 314999999 observations read from the data set WORK.ALL_
FILES.
NOTE: There were 33930417 observations read from the data set WORK.CARTEMP.
NOTE: The data set WORK.ALL_FILES has 348930416 observations and 16
variables.
NOTE: DATA statement used (Total process time):
10 The SAS System 10:09 Tuesday,
December 22, 2015
real time 4:05.94
cpu time 50.58 seconds
SYMBOLGEN: Macro variable YEAR resolves to 2006
NOTE: There were 348930416 observations read from the data set WORK.ALL_
FILES.
NOTE: The data set BWORKHOS.CARCLAIMLIST2006 has 348930416 observations and
16 variables.
NOTE: DATA statement used (Total process time):
real time 3:35.88
cpu time 49.43 seconds
180: LINE and COLUMN cannot be determined.
NOTE: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the
LINE and
COLUMN where the error has occurred.
ERROR 180-322: Statement is not valid or it is used out of proper order.
180: LINE and COLUMN cannot be determined.
NOTE: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the
LINE and
COLUMN where the error has occurred.
ERROR 180-322: Statement is not valid or it is used out of proper order.
SYMBOLGEN: Macro variable YEAR resolves to 2006
SYMBOLGEN: Macro variable YEAR resolves to 2006
NOTE: SAS set option OBS=0 and will continue to check statements.
This might cause NOTE: No observations in data set.
NOTE: The PROCEDURE CONTENTS printed page 1.
NOTE: PROCEDURE CONTENTS used (Total process time):
real time 2.07 seconds
cpu time 0.01 seconds
SYMBOLGEN: Macro variable YEAR resolves to 2006
SYMBOLGEN: Macro variable YEAR resolves to 2006
NOTE: PROCEDURE PRINT used (Total process time):
real time 0.02 seconds
cpu time 0.00 seconds
SYMBOLGEN: Macro variable YEAR resolves to 2006
NOTE: The data set BWORKHOS.FINDERFILE has 0 observations and 3 variables.
WARNING: Data set BWORKHOS.FINDERFILE was not replaced because this step was
stopped.
NOTE: DATA statement used (Total process time):
real time 0.99 seconds
cpu time 0.01 seconds
NOTE: PROCEDURE SORT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
SYMBOLGEN: Macro variable YEAR resolves to 2006
SYMBOLGEN: Macro variable YEAR resolves to 2006
NOTE: The data set BWORKHOS.CARCLAIMLIST2006 has 0 observations and 18
variables.
11 The SAS System 10:09 Tuesday,
December 22, 2015
WARNING: Data set BWORKHOS.CARCLAIMLIST2006 was not replaced because this
step was
stopped.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
180: LINE and COLUMN cannot be determined.
NOTE: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the
LINE and
COLUMN where the error has occurred.
ERROR 180-322: Statement is not valid or it is used out of proper order.
180: LINE and COLUMN cannot be determined.
NOTE: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the
LINE and
COLUMN where the error has occurred.
ERROR 180-322: Statement is not valid or it is used out of proper order.
180: LINE and COLUMN cannot be determined.
NOTE: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the
LINE and
COLUMN where the error has occurred.
ERROR 180-322: Statement is not valid or it is used out of proper order.
NOTE: Libname BENEXW refers to the same physical library as TEMP.
NOTE: Libref BENEXW was successfully assigned as follows:
Engine: V9
Physical Name: /disk/agebulk5/medicare.work/lbaker-DUA23466/lbaker/
data/xw
NOTE: Data file BENEXW.NPI_UPIN_XW_FINAL.DATA is in a format that is native
to another
host, or the file encoding does not match the session encoding. Cross
Environment
Data Access will be used, which might require additional CPU resources
and might
reduce performance.
NOTE: The data set BWORKHOS.NPIXWALK has 0 observations and 2 variables.
WARNING: Data set BWORKHOS.NPIXWALK was not replaced because this step was
stopped.
NOTE: DATA statement used (Total process time):
real time 0.32 seconds
cpu time 0.00 seconds
NOTE: PROCEDURE SORT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
SYMBOLGEN: Macro variable YEAR resolves to 2006
SYMBOLGEN: Macro variable YEAR resolves to 2006
NOTE: PROCEDURE SORT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
SYMBOLGEN: Macro variable YEAR resolves to 2006
158 %readin0611(2007,07,1);
SYMBOLGEN: Macro variable DATALOC resolves to /disk/agedisk1/medicare/data/
20pct/car
SYMBOLGEN: Macro variable YEAR resolves to 2007
NOTE: Libref LOC was successfully assigned as follows:
Engine: V9
Physical Name: /disk/agedisk1/medicare/data/20pct/car/2007
SYMBOLGEN: Macro variable YEAR resolves to 2007
SYMBOLGEN: Macro variable YR resolves to 07
12 The SAS System 10:09 Tuesday,
December 22, 2015
NOTE: The data set BWORKHOS.CARCLAIMLIST2006 has 0 observations and 17
variables.
WARNING: Data set BWORKHOS.CARCLAIMLIST2006 was not replaced because this
step was
stopped.
NOTE: DATA statement used (Total process time):
real time 1.32 seconds
cpu time 0.00 seconds
SYMBOLGEN: Macro variable YEAR resolves to 2007
SYMBOLGEN: Macro variable FIRST resolves to 1
SYMBOLGEN: Macro variable NUMOBS resolves to 34999999
NOTE: The data set WORK.CARTEMP has 0 observations and 16 variables.
WARNING: Data set WORK.CARTEMP was not replaced because this step was
stopped.
NOTE: DATA statement used (Total process time):
real time 0.06 seconds
cpu time 0.00 seconds
SYMBOLGEN: Macro variable FILE resolves to 1
NOTE: PROCEDURE SORT used (Total process time):
real time 0.00 seconds
cpu time 0.01 seconds
NOTE: The data set WORK.ALL_FILES has 0 observations and 16 variables.
WARNING: Data set WORK.ALL_FILES was not replaced because this step was
stopped.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
SYMBOLGEN: Macro variable YEAR resolves to 2007
SYMBOLGEN: Macro variable YR resolves to 07
SYMBOLGEN: Macro variable YEAR resolves to 2007
SYMBOLGEN: Macro variable FIRST resolves to 35000000
SYMBOLGEN: Macro variable NUMOBS resolves to 69999999
NOTE: The data set WORK.CARTEMP has 0 observations and 16 variables.
WARNING: Data set WORK.CARTEMP was not replaced because this step was
stopped.
NOTE: DATA statement used (Total process time):
real time 0.06 seconds
cpu time 0.00 seconds
SYMBOLGEN: Macro variable FILE resolves to 2
NOTE: PROCEDURE SORT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
NOTE: The data set WORK.ALL_FILES has 0 observations and 16 variables.
WARNING: Data set WORK.ALL_FILES was not replaced because this step was
stopped.
NOTE: DATA statement used (Total process time):
13 The SAS System 10:09 Tuesday,
December 22, 2015
real time 0.00 seconds
cpu time 0.00 seconds
SYMBOLGEN: Macro variable YEAR resolves to 2007
SYMBOLGEN: Macro variable YR resolves to 07
SYMBOLGEN: Macro variable YEAR resolves to 2007
SYMBOLGEN: Macro variable FIRST resolves to 70000000
SYMBOLGEN: Macro variable NUMOBS resolves to 104999999
NOTE: The data set WORK.CARTEMP has 0 observations and 16 variables.
WARNING: Data set WORK.CARTEMP was not replaced because this step was
stopped.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
SYMBOLGEN: Macro variable FILE resolves to 3
NOTE: PROCEDURE SORT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
NOTE: The data set WORK.ALL_FILES has 0 observations and 16 variables.
WARNING: Data set WORK.ALL_FILES was not replaced because this step was
stopped.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
SYMBOLGEN: Macro variable YEAR resolves to 2007
SYMBOLGEN: Macro variable YR resolves to 07
SYMBOLGEN: Macro variable YEAR resolves to 2007
SYMBOLGEN: Macro variable FIRST resolves to 105000000
SYMBOLGEN: Macro variable NUMOBS resolves to 139999999
NOTE: The data set WORK.CARTEMP has 0 observations and 16 variables.
WARNING: Data set WORK.CARTEMP was not replaced because this step was
stopped.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
SYMBOLGEN: Macro variable FILE resolves to 4
NOTE: PROCEDURE SORT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
NOTE: The data set WORK.ALL_FILES has 0 observations and 16 variables.
WARNING: Data set WORK.ALL_FILES was not replaced because this step was
stopped.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
14 The SAS System 10:09 Tuesday,
December 22, 2015
SYMBOLGEN: Macro variable YEAR resolves to 2007
SYMBOLGEN: Macro variable YR resolves to 07
SYMBOLGEN: Macro variable YEAR resolves to 2007
SYMBOLGEN: Macro variable FIRST resolves to 140000000
SYMBOLGEN: Macro variable NUMOBS resolves to 174999999
NOTE: The data set WORK.CARTEMP has 0 observations and 16 variables.
WARNING: Data set WORK.CARTEMP was not replaced because this step was
stopped.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
SYMBOLGEN: Macro variable FILE resolves to 5
NOTE: PROCEDURE SORT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
NOTE: The data set WORK.ALL_FILES has 0 observations and 16 variables.
WARNING: Data set WORK.ALL_FILES was not replaced because this step was
stopped.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
SYMBOLGEN: Macro variable YEAR resolves to 2007
SYMBOLGEN: Macro variable YR resolves to 07
SYMBOLGEN: Macro variable YEAR resolves to 2007
SYMBOLGEN: Macro variable FIRST resolves to 175000000
SYMBOLGEN: Macro variable NUMOBS resolves to 209999999
NOTE: The data set WORK.CARTEMP has 0 observations and 16 variables.
WARNING: Data set WORK.CARTEMP was not replaced because this step was
stopped.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
SYMBOLGEN: Macro variable FILE resolves to 6
NOTE: PROCEDURE SORT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
NOTE: The data set WORK.ALL_FILES has 0 observations and 16 variables.
WARNING: Data set WORK.ALL_FILES was not replaced because this step was
stopped.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
15 The SAS System 10:09 Tuesday,
December 22, 2015
SYMBOLGEN: Macro variable YEAR resolves to 2007
SYMBOLGEN: Macro variable YR resolves to 07
SYMBOLGEN: Macro variable YEAR resolves to 2007
SYMBOLGEN: Macro variable FIRST resolves to 210000000
SYMBOLGEN: Macro variable NUMOBS resolves to 244999999
NOTE: The data set WORK.CARTEMP has 0 observations and 16 variables.
WARNING: Data set WORK.CARTEMP was not replaced because this step was
stopped.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
SYMBOLGEN: Macro variable FILE resolves to 7
NOTE: PROCEDURE SORT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
NOTE: The data set WORK.ALL_FILES has 0 observations and 16 variables.
WARNING: Data set WORK.ALL_FILES was not replaced because this step was
stopped.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
SYMBOLGEN: Macro variable YEAR resolves to 2007
SYMBOLGEN: Macro variable YR resolves to 07
SYMBOLGEN: Macro variable YEAR resolves to 2007
SYMBOLGEN: Macro variable FIRST resolves to 245000000
SYMBOLGEN: Macro variable NUMOBS resolves to 279999999
NOTE: The data set WORK.CARTEMP has 0 observations and 16 variables.
WARNING: Data set WORK.CARTEMP was not replaced because this step was
stopped.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
SYMBOLGEN: Macro variable FILE resolves to 8
NOTE: PROCEDURE SORT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
NOTE: The data set WORK.ALL_FILES has 0 observations and 16 variables.
WARNING: Data set WORK.ALL_FILES was not replaced because this step was
stopped.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
SYMBOLGEN: Macro variable YEAR resolves to 2007
SYMBOLGEN: Macro variable YR resolves to 07
16 The SAS System 10:09 Tuesday,
December 22, 2015
SYMBOLGEN: Macro variable YEAR resolves to 2007
SYMBOLGEN: Macro variable FIRST resolves to 280000000
SYMBOLGEN: Macro variable NUMOBS resolves to 314999999
NOTE: The data set WORK.CARTEMP has 0 observations and 16 variables.
WARNING: Data set WORK.CARTEMP was not replaced because this step was
stopped.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
SYMBOLGEN: Macro variable FILE resolves to 9
NOTE: PROCEDURE SORT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
NOTE: The data set WORK.ALL_FILES has 0 observations and 16 variables.
WARNING: Data set WORK.ALL_FILES was not replaced because this step was
stopped.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
SYMBOLGEN: Macro variable YEAR resolves to 2007
SYMBOLGEN: Macro variable YR resolves to 07
SYMBOLGEN: Macro variable YEAR resolves to 2007
SYMBOLGEN: Macro variable FIRST resolves to 315000000
SYMBOLGEN: Macro variable NUMOBS resolves to MAX
NOTE: The data set WORK.CARTEMP has 0 observations and 16 variables.
WARNING: Data set WORK.CARTEMP was not replaced because this step was
stopped.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.01 seconds
SYMBOLGEN: Macro variable FILE resolves to 10
NOTE: PROCEDURE SORT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
NOTE: The data set WORK.ALL_FILES has 0 observations and 16 variables.
WARNING: Data set WORK.ALL_FILES was not replaced because this step was
stopped.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
SYMBOLGEN: Macro variable YEAR resolves to 2007
NOTE: The data set BWORKHOS.CARCLAIMLIST2007 has 0 observations and 16
variables.
WARNING: Data set BWORKHOS.CARCLAIMLIST2007 was not replaced because this
step was
17 The SAS System 10:09 Tuesday,
December 22, 2015
stopped.
NOTE: DATA statement used (Total process time):
real time 0.02 seconds
cpu time 0.00 seconds
180: LINE and COLUMN cannot be determined.
NOTE: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the
LINE and
COLUMN where the error has occurred.
ERROR 180-322: Statement is not valid or it is used out of proper order.
180: LINE and COLUMN cannot be determined.
NOTE: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the
LINE and
COLUMN where the error has occurred.
ERROR 180-322: Statement is not valid or it is used out of proper order.
SYMBOLGEN: Macro variable YEAR resolves to 2007
SYMBOLGEN: Macro variable YEAR resolves to 2007
NOTE: The PROCEDURE CONTENTS printed page 2.
NOTE: PROCEDURE CONTENTS used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
SYMBOLGEN: Macro variable YEAR resolves to 2007
SYMBOLGEN: Macro variable YEAR resolves to 2007
NOTE: PROCEDURE PRINT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
SYMBOLGEN: Macro variable YEAR resolves to 2007
NOTE: The data set BWORKHOS.FINDERFILE has 0 observations and 3 variables.
WARNING: Data set BWORKHOS.FINDERFILE was not replaced because this step was
stopped.
NOTE: DATA statement used (Total process time):
real time 0.10 seconds
cpu time 0.00 seconds
NOTE: PROCEDURE SORT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
SYMBOLGEN: Macro variable YEAR resolves to 2007
SYMBOLGEN: Macro variable YEAR resolves to 2007
NOTE: The data set BWORKHOS.CARCLAIMLIST2007 has 0 observations and 3
variables.
WARNING: Data set BWORKHOS.CARCLAIMLIST2007 was not replaced because this
step was
stopped.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
180: LINE and COLUMN cannot be determined.
NOTE: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the
LINE and
18 The SAS System 10:09 Tuesday,
December 22, 2015
COLUMN where the error has occurred.
ERROR 180-322: Statement is not valid or it is used out of proper order.
180: LINE and COLUMN cannot be determined.
NOTE: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the
LINE and
COLUMN where the error has occurred.
ERROR 180-322: Statement is not valid or it is used out of proper order.
180: LINE and COLUMN cannot be determined.
NOTE: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the
LINE and
COLUMN where the error has occurred.
ERROR 180-322: Statement is not valid or it is used out of proper order.
NOTE: Libname BENEXW refers to the same physical library as TEMP.
NOTE: Libref BENEXW was successfully assigned as follows:
Engine: V9
Physical Name: /disk/agebulk5/medicare.work/lbaker-DUA23466/lbaker/
data/xw
NOTE: Data file BENEXW.NPI_UPIN_XW_FINAL.DATA is in a format that is native
to another
host, or the file encoding does not match the session encoding. Cross
Environment
Data Access will be used, which might require additional CPU resources
and might
reduce performance.
NOTE: The data set BWORKHOS.NPIXWALK has 0 observations and 2 variables.
WARNING: Data set BWORKHOS.NPIXWALK was not replaced because this step was
stopped.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
NOTE: PROCEDURE SORT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
SYMBOLGEN: Macro variable YEAR resolves to 2007
ERROR: Variable PRF_NPI not found.
SYMBOLGEN: Macro variable YEAR resolves to 2007
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
SYMBOLGEN: Macro variable YEAR resolves to 2007
159 %readin0611(2008,08,1);
SYMBOLGEN: Macro variable DATALOC resolves to /disk/agedisk1/medicare/data/
20pct/car
SYMBOLGEN: Macro variable YEAR resolves to 2008
NOTE: Libref LOC was successfully assigned as follows:
Engine: V9
Physical Name: /disk/agedisk1/medicare/data/20pct/car/2008
SYMBOLGEN: Macro variable YEAR resolves to 2008
SYMBOLGEN: Macro variable YR resolves to 08
NOTE: The data set BWORKHOS.CARCLAIMLIST2007 has 0 observations and 3
variables.
WARNING: Data set BWORKHOS.CARCLAIMLIST2007 was not replaced because this
step was
stopped.
NOTE: DATA statement used (Total process time):
real time 2.14 seconds
cpu time 0.00 seconds
19 The SAS System 10:09 Tuesday,
December 22, 2015
SYMBOLGEN: Macro variable YEAR resolves to 2008
SYMBOLGEN: Macro variable FIRST resolves to 1
SYMBOLGEN: Macro variable NUMOBS resolves to 34999999
NOTE: The data set WORK.CARTEMP has 0 observations and 16 variables.
WARNING: Data set WORK.CARTEMP was not replaced because this step was
stopped.
NOTE: DATA statement used (Total process time):
real time 0.07 seconds
cpu time 0.00 seconds
SYMBOLGEN: Macro variable FILE resolves to 1
NOTE: PROCEDURE SORT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
NOTE: The data set WORK.ALL_FILES has 0 observations and 16 variables.
WARNING: Data set WORK.ALL_FILES was not replaced because this step was
stopped.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
SYMBOLGEN: Macro variable YEAR resolves to 2008
SYMBOLGEN: Macro variable YR resolves to 08
SYMBOLGEN: Macro variable YEAR resolves to 2008
SYMBOLGEN: Macro variable FIRST resolves to 35000000
SYMBOLGEN: Macro variable NUMOBS resolves to 69999999
NOTE: The data set WORK.CARTEMP has 0 observations and 16 variables.
WARNING: Data set WORK.CARTEMP was not replaced because this step was
stopped.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
SYMBOLGEN: Macro variable FILE resolves to 2
NOTE: PROCEDURE SORT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
NOTE: The data set WORK.ALL_FILES has 0 observations and 16 variables.
WARNING: Data set WORK.ALL_FILES was not replaced because this step was
stopped.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
SYMBOLGEN: Macro variable YEAR resolves to 2008
SYMBOLGEN: Macro variable YR resolves to 08
SYMBOLGEN: Macro variable YEAR resolves to 2008
20 The SAS System 10:09 Tuesday,
December 22, 2015
SYMBOLGEN: Macro variable FIRST resolves to 70000000
SYMBOLGEN: Macro variable NUMOBS resolves to 104999999
NOTE: The data set WORK.CARTEMP has 0 observations and 16 variables.
WARNING: Data set WORK.CARTEMP was not replaced because this step was
stopped.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
SYMBOLGEN: Macro variable FILE resolves to 3
NOTE: PROCEDURE SORT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
NOTE: The data set WORK.ALL_FILES has 0 observations and 16 variables.
WARNING: Data set WORK.ALL_FILES was not replaced because this step was
stopped.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
SYMBOLGEN: Macro variable YEAR resolves to 2008
SYMBOLGEN: Macro variable YR resolves to 08
SYMBOLGEN: Macro variable YEAR resolves to 2008
SYMBOLGEN: Macro variable FIRST resolves to 105000000
SYMBOLGEN: Macro variable NUMOBS resolves to 139999999
NOTE: The data set WORK.CARTEMP has 0 observations and 16 variables.
WARNING: Data set WORK.CARTEMP was not replaced because this step was
stopped.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
SYMBOLGEN: Macro variable FILE resolves to 4
NOTE: PROCEDURE SORT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
NOTE: The data set WORK.ALL_FILES has 0 observations and 16 variables.
WARNING: Data set WORK.ALL_FILES was not replaced because this step was
stopped.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
SYMBOLGEN: Macro variable YEAR resolves to 2008
SYMBOLGEN: Macro variable YR resolves to 08
SYMBOLGEN: Macro variable YEAR resolves to 2008
SYMBOLGEN: Macro variable FIRST resolves to 140000000
SYMBOLGEN: Macro variable NUMOBS resolves to 174999999
21 The SAS System 10:09 Tuesday,
December 22, 2015
NOTE: The data set WORK.CARTEMP has 0 observations and 16 variables.
WARNING: Data set WORK.CARTEMP was not replaced because this step was
stopped.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
SYMBOLGEN: Macro variable FILE resolves to 5
NOTE: PROCEDURE SORT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
NOTE: The data set WORK.ALL_FILES has 0 observations and 16 variables.
WARNING: Data set WORK.ALL_FILES was not replaced because this step was
stopped.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
SYMBOLGEN: Macro variable YEAR resolves to 2008
SYMBOLGEN: Macro variable YR resolves to 08
SYMBOLGEN: Macro variable YEAR resolves to 2008
SYMBOLGEN: Macro variable FIRST resolves to 175000000
SYMBOLGEN: Macro variable NUMOBS resolves to 209999999
NOTE: The data set WORK.CARTEMP has 0 observations and 16 variables.
WARNING: Data set WORK.CARTEMP was not replaced because this step was
stopped.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
SYMBOLGEN: Macro variable FILE resolves to 6
NOTE: PROCEDURE SORT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
NOTE: The data set WORK.ALL_FILES has 0 observations and 16 variables.
WARNING: Data set WORK.ALL_FILES was not replaced because this step was
stopped.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
SYMBOLGEN: Macro variable YEAR resolves to 2008
SYMBOLGEN: Macro variable YR resolves to 08
SYMBOLGEN: Macro variable YEAR resolves to 2008
SYMBOLGEN: Macro variable FIRST resolves to 210000000
SYMBOLGEN: Macro variable NUMOBS resolves to 244999999
NOTE: The data set WORK.CARTEMP has 0 observations and 16 variables.
22 The SAS System 10:09 Tuesday,
December 22, 2015
WARNING: Data set WORK.CARTEMP was not replaced because this step was
stopped.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
SYMBOLGEN: Macro variable FILE resolves to 7
NOTE: PROCEDURE SORT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
NOTE: The data set WORK.ALL_FILES has 0 observations and 16 variables.
WARNING: Data set WORK.ALL_FILES was not replaced because this step was
stopped.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
SYMBOLGEN: Macro variable YEAR resolves to 2008
SYMBOLGEN: Macro variable YR resolves to 08
SYMBOLGEN: Macro variable YEAR resolves to 2008
SYMBOLGEN: Macro variable FIRST resolves to 245000000
SYMBOLGEN: Macro variable NUMOBS resolves to 279999999
NOTE: The data set WORK.CARTEMP has 0 observations and 16 variables.
WARNING: Data set WORK.CARTEMP was not replaced because this step was
stopped.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
SYMBOLGEN: Macro variable FILE resolves to 8
NOTE: PROCEDURE SORT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
NOTE: The data set WORK.ALL_FILES has 0 observations and 16 variables.
WARNING: Data set WORK.ALL_FILES was not replaced because this step was
stopped.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
SYMBOLGEN: Macro variable YEAR resolves to 2008
SYMBOLGEN: Macro variable YR resolves to 08
SYMBOLGEN: Macro variable YEAR resolves to 2008
SYMBOLGEN: Macro variable FIRST resolves to 280000000
SYMBOLGEN: Macro variable NUMOBS resolves to 314999999
NOTE: The data set WORK.CARTEMP has 0 observations and 16 variables.
WARNING: Data set WORK.CARTEMP was not replaced because this step was
stopped.
NOTE: DATA statement used (Total process time):
23 The SAS System 10:09 Tuesday,
December 22, 2015
real time 0.00 seconds
cpu time 0.00 seconds
SYMBOLGEN: Macro variable FILE resolves to 9
NOTE: PROCEDURE SORT used (Total process time):
real time 0.00 seconds
cpu time 0.01 seconds
NOTE: The data set WORK.ALL_FILES has 0 observations and 16 variables.
WARNING: Data set WORK.ALL_FILES was not replaced because this step was
stopped.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
SYMBOLGEN: Macro variable YEAR resolves to 2008
SYMBOLGEN: Macro variable YR resolves to 08
SYMBOLGEN: Macro variable YEAR resolves to 2008
SYMBOLGEN: Macro variable FIRST resolves to 315000000
SYMBOLGEN: Macro variable NUMOBS resolves to MAX
NOTE: The data set WORK.CARTEMP has 0 observations and 16 variables.
WARNING: Data set WORK.CARTEMP was not replaced because this step was
stopped.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
SYMBOLGEN: Macro variable FILE resolves to 10
NOTE: PROCEDURE SORT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
NOTE: The data set WORK.ALL_FILES has 0 observations and 16 variables.
WARNING: Data set WORK.ALL_FILES was not replaced because this step was
stopped.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
SYMBOLGEN: Macro variable YEAR resolves to 2008
NOTE: The data set BWORKHOS.CARCLAIMLIST2008 has 0 observations and 16
variables.
WARNING: Data set BWORKHOS.CARCLAIMLIST2008 was not replaced because this
step was
stopped.
NOTE: DATA statement used (Total process time):
real time 0.21 seconds
cpu time 0.00 seconds
180: LINE and COLUMN cannot be determined.
24 The SAS System 10:09 Tuesday,
December 22, 2015
NOTE: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the
LINE and
COLUMN where the error has occurred.
ERROR 180-322: Statement is not valid or it is used out of proper order.
180: LINE and COLUMN cannot be determined.
NOTE: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the
LINE and
COLUMN where the error has occurred.
ERROR 180-322: Statement is not valid or it is used out of proper order.
SYMBOLGEN: Macro variable YEAR resolves to 2008
SYMBOLGEN: Macro variable YEAR resolves to 2008
NOTE: The PROCEDURE CONTENTS printed page 3.
NOTE: PROCEDURE CONTENTS used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
SYMBOLGEN: Macro variable YEAR resolves to 2008
SYMBOLGEN: Macro variable YEAR resolves to 2008
NOTE: PROCEDURE PRINT used (Total process time):
real time 0.03 seconds
cpu time 0.00 seconds
SYMBOLGEN: Macro variable YEAR resolves to 2008
NOTE: The data set BWORKHOS.FINDERFILE has 0 observations and 3 variables.
WARNING: Data set BWORKHOS.FINDERFILE was not replaced because this step was
stopped.
NOTE: DATA statement used (Total process time):
real time 0.37 seconds
cpu time 0.00 seconds
NOTE: PROCEDURE SORT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
SYMBOLGEN: Macro variable YEAR resolves to 2008
SYMBOLGEN: Macro variable YEAR resolves to 2008
NOTE: The data set BWORKHOS.CARCLAIMLIST2008 has 0 observations and 18
variables.
WARNING: Data set BWORKHOS.CARCLAIMLIST2008 was not replaced because this
step was
stopped.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
180: LINE and COLUMN cannot be determined.
NOTE: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the
LINE and
COLUMN where the error has occurred.
ERROR 180-322: Statement is not valid or it is used out of proper order.
180: LINE and COLUMN cannot be determined.
NOTE: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the
LINE and
COLUMN where the error has occurred.
ERROR 180-322: Statement is not valid or it is used out of proper order.
180: LINE and COLUMN cannot be determined.
25 The SAS System 10:09 Tuesday,
December 22, 2015
NOTE: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the
LINE and
COLUMN where the error has occurred.
ERROR 180-322: Statement is not valid or it is used out of proper order.
NOTE: Libname BENEXW refers to the same physical library as TEMP.
NOTE: Libref BENEXW was successfully assigned as follows:
Engine: V9
Physical Name: /disk/agebulk5/medicare.work/lbaker-DUA23466/lbaker/
data/xw
NOTE: Data file BENEXW.NPI_UPIN_XW_FINAL.DATA is in a format that is native
to another
host, or the file encoding does not match the session encoding. Cross
Environment
Data Access will be used, which might require additional CPU resources
and might
reduce performance.
NOTE: The data set BWORKHOS.NPIXWALK has 0 observations and 2 variables.
WARNING: Data set BWORKHOS.NPIXWALK was not replaced because this step was
stopped.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
NOTE: PROCEDURE SORT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
SYMBOLGEN: Macro variable YEAR resolves to 2008
SYMBOLGEN: Macro variable YEAR resolves to 2008
NOTE: PROCEDURE SORT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
SYMBOLGEN: Macro variable YEAR resolves to 2008
160 %readin0611(2009,09,1);
SYMBOLGEN: Macro variable DATALOC resolves to /disk/agedisk1/medicare/data/
20pct/car
SYMBOLGEN: Macro variable YEAR resolves to 2009
NOTE: Libref LOC was successfully assigned as follows:
Engine: V9
Physical Name: /disk/agedisk1/medicare/data/20pct/car/2009
SYMBOLGEN: Macro variable YEAR resolves to 2009
SYMBOLGEN: Macro variable YR resolves to 09
NOTE: The data set BWORKHOS.CARCLAIMLIST2008 has 0 observations and 17
variables.
WARNING: Data set BWORKHOS.CARCLAIMLIST2008 was not replaced because this
step was
stopped.
NOTE: DATA statement used (Total process time):
real time 0.88 seconds
cpu time 0.00 seconds
SYMBOLGEN: Macro variable YEAR resolves to 2009
SYMBOLGEN: Macro variable FIRST resolves to 1
SYMBOLGEN: Macro variable NUMOBS resolves to 34999999
NOTE: The data set WORK.CARTEMP has 0 observations and 16 variables.
WARNING: Data set WORK.CARTEMP was not replaced because this step was
stopped.
NOTE: DATA statement used (Total process time):
real time 0.04 seconds
26 The SAS System 10:09 Tuesday,
December 22, 2015
cpu time 0.00 seconds
SYMBOLGEN: Macro variable FILE resolves to 1
NOTE: PROCEDURE SORT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
NOTE: The data set WORK.ALL_FILES has 0 observations and 16 variables.
WARNING: Data set WORK.ALL_FILES was not replaced because this step was
stopped.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.01 seconds
SYMBOLGEN: Macro variable YEAR resolves to 2009
SYMBOLGEN: Macro variable YR resolves to 09
SYMBOLGEN: Macro variable YEAR resolves to 2009
SYMBOLGEN: Macro variable FIRST resolves to 35000000
SYMBOLGEN: Macro variable NUMOBS resolves to 69999999
NOTE: The data set WORK.CARTEMP has 0 observations and 16 variables.
WARNING: Data set WORK.CARTEMP was not replaced because this step was
stopped.
NOTE: DATA statement used (Total process time):
real time 0.01 seconds
cpu time 0.00 seconds
SYMBOLGEN: Macro variable FILE resolves to 2
NOTE: PROCEDURE SORT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
NOTE: The data set WORK.ALL_FILES has 0 observations and 16 variables.
WARNING: Data set WORK.ALL_FILES was not replaced because this step was
stopped.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
SYMBOLGEN: Macro variable YEAR resolves to 2009
SYMBOLGEN: Macro variable YR resolves to 09
SYMBOLGEN: Macro variable YEAR resolves to 2009
SYMBOLGEN: Macro variable FIRST resolves to 70000000
SYMBOLGEN: Macro variable NUMOBS resolves to 104999999
NOTE: The data set WORK.CARTEMP has 0 observations and 16 variables.
WARNING: Data set WORK.CARTEMP was not replaced because this step was
stopped.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
27 The SAS System 10:09 Tuesday,
December 22, 2015
SYMBOLGEN: Macro variable FILE resolves to 3
NOTE: PROCEDURE SORT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
NOTE: The data set WORK.ALL_FILES has 0 observations and 16 variables.
WARNING: Data set WORK.ALL_FILES was not replaced because this step was
stopped.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
SYMBOLGEN: Macro variable YEAR resolves to 2009
SYMBOLGEN: Macro variable YR resolves to 09
SYMBOLGEN: Macro variable YEAR resolves to 2009
SYMBOLGEN: Macro variable FIRST resolves to 105000000
SYMBOLGEN: Macro variable NUMOBS resolves to 139999999
NOTE: The data set WORK.CARTEMP has 0 observations and 16 variables.
WARNING: Data set WORK.CARTEMP was not replaced because this step was
stopped.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
SYMBOLGEN: Macro variable FILE resolves to 4
NOTE: PROCEDURE SORT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
NOTE: The data set WORK.ALL_FILES has 0 observations and 16 variables.
WARNING: Data set WORK.ALL_FILES was not replaced because this step was
stopped.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
SYMBOLGEN: Macro variable YEAR resolves to 2009
SYMBOLGEN: Macro variable YR resolves to 09
SYMBOLGEN: Macro variable YEAR resolves to 2009
SYMBOLGEN: Macro variable FIRST resolves to 140000000
SYMBOLGEN: Macro variable NUMOBS resolves to 174999999
NOTE: The data set WORK.CARTEMP has 0 observations and 16 variables.
WARNING: Data set WORK.CARTEMP was not replaced because this step was
stopped.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
SYMBOLGEN: Macro variable FILE resolves to 5
28 The SAS System 10:09 Tuesday,
December 22, 2015
NOTE: PROCEDURE SORT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
NOTE: The data set WORK.ALL_FILES has 0 observations and 16 variables.
WARNING: Data set WORK.ALL_FILES was not replaced because this step was
stopped.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
SYMBOLGEN: Macro variable YEAR resolves to 2009
SYMBOLGEN: Macro variable YR resolves to 09
SYMBOLGEN: Macro variable YEAR resolves to 2009
SYMBOLGEN: Macro variable FIRST resolves to 175000000
SYMBOLGEN: Macro variable NUMOBS resolves to 209999999
NOTE: The data set WORK.CARTEMP has 0 observations and 16 variables.
WARNING: Data set WORK.CARTEMP was not replaced because this step was
stopped.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
SYMBOLGEN: Macro variable FILE resolves to 6
NOTE: PROCEDURE SORT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
NOTE: The data set WORK.ALL_FILES has 0 observations and 16 variables.
WARNING: Data set WORK.ALL_FILES was not replaced because this step was
stopped.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
SYMBOLGEN: Macro variable YEAR resolves to 2009
SYMBOLGEN: Macro variable YR resolves to 09
SYMBOLGEN: Macro variable YEAR resolves to 2009
SYMBOLGEN: Macro variable FIRST resolves to 210000000
SYMBOLGEN: Macro variable NUMOBS resolves to 244999999
NOTE: The data set WORK.CARTEMP has 0 observations and 16 variables.
WARNING: Data set WORK.CARTEMP was not replaced because this step was
stopped.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
SYMBOLGEN: Macro variable FILE resolves to 7
NOTE: PROCEDURE SORT used (Total process time):
29 The SAS System 10:09 Tuesday,
December 22, 2015
real time 0.00 seconds
cpu time 0.00 seconds
NOTE: The data set WORK.ALL_FILES has 0 observations and 16 variables.
WARNING: Data set WORK.ALL_FILES was not replaced because this step was
stopped.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
SYMBOLGEN: Macro variable YEAR resolves to 2009
SYMBOLGEN: Macro variable YR resolves to 09
SYMBOLGEN: Macro variable YEAR resolves to 2009
SYMBOLGEN: Macro variable FIRST resolves to 245000000
SYMBOLGEN: Macro variable NUMOBS resolves to 279999999
NOTE: The data set WORK.CARTEMP has 0 observations and 16 variables.
WARNING: Data set WORK.CARTEMP was not replaced because this step was
stopped.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
SYMBOLGEN: Macro variable FILE resolves to 8
NOTE: PROCEDURE SORT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
NOTE: The data set WORK.ALL_FILES has 0 observations and 16 variables.
WARNING: Data set WORK.ALL_FILES was not replaced because this step was
stopped.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
SYMBOLGEN: Macro variable YEAR resolves to 2009
SYMBOLGEN: Macro variable YR resolves to 09
SYMBOLGEN: Macro variable YEAR resolves to 2009
SYMBOLGEN: Macro variable FIRST resolves to 280000000
SYMBOLGEN: Macro variable NUMOBS resolves to 314999999
NOTE: The data set WORK.CARTEMP has 0 observations and 16 variables.
WARNING: Data set WORK.CARTEMP was not replaced because this step was
stopped.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
SYMBOLGEN: Macro variable FILE resolves to 9
NOTE: PROCEDURE SORT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
30 The SAS System 10:09 Tuesday,
December 22, 2015
NOTE: The data set WORK.ALL_FILES has 0 observations and 16 variables.
WARNING: Data set WORK.ALL_FILES was not replaced because this step was
stopped.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
SYMBOLGEN: Macro variable YEAR resolves to 2009
SYMBOLGEN: Macro variable YR resolves to 09
SYMBOLGEN: Macro variable YEAR resolves to 2009
SYMBOLGEN: Macro variable FIRST resolves to 315000000
SYMBOLGEN: Macro variable NUMOBS resolves to MAX
NOTE: The data set WORK.CARTEMP has 0 observations and 16 variables.
WARNING: Data set WORK.CARTEMP was not replaced because this step was
stopped.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
SYMBOLGEN: Macro variable FILE resolves to 10
NOTE: PROCEDURE SORT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
NOTE: The data set WORK.ALL_FILES has 0 observations and 16 variables.
WARNING: Data set WORK.ALL_FILES was not replaced because this step was
stopped.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
SYMBOLGEN: Macro variable YEAR resolves to 2009
NOTE: The data set BWORKHOS.CARCLAIMLIST2009 has 0 observations and 16
variables.
WARNING: Data set BWORKHOS.CARCLAIMLIST2009 was not replaced because this
step was
stopped.
NOTE: DATA statement used (Total process time):
real time 0.01 seconds
cpu time 0.00 seconds
180: LINE and COLUMN cannot be determined.
NOTE: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the
LINE and
COLUMN where the error has occurred.
ERROR 180-322: Statement is not valid or it is used out of proper order.
180: LINE and COLUMN cannot be determined.
NOTE: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the
LINE and
COLUMN where the error has occurred.
ERROR 180-322: Statement is not valid or it is used out of proper order.
SYMBOLGEN: Macro variable YEAR resolves to 2009
SYMBOLGEN: Macro variable YEAR resolves to 2009
31 The SAS System 10:09 Tuesday,
December 22, 2015
NOTE: The PROCEDURE CONTENTS printed page 4.
NOTE: PROCEDURE CONTENTS used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
SYMBOLGEN: Macro variable YEAR resolves to 2009
SYMBOLGEN: Macro variable YEAR resolves to 2009
NOTE: PROCEDURE PRINT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
SYMBOLGEN: Macro variable YEAR resolves to 2009
NOTE: The data set BWORKHOS.FINDERFILE has 0 observations and 3 variables.
WARNING: Data set BWORKHOS.FINDERFILE was not replaced because this step was
stopped.
NOTE: DATA statement used (Total process time):
real time 0.05 seconds
cpu time 0.01 seconds
NOTE: PROCEDURE SORT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
SYMBOLGEN: Macro variable YEAR resolves to 2009
SYMBOLGEN: Macro variable YEAR resolves to 2009
NOTE: The data set BWORKHOS.CARCLAIMLIST2009 has 0 observations and 3
variables.
WARNING: Data set BWORKHOS.CARCLAIMLIST2009 was not replaced because this
step was
stopped.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
180: LINE and COLUMN cannot be determined.
NOTE: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the
LINE and
COLUMN where the error has occurred.
ERROR 180-322: Statement is not valid or it is used out of proper order.
180: LINE and COLUMN cannot be determined.
NOTE: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the
LINE and
COLUMN where the error has occurred.
ERROR 180-322: Statement is not valid or it is used out of proper order.
180: LINE and COLUMN cannot be determined.
NOTE: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the
LINE and
COLUMN where the error has occurred.
ERROR 180-322: Statement is not valid or it is used out of proper order.
NOTE: Libname BENEXW refers to the same physical library as TEMP.
NOTE: Libref BENEXW was successfully assigned as follows:
Engine: V9
Physical Name: /disk/agebulk5/medicare.work/lbaker-DUA23466/lbaker/
data/xw
NOTE: Data file BENEXW.NPI_UPIN_XW_FINAL.DATA is in a format that is native
to another
host, or the file encoding does not match the session encoding. Cross
Environment
32 The SAS System 10:09 Tuesday,
December 22, 2015
Data Access will be used, which might require additional CPU resources
and might
reduce performance.
NOTE: The data set BWORKHOS.NPIXWALK has 0 observations and 2 variables.
WARNING: Data set BWORKHOS.NPIXWALK was not replaced because this step was
stopped.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.01 seconds
NOTE: PROCEDURE SORT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
SYMBOLGEN: Macro variable YEAR resolves to 2009
ERROR: Variable PRF_NPI not found.
SYMBOLGEN: Macro variable YEAR resolves to 2009
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
SYMBOLGEN: Macro variable YEAR resolves to 2009
161 %readin0611(2010,10,1);
SYMBOLGEN: Macro variable DATALOC resolves to /disk/agedisk1/medicare/data/
20pct/car
SYMBOLGEN: Macro variable YEAR resolves to 2010
NOTE: Libref LOC was successfully assigned as follows:
Engine: V9
Physical Name: /disk/agedisk1/medicare/data/20pct/car/2010
SYMBOLGEN: Macro variable YEAR resolves to 2010
SYMBOLGEN: Macro variable YR resolves to 10
NOTE: The data set BWORKHOS.CARCLAIMLIST2009 has 0 observations and 3
variables.
WARNING: Data set BWORKHOS.CARCLAIMLIST2009 was not replaced because this
step was
stopped.
NOTE: DATA statement used (Total process time):
real time 0.03 seconds
cpu time 0.00 seconds
SYMBOLGEN: Macro variable YEAR resolves to 2010
SYMBOLGEN: Macro variable FIRST resolves to 1
SYMBOLGEN: Macro variable NUMOBS resolves to 34999999
NOTE: The data set WORK.CARTEMP has 0 observations and 16 variables.
WARNING: Data set WORK.CARTEMP was not replaced because this step was
stopped.
NOTE: DATA statement used (Total process time):
real time 0.06 seconds
cpu time 0.00 seconds
SYMBOLGEN: Macro variable FILE resolves to 1
NOTE: PROCEDURE SORT used (Total process time):
real time 0.00 seconds
33 The SAS System 10:09 Tuesday,
December 22, 2015
cpu time 0.00 seconds
NOTE: The data set WORK.ALL_FILES has 0 observations and 16 variables.
WARNING: Data set WORK.ALL_FILES was not replaced because this step was
stopped.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
SYMBOLGEN: Macro variable YEAR resolves to 2010
SYMBOLGEN: Macro variable YR resolves to 10
SYMBOLGEN: Macro variable YEAR resolves to 2010
SYMBOLGEN: Macro variable FIRST resolves to 35000000
SYMBOLGEN: Macro variable NUMOBS resolves to 69999999
NOTE: The data set WORK.CARTEMP has 0 observations and 16 variables.
WARNING: Data set WORK.CARTEMP was not replaced because this step was
stopped.
NOTE: DATA statement used (Total process time):
real time 0.01 seconds
cpu time 0.00 seconds
SYMBOLGEN: Macro variable FILE resolves to 2
NOTE: PROCEDURE SORT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
NOTE: The data set WORK.ALL_FILES has 0 observations and 16 variables.
WARNING: Data set WORK.ALL_FILES was not replaced because this step was
stopped.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
SYMBOLGEN: Macro variable YEAR resolves to 2010
SYMBOLGEN: Macro variable YR resolves to 10
SYMBOLGEN: Macro variable YEAR resolves to 2010
SYMBOLGEN: Macro variable FIRST resolves to 70000000
SYMBOLGEN: Macro variable NUMOBS resolves to 104999999
NOTE: The data set WORK.CARTEMP has 0 observations and 16 variables.
WARNING: Data set WORK.CARTEMP was not replaced because this step was
stopped.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
SYMBOLGEN: Macro variable FILE resolves to 3
NOTE: PROCEDURE SORT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
34 The SAS System 10:09 Tuesday,
December 22, 2015
NOTE: The data set WORK.ALL_FILES has 0 observations and 16 variables.
WARNING: Data set WORK.ALL_FILES was not replaced because this step was
stopped.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
SYMBOLGEN: Macro variable YEAR resolves to 2010
SYMBOLGEN: Macro variable YR resolves to 10
SYMBOLGEN: Macro variable YEAR resolves to 2010
SYMBOLGEN: Macro variable FIRST resolves to 105000000
SYMBOLGEN: Macro variable NUMOBS resolves to 139999999
NOTE: The data set WORK.CARTEMP has 0 observations and 16 variables.
WARNING: Data set WORK.CARTEMP was not replaced because this step was
stopped.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
SYMBOLGEN: Macro variable FILE resolves to 4
NOTE: PROCEDURE SORT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
NOTE: The data set WORK.ALL_FILES has 0 observations and 16 variables.
WARNING: Data set WORK.ALL_FILES was not replaced because this step was
stopped.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
SYMBOLGEN: Macro variable YEAR resolves to 2010
SYMBOLGEN: Macro variable YR resolves to 10
SYMBOLGEN: Macro variable YEAR resolves to 2010
SYMBOLGEN: Macro variable FIRST resolves to 140000000
SYMBOLGEN: Macro variable NUMOBS resolves to 174999999
NOTE: The data set WORK.CARTEMP has 0 observations and 16 variables.
WARNING: Data set WORK.CARTEMP was not replaced because this step was
stopped.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
SYMBOLGEN: Macro variable FILE resolves to 5
NOTE: PROCEDURE SORT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
35 The SAS System 10:09 Tuesday,
December 22, 2015
NOTE: The data set WORK.ALL_FILES has 0 observations and 16 variables.
WARNING: Data set WORK.ALL_FILES was not replaced because this step was
stopped.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
SYMBOLGEN: Macro variable YEAR resolves to 2010
SYMBOLGEN: Macro variable YR resolves to 10
SYMBOLGEN: Macro variable YEAR resolves to 2010
SYMBOLGEN: Macro variable FIRST resolves to 175000000
SYMBOLGEN: Macro variable NUMOBS resolves to 209999999
NOTE: The data set WORK.CARTEMP has 0 observations and 16 variables.
WARNING: Data set WORK.CARTEMP was not replaced because this step was
stopped.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
SYMBOLGEN: Macro variable FILE resolves to 6
NOTE: PROCEDURE SORT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
NOTE: The data set WORK.ALL_FILES has 0 observations and 16 variables.
WARNING: Data set WORK.ALL_FILES was not replaced because this step was
stopped.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
SYMBOLGEN: Macro variable YEAR resolves to 2010
SYMBOLGEN: Macro variable YR resolves to 10
SYMBOLGEN: Macro variable YEAR resolves to 2010
SYMBOLGEN: Macro variable FIRST resolves to 210000000
SYMBOLGEN: Macro variable NUMOBS resolves to 244999999
NOTE: The data set WORK.CARTEMP has 0 observations and 16 variables.
WARNING: Data set WORK.CARTEMP was not replaced because this step was
stopped.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
SYMBOLGEN: Macro variable FILE resolves to 7
NOTE: PROCEDURE SORT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
NOTE: The data set WORK.ALL_FILES has 0 observations and 16 variables.
WARNING: Data set WORK.ALL_FILES was not replaced because this step was
stopped.
36 The SAS System 10:09 Tuesday,
December 22, 2015
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
SYMBOLGEN: Macro variable YEAR resolves to 2010
SYMBOLGEN: Macro variable YR resolves to 10
SYMBOLGEN: Macro variable YEAR resolves to 2010
SYMBOLGEN: Macro variable FIRST resolves to 245000000
SYMBOLGEN: Macro variable NUMOBS resolves to 279999999
NOTE: The data set WORK.CARTEMP has 0 observations and 16 variables.
WARNING: Data set WORK.CARTEMP was not replaced because this step was
stopped.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
SYMBOLGEN: Macro variable FILE resolves to 8
NOTE: PROCEDURE SORT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
NOTE: The data set WORK.ALL_FILES has 0 observations and 16 variables.
WARNING: Data set WORK.ALL_FILES was not replaced because this step was
stopped.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
SYMBOLGEN: Macro variable YEAR resolves to 2010
SYMBOLGEN: Macro variable YR resolves to 10
SYMBOLGEN: Macro variable YEAR resolves to 2010
SYMBOLGEN: Macro variable FIRST resolves to 280000000
SYMBOLGEN: Macro variable NUMOBS resolves to 314999999
NOTE: The data set WORK.CARTEMP has 0 observations and 16 variables.
WARNING: Data set WORK.CARTEMP was not replaced because this step was
stopped.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
SYMBOLGEN: Macro variable FILE resolves to 9
NOTE: PROCEDURE SORT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
NOTE: The data set WORK.ALL_FILES has 0 observations and 16 variables.
WARNING: Data set WORK.ALL_FILES was not replaced because this step was
stopped.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
37 The SAS System 10:09 Tuesday,
December 22, 2015
cpu time 0.00 seconds
SYMBOLGEN: Macro variable YEAR resolves to 2010
SYMBOLGEN: Macro variable YR resolves to 10
SYMBOLGEN: Macro variable YEAR resolves to 2010
SYMBOLGEN: Macro variable FIRST resolves to 315000000
SYMBOLGEN: Macro variable NUMOBS resolves to MAX
NOTE: The data set WORK.CARTEMP has 0 observations and 16 variables.
WARNING: Data set WORK.CARTEMP was not replaced because this step was
stopped.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
SYMBOLGEN: Macro variable FILE resolves to 10
NOTE: PROCEDURE SORT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
NOTE: The data set WORK.ALL_FILES has 0 observations and 16 variables.
WARNING: Data set WORK.ALL_FILES was not replaced because this step was
stopped.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
SYMBOLGEN: Macro variable YEAR resolves to 2010
NOTE: The data set BWORKHOS.CARCLAIMLIST2010 has 0 observations and 16
variables.
WARNING: Data set BWORKHOS.CARCLAIMLIST2010 was not replaced because this
step was
stopped.
NOTE: DATA statement used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds
180: LINE and COLUMN cannot be determined.
NOTE: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the
LINE and
COLUMN where the error has occurred.
ERROR 180-322: Statement is not valid or it is used out of proper order.
180: LINE and COLUMN cannot be determined.
NOTE: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the
LINE and
COLUMN where the error has occurred.
ERROR 180-322: Statement is not valid or it is used out of proper order.
SYMBOLGEN: Macro variable YEAR resolves to 2010
SYMBOLGEN: Macro variable YEAR resolves to 2010
NOTE: The PROCEDURE CONTENTS printed page 5.
NOTE: PROCEDURE CONTENTS used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
38 The SAS System 10:09 Tuesday,
December 22, 2015
SYMBOLGEN: Macro variable YEAR resolves to 2010
SYMBOLGEN: Macro variable YEAR resolves to 2010
NOTE: PROCEDURE PRINT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
SYMBOLGEN: Macro variable YEAR resolves to 2010
NOTE: The data set BWORKHOS.FINDERFILE has 0 observations and 3 variables.
WARNING: Data set BWORKHOS.FINDERFILE was not replaced because this step was
stopped.
NOTE: DATA statement used (Total process time):
real time 0.02 seconds
cpu time 0.00 seconds
NOTE: PROCEDURE SORT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
SYMBOLGEN: Macro variable YEAR resolves to 2010
SYMBOLGEN: Macro variable YEAR resolves to 2010
NOTE: The data set BWORKHOS.CARCLAIMLIST2010 has 0 observations and 3
variables.
WARNING: Data set BWORKHOS.CARCLAIMLIST2010 was not replaced because this
step was
stopped.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
180: LINE and COLUMN cannot be determined.
NOTE: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the
LINE and
COLUMN where the error has occurred.
ERROR 180-322: Statement is not valid or it is used out of proper order.
180: LINE and COLUMN cannot be determined.
NOTE: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the
LINE and
COLUMN where the error has occurred.
ERROR 180-322: Statement is not valid or it is used out of proper order.
180: LINE and COLUMN cannot be determined.
NOTE: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the
LINE and
COLUMN where the error has occurred.
ERROR 180-322: Statement is not valid or it is used out of proper order.
NOTE: Libname BENEXW refers to the same physical library as TEMP.
NOTE: Libref BENEXW was successfully assigned as follows:
Engine: V9
Physical Name: /disk/agebulk5/medicare.work/lbaker-DUA23466/lbaker/
data/xw
NOTE: Data file BENEXW.NPI_UPIN_XW_FINAL.DATA is in a format that is native
to another
host, or the file encoding does not match the session encoding. Cross
Environment
Data Access will be used, which might require additional CPU resources
and might
reduce performance.
NOTE: The data set BWORKHOS.NPIXWALK has 0 observations and 2 variables.
WARNING: Data set BWORKHOS.NPIXWALK was not replaced because this step was
stopped.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
39 The SAS System 10:09 Tuesday,
December 22, 2015
cpu time 0.00 seconds
NOTE: PROCEDURE SORT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
SYMBOLGEN: Macro variable YEAR resolves to 2010
ERROR: Variable PRF_NPI not found.
SYMBOLGEN: Macro variable YEAR resolves to 2010
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
SYMBOLGEN: Macro variable YEAR resolves to 2010
162 %readin0611(2011,11,1);
SYMBOLGEN: Macro variable DATALOC resolves to /disk/agedisk1/medicare/data/
20pct/car
SYMBOLGEN: Macro variable YEAR resolves to 2011
NOTE: Libref LOC was successfully assigned as follows:
Engine: V9
Physical Name: /disk/agedisk1/medicare/data/20pct/car/2011
SYMBOLGEN: Macro variable YEAR resolves to 2011
SYMBOLGEN: Macro variable YR resolves to 11
NOTE: The data set BWORKHOS.CARCLAIMLIST2010 has 0 observations and 3
variables.
WARNING: Data set BWORKHOS.CARCLAIMLIST2010 was not replaced because this
step was
stopped.
NOTE: DATA statement used (Total process time):
real time 0.04 seconds
cpu time 0.00 seconds
SYMBOLGEN: Macro variable YEAR resolves to 2011
SYMBOLGEN: Macro variable FIRST resolves to 1
SYMBOLGEN: Macro variable NUMOBS resolves to 34999999
NOTE: The data set WORK.CARTEMP has 0 observations and 16 variables.
WARNING: Data set WORK.CARTEMP was not replaced because this step was
stopped.
NOTE: DATA statement used (Total process time):
real time 0.04 seconds
cpu time 0.01 seconds
SYMBOLGEN: Macro variable FILE resolves to 1
NOTE: PROCEDURE SORT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
NOTE: The data set WORK.ALL_FILES has 0 observations and 16 variables.
WARNING: Data set WORK.ALL_FILES was not replaced because this step was
stopped.
NOTE: DATA statement used (Total process time):
40 The SAS System 10:09 Tuesday,
December 22, 2015
real time 0.00 seconds
cpu time 0.00 seconds
SYMBOLGEN: Macro variable YEAR resolves to 2011
SYMBOLGEN: Macro variable YR resolves to 11
SYMBOLGEN: Macro variable YEAR resolves to 2011
SYMBOLGEN: Macro variable FIRST resolves to 35000000
SYMBOLGEN: Macro variable NUMOBS resolves to 69999999
NOTE: The data set WORK.CARTEMP has 0 observations and 16 variables.
WARNING: Data set WORK.CARTEMP was not replaced because this step was
stopped.
NOTE: DATA statement used (Total process time):
real time 0.01 seconds
cpu time 0.00 seconds
SYMBOLGEN: Macro variable FILE resolves to 2
NOTE: PROCEDURE SORT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
NOTE: The data set WORK.ALL_FILES has 0 observations and 16 variables.
WARNING: Data set WORK.ALL_FILES was not replaced because this step was
stopped.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
SYMBOLGEN: Macro variable YEAR resolves to 2011
SYMBOLGEN: Macro variable YR resolves to 11
SYMBOLGEN: Macro variable YEAR resolves to 2011
SYMBOLGEN: Macro variable FIRST resolves to 70000000
SYMBOLGEN: Macro variable NUMOBS resolves to 104999999
NOTE: The data set WORK.CARTEMP has 0 observations and 16 variables.
WARNING: Data set WORK.CARTEMP was not replaced because this step was
stopped.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
SYMBOLGEN: Macro variable FILE resolves to 3
NOTE: PROCEDURE SORT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
NOTE: The data set WORK.ALL_FILES has 0 observations and 16 variables.
WARNING: Data set WORK.ALL_FILES was not replaced because this step was
stopped.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
41 The SAS System 10:09 Tuesday,
December 22, 2015
SYMBOLGEN: Macro variable YEAR resolves to 2011
SYMBOLGEN: Macro variable YR resolves to 11
SYMBOLGEN: Macro variable YEAR resolves to 2011
SYMBOLGEN: Macro variable FIRST resolves to 105000000
SYMBOLGEN: Macro variable NUMOBS resolves to 139999999
NOTE: The data set WORK.CARTEMP has 0 observations and 16 variables.
WARNING: Data set WORK.CARTEMP was not replaced because this step was
stopped.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
SYMBOLGEN: Macro variable FILE resolves to 4
NOTE: PROCEDURE SORT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
NOTE: The data set WORK.ALL_FILES has 0 observations and 16 variables.
WARNING: Data set WORK.ALL_FILES was not replaced because this step was
stopped.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
SYMBOLGEN: Macro variable YEAR resolves to 2011
SYMBOLGEN: Macro variable YR resolves to 11
SYMBOLGEN: Macro variable YEAR resolves to 2011
SYMBOLGEN: Macro variable FIRST resolves to 140000000
SYMBOLGEN: Macro variable NUMOBS resolves to 174999999
NOTE: The data set WORK.CARTEMP has 0 observations and 16 variables.
WARNING: Data set WORK.CARTEMP was not replaced because this step was
stopped.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
SYMBOLGEN: Macro variable FILE resolves to 5
NOTE: PROCEDURE SORT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
NOTE: The data set WORK.ALL_FILES has 0 observations and 16 variables.
WARNING: Data set WORK.ALL_FILES was not replaced because this step was
stopped.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
42 The SAS System 10:09 Tuesday,
December 22, 2015
SYMBOLGEN: Macro variable YEAR resolves to 2011
SYMBOLGEN: Macro variable YR resolves to 11
SYMBOLGEN: Macro variable YEAR resolves to 2011
SYMBOLGEN: Macro variable FIRST resolves to 175000000
SYMBOLGEN: Macro variable NUMOBS resolves to 209999999
NOTE: The data set WORK.CARTEMP has 0 observations and 16 variables.
WARNING: Data set WORK.CARTEMP was not replaced because this step was
stopped.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
SYMBOLGEN: Macro variable FILE resolves to 6
NOTE: PROCEDURE SORT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
NOTE: The data set WORK.ALL_FILES has 0 observations and 16 variables.
WARNING: Data set WORK.ALL_FILES was not replaced because this step was
stopped.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
SYMBOLGEN: Macro variable YEAR resolves to 2011
SYMBOLGEN: Macro variable YR resolves to 11
SYMBOLGEN: Macro variable YEAR resolves to 2011
SYMBOLGEN: Macro variable FIRST resolves to 210000000
SYMBOLGEN: Macro variable NUMOBS resolves to 244999999
NOTE: The data set WORK.CARTEMP has 0 observations and 16 variables.
WARNING: Data set WORK.CARTEMP was not replaced because this step was
stopped.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
SYMBOLGEN: Macro variable FILE resolves to 7
NOTE: PROCEDURE SORT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
NOTE: The data set WORK.ALL_FILES has 0 observations and 16 variables.
WARNING: Data set WORK.ALL_FILES was not replaced because this step was
stopped.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
SYMBOLGEN: Macro variable YEAR resolves to 2011
SYMBOLGEN: Macro variable YR resolves to 11
43 The SAS System 10:09 Tuesday,
December 22, 2015
SYMBOLGEN: Macro variable YEAR resolves to 2011
SYMBOLGEN: Macro variable FIRST resolves to 245000000
SYMBOLGEN: Macro variable NUMOBS resolves to 279999999
NOTE: The data set WORK.CARTEMP has 0 observations and 16 variables.
WARNING: Data set WORK.CARTEMP was not replaced because this step was
stopped.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
SYMBOLGEN: Macro variable FILE resolves to 8
NOTE: PROCEDURE SORT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
NOTE: The data set WORK.ALL_FILES has 0 observations and 16 variables.
WARNING: Data set WORK.ALL_FILES was not replaced because this step was
stopped.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
SYMBOLGEN: Macro variable YEAR resolves to 2011
SYMBOLGEN: Macro variable YR resolves to 11
SYMBOLGEN: Macro variable YEAR resolves to 2011
SYMBOLGEN: Macro variable FIRST resolves to 280000000
SYMBOLGEN: Macro variable NUMOBS resolves to 314999999
NOTE: The data set WORK.CARTEMP has 0 observations and 16 variables.
WARNING: Data set WORK.CARTEMP was not replaced because this step was
stopped.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
SYMBOLGEN: Macro variable FILE resolves to 9
NOTE: PROCEDURE SORT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
NOTE: The data set WORK.ALL_FILES has 0 observations and 16 variables.
WARNING: Data set WORK.ALL_FILES was not replaced because this step was
stopped.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
SYMBOLGEN: Macro variable YEAR resolves to 2011
SYMBOLGEN: Macro variable YR resolves to 11
SYMBOLGEN: Macro variable YEAR resolves to 2011
SYMBOLGEN: Macro variable FIRST resolves to 315000000
44 The SAS System 10:09 Tuesday,
December 22, 2015
SYMBOLGEN: Macro variable NUMOBS resolves to MAX
NOTE: The data set WORK.CARTEMP has 0 observations and 16 variables.
WARNING: Data set WORK.CARTEMP was not replaced because this step was
stopped.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
SYMBOLGEN: Macro variable FILE resolves to 10
NOTE: PROCEDURE SORT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
NOTE: The data set WORK.ALL_FILES has 0 observations and 16 variables.
WARNING: Data set WORK.ALL_FILES was not replaced because this step was
stopped.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
SYMBOLGEN: Macro variable YEAR resolves to 2011
NOTE: The data set BWORKHOS.CARCLAIMLIST2011 has 0 observations and 16
variables.
WARNING: Data set BWORKHOS.CARCLAIMLIST2011 was not replaced because this
step was
stopped.
NOTE: DATA statement used (Total process time):
real time 0.01 seconds
cpu time 0.00 seconds
180: LINE and COLUMN cannot be determined.
NOTE: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the
LINE and
COLUMN where the error has occurred.
ERROR 180-322: Statement is not valid or it is used out of proper order.
180: LINE and COLUMN cannot be determined.
NOTE: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the
LINE and
COLUMN where the error has occurred.
ERROR 180-322: Statement is not valid or it is used out of proper order.
SYMBOLGEN: Macro variable YEAR resolves to 2011
SYMBOLGEN: Macro variable YEAR resolves to 2011
NOTE: The PROCEDURE CONTENTS printed page 6.
NOTE: PROCEDURE CONTENTS used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
SYMBOLGEN: Macro variable YEAR resolves to 2011
SYMBOLGEN: Macro variable YEAR resolves to 2011
NOTE: PROCEDURE PRINT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
45 The SAS System 10:09 Tuesday,
December 22, 2015
SYMBOLGEN: Macro variable YEAR resolves to 2011
NOTE: The data set BWORKHOS.FINDERFILE has 0 observations and 3 variables.
WARNING: Data set BWORKHOS.FINDERFILE was not replaced because this step was
stopped.
NOTE: DATA statement used (Total process time):
real time 0.04 seconds
cpu time 0.00 seconds
NOTE: PROCEDURE SORT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
SYMBOLGEN: Macro variable YEAR resolves to 2011
SYMBOLGEN: Macro variable YEAR resolves to 2011
NOTE: The data set BWORKHOS.CARCLAIMLIST2011 has 0 observations and 3
variables.
WARNING: Data set BWORKHOS.CARCLAIMLIST2011 was not replaced because this
step was
stopped.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
180: LINE and COLUMN cannot be determined.
NOTE: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the
LINE and
COLUMN where the error has occurred.
ERROR 180-322: Statement is not valid or it is used out of proper order.
180: LINE and COLUMN cannot be determined.
NOTE: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the
LINE and
COLUMN where the error has occurred.
ERROR 180-322: Statement is not valid or it is used out of proper order.
180: LINE and COLUMN cannot be determined.
NOTE: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the
LINE and
COLUMN where the error has occurred.
ERROR 180-322: Statement is not valid or it is used out of proper order.
NOTE: Libname BENEXW refers to the same physical library as TEMP.
NOTE: Libref BENEXW was successfully assigned as follows:
Engine: V9
Physical Name: /disk/agebulk5/medicare.work/lbaker-DUA23466/lbaker/
data/xw
NOTE: Data file BENEXW.NPI_UPIN_XW_FINAL.DATA is in a format that is native
to another
host, or the file encoding does not match the session encoding. Cross
Environment
Data Access will be used, which might require additional CPU resources
and might
reduce performance.
NOTE: The data set BWORKHOS.NPIXWALK has 0 observations and 2 variables.
WARNING: Data set BWORKHOS.NPIXWALK was not replaced because this step was
stopped.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
NOTE: PROCEDURE SORT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
46 The SAS System 10:09 Tuesday,
December 22, 2015
SYMBOLGEN: Macro variable YEAR resolves to 2011
ERROR: Variable PRF_NPI not found.
SYMBOLGEN: Macro variable YEAR resolves to 2011
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
SYMBOLGEN: Macro variable YEAR resolves to 2011
163
164 run;
NOTE: The data set BWORKHOS.CARCLAIMLIST2011 has 0 observations and 3
variables.
WARNING: Data set BWORKHOS.CARCLAIMLIST2011 was not replaced because this
step was
stopped.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
165
166 ods listing close;
167
168
NOTE: PROCEDURE PRINTTO used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
25
26 *-----------------------------------------------------;
27 %macro process(year,yr,file,first,numobs);
28
29 data cartemp;
30 set loc.carl&year.
31 (firstobs=&first. obs=&numobs.
32 keep=expnsdt1 hcpcs_cd bene_id lalowchg lprvpmt linepmt mdfr
_cd1 mdfr_cd2
32 ! betos plcsrvc
33 prf_npi prf_upin);
34
35 snf = (plcsrvc in ('31', '32', '33'));
36 hha = (plcsrvc in ('12'));
37 inpt = (plcsrvc in ('21'));
38 hspc = (plcsrvc in ('34'));
39
40 run;
41
42
43 proc sort data=cartemp;
44 by bene_id;
45
46 *append datasets;
47
48 %if &file.=1 %then %do;
49 data all_files;
50 set cartemp;
51 %end;
52 %else %do;
53 data all_files;
54 set all_files cartemp;
55 %end;
56 run;
57
58
59 %mend process;
60
61
62
63 *-----------------------------------------------------;
64 %macro readin0611(year,yr,numfiles);
3 The SAS System 11:10 Tuesday,
December 22, 2015
65 libname loc "&dataloc./&year.";
66
67
68 %process(&year. , &yr. , 1 , 1 , 34999999);
69 %process(&year. , &yr. , 2 , 35000000 , 69999999);
70 %process(&year. , &yr. , 3 , 70000000 , 104999999);
71 %process(&year. , &yr. , 4 , 105000000 , 139999999);
72 %process(&year. , &yr. , 5 , 140000000 , 174999999);
73 %process(&year. , &yr. , 6 , 175000000 , 209999999);
74 %process(&year. , &yr. , 7 , 210000000 , 244999999);
75 %process(&year. , &yr. , 8 , 245000000 , 279999999);
76 %process(&year. , &yr. , 9 , 280000000 , 314999999);
77 %process(&year. , &yr. , 10, 315000000 , MAX);
78
79
80 data bworkhos.carclaimlist&year.;
81 set all_files;
82 run;
83
84 *date_new = input(expnsdt1, date9.);
85 input expnsdt1 date9.;
86 put expnsdt1;
87 run;
88
89
90
91 proc contents data=bworkhos.carclaimlist&year.;
92 title "&year.";
93 proc print data=bworkhos.carclaimlist&year. (obs=150);
94 title "&year.";
95 run;
96
97 data bworkhos.finderfile;
98 set bworkhos.car&year. (keep=bene_id indexdat);
99 indexdate=indexdat;
100 proc sort data=bworkhos.finderfile;
101 by bene_id;
102 run;
103
104 data bworkhos.carclaimlist&year.;
105 merge bworkhos.carclaimlist&year. (in=in1)
106 bworkhos.finderfile (in=in2);
107 by bene_id;
108 run;
109
110
111 days=datdif(expnsdt1,indexdate,'act/act');
112
113
114
115 if in1 and in2;
116
117 if days>=-365 and days<=365;
118
119 * if (date_new-indexdate)>=-365 and (date_new-indexdate)<=365;
120
121 * if (expnsdt1-indexdate)>=-365 and (expnsdt1-indexdate)<=365;
122
4 The SAS System 11:10 Tuesday,
December 22, 2015
123 ***Reconciling npi upin using crosswalk;
124 libname benexw "/disk/agebulk5/medicare.work/lbaker-DUA23466/
lbaker/data/xw";
125 data bworkhos.npixwalk (keep=prf_npi xw_upin);
126 set benexw.npi_upin_xw_final;
127
128 prf_npi=npi;
129 xw_upin=upin;
130
131 proc sort data=bworkhos.npixwalk;
132 by prf_npi;
133
134
135 proc sort data=bworkhos.carclaimlist&year.;
136 by prf_npi;
137
138
139 data bworkhos.carclaimlist&year. (drop=xw_upin); *taxnumhhibase;
140 merge bworkhos.carclaimlist&year. (in=in1)
141 bworkhos.npixwalk;
142 by prf_npi;
143 if in1;
144
145 length prf_physid $10;
146 prf_physid="none";
147 if prf_upin ne "" and prf_upin ne "none" then prf_physid=prf
_upin;
148 else if xw_upin ne "" then prf_physid=xw_upin;
149 else prf_physid=prf_npi;
150
151
152 %mend readin0611;
153 *-----------------------------------------------------;
154
155
156
157 %readin0611(2006,06,1);
SYMBOLGEN: Macro variable DATALOC resolves to /disk/agedisk1/medicare/data/
20pct/car
SYMBOLGEN: Macro variable YEAR resolves to 2006
NOTE: Libref LOC was successfully assigned as follows:
Engine: V9
Physical Name: /disk/agedisk1/medicare/data/20pct/car/2006
SYMBOLGEN: Macro variable YEAR resolves to 2006
SYMBOLGEN: Macro variable YR resolves to 06
SYMBOLGEN: Macro variable YEAR resolves to 2006
SYMBOLGEN: Macro variable FIRST resolves to 1
SYMBOLGEN: Macro variable NUMOBS resolves to 34999999
NOTE: There were 34999999 observations read from the data set LOC.CARL2006.
NOTE: The data set WORK.CARTEMP has 34999999 observations and 16 variables.
NOTE: DATA statement used (Total process time):
real time 34.89 seconds
cpu time 10.34 seconds
SYMBOLGEN: Macro variable FILE resolves to 1
NOTE: There were 34999999 observations read from the data set WORK.CARTEMP.
NOTE: The data set WORK.CARTEMP has 34999999 observations and 16 variables.
NOTE: PROCEDURE SORT used (Total process time):
5 The SAS System 11:10 Tuesday,
December 22, 2015
real time 15.39 seconds
cpu time 17.45 seconds
NOTE: There were 34999999 observations read from the data set WORK.CARTEMP.
NOTE: The data set WORK.ALL_FILES has 34999999 observations and 16 variables.
NOTE: DATA statement used (Total process time):
real time 4.37 seconds
cpu time 4.32 seconds
SYMBOLGEN: Macro variable YEAR resolves to 2006
SYMBOLGEN: Macro variable YR resolves to 06
SYMBOLGEN: Macro variable YEAR resolves to 2006
SYMBOLGEN: Macro variable FIRST resolves to 35000000
SYMBOLGEN: Macro variable NUMOBS resolves to 69999999
NOTE: There were 35000000 observations read from the data set LOC.CARL2006.
NOTE: The data set WORK.CARTEMP has 35000000 observations and 16 variables.
NOTE: DATA statement used (Total process time):
real time 32.60 seconds
cpu time 10.68 seconds
SYMBOLGEN: Macro variable FILE resolves to 2
NOTE: There were 35000000 observations read from the data set WORK.CARTEMP.
NOTE: The data set WORK.CARTEMP has 35000000 observations and 16 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 14.14 seconds
cpu time 17.33 seconds
NOTE: There were 34999999 observations read from the data set WORK.ALL_FILES.
NOTE: There were 35000000 observations read from the data set WORK.CARTEMP.
NOTE: The data set WORK.ALL_FILES has 69999999 observations and 16 variables.
NOTE: DATA statement used (Total process time):
real time 9.04 seconds
cpu time 8.77 seconds
SYMBOLGEN: Macro variable YEAR resolves to 2006
SYMBOLGEN: Macro variable YR resolves to 06
SYMBOLGEN: Macro variable YEAR resolves to 2006
SYMBOLGEN: Macro variable FIRST resolves to 70000000
SYMBOLGEN: Macro variable NUMOBS resolves to 104999999
NOTE: There were 35000000 observations read from the data set LOC.CARL2006.
NOTE: The data set WORK.CARTEMP has 35000000 observations and 16 variables.
NOTE: DATA statement used (Total process time):
real time 29.24 seconds
cpu time 10.92 seconds
SYMBOLGEN: Macro variable FILE resolves to 3
6 The SAS System 11:10 Tuesday,
December 22, 2015
NOTE: There were 35000000 observations read from the data set WORK.CARTEMP.
NOTE: The data set WORK.CARTEMP has 35000000 observations and 16 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 14.93 seconds
cpu time 17.43 seconds
NOTE: There were 69999999 observations read from the data set WORK.ALL_FILES.
NOTE: There were 35000000 observations read from the data set WORK.CARTEMP.
NOTE: The data set WORK.ALL_FILES has 104999999 observations and 16
variables.
NOTE: DATA statement used (Total process time):
real time 15.40 seconds
cpu time 13.31 seconds
SYMBOLGEN: Macro variable YEAR resolves to 2006
SYMBOLGEN: Macro variable YR resolves to 06
SYMBOLGEN: Macro variable YEAR resolves to 2006
SYMBOLGEN: Macro variable FIRST resolves to 105000000
SYMBOLGEN: Macro variable NUMOBS resolves to 139999999
NOTE: There were 35000000 observations read from the data set LOC.CARL2006.
NOTE: The data set WORK.CARTEMP has 35000000 observations and 16 variables.
NOTE: DATA statement used (Total process time):
real time 35.77 seconds
cpu time 11.00 seconds
SYMBOLGEN: Macro variable FILE resolves to 4
NOTE: There were 35000000 observations read from the data set WORK.CARTEMP.
NOTE: The data set WORK.CARTEMP has 35000000 observations and 16 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 13.04 seconds
cpu time 16.51 seconds
NOTE: There were 104999999 observations read from the data set WORK.ALL_
FILES.
NOTE: There were 35000000 observations read from the data set WORK.CARTEMP.
NOTE: The data set WORK.ALL_FILES has 139999999 observations and 16
variables.
NOTE: DATA statement used (Total process time):
real time 1:23.09
cpu time 18.67 seconds
SYMBOLGEN: Macro variable YEAR resolves to 2006
SYMBOLGEN: Macro variable YR resolves to 06
SYMBOLGEN: Macro variable YEAR resolves to 2006
SYMBOLGEN: Macro variable FIRST resolves to 140000000
SYMBOLGEN: Macro variable NUMOBS resolves to 174999999
NOTE: There were 35000000 observations read from the data set LOC.CARL2006.
NOTE: The data set WORK.CARTEMP has 35000000 observations and 16 variables.
NOTE: DATA statement used (Total process time):
real time 29.48 seconds
cpu time 10.81 seconds
7 The SAS System 11:10 Tuesday,
December 22, 2015
SYMBOLGEN: Macro variable FILE resolves to 5
NOTE: There were 35000000 observations read from the data set WORK.CARTEMP.
NOTE: The data set WORK.CARTEMP has 35000000 observations and 16 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 13.98 seconds
cpu time 16.86 seconds
NOTE: There were 139999999 observations read from the data set WORK.ALL_
FILES.
NOTE: There were 35000000 observations read from the data set WORK.CARTEMP.
NOTE: The data set WORK.ALL_FILES has 174999999 observations and 16
variables.
NOTE: DATA statement used (Total process time):
real time 3:53.77
cpu time 24.72 seconds
SYMBOLGEN: Macro variable YEAR resolves to 2006
SYMBOLGEN: Macro variable YR resolves to 06
SYMBOLGEN: Macro variable YEAR resolves to 2006
SYMBOLGEN: Macro variable FIRST resolves to 175000000
SYMBOLGEN: Macro variable NUMOBS resolves to 209999999
NOTE: There were 35000000 observations read from the data set LOC.CARL2006.
NOTE: The data set WORK.CARTEMP has 35000000 observations and 16 variables.
NOTE: DATA statement used (Total process time):
real time 30.24 seconds
cpu time 10.40 seconds
SYMBOLGEN: Macro variable FILE resolves to 6
NOTE: There were 35000000 observations read from the data set WORK.CARTEMP.
NOTE: The data set WORK.CARTEMP has 35000000 observations and 16 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 14.01 seconds
cpu time 17.27 seconds
NOTE: There were 174999999 observations read from the data set WORK.ALL_
FILES.
NOTE: There were 35000000 observations read from the data set WORK.CARTEMP.
NOTE: The data set WORK.ALL_FILES has 209999999 observations and 16
variables.
NOTE: DATA statement used (Total process time):
real time 4:01.14
cpu time 28.90 seconds
SYMBOLGEN: Macro variable YEAR resolves to 2006
SYMBOLGEN: Macro variable YR resolves to 06
SYMBOLGEN: Macro variable YEAR resolves to 2006
SYMBOLGEN: Macro variable FIRST resolves to 210000000
SYMBOLGEN: Macro variable NUMOBS resolves to 244999999
NOTE: There were 35000000 observations read from the data set LOC.CARL2006.
8 The SAS System 11:10 Tuesday,
December 22, 2015
NOTE: The data set WORK.CARTEMP has 35000000 observations and 16 variables.
NOTE: DATA statement used (Total process time):
real time 32.25 seconds
cpu time 9.36 seconds
SYMBOLGEN: Macro variable FILE resolves to 7
NOTE: There were 35000000 observations read from the data set WORK.CARTEMP.
NOTE: The data set WORK.CARTEMP has 35000000 observations and 16 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 16.61 seconds
cpu time 17.72 seconds
NOTE: There were 209999999 observations read from the data set WORK.ALL_
FILES.
NOTE: There were 35000000 observations read from the data set WORK.CARTEMP.
NOTE: The data set WORK.ALL_FILES has 244999999 observations and 16
variables.
NOTE: DATA statement used (Total process time):
real time 4:52.85
cpu time 33.84 seconds
SYMBOLGEN: Macro variable YEAR resolves to 2006
SYMBOLGEN: Macro variable YR resolves to 06
SYMBOLGEN: Macro variable YEAR resolves to 2006
SYMBOLGEN: Macro variable FIRST resolves to 245000000
SYMBOLGEN: Macro variable NUMOBS resolves to 279999999
NOTE: There were 35000000 observations read from the data set LOC.CARL2006.
NOTE: The data set WORK.CARTEMP has 35000000 observations and 16 variables.
NOTE: DATA statement used (Total process time):
real time 29.19 seconds
cpu time 10.02 seconds
SYMBOLGEN: Macro variable FILE resolves to 8
NOTE: There were 35000000 observations read from the data set WORK.CARTEMP.
NOTE: The data set WORK.CARTEMP has 35000000 observations and 16 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 15.94 seconds
cpu time 18.51 seconds
NOTE: There were 244999999 observations read from the data set WORK.ALL_
FILES.
NOTE: There were 35000000 observations read from the data set WORK.CARTEMP.
NOTE: The data set WORK.ALL_FILES has 279999999 observations and 16
variables.
NOTE: DATA statement used (Total process time):
real time 2:50.55
cpu time 36.83 seconds
SYMBOLGEN: Macro variable YEAR resolves to 2006
SYMBOLGEN: Macro variable YR resolves to 06
SYMBOLGEN: Macro variable YEAR resolves to 2006
9 The SAS System 11:10 Tuesday,
December 22, 2015
SYMBOLGEN: Macro variable FIRST resolves to 280000000
SYMBOLGEN: Macro variable NUMOBS resolves to 314999999
NOTE: There were 35000000 observations read from the data set LOC.CARL2006.
NOTE: The data set WORK.CARTEMP has 35000000 observations and 16 variables.
NOTE: DATA statement used (Total process time):
real time 24.60 seconds
cpu time 10.03 seconds
SYMBOLGEN: Macro variable FILE resolves to 9
NOTE: There were 35000000 observations read from the data set WORK.CARTEMP.
NOTE: The data set WORK.CARTEMP has 35000000 observations and 16 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 13.30 seconds
cpu time 16.36 seconds
NOTE: PROCEDURE PRINTTO used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
26
27 *-----------------------------------------------------;
28 %macro process(year,yr,file,first,numobs);
29
30 data cartemp;
31 set loc.carl&year.
32 (firstobs=&first. obs=&numobs.
33 keep=expnsdt1 hcpcs_cd bene_id lalowchg lprvpmt linepmt mdfr
_cd1 mdfr_cd2
33 ! betos plcsrvc
34 prf_npi prf_upin);
35
36 snf = (plcsrvc in ('31', '32', '33'));
37 hha = (plcsrvc in ('12'));
38 inpt = (plcsrvc in ('21'));
39 hspc = (plcsrvc in ('34'));
40
41 run;
42
43
44 proc sort data=cartemp;
45 by bene_id;
46
47 *append datasets;
48
49 %if &file.=1 %then %do;
50 data all_files;
51 set cartemp;
52 %end;
53 %else %do;
54 data all_files;
55 set all_files cartemp;
56 %end;
57 run;
58
59
60 %mend process;
61
62
63
64 *-----------------------------------------------------;
3 The SAS System 11:36 Tuesday,
December 22, 2015
65 %macro readin0611(year,yr,numfiles);
66 libname loc "&dataloc./&year.";
67
68
69 %process(&year. , &yr. , 1 , 1 , 34999999);
70 %process(&year. , &yr. , 2 , 35000000 , 69999999);
71 /*
72 %process(&year. , &yr. , 3 , 70000000 , 104999999);
73 %process(&year. , &yr. , 4 , 105000000 , 139999999);
74 %process(&year. , &yr. , 5 , 140000000 , 174999999);
75 %process(&year. , &yr. , 6 , 175000000 , 209999999);
76 %process(&year. , &yr. , 7 , 210000000 , 244999999);
77 %process(&year. , &yr. , 8 , 245000000 , 279999999);
78 %process(&year. , &yr. , 9 , 280000000 , 314999999);
79 %process(&year. , &yr. , 10, 315000000 , MAX);
80 */
81
82 data bworkhos.carclaimlist&year.;
83 set all_files;
84 run;
85
86 *date_new = input(expnsdt1, date9.);
87 input expnsdt1 date9.;
88 put expnsdt1;
89 run;
90
91
92
93 proc contents data=bworkhos.carclaimlist&year.;
94 title "&year.";
95 proc print data=bworkhos.carclaimlist&year. (obs=150);
96 title "&year.";
97 run;
98
99 data bworkhos.finderfile;
100 set bworkhos.car&year. (keep=bene_id indexdat);
101 indexdate=indexdat;
102 proc sort data=bworkhos.finderfile;
103 by bene_id;
104 run;
105
106 data bworkhos.carclaimlist&year.;
107 merge bworkhos.carclaimlist&year. (in=in1)
108 bworkhos.finderfile (in=in2);
109 by bene_id;
110 run;
111
112
113 days=datdif(expnsdt1,indexdate,'act/act');
114
115
116
117 if in1 and in2;
118
119 if days>=-365 and days<=365;
120
121 * if (date_new-indexdate)>=-365 and (date_new-indexdate)<=365;
122
4 The SAS System 11:36 Tuesday,
December 22, 2015
123 * if (expnsdt1-indexdate)>=-365 and (expnsdt1-indexdate)<=365;
124
125 ***Reconciling npi upin using crosswalk;
126 libname benexw "/disk/agebulk5/medicare.work/lbaker-DUA23466/
lbaker/data/xw";
127 data bworkhos.npixwalk (keep=prf_npi xw_upin);
128 set benexw.npi_upin_xw_final;
129
130 prf_npi=npi;
131 xw_upin=upin;
132
133 proc sort data=bworkhos.npixwalk;
134 by prf_npi;
135
136
137 proc sort data=bworkhos.carclaimlist&year.;
138 by prf_npi;
139
140
141 data bworkhos.carclaimlist&year. (drop=xw_upin); *taxnumhhibase;
142 merge bworkhos.carclaimlist&year. (in=in1)
143 bworkhos.npixwalk;
144 by prf_npi;
145 if in1;
146
147 length prf_physid $10;
148 prf_physid="none";
149 if prf_upin ne "" and prf_upin ne "none" then prf_physid=prf
_upin;
150 else if xw_upin ne "" then prf_physid=xw_upin;
151 else prf_physid=prf_npi;
152
153
154 %mend readin0611;
155 *-----------------------------------------------------;
156
157
158
159 %readin0611(2006,06,1);
SYMBOLGEN: Macro variable DATALOC resolves to /disk/agedisk1/medicare/data/
20pct/car
SYMBOLGEN: Macro variable YEAR resolves to 2006
NOTE: Libref LOC was successfully assigned as follows:
Engine: V9
Physical Name: /disk/agedisk1/medicare/data/20pct/car/2006
SYMBOLGEN: Macro variable YEAR resolves to 2006
SYMBOLGEN: Macro variable YR resolves to 06
SYMBOLGEN: Macro variable YEAR resolves to 2006
SYMBOLGEN: Macro variable FIRST resolves to 1
SYMBOLGEN: Macro variable NUMOBS resolves to 34999999
NOTE: There were 34999999 observations read from the data set LOC.CARL2006.
NOTE: The data set WORK.CARTEMP has 34999999 observations and 16 variables.
NOTE: DATA statement used (Total process time):
real time 26.65 seconds
cpu time 10.04 seconds
ERROR: User asked for termination
NOTE: The SAS System stopped processing this step because of errors.
NOTE: SAS set option OBS=0 and will continue to check statements.
This might cause NOTE: No observations in data set.
NOTE: There were 197158058 observations read from the data set WORK.ALL_
FILES.
WARNING: The data set WORK.ALL_FILES may be incomplete. When this step was
stopped there
were 197158058 observations and 16 variables.
WARNING: Data set WORK.ALL_FILES was not replaced because this step was
stopped.
NOTE: DATA statement used (Total process time):
real time 2:20.84
cpu time 27.66 seconds
ERROR: System is Terminating Due to Hang Up Signal (SIGHUP)
SYMBOLGEN: Macro variable FILE resolves to 1
NOTE: There were 34999999 observations read from the data set WORK.CARTEMP.
5 The SAS System 11:36 Tuesday,
December 22, 2015
NOTE: The data set WORK.CARTEMP has 34999999 observations and 16 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 13.98 seconds
cpu time 16.90 seconds
ERROR: User asked for termination
NOTE: The SAS System stopped processing this step because of errors.
NOTE: SAS set option OBS=0 and will continue to check statements.
This might cause NOTE: No observations in data set.
NOTE: There were 8571784 observations read from the data set WORK.CARTEMP.
WARNING: The data set WORK.ALL_FILES may be incomplete. When this step was
stopped there
were 8571784 observations and 16 variables.
NOTE: DATA statement used (Total process time):
real time 8.19 seconds
cpu time 1.10 seconds
NOTE: PROCEDURE PRINTTO used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
26
27 *-----------------------------------------------------;
28 %macro process(year,yr,file,first,numobs);
29
30 data cartemp;
31 set loc.carl&year.
32 (firstobs=&first. obs=&numobs.
33 keep=expnsdt1 hcpcs_cd bene_id lalowchg lprvpmt linepmt mdfr
_cd1 mdfr_cd2
33 ! betos plcsrvc
34 prf_npi prf_upin);
35
36 snf = (plcsrvc in ('31', '32', '33'));
37 hha = (plcsrvc in ('12'));
38 inpt = (plcsrvc in ('21'));
39 hspc = (plcsrvc in ('34'));
40
41 run;
42
43
44 proc sort data=cartemp;
45 by bene_id;
46
47 *append datasets;
48
49 %if &file.=1 %then %do;
50 data all_files;
51 set cartemp;
52 %end;
53 %else %do;
54 data all_files;
55 set all_files cartemp;
56 %end;
57 run;
58
59
60 %mend process;
61
62
63
64 *-----------------------------------------------------;
3 The SAS System 11:37 Tuesday,
December 22, 2015
65 %macro readin0611(year,yr,numfiles);
66 libname loc "&dataloc./&year.";
67
68
69 %process(&year. , &yr. , 1 , 1 , 34999999);
70 %process(&year. , &yr. , 2 , 35000000 , 69999999);
71 /*
72 %process(&year. , &yr. , 3 , 70000000 , 104999999);
73 %process(&year. , &yr. , 4 , 105000000 , 139999999);
74 %process(&year. , &yr. , 5 , 140000000 , 174999999);
75 %process(&year. , &yr. , 6 , 175000000 , 209999999);
76 %process(&year. , &yr. , 7 , 210000000 , 244999999);
77 %process(&year. , &yr. , 8 , 245000000 , 279999999);
78 %process(&year. , &yr. , 9 , 280000000 , 314999999);
79 %process(&year. , &yr. , 10, 315000000 , MAX);
80 */
81
82 data bworkhos.carclaimlist&year.;
83 set all_files;
84 run;
85
86 *date_new = input(expnsdt1, date9.);
87 input expnsdt1 date9.;
88 put expnsdt1;
89 run;
90
91
92
93 proc contents data=bworkhos.carclaimlist&year.;
94 title "&year.";
95 proc print data=bworkhos.carclaimlist&year. (obs=150);
96 title "&year.";
97 run;
98
99 data bworkhos.finderfile;
100 set bworkhos.car&year. (keep=bene_id indexdat);
101 indexdate=indexdat;
102 proc sort data=bworkhos.finderfile;
103 by bene_id;
104 run;
105
106 data bworkhos.carclaimlist&year.;
107 merge bworkhos.carclaimlist&year. (in=in1)
108 bworkhos.finderfile (in=in2);
109 by bene_id;
110 run;
111
112
113 days=datdif(expnsdt1,indexdate,'act/act');
114
115
116
117 if in1 and in2;
118
119 if days>=-365 and days<=365;
120
121 * if (date_new-indexdate)>=-365 and (date_new-indexdate)<=365;
122
4 The SAS System 11:37 Tuesday,
December 22, 2015
123 * if (expnsdt1-indexdate)>=-365 and (expnsdt1-indexdate)<=365;
124
125 ***Reconciling npi upin using crosswalk;
126 libname benexw "/disk/agebulk5/medicare.work/lbaker-DUA23466/
lbaker/data/xw";
127 data bworkhos.npixwalk (keep=prf_npi xw_upin);
128 set benexw.npi_upin_xw_final;
129
130 prf_npi=npi;
131 xw_upin=upin;
132
133 proc sort data=bworkhos.npixwalk;
134 by prf_npi;
135
136
137 proc sort data=bworkhos.carclaimlist&year.;
138 by prf_npi;
139
140
141 data bworkhos.carclaimlist&year. (drop=xw_upin); *taxnumhhibase;
142 merge bworkhos.carclaimlist&year. (in=in1)
143 bworkhos.npixwalk;
144 by prf_npi;
145 if in1;
146
147 length prf_physid $10;
148 prf_physid="none";
149 if prf_upin ne "" and prf_upin ne "none" then prf_physid=prf
_upin;
150 else if xw_upin ne "" then prf_physid=xw_upin;
151 else prf_physid=prf_npi;
152
153
154 %mend readin0611;
155 *-----------------------------------------------------;
156
157
158
159 %readin0611(2006,06,1);
SYMBOLGEN: Macro variable DATALOC resolves to /disk/agedisk1/medicare/data/
20pct/car
SYMBOLGEN: Macro variable YEAR res
【在 m*********6 的大作中提到】![](/moin_static193/solenoid/img/up.png) : cartemp没有被创建,要么没找到loc.carl&year.,要么data step里语句有问题。上个 : 完整的log吧,前面的cartemp和all_files为空,后面的dataset必须为空啊。现在显示 : 的log看不出来data cartemp那步发生了什么
| G********L 发帖数: 12 | 8 82 data bworkhos.carclaimlist&year.;
83 set all_files;
84 run;
85
86 *date_new = input(expnsdt1, date9.);
87 input expnsdt1 date9.;
88 put expnsdt1;
89 run;
其他的不知道,这几行肯定有问题。data step在84行的run之后就结束了。我猜你需要
把87-89行也像86行一样comment out才行。需要用date9 format的话,在83行后面加上
format expnsdt1 date9.;就可以了。 | t*****a 发帖数: 459 | 9 SAS的问题最好解决了,直接联系客服,让他们给你debug,他们能直接把改好的code寄
给你。 | m*********6 发帖数: 482 | 10 到line82为止的code都跑完了,把line 84-87要做的转换放data step里试下? | l**********8 发帖数: 305 | |
|