Desktop productivity for business analysts and programmers

Getting a syntax error, not sure why....

Reply
Frequent Contributor
Posts: 135

Getting a syntax error, not sure why....

1 ;*';*";*/;quit;run;

2 OPTIONS PAGENO=MIN;

3 %LET _CLIENTTASKLABEL='NCT1801';

4 %LET _CLIENTPROCESSFLOWNAME='Process Flow';

5 %LET _CLIENTPROJECTPATH='';

6 %LET _CLIENTPROJECTNAME='';

7 %LET _SASPROGRAMFILE=;

8

9 ODS _ALL_ CLOSE;

10 OPTIONS DEV=ACTIVEX;

11 GOPTIONS XPIXELS=0 YPIXELS=0;

12 FILENAME EGSR TEMP;

13 ODS tagsets.sasreport13(ID=EGSR) FILE=EGSR

14 STYLE=HtmlBlue

15 STYLESHEET=(URL="file:///C:/Program%20Files/SASHome/SASEnterpriseGuide/7.1/Styles/HtmlBlue.css")

16 NOGTITLE

17 NOGFOOTNOTE

18 GPATH=&sasworklocation

19 ENCODING=UTF8

20 options(rolap="on")

21 ;

NOTE: Writing TAGSETS.SASREPORT13(EGSR) Body file: EGSR

22

23 GOPTIONS ACCESSIBLE;

24

25 %GLOBAL FileNameUserID;

26 %GLOBAL FileNameDate;

27 %GLOBAL FileNameEmail;

28

29 %LET FileNameUserID =fs115055;

30 %LET FileNameDate = 201801;

31 %LET FileNameEmail = NCTTRIANGLE;

32

33 %LET TEST = &cOrgNameDataAnalytics./users/&FileNameUserID./&FileNameDate.;

34 %LET NAME = NCTTRI;

35

36 %PUT &TEST;

/opt/t7iw/sasdata/users/fs115055/201801

37

38 LIBNAME &NAME "&cOrgNameDataAnalytics./users/&FileNameUserID./&FileNameDate.";

NOTE: Libref NCTTRI was successfully assigned as follows:

Engine: V9

Physical Name: /opt/t7iw/sasdata/users/fs115055/201801

40

41 %LET DATE1 = '2018-01-01' ; *- CURRENT MONTH SETTLEMENT FROM DT -*;

42 %LET DATE3 = '2018-01-31' ; *- CURRENT MONTH SETTLEMENT THRU DT -*;

43 proc sql ;

44 CONNECT TO Teradata as tera (authdomain="T2017_IW_Prod" TDPID="edwfsp.fs.centene.com");

45 CREATE TABLE &NAME..NT01 AS

46 SELECT * FROM CONNECTION TO tera

47 (SELECT

48 CLM_LINE_ID AS CLMLN,

49 MCS_AT_RISK AS RISKIND,

50 DLT_SRVCS_NBR AS DLTSVCS,

51 DLT_PYMT_AMT AS DLTPAID,

52 DLT_ALOWD_CHRG_AMT AS DLTALLW,

53 TMA_PRCDR_CD AS TMAPROC,

54 TMA_ENRLMT_HLTH_CD AS TMAENRCD,

2 The SAS System 11:06 Thursday, February 8, 2018

55 LTRIM(REV_CODE) AS REVCD,

56 HOSP_PROF_SERV AS HOSOPSVC,

57 TMA_TYP_SRVC_CD AS LTMATOS,

58 PRVDR_TXMY_CD AS PROVTXMY,

59 CLM_BGN_SRVC_DT AS LBEGDT,

60 CLM_END_SRVC_DT AS LENDDT,

61 SAL_RES_SHARE AS SALARYRS,

62 PLAN_CVRG_OPTN_CD AS PLNCVOPT,

63 CLM_BASE_ID AS CLMNBR,

64 CHAP_CLM_SUB_NO AS SUBNBR,

65 CLM_ADJ_ID AS CLMADJ,

66 CLM_TRANS_TYP AS TRANSTYP,

67 BILL_STATUS_CD AS BILLSTAT,

68 CLM_BGN_SRVC_DT AS HBEGDT,

69 CLM_END_SRVC_DT AS HENDDT,

70 SPON_STATUS AS SPSTAT,

71 DEERS_SPON_STATUS AS DEERSSPSTAT,

72 PATNT_SEX_REL_CODE AS PTSXREL,

73 PATNT_RLTNSHP_CD AS PTRELCD,

74 SETTLE_CUTOFF_DATE AS DTPROC,

75 ALLOWED_CHRG AS HALLOW,

76 PATNT_ZIP_CODE AS BENEZIP,

77 T3_CNTRCT_IND AS T3IND

78

79 FROM NINST_CLM_LN LN

80 INNER JOIN

81 NINST_CLM_HDR HD

82 ON CLM_BASE_ID = CLM_BASE_ID AND

83 CHAP_CLM_SUB_NO = CHAP_CLM_SUB_NO AND

84 CLM_ADJ_ID = CLM_ADJ_ID AND

85 CLM_TRANS_TYP = CLM_TRANS_TYP

86

87 WHERE SETTLE_CUTOFF_DATE BETWEEN &DATE1 AND &DATE3

88 );

ERROR: Teradata prepare: Syntax error: expected something between the word 'NINST_CLM_LN' and the 'LN' keyword. SQL statement was:

SELECT CLM_LINE_ID AS CLMLN, MCS_AT_RISK AS RISKIND, DLT_SRVCS_NBR AS DLTSVCS, DLT_PYMT_AMT AS DLTPAID, DLT_ALOWD_CHRG_AMT

AS DLTALLW, TMA_PRCDR_CD AS TMAPROC, TMA_ENRLMT_HLTH_CD AS TMAENRCD, LTRIM(REV_CODE) AS REVCD, HOSP_PROF_SERV AS HOSOPSVC,

TMA_TYP_SRVC_CD AS LTMATOS, PRVDR_TXMY_CD AS PROVTXMY, CLM_BGN_SRVC_DT AS LBEGDT, CLM_END_SRVC_DT AS LENDDT, SAL_RES_SHARE

AS SALARYRS, PLAN_CVRG_OPTN_CD AS PLNCVOPT, CLM_BASE_ID AS CLMNBR, CHAP_CLM_SUB_NO AS SUBNBR, CLM_ADJ_ID AS CLMADJ,

CLM_TRANS_TYP AS TRANSTYP, BILL_STATUS_CD AS BILLSTAT, CLM_BGN_SRVC_DT AS HBEGDT, CLM_END_SRVC_DT AS HENDDT, SPON_STATUS AS

SPSTAT, DEERS_SPON_STATUS AS DEERSSPSTAT, PATNT_SEX_REL_CODE AS PTSXREL, PATNT_RLTNSHP_CD AS PTRELCD, SETTLE_CUTOFF_DATE AS

DTPROC, ALLOWED_CHRG AS HALLOW, PATNT_ZIP_CODE AS BENEZIP, T3_CNTRCT_IND AS T3IND FROM NINST_CLM_LN LN INNER JOIN

NINST_CLM_HDR HD ON CLM_BASE_ID = CLM_BASE_ID AND CHAP_CLM_SUB_NO = CHAP_CLM_SUB_NO AND CLM_ADJ_ID = CLM_ADJ_ID AND

CLM_TRANS_TYP = CLM_TRANS_TYP WHERE SETTLE_CUTOFF_DATE BETWEEN '2018-01-01' AND '2018-01-31'.

NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements.

89

90 %PUT &SQLXMSG &SQLXRC;

Syntax error: expected something between the word 'NINST_CLM_LN' and the 'LN' keyword 3706

91

NOTE: The SAS System stopped processing this step because of errors.

NOTE: PROCEDURE SQL used (Total process time):

real time 0.08 seconds

cpu time 0.02 seconds

 

92 PROC PRINT DATA =NT01.DATA (OBS=10);

ERROR: Libref NT01 is not assigned.

93 TITLE1 "10 OBS FROM FACT003.A082633.NT01.NCT1801.SASS";

3 The SAS System 11:06 Thursday, February 8, 2018

94 TITLE2 "ALL ADJ FOR SETTLEMENT DATES: &DATE1 - &DATE3";

95 TITLE3 "FACT003.ROUTINE.T3-OP8(NCT1801) - JS010";

96 RUN;

NOTE: The SAS System stopped processing this step because of errors.

NOTE: PROCEDURE PRINT used (Total process time):

real time 0.00 seconds

cpu time 0.00 seconds

 

97

98

99 *- FACT003.ROUTINE.T3-OP8(NCT1801) - JS020 -*;

100

101 %LET DATE1 = '2018-01-01' ; *- CURRENT MONTH SETTLEMENT FROM DT -*;

102 %LET DATE3 = '2018-01-31' ; *- CURRENT MONTH SETTLEMENT THRU DT -*;

103

 

104 proc sql ;

105 CONNECT TO Teradata as tera (authdomain="T2017_IW_Prod" TDPID="edwfsp.fs.centene.com");

106 CREATE TABLE &NAME..NT02 AS

107 SELECT * FROM CONNECTION TO tera

108 (SELECT

109 CLM_LINE_ID AS CLMLN ,

110 MCS_AT_RISK AS RISKIND,

111 DLT_SRVCS_NBR AS DLTSVCS,

112 DLT_PYMT_AMT AS DLTPAID,

113 DLT_ALOWD_CHRG_AMT AS DLTALLW,

114 TMA_PRCDR_CD AS TMAPROC,

115 TMA_ENRLMT_HLTH_CD AS TMAENRCD,

116 LTRIM(REV_CODE) AS REVCD,

117 HOSP_PROF_SERV AS HOSOPSVC,

118 TMA_TYP_SRVC_CD AS LTMATOS,

119 PRVDR_TXMY_CD AS PROVTXMY,

120 CLM_BGN_SRVC_DT AS LBEGDT,

121 CLM_END_SRVC_DT AS LENDDT,

122 SAL_RES_SHARE AS SALARYRS,

123 PLAN_CVRG_OPTN_CD AS PLNCVOPT,

124 CLM_BASE_ID AS CLMNBR,

125 CHAP_CLM_SUB_NO AS SUBNBR,

126 CLM_ADJ_ID AS CLMADJ,

127 CLM_TRANS_TYP AS TRANSTYP,

128 BILL_STATUS_CD AS BILLSTAT,

129 CLM_BGN_SRVC_DT AS HBEGDT,

130 CLM_END_SRVC_DT AS HENDDT,

131 SPON_STATUS AS SPSTAT,

132 DEERS_SPON_STATUS AS DEERSSPSTAT,

133 PATNT_SEX_REL_CODE AS PTSXREL,

134 PATNT_RLTNSHP_CD AS PTRELCD,

135 SETTLE_CUTOFF_DATE AS DTPROC,

136 SUPP_COV_DAYS AS SUPPCVDY,

137 DRG_LOS AS DRGLOS,

138 ADMIT_SRVC_DT AS ADMITDT,

139 DISCHG_LVIS_DT AS DISCHDT,

140 ALLOWED_CHRG AS HALLOW,

141 PATNT_ZIP_CODE AS BENEZIP,

142 T3_CNTRCT_IND AS T3IND

143

4 The SAS System 11:06 Thursday, February 8, 2018

144 FROM INST_CLM_LN LN

145 INNER JOIN

146 INST_CLM_HDR HD

147

148 ON CLM_BASE_ID = CLM_BASE_ID AND

149 CHAP_CLM_SUB_NO = CHAP_CLM_SUB_NO AND

150 CLM_ADJ_ID = CLM_ADJ_ID AND

151 CLM_TRANS_TYP = CLM_TRANS_TYP

152

153 WHERE SETTLE_CUTOFF_DATE BETWEEN &DATE1 AND &DATE3

154 );

ERROR: Teradata prepare: Syntax error: expected something between the word 'INST_CLM_LN' and the 'LN' keyword. SQL statement was:

SELECT CLM_LINE_ID AS CLMLN , MCS_AT_RISK AS RISKIND, DLT_SRVCS_NBR AS DLTSVCS, DLT_PYMT_AMT AS DLTPAID, DLT_ALOWD_CHRG_AMT

AS DLTALLW, TMA_PRCDR_CD AS TMAPROC, TMA_ENRLMT_HLTH_CD AS TMAENRCD, LTRIM(REV_CODE) AS REVCD, HOSP_PROF_SERV AS HOSOPSVC,

TMA_TYP_SRVC_CD AS LTMATOS, PRVDR_TXMY_CD AS PROVTXMY, CLM_BGN_SRVC_DT AS LBEGDT, CLM_END_SRVC_DT AS LENDDT, SAL_RES_SHARE

AS SALARYRS, PLAN_CVRG_OPTN_CD AS PLNCVOPT, CLM_BASE_ID AS CLMNBR, CHAP_CLM_SUB_NO AS SUBNBR, CLM_ADJ_ID AS CLMADJ,

CLM_TRANS_TYP AS TRANSTYP, BILL_STATUS_CD AS BILLSTAT, CLM_BGN_SRVC_DT AS HBEGDT, CLM_END_SRVC_DT AS HENDDT, SPON_STATUS AS

SPSTAT, DEERS_SPON_STATUS AS DEERSSPSTAT, PATNT_SEX_REL_CODE AS PTSXREL, PATNT_RLTNSHP_CD AS PTRELCD, SETTLE_CUTOFF_DATE AS

DTPROC, SUPP_COV_DAYS AS SUPPCVDY, DRG_LOS AS DRGLOS, ADMIT_SRVC_DT AS ADMITDT, DISCHG_LVIS_DT AS DISCHDT, ALLOWED_CHRG AS

HALLOW, PATNT_ZIP_CODE AS BENEZIP, T3_CNTRCT_IND AS T3IND FROM INST_CLM_LN LN INNER JOIN INST_CLM_HDR HD ON CLM_BASE_ID =

CLM_BASE_ID AND CHAP_CLM_SUB_NO = CHAP_CLM_SUB_NO AND CLM_ADJ_ID = CLM_ADJ_ID AND CLM_TRANS_TYP = CLM_TRANS_TYP WHERE

SETTLE_CUTOFF_DATE BETWEEN '2018-01-01' AND '2018-01-31'.

NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements.

155

156 %PUT &SQLXMSG &SQLXRC;

Syntax error: expected something between the word 'INST_CLM_LN' and the 'LN' keyword 3706

157

NOTE: The SAS System stopped processing this step because of errors.

NOTE: PROCEDURE SQL used (Total process time):

real time 0.12 seconds

cpu time 0.01 seconds

 

158 PROC PRINT DATA =NT02.DATA (OBS=10);

ERROR: Libref NT02 is not assigned.

159 TITLE1 "10 OBS FROM FACT003.A082633.NT02.NCT1801.SASS";

160 TITLE2 "ALL ADJ FOR SETTLEMENT DATES: &DATE1 - &DATE3";

161 TITLE3 "FACT003.ROUTINE.T3-OP8(NCT1801) - JS020";

162 RUN;

NOTE: The SAS System stopped processing this step because of errors.

NOTE: PROCEDURE PRINT used (Total process time):

real time 0.00 seconds

cpu time 0.01 seconds

 

163

164

165 *- FACT003.ROUTINE.T3-OP8(NCT1801) - JS030 -*;

166

167 %LET DATE1 = 01APR2011 ; *- SETTLEMENT FROM DATE OP2 -*;

168 %LET DATE3 = 31JAN2018 ; *- SETTLEMENT THRU DATE -*;

169

170 *- PUT FILES TOGETHER AND SET VARIABLES -*;

171

 

172 DATA &NAME..NT03;

173 LENGTH CONTRACT $4. TYPE $19. STATUSC $5.;

5 The SAS System 11:06 Thursday, February 8, 2018

174 SET NT01.DATA NT02.DATA;

ERROR: Libref NT01 is not assigned.

ERROR: Libref NT02 is not assigned.

175

176 IF HOSOPSVC='1' AND ("01JAN1960"D LE DISCHDT LE "&DATE3"D)

177 AND DISCHDT LE DTPROC

178 THEN DOD=DISCHDT;

179 ELSE

180 IF HOSOPSVC='1' THEN DOD=LENDDT;

181 ELSE

182 DOD=LBEGDT;

183

184 IF HOSOPSVC='1' THEN DOS=ADMITDT;

185 ELSE

186 DOS=LBEGDT;

187

188 IF SUBSTR(LTMATOS,1,1) IN ('I' 'M') THEN IPOP = 'IP';

189 ELSE

190 IPOP = 'OP';

191

192 IF TMAENRCD = 'U' THEN TYPE = 'CIVILIAN ENROLLED'; /*SPLIT MTF PRIME FROM NONPRIME FOR T2017*/

193 ELSE IF TMAENRCD = 'Z' THEN TYPE = 'MTF PRIME';

194 ELSE TMAENRCD = 'NON-PRIME';

195

196 IF T3IND = 'T3' THEN CONTRACT = 'T3';

197 ELSE

198 CONTRACT = 'TNEX';

199

200 IF SPSTAT = '1' AND PTSXREL IN ('1' '2') THEN STATUSC = 'ADSM';

201 ELSE

202 IF SPSTAT = '1' THEN STATUSC = 'ADFM';

203 ELSE

204 IF SPSTAT IN ('2' '3') THEN STATUSC = 'NADFM';

205 ELSE

206 STATUSC = SPSTAT!!PTSXREL;

207

208 IF DEERSSPSTAT IN ('A' 'G' 'J' 'N' 'S' 'T' 'V' 'Y') AND

209 PTRELCD = 'A' THEN STATUSD = '4';

210 ELSE

211 IF DEERSSPSTAT IN ('A' 'G' 'J' 'N' 'S' 'T' 'V' 'Y')

212 THEN STATUSD = '1';

213 ELSE

214 IF DEERSSPSTAT IN ('D' 'F' 'Q' 'R') AND

215 PTRELCD = 'A' THEN STATUSD = '2';

216 ELSE

217 IF DEERSSPSTAT IN ('D' 'F' 'Q' 'R')

218 THEN STATUSD = '3';

219 ELSE

220 IF DEERSSPSTAT IN ('1' 'B' 'C' 'E' 'H'

221 'I' 'K' 'L' 'M' 'O' 'P' 'U' 'Z'

222 'W' '') /* ADDED W & BLANK PER DARIA */

223 THEN STATUSD = '3';

224 ELSE

225 STATUSD = DEERSSPSTAT;

226

227 MOS = PUT(DOS,YYMMD7.);

228 MOD = PUT(DOD,YYMMD7.);

229 MOP = PUT(DTPROC,YYMMD7.);

6 The SAS System 11:06 Thursday, February 8, 2018

230

231 RUN;

NOTE: Numeric values have been converted to character values at the places given by: (Line)Smiley SadColumn).

188:19

NOTE: The SAS System stopped processing this step because of errors.

WARNING: The data set NCTTRI.NT03 may be incomplete. When this step was stopped there were 0 observations and 23 variables.

WARNING: Data set NCTTRI.NT03 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

 

232

233 *-REMOVED TNEX CLAIMS PER DAN 07/24/2013-*;

234 *-TRIANGLE SHOULD START ON 04/11-*;

235

236 DATA &NAME..NT04;

237 SET NT03.DATA NT04PRV.DATA;

ERROR: Libref NT03 is not assigned.

ERROR: Libref NT04PRV is not assigned.

238 WHERE CONTRACT = 'T3';

239 RUN;

NOTE: The SAS System stopped processing this step because of errors.

WARNING: The data set NCTTRI.NT04 may be incomplete. When this step was stopped there were 0 observations and 0 variables.

WARNING: Data set NCTTRI.NT04 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

 

240

241 PROC PRINT DATA =NT04.DATA (OBS=10);

ERROR: Libref NT04 is not assigned.

242 TITLE1 "10 OBS FROM FACT003.A082633.NT04.NCT1801.SASS";

243 TITLE2 "ALL ADJ FOR DOS: &DATE1 - &DATE3";

244 TITLE3 "SETTLED THROUGH &DATE3";

245 TITLE4 "FACT003.ROUTINE.T3-OP8(NCT1712) - JS030";

246 RUN;

NOTE: The SAS System stopped processing this step because of errors.

NOTE: PROCEDURE PRINT used (Total process time):

real time 0.00 seconds

cpu time 0.00 seconds

 

248 *- FACT003.ROUTINE.T3-OP8(NCT1801) - JS034 -*;

249

250 *- NEED TO SPLIT FILE TO GET THE SORT TO RUN -*;

251

 

252 DATA &NAME..NT05A &NAME..NT05B &NAME..NT05C;

253 SET NT04.DATA;

ERROR: Libref NT04 is not assigned.

254

255 IF '2011-04' LE MOS LE '2013-03' THEN OUTPUT NT05A.DATA;

__________

7 The SAS System 11:06 Thursday, February 8, 2018

455

ERROR 455-185: Data set was not specified on the DATA statement.

256 ELSE

257 IF '2013-04' LE MOS LE '2015-09' THEN OUTPUT NT05B.DATA;

__________

455

ERROR 455-185: Data set was not specified on the DATA statement.

258 ELSE

259 OUTPUT NT05C.DATA;

__________

455

ERROR 455-185: Data set was not specified on the DATA statement.

260 RUN;

NOTE: The SAS System stopped processing this step because of errors.

WARNING: The data set NCTTRI.NT05A may be incomplete. When this step was stopped there were 0 observations and 1 variables.

WARNING: Data set NCTTRI.NT05A was not replaced because this step was stopped.

WARNING: The data set NCTTRI.NT05B may be incomplete. When this step was stopped there were 0 observations and 1 variables.

WARNING: Data set NCTTRI.NT05B was not replaced because this step was stopped.

WARNING: The data set NCTTRI.NT05C may be incomplete. When this step was stopped there were 0 observations and 1 variables.

WARNING: Data set NCTTRI.NT05C 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

 

261

262 PROC SORT DATA= NT05A.DATA OUT= NT05D.DATA;

ERROR: Libref NT05A is not assigned.

ERROR: Libref NT05D is not assigned.

263 BY CLMNBR CLMLN CLMADJ;

264 RUN;

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

 

265

266

267 *- FACT003.ROUTINE.T3-OP8(NCT1801) - JS035 -*;

268

 

269 PROC SORT DATA= NT05B.DATA OUT= NT05E.DATA;

ERROR: Libref NT05B is not assigned.

ERROR: Libref NT05E is not assigned.

270 BY CLMNBR CLMLN CLMADJ;

271 RUN;

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

 

8 The SAS System 11:06 Thursday, February 8, 2018

272

273

274 *- FACT003.ROUTINE.T3-OP8(NCT1801) - JS036 -*;

275

 

276 PROC SORT DATA= NT05C.DATA OUT= NT05F.DATA;

ERROR: Libref NT05C is not assigned.

ERROR: Libref NT05F is not assigned.

277 BY CLMNBR CLMLN CLMADJ;

278 RUN;

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

 

279

280

281 *- FACT003.ROUTINE.T3-OP8(NCT1801) - JS037 -*;

282

 

283 DATA &NAME..NT05G.DATA;

NOTE: Line generated by the macro variable "NAME".

283 NCTTRI

______

211

ERROR 211-185: Invalid data set name.

284 LENGTH IPOP1 $2. TYPE1 $19. STATUSC1 $5.;

285 SET NT05D.DATA;

ERROR: Libref NT05D is not assigned.

286 BY CLMNBR CLMLN CLMADJ;

287

288 RETAIN IPOP1 TYPE1 STATUSC1 STATUSD1;

289

290 IF FIRST.CLMLN THEN DO;

291 IPOP1 = IPOP;

292 TYPE1 = TYPE;

293 STATUSC1 = STATUSC;

294 STATUSD1 = STATUSD;

295 END;

296 RUN;

NOTE: The SAS System stopped processing this step because of errors.

NOTE: DATA statement used (Total process time):

real time 0.00 seconds

cpu time 0.00 seconds

 

297

298 DATA &NAME..NT05H.DATA;

NOTE: Line generated by the macro variable "NAME".

298 NCTTRI

______

211

ERROR 211-185: Invalid data set name.

9 The SAS System 11:06 Thursday, February 8, 2018

 

299 LENGTH IPOP1 $2. TYPE1 $19. STATUSC1 $5.;

300 SET NT05E.DATA;

ERROR: Libref NT05E is not assigned.

301 BY CLMNBR CLMLN CLMADJ;

302

303 RETAIN IPOP1 TYPE1 STATUSC1 STATUSD1;

304

305 IF FIRST.CLMLN THEN DO;

306 IPOP1 = IPOP;

307 TYPE1 = TYPE;

308 STATUSC1 = STATUSC;

309 STATUSD1 = STATUSD;

310 END;

311 RUN;

NOTE: The SAS System stopped processing this step because of errors.

NOTE: DATA statement used (Total process time):

real time 0.00 seconds

cpu time 0.00 seconds

 

312

313 DATA &NAME..NT05I.DATA;

NOTE: Line generated by the macro variable "NAME".

313 NCTTRI

______

211

ERROR 211-185: Invalid data set name.

314 LENGTH IPOP1 $2. TYPE1 $19. STATUSC1 $5.;

315 SET NT05F.DATA;

ERROR: Libref NT05F is not assigned.

316 BY CLMNBR CLMLN CLMADJ;

317

318 RETAIN IPOP1 TYPE1 STATUSC1 STATUSD1;

319

320 IF FIRST.CLMLN THEN DO;

321 IPOP1 = IPOP;

322 TYPE1 = TYPE;

323 STATUSC1 = STATUSC;

324 STATUSD1 = STATUSD;

325 END;

326 RUN;

NOTE: The SAS System stopped processing this step because of errors.

NOTE: DATA statement used (Total process time):

real time 0.00 seconds

cpu time 0.00 seconds

 

327

328

329

330 *- FACT003.ROUTINE.T3-OP8(NCT1801) - JS038 -*;

331

332 PROC SORT DATA= NT05G.DATA OUT= NT05J.DATA;

ERROR: Libref NT05G is not assigned.

10 The SAS System 11:06 Thursday, February 8, 2018

ERROR: Libref NT05J is not assigned.

333 BY CLMNBR CLMLN CLMADJ;

334 RUN;

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

 

335

 

336 PROC SORT DATA= NT05H.DATA OUT= NT05K.DATA;

ERROR: Libref NT05H is not assigned.

ERROR: Libref NT05K is not assigned.

337 BY CLMNBR CLMLN CLMADJ;

338 RUN;

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

 

339

 

340 PROC SORT DATA= NT05I.DATA OUT= NT05L.DATA;

ERROR: Libref NT05I is not assigned.

ERROR: Libref NT05L is not assigned.

341 BY CLMNBR CLMLN CLMADJ;

342 RUN;

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

 

343

344

345 *- FACT003.ROUTINE.T3-OP8(NCT1801) - JS039 -*;

346

 

347 DATA &NAME..NT05.DATA;

NOTE: Line generated by the macro variable "NAME".

347 NCTTRI

______

211

ERROR 211-185: Invalid data set name.

348 SET NT05J.DATA NT05K.DATA NT05L.DATA;

ERROR: Libref NT05J is not assigned.

ERROR: Libref NT05K is not assigned.

ERROR: Libref NT05L is not assigned.

349 BY CLMNBR CLMLN CLMADJ;

350

351 DROP IPOP TYPE STATUSC STATUSD;

352 RUN;

11 The SAS System 11:06 Thursday, February 8, 2018

 

NOTE: The SAS System stopped processing this step because of errors.

NOTE: DATA statement used (Total process time):

real time 0.00 seconds

cpu time 0.00 seconds

 

353

354 PROC PRINT DATA =NT05.DATA (OBS=10);

ERROR: Libref NT05 is not assigned.

355 TITLE1 "10 OBS FROM FACT003.A082633.NT05.NCT1801.SASS";

356 TITLE2 "FACT003.ROUTINE.T3-OP8(NCT1801) - JS039";

357 RUN;

NOTE: The SAS System stopped processing this step because of errors.

NOTE: PROCEDURE PRINT used (Total process time):

real time 0.00 seconds

cpu time 0.00 seconds

 

358

359 *- DO SOME FREQS -*;

360

 

361 PROC FREQ DATA=NT05.DATA;

ERROR: Libref NT05 is not assigned.

362 TABLES STATUSC1*STATUSD1 LTMATOS / MISSING;

ERROR: No data set open to look up variables.

ERROR: No data set open to look up variables.

ERROR: No data set open to look up variables.

363 TITLE1 "FROM FACT003.A082633.NT05.NCT1801.SASS";

364 RUN;

NOTE: The SAS System stopped processing this step because of errors.

NOTE: PROCEDURE FREQ used (Total process time):

real time 0.00 seconds

cpu time 0.00 seconds

 

365

366

367 *- FACT003.ROUTINE.T3-OP8(NCT1801) - JS040 -*;

368

369 *- USE ALLOWED OBSERVATIONS FOR VISIT COUNTS BECAUSE -*;

370 *- NUMBER OF SERVICES VARIABLE DOESNT WORK FOR ADJUSTMENTS -*;

371

372 *- USE MOST RECENT ADJUSTMENT FOR ADMIT COUNTS BECAUSE -*;

373 *- TEDS USE MOST CURRENT ADJUSTMENT -*;

374

375 *--------------------------*;

376 *- VISIT COUNT DERIVATION -*;

377 *--------------------------*;

378

379 *- KEEP UNDERWRITTEN LINES WHERE DELTA ALLOWED IS > $0 -*;

380

 

381 DATA &NAME..NT06.DATA;

NOTE: Line generated by the macro variable "NAME".

12 The SAS System 11:06 Thursday, February 8, 2018

381 NCTTRI

______

211

ERROR 211-185: Invalid data set name.

382 SET NT05.DATA;

ERROR: Libref NT05 is not assigned.

383

384 WHERE RISKIND = 'Y' AND DLTALLW > 0;

385

386 VSTCNT = 0;

387

388 *- CALCULATE VISIT COUNT FOR ALLOWED LINES -*;

389

390 IF HOSOPSVC = '1' THEN DELETE;

391 ELSE

392 DO;

393 IF SUBSTR(LTMATOS,2,1) IN ('G' 'B' 'M') THEN VSTCNT = 0;

394 ELSE

395 IF ('90000' LE TMAPROC LE '90580' OR

396 '90594' LE TMAPROC LE '90595' OR

397 '90599' LE TMAPROC LE '92871' OR

398 '92898' LE TMAPROC LE '94999' OR

399 '95200' LE TMAPROC LE '97799' OR

400 '98900' LE TMAPROC LE '98922' OR

401 '99150' LE TMAPROC LE '99152' OR

402 '99155' LE TMAPROC LE '99195' OR

403 '99201' LE TMAPROC LE '99539' OR

404 '99551' LE TMAPROC LE '99601' OR

405 TMAPROC IN ('90590' '97810' '97813') )

406 THEN DO;

407 IF DLTSVCS > 99 THEN VSTCNT = 99;

408 ELSE

409 VSTCNT = DLTSVCS;

410 END;

411 ELSE

412 IF '95000' LE TMAPROC LE '95199' THEN VSTCNT = 1;

413 ELSE

414 VSTCNT = 0;

415 OUTPUT NT06.DATA;

_________

455

ERROR 455-185: Data set was not specified on the DATA statement.

416 END;

417

418 KEEP CONTRACT IPOP1 TYPE1 MOS MOP VSTCNT STATUSD1 STATUSC1

419 BENEZIP HBEGDT;

420 RUN;

NOTE: Numeric values have been converted to character values at the places given by: (Line)Smiley SadColumn).

393:19

NOTE: The SAS System stopped processing this step because of errors.

NOTE: DATA statement used (Total process time):

real time 0.00 seconds

cpu time 0.00 seconds

 

13 The SAS System 11:06 Thursday, February 8, 2018

421

422 *--------------------------*;

423 *- ADMIT COUNT DERIVATION -*;

424 *--------------------------*;

425

426 *- DETERMINE WHICH LINES ARE UNDERWRITTEN & ALLOWED -*;

427 *- AT MOST RECENT ADJUSTMENT TO GET ADMIT COUNTS -*;

428 *- KEEP ONLY INPATIENT FACILITY CLAIMS TOO -*;

429

430 DATA &NAME..NT07.DATA;

NOTE: Line generated by the macro variable "NAME".

430 NCTTRI

______

211

ERROR 211-185: Invalid data set name.

431 SET NT05.DATA;

ERROR: Libref NT05 is not assigned.

432 BY CLMNBR CLMLN CLMADJ;

433

434 IF FIRST.CLMLN AND

435 HALLOW GT 0 AND

436 RISKIND='Y' AND

437 HOSOPSVC = '1' AND

438 IPOP1 = 'IP';

439

440 VSTCNT = 0;

441 ADMTCNT = 0;

442

443 RUN;

NOTE: The SAS System stopped processing this step because of errors.

NOTE: DATA statement used (Total process time):

real time 0.00 seconds

cpu time 0.00 seconds

 

444

445 *- IDENTIFY CLAIMS WITH SPECIFIED REVENUE CODES -*;

446

447 DATA &NAME..REVS;

448 SET NT07.DATA;

ERROR: Libref NT07 is not assigned.

449 IF REVCD IN ('0655' '0656') THEN OUTPUT REVS;

____

455

ERROR 455-185: Data set was not specified on the DATA statement.

450 ELSE

451 DELETE;

452 RUN;

NOTE: The SAS System stopped processing this step because of errors.

WARNING: The data set NCTTRI.REVS may be incomplete. When this step was stopped there were 0 observations and 1 variables.

WARNING: Data set NCTTRI.REVS 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 11:06 Thursday, February 8, 2018

 

453

454 PROC SORT NODUPKEY DATA=REVS (KEEP=CLMNBR);

ERROR: The variable CLMNBR in the DROP, KEEP, or RENAME list has never been referenced.

455 BY CLMNBR;

456 RUN;

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

 

457

 

458 PROC SORT DATA=NT07.DATA OUT=NT08.DATA;

ERROR: Libref NT07 is not assigned.

ERROR: Libref NT08 is not assigned.

459 BY CLMNBR;

460 RUN;

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

 

461

 

462 DATA &NAME..NT09.DATA;

NOTE: Line generated by the macro variable "NAME".

462 NCTTRI

______

211

ERROR 211-185: Invalid data set name.

463 MERGE NT08.DATA (IN=INA) REVS (IN=INB);

ERROR: Libref NT08 is not assigned.

464 BY CLMNBR;

465 IF INA;

466

467 IF INA AND INB THEN REVCHK = 'Y';

468 ELSE

469 REVCHK = 'N';

470

471 INSTTYPE = SUBSTR(PROVTXMY,1,2);

472

473 /* DEFINE ADMISSION COUNT */

474

475 IF SUPPCVDY = 0 THEN ADMTCNT = 0;

476 ELSE

477 IF INSTTYPE = '70' THEN ADMTCNT = 0;

478 ELSE

479 IF (INSTTYPE IN ('78' '79') AND

480 REVCHK = 'N') THEN ADMTCNT = 0;

481 ELSE

482 IF BILLSTAT IN ('1' '2' '7' '3' '4') THEN ADMTCNT = 1;

15 The SAS System 11:06 Thursday, February 8, 2018

483 ELSE

484 ADMTCNT = 0;

485

486 RUN;

NOTE: Numeric values have been converted to character values at the places given by: (Line)Smiley SadColumn).

471:24

NOTE: The SAS System stopped processing this step because of errors.

NOTE: DATA statement used (Total process time):

real time 0.00 seconds

cpu time 0.00 seconds

 

487

488 *- COUNT ONLY ONCE PER CLAIM -*;

489

490 PROC SORT DATA=NT09.DATA OUT=NT10.DATA;

ERROR: Libref NT09 is not assigned.

ERROR: Libref NT10 is not assigned.

491 BY CLMNBR CLMLN;

492 RUN;

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

 

493

 

494 DATA &NAME..NT11.DATA;

NOTE: Line generated by the macro variable "NAME".

494 NCTTRI

______

211

ERROR 211-185: Invalid data set name.

495 SET NT10.DATA;

ERROR: Libref NT10 is not assigned.

496 BY CLMNBR CLMLN;

497

498 IF FIRST.CLMNBR THEN ADMTCNT = ADMTCNT;

499 ELSE

500 ADMTCNT = 0;

501

502 KEEP CONTRACT IPOP1 TYPE1 MOS MOP ADMTCNT INSTTYPE STATUSD1

503 STATUSC1 BENEZIP HBEGDT;

504

505 RUN;

NOTE: The SAS System stopped processing this step because of errors.

NOTE: DATA statement used (Total process time):

real time 0.00 seconds

cpu time 0.00 seconds

 

506

507 *--------------------------*;

16 The SAS System 11:06 Thursday, February 8, 2018

508 *- PAID AMOUNT DERIVATION -*;

509 *--------------------------*;

510

511 *- KEEP DELTA PAID AMOUNTS FROM NT05 -*;

512

513 DATA &NAME..NT12.DATA;

NOTE: Line generated by the macro variable "NAME".

513 NCTTRI

______

211

ERROR 211-185: Invalid data set name.

514 SET NT05.DATA;

ERROR: Libref NT05 is not assigned.

515 WHERE RISKIND = 'Y' AND DLTPAID NE 0;

516 KEEP CONTRACT IPOP1 TYPE1 MOS MOP DLTPAID STATUSD1 STATUSC1

517 BENEZIP HBEGDT;

518 RUN;

NOTE: The SAS System stopped processing this step because of errors.

NOTE: DATA statement used (Total process time):

real time 0.00 seconds

cpu time 0.00 seconds

 

519

520

521 *- FACT003.ROUTINE.T3-OP8(NCT1801) - JS045 -*;

522

523 *- PUT FILES TOGETHER -*;

524

525 DATA &NAME..NT13.DATA;

NOTE: Line generated by the macro variable "NAME".

525 NCTTRI

______

211

ERROR 211-185: Invalid data set name.

526 SET NT06.DATA

527 (KEEP=CONTRACT IPOP1 TYPE1 MOS MOP VSTCNT STATUSD1

528 STATUSC1 BENEZIP HBEGDT)

ERROR: Libref NT06 is not assigned.

529 NT11.DATA

530 (KEEP=CONTRACT IPOP1 TYPE1 MOS MOP ADMTCNT STATUSD1

531 STATUSC1 BENEZIP HBEGDT)

ERROR: Libref NT11 is not assigned.

532 NT12.DATA

533 (KEEP=CONTRACT IPOP1 TYPE1 MOS MOP DLTPAID STATUSD1

534 STATUSC1 BENEZIP HBEGDT);

ERROR: Libref NT12 is not assigned.

535 RUN;

NOTE: The SAS System stopped processing this step because of errors.

NOTE: DATA statement used (Total process time):

real time 0.00 seconds

cpu time 0.00 seconds

 

17 The SAS System 11:06 Thursday, February 8, 2018

536

537 *- NEED TO SPLIT FILE TO GET THE SORT TO RUN -*;

538

539 DATA &NAME..NT13A &NAME..NT13B &NAME..NT13C;

540 SET NT13.DATA;

ERROR: Libref NT13 is not assigned.

541

542 IF '2011-04' LE MOS LE '2013-03' THEN OUTPUT NT13A.DATA;

__________

455

ERROR 455-185: Data set was not specified on the DATA statement.

543 ELSE

544 IF '2013-04' LE MOS LE '2015-09' THEN OUTPUT NT13B.DATA;

__________

455

ERROR 455-185: Data set was not specified on the DATA statement.

545 ELSE

546 OUTPUT NT13C.DATA;

__________

455

ERROR 455-185: Data set was not specified on the DATA statement.

547 RUN;

NOTE: The SAS System stopped processing this step because of errors.

WARNING: The data set NCTTRI.NT13A may be incomplete. When this step was stopped there were 0 observations and 1 variables.

WARNING: Data set NCTTRI.NT13A was not replaced because this step was stopped.

WARNING: The data set NCTTRI.NT13B may be incomplete. When this step was stopped there were 0 observations and 1 variables.

WARNING: Data set NCTTRI.NT13B was not replaced because this step was stopped.

WARNING: The data set NCTTRI.NT13C may be incomplete. When this step was stopped there were 0 observations and 1 variables.

WARNING: Data set NCTTRI.NT13C 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

 

548

549 PROC SORT DATA= NT13A.DATA OUT= NT13D.DATA;

ERROR: Libref NT13A is not assigned.

ERROR: Libref NT13D is not assigned.

550 BY BENEZIP HBEGDT CONTRACT IPOP1 TYPE1 MOS MOP STATUSD1

551 STATUSC1;

552 RUN;

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

 

553

 

554 PROC SORT DATA= NT13B.DATA OUT= NT13E.DATA;

ERROR: Libref NT13B is not assigned.

ERROR: Libref NT13E is not assigned.

555 BY BENEZIP HBEGDT CONTRACT IPOP1 TYPE1 MOS MOP STATUSD1

18 The SAS System 11:06 Thursday, February 8, 2018

556 STATUSC1;

557 RUN;

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

 

558

 

559 PROC SORT DATA= NT13C.DATA OUT= NT13F.DATA;

ERROR: Libref NT13C is not assigned.

ERROR: Libref NT13F is not assigned.

560 BY BENEZIP HBEGDT CONTRACT IPOP1 TYPE1 MOS MOP STATUSD1

561 STATUSC1;

562 RUN;

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

 

563

 

564 DATA &NAME..NT14;

565 SET NT13D.DATA NT13E.DATA NT13F.DATA;

ERROR: Libref NT13D is not assigned.

ERROR: Libref NT13E is not assigned.

ERROR: Libref NT13F is not assigned.

566 BY BENEZIP HBEGDT CONTRACT IPOP1 TYPE1 MOS MOP STATUSD1

567 STATUSC1;

568 RUN;

NOTE: The SAS System stopped processing this step because of errors.

WARNING: The data set NCTTRI.NT14 may be incomplete. When this step was stopped there were 0 observations and 0 variables.

WARNING: Data set NCTTRI.NT14 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

 

569

570 PROC SUMMARY NWAY MISSING DATA=NT14.DATA;

ERROR: Libref NT14 is not assigned.

571 BY BENEZIP HBEGDT CONTRACT IPOP1 TYPE1 MOS MOP STATUSD1

572 STATUSC1;

573 VAR DLTPAID VSTCNT ADMTCNT;

ERROR: No data set open to look up variables.

ERROR: No data set open to look up variables.

ERROR: No data set open to look up variables.

574 OUTPUT OUT=NT15.DATA (DROP=_TYPE_ _FREQ_) SUM=;

ERROR: Libref NT15 is not assigned.

575

576

577 *- OK TO USE THE NEW ZIP AREA ASSIGNMENT TABLE SINCE -*;

578 *- IT IS ONLY SPLIT PRIME TRANSITIONAL / OTHER -*;

19 The SAS System 11:06 Thursday, February 8, 2018

579

580 *- READ IN MARKET AREA, MARKET & AREA FROM DB2 TABLE -*;

581

NOTE: The SAS System stopped processing this step because of errors.

NOTE: PROCEDURE SUMMARY used (Total process time):

real time 0.00 seconds

cpu time 0.00 seconds

 

582 proc sql ;

583 CONNECT TO Teradata as tera (authdomain="T2017_IW_Prod" TDPID="edwfsp.fs.centene.com");

584 CREATE TABLE &NAME..ZIPAREA AS

585 SELECT * FROM CONNECTION TO tera

586 (SELECT

587 ZIP_CD AS ZIP,

588 EFCTV_DT AS STARTDT,

589 AREA_TYP_DESC AS AREATYP,

590 AREA_NAME AS AREA,

591 MRKT_NAME AS MARKET,

592 MRKT_AREA_NAME AS MKTAREA,

593 TRMNTN_DT AS ENDDT

594

595 FROM ZIP_AREA_ASGNMT

596

597 );

ERROR: Teradata prepare: Column MRKT_NAME not found in IW_PRD_AV.ZIP_AREA_ASGNMT. SQL statement was: SELECT ZIP_CD AS ZIP, EFCTV_DT

AS STARTDT, AREA_TYP_DESC AS AREATYP, AREA_NAME AS AREA, MRKT_NAME AS MARKET, MRKT_AREA_NAME AS MKTAREA, TRMNTN_DT AS ENDDT

FROM ZIP_AREA_ASGNMT.

NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements.

598

599 %PUT &SQLXMSG &SQLXRC;

Column MRKT_NAME not found in IW_PRD_AV.ZIP_AREA_ASGNMT 5628

600

NOTE: The SAS System stopped processing this step because of errors.

NOTE: PROCEDURE SQL used (Total process time):

real time 0.08 seconds

cpu time 0.01 seconds

 

601 PROC SORT NODUPKEY DATA=ZIPAREA OUT=ZIPAREA.DATA;

ERROR: File WORK.ZIPAREA.DATA does not exist.

ERROR: Libref ZIPAREA is not assigned.

602 BY ZIP STARTDT ENDDT;

603 RUN;

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

 

604

605 *- NEED TO SPLIT FILE TO GET THE MERGE TO RUN -*;

606

 

607 DATA &NAME..NT16 &NAME..NT17 &NAME..NT18 &NAME..NT24 &NAME..NT26;

608 SET NT15.DATA;

20 The SAS System 11:06 Thursday, February 8, 2018

ERROR: Libref NT15 is not assigned.

609

610 IF MOP LE '2012-12' THEN OUTPUT NT16.DATA;

_________

455

ERROR 455-185: Data set was not specified on the DATA statement.

611 ELSE

612 IF MOP LE '2013-12' THEN OUTPUT NT17.DATA;

_________

455

ERROR 455-185: Data set was not specified on the DATA statement.

613 ELSE

614 IF MOP LE '2014-12' THEN OUTPUT NT18.DATA;

_________

455

ERROR 455-185: Data set was not specified on the DATA statement.

615 ELSE

616 IF MOP LE '2015-12' THEN OUTPUT NT24.DATA;

_________

455

ERROR 455-185: Data set was not specified on the DATA statement.

617 ELSE

618 OUTPUT NT26.DATA;

_________

455

ERROR 455-185: Data set was not specified on the DATA statement.

619 RUN;

NOTE: The SAS System stopped processing this step because of errors.

WARNING: The data set NCTTRI.NT16 may be incomplete. When this step was stopped there were 0 observations and 1 variables.

WARNING: Data set NCTTRI.NT16 was not replaced because this step was stopped.

WARNING: The data set NCTTRI.NT17 may be incomplete. When this step was stopped there were 0 observations and 1 variables.

WARNING: Data set NCTTRI.NT17 was not replaced because this step was stopped.

WARNING: The data set NCTTRI.NT18 may be incomplete. When this step was stopped there were 0 observations and 1 variables.

WARNING: Data set NCTTRI.NT18 was not replaced because this step was stopped.

WARNING: The data set NCTTRI.NT24 may be incomplete. When this step was stopped there were 0 observations and 1 variables.

WARNING: Data set NCTTRI.NT24 was not replaced because this step was stopped.

WARNING: The data set NCTTRI.NT26 may be incomplete. When this step was stopped there were 0 observations and 1 variables.

WARNING: Data set NCTTRI.NT26 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

 

620

621 PROC SQL;

622 CREATE TABLE &NAME..NT19 (SORTEDBY=_NULL_) AS

623 SELECT A.*, B.MKTAREA, B.MARKET, B.AREA, B.AREATYP

624 FROM NT16.DATA AS A LEFT JOIN ZIPAREA.DATA AS B

625 ON A.BENEZIP = B.ZIP AND

626 B.STARTDT LE A.HBEGDT LE B.ENDDT;

ERROR: Libref NT16 is not assigned.

ERROR: Libref ZIPAREA is not assigned.

21 The SAS System 11:06 Thursday, February 8, 2018

NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements.

627

NOTE: The SAS System stopped processing this step because of errors.

NOTE: PROCEDURE SQL used (Total process time):

real time 0.00 seconds

cpu time 0.00 seconds

 

628 PROC SQL;

629 CREATE TABLE &NAME..NT20 (SORTEDBY=_NULL_) AS

630 SELECT A.*, B.MKTAREA, B.MARKET, B.AREA, B.AREATYP

631 FROM NT17.DATA AS A LEFT JOIN ZIPAREA.DATA AS B

632 ON A.BENEZIP = B.ZIP AND

633 B.STARTDT LE A.HBEGDT LE B.ENDDT;

ERROR: Libref NT17 is not assigned.

ERROR: Libref ZIPAREA is not assigned.

NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements.

634

NOTE: The SAS System stopped processing this step because of errors.

NOTE: PROCEDURE SQL used (Total process time):

real time 0.00 seconds

cpu time 0.00 seconds

 

635 PROC SQL;

636 CREATE TABLE &NAME..NT21 (SORTEDBY=_NULL_) AS

637 SELECT A.*, B.MKTAREA, B.MARKET, B.AREA, B.AREATYP

638 FROM NT18.DATA AS A LEFT JOIN ZIPAREA.DATA AS B

639 ON A.BENEZIP = B.ZIP AND

640 B.STARTDT LE A.HBEGDT LE B.ENDDT;

ERROR: Libref NT18 is not assigned.

ERROR: Libref ZIPAREA is not assigned.

NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements.

641

NOTE: The SAS System stopped processing this step because of errors.

NOTE: PROCEDURE SQL used (Total process time):

real time 0.00 seconds

cpu time 0.00 seconds

 

642 PROC SQL;

643 CREATE TABLE &NAME..NT25 (SORTEDBY=_NULL_) AS

644 SELECT A.*, B.MKTAREA, B.MARKET, B.AREA, B.AREATYP

645 FROM NT24.DATA AS A LEFT JOIN ZIPAREA.DATA AS B

646 ON A.BENEZIP = B.ZIP AND

647 B.STARTDT LE A.HBEGDT LE B.ENDDT;

ERROR: Libref NT24 is not assigned.

ERROR: Libref ZIPAREA is not assigned.

NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements.

648

NOTE: The SAS System stopped processing this step because of errors.

NOTE: PROCEDURE SQL used (Total process time):

real time 0.00 seconds

cpu time 0.00 seconds

 

649 PROC SQL;

650 CREATE TABLE &NAME..NT27 (SORTEDBY=_NULL_) AS

22 The SAS System 11:06 Thursday, February 8, 2018

651 SELECT A.*, B.MKTAREA, B.MARKET, B.AREA, B.AREATYP

652 FROM NT26.DATA AS A LEFT JOIN ZIPAREA.DATA AS B

653 ON A.BENEZIP = B.ZIP AND

654 B.STARTDT LE A.HBEGDT LE B.ENDDT;

ERROR: Libref NT26 is not assigned.

ERROR: Libref ZIPAREA is not assigned.

NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements.

655

NOTE: The SAS System stopped processing this step because of errors.

NOTE: PROCEDURE SQL used (Total process time):

real time 0.00 seconds

cpu time 0.00 seconds

 

656 DATA &NAME..NT22;

657 LENGTH AREATYPE $22. FC $15.;

658 SET NT19.DATA NT20.DATA NT21.DATA NT25.DATA NT27.DATA;

ERROR: Libref NT19 is not assigned.

ERROR: Libref NT20 is not assigned.

ERROR: Libref NT21 is not assigned.

ERROR: Libref NT25 is not assigned.

ERROR: Libref NT27 is not assigned.

659

660 IF UPCASE(TRIM(AREATYP)) = 'PRIME TRANSITIONAL' THEN

661 AREATYPE = 'PRIME TRANSITIONAL';

662 ELSE

663 AREATYPE = 'NOT PRIME TRANSITIONAL';

664

665 IF UPCASE(TRIM(MARKET)) = 'FT CAMPBELL' THEN /**FT CAMPBELL CAN BE REMOVED FOR T2017**/

666 FC = 'FT CAMPBELL';

667 ELSE

668 FC = 'NOT FT CAMPBELL';

669

670 RUN;

NOTE: Numeric values have been converted to character values at the places given by: (Line)Smiley SadColumn).

660:22 665:22

NOTE: The SAS System stopped processing this step because of errors.

WARNING: The data set NCTTRI.NT22 may be incomplete. When this step was stopped there were 0 observations and 4 variables.

WARNING: Data set NCTTRI.NT22 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

 

671

672 *-REMOVED AREATYPE FROM OUTPUT PER DAN 07/24/2013-*;

673 *-PRIME TRANSITIONAL-*;

674

675 PROC SUMMARY NWAY MISSING DATA=NT22.DATA;

ERROR: Libref NT22 is not assigned.

676 CLASS CONTRACT IPOP1 TYPE1 MOS MOP STATUSD1 STATUSC1 FC;

ERROR: No data set open to look up variables.

ERROR: No data set open to look up variables.

ERROR: No data set open to look up variables.

ERROR: No data set open to look up variables.

ERROR: No data set open to look up variables.

ERROR: No data set open to look up variables.

23 The SAS System 11:06 Thursday, February 8, 2018

ERROR: No data set open to look up variables.

ERROR: No data set open to look up variables.

677 VAR DLTPAID VSTCNT ADMTCNT;

ERROR: No data set open to look up variables.

ERROR: No data set open to look up variables.

ERROR: No data set open to look up variables.

678 OUTPUT OUT=NT23.DATA (DROP=_TYPE_ _FREQ_) SUM=;

ERROR: Libref NT23 is not assigned.

679

NOTE: The SAS System stopped processing this step because of errors.

NOTE: PROCEDURE SUMMARY used (Total process time):

real time 0.00 seconds

cpu time 0.00 seconds

 

680 DATA _NULL_;

681 SET NT23.DATA;

ERROR: Libref NT23 is not assigned.

682 WHERE MOS GE '2011-04';

683 FILE NTO1 LS=200;

684

685 PUT CONTRACT +(-1)'$'

686 IPOP1 +(-1)'$'

687 TYPE1 +(-1)'$'

688 MOS +(-1)'$'

689 MOP +(-1)'$'

690 STATUSD1 +(-1)'$'

691 STATUSC1 +(-1)'$'

692 DLTPAID +(-1)'$'

693 VSTCNT +(-1)'$'

694 ADMTCNT +(-1)'$'

695 FC +(-1)'$';

696 RUN;

NOTE: The SAS System stopped processing this step because of errors.

NOTE: DATA statement used (Total process time):

real time 0.00 seconds

cpu time 0.01 seconds

 

697

698

699

700 GOPTIONS NOACCESSIBLE;

701 %LET _CLIENTTASKLABEL=;

702 %LET _CLIENTPROCESSFLOWNAME=;

703 %LET _CLIENTPROJECTPATH=;

704 %LET _CLIENTPROJECTNAME=;

705 %LET _SASPROGRAMFILE=;

706

707 ;*';*";*/;quit;run;

708 ODS _ALL_ CLOSE;

709

710

711 QUIT; RUN;

712

Super User
Posts: 24,004

Re: Getting a syntax error, not sure why....

Well...the first error is identified as here:

FROM NINST_CLM_LN LN

 

It looks like you're using TERADATA, so does TERADATA require the keyword AS between it to identify alias?

 

FROM NINST_CLM_LN AS LN

 

For some reason it's thinking thats an error? Or do you need to reference the schema and table names using the two level names:

 

FROM dbo.NINST_CLM_LN AS LN

 

Without doing too much work, those would be my first checks. Also, please don't include your full log for all your code. Up to the first few errors is usually sufficient. 

 

Spoiler

essdee wrote:

1 ;*';*";*/;quit;run;

2 OPTIONS PAGENO=MIN;

3 %LET _CLIENTTASKLABEL='NCT1801';

4 %LET _CLIENTPROCESSFLOWNAME='Process Flow';

5 %LET _CLIENTPROJECTPATH='';

6 %LET _CLIENTPROJECTNAME='';

7 %LET _SASPROGRAMFILE=;

8

9 ODS _ALL_ CLOSE;

10 OPTIONS DEV=ACTIVEX;

11 GOPTIONS XPIXELS=0 YPIXELS=0;

12 FILENAME EGSR TEMP;

13 ODS tagsets.sasreport13(ID=EGSR) FILE=EGSR

14 STYLE=HtmlBlue

15 STYLESHEET=(URL="file:///C:/Program%20Files/SASHome/SASEnterpriseGuide/7.1/Styles/HtmlBlue.css")

16 NOGTITLE

17 NOGFOOTNOTE

18 GPATH=&sasworklocation

19 ENCODING=UTF8

20 options(rolap="on")

21 ;

NOTE: Writing TAGSETS.SASREPORT13(EGSR) Body file: EGSR

22

23 GOPTIONS ACCESSIBLE;

24

25 %GLOBAL FileNameUserID;

26 %GLOBAL FileNameDate;

27 %GLOBAL FileNameEmail;

28

29 %LET FileNameUserID =fs115055;

30 %LET FileNameDate = 201801;

31 %LET FileNameEmail = NCTTRIANGLE;

32

33 %LET TEST = &cOrgNameDataAnalytics./users/&FileNameUserID./&FileNameDate.;

34 %LET NAME = NCTTRI;

35

36 %PUT &TEST;

/opt/t7iw/sasdata/users/fs115055/201801

37

38 LIBNAME &NAME "&cOrgNameDataAnalytics./users/&FileNameUserID./&FileNameDate.";

NOTE: Libref NCTTRI was successfully assigned as follows:

Engine: V9

Physical Name: /opt/t7iw/sasdata/users/fs115055/201801

40

41 %LET DATE1 = '2018-01-01' ; *- CURRENT MONTH SETTLEMENT FROM DT -*;

42 %LET DATE3 = '2018-01-31' ; *- CURRENT MONTH SETTLEMENT THRU DT -*;

43 proc sql ;

44 CONNECT TO Teradata as tera (authdomain="T2017_IW_Prod" TDPID="edwfsp.fs.centene.com");

45 CREATE TABLE &NAME..NT01 AS

46 SELECT * FROM CONNECTION TO tera

47 (SELECT

48 CLM_LINE_ID AS CLMLN,

49 MCS_AT_RISK AS RISKIND,

50 DLT_SRVCS_NBR AS DLTSVCS,

51 DLT_PYMT_AMT AS DLTPAID,

52 DLT_ALOWD_CHRG_AMT AS DLTALLW,

53 TMA_PRCDR_CD AS TMAPROC,

54 TMA_ENRLMT_HLTH_CD AS TMAENRCD,

2 The SAS System 11:06 Thursday, February 8, 2018

55 LTRIM(REV_CODE) AS REVCD,

56 HOSP_PROF_SERV AS HOSOPSVC,

57 TMA_TYP_SRVC_CD AS LTMATOS,

58 PRVDR_TXMY_CD AS PROVTXMY,

59 CLM_BGN_SRVC_DT AS LBEGDT,

60 CLM_END_SRVC_DT AS LENDDT,

61 SAL_RES_SHARE AS SALARYRS,

62 PLAN_CVRG_OPTN_CD AS PLNCVOPT,

63 CLM_BASE_ID AS CLMNBR,

64 CHAP_CLM_SUB_NO AS SUBNBR,

65 CLM_ADJ_ID AS CLMADJ,

66 CLM_TRANS_TYP AS TRANSTYP,

67 BILL_STATUS_CD AS BILLSTAT,

68 CLM_BGN_SRVC_DT AS HBEGDT,

69 CLM_END_SRVC_DT AS HENDDT,

70 SPON_STATUS AS SPSTAT,

71 DEERS_SPON_STATUS AS DEERSSPSTAT,

72 PATNT_SEX_REL_CODE AS PTSXREL,

73 PATNT_RLTNSHP_CD AS PTRELCD,

74 SETTLE_CUTOFF_DATE AS DTPROC,

75 ALLOWED_CHRG AS HALLOW,

76 PATNT_ZIP_CODE AS BENEZIP,

77 T3_CNTRCT_IND AS T3IND

78

79 FROM NINST_CLM_LN LN

80 INNER JOIN

81 NINST_CLM_HDR HD

82 ON CLM_BASE_ID = CLM_BASE_ID AND

83 CHAP_CLM_SUB_NO = CHAP_CLM_SUB_NO AND

84 CLM_ADJ_ID = CLM_ADJ_ID AND

85 CLM_TRANS_TYP = CLM_TRANS_TYP

86

87 WHERE SETTLE_CUTOFF_DATE BETWEEN &DATE1 AND &DATE3

88 );

ERROR: Teradata prepare: Syntax error: expected something between the word 'NINST_CLM_LN' and the 'LN' keyword. SQL statement was:

SELECT CLM_LINE_ID AS CLMLN, MCS_AT_RISK AS RISKIND, DLT_SRVCS_NBR AS DLTSVCS, DLT_PYMT_AMT AS DLTPAID, DLT_ALOWD_CHRG_AMT

AS DLTALLW, TMA_PRCDR_CD AS TMAPROC, TMA_ENRLMT_HLTH_CD AS TMAENRCD, LTRIM(REV_CODE) AS REVCD, HOSP_PROF_SERV AS HOSOPSVC,

TMA_TYP_SRVC_CD AS LTMATOS, PRVDR_TXMY_CD AS PROVTXMY, CLM_BGN_SRVC_DT AS LBEGDT, CLM_END_SRVC_DT AS LENDDT, SAL_RES_SHARE

AS SALARYRS, PLAN_CVRG_OPTN_CD AS PLNCVOPT, CLM_BASE_ID AS CLMNBR, CHAP_CLM_SUB_NO AS SUBNBR, CLM_ADJ_ID AS CLMADJ,

CLM_TRANS_TYP AS TRANSTYP, BILL_STATUS_CD AS BILLSTAT, CLM_BGN_SRVC_DT AS HBEGDT, CLM_END_SRVC_DT AS HENDDT, SPON_STATUS AS

SPSTAT, DEERS_SPON_STATUS AS DEERSSPSTAT, PATNT_SEX_REL_CODE AS PTSXREL, PATNT_RLTNSHP_CD AS PTRELCD, SETTLE_CUTOFF_DATE AS

DTPROC, ALLOWED_CHRG AS HALLOW, PATNT_ZIP_CODE AS BENEZIP, T3_CNTRCT_IND AS T3IND FROM NINST_CLM_LN LN INNER JOIN

NINST_CLM_HDR HD ON CLM_BASE_ID = CLM_BASE_ID AND CHAP_CLM_SUB_NO = CHAP_CLM_SUB_NO AND CLM_ADJ_ID = CLM_ADJ_ID AND

CLM_TRANS_TYP = CLM_TRANS_TYP WHERE SETTLE_CUTOFF_DATE BETWEEN '2018-01-01' AND '2018-01-31'.

NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements.

89

90 %PUT &SQLXMSG &SQLXRC;

Syntax error: expected something between the word 'NINST_CLM_LN' and the 'LN' keyword 3706

91

NOTE: The SAS System stopped processing this step because of errors.

NOTE: PROCEDURE SQL used (Total process time):

real time 0.08 seconds

cpu time 0.02 seconds

 

92 PROC PRINT DATA =NT01.DATA (OBS=10);

ERROR: Libref NT01 is not assigned.

93 TITLE1 "10 OBS FROM FACT003.A082633.NT01.NCT1801.SASS";

3 The SAS System 11:06 Thursday, February 8, 2018

94 TITLE2 "ALL ADJ FOR SETTLEMENT DATES: &DATE1 - &DATE3";

95 TITLE3 "FACT003.ROUTINE.T3-OP8(NCT1801) - JS010";

96 RUN;

NOTE: The SAS System stopped processing this step because of errors.

NOTE: PROCEDURE PRINT used (Total process time):

real time 0.00 seconds

cpu time 0.00 seconds

 

97

98

99 *- FACT003.ROUTINE.T3-OP8(NCT1801) - JS020 -*;

100

101 %LET DATE1 = '2018-01-01' ; *- CURRENT MONTH SETTLEMENT FROM DT -*;

102 %LET DATE3 = '2018-01-31' ; *- CURRENT MONTH SETTLEMENT THRU DT -*;

103

 

104 proc sql ;

105 CONNECT TO Teradata as tera (authdomain="T2017_IW_Prod" TDPID="edwfsp.fs.centene.com");

106 CREATE TABLE &NAME..NT02 AS

107 SELECT * FROM CONNECTION TO tera

108 (SELECT

109 CLM_LINE_ID AS CLMLN ,

110 MCS_AT_RISK AS RISKIND,

111 DLT_SRVCS_NBR AS DLTSVCS,

112 DLT_PYMT_AMT AS DLTPAID,

113 DLT_ALOWD_CHRG_AMT AS DLTALLW,

114 TMA_PRCDR_CD AS TMAPROC,

115 TMA_ENRLMT_HLTH_CD AS TMAENRCD,

116 LTRIM(REV_CODE) AS REVCD,

117 HOSP_PROF_SERV AS HOSOPSVC,

118 TMA_TYP_SRVC_CD AS LTMATOS,

119 PRVDR_TXMY_CD AS PROVTXMY,

120 CLM_BGN_SRVC_DT AS LBEGDT,

121 CLM_END_SRVC_DT AS LENDDT,

122 SAL_RES_SHARE AS SALARYRS,

123 PLAN_CVRG_OPTN_CD AS PLNCVOPT,

124 CLM_BASE_ID AS CLMNBR,

125 CHAP_CLM_SUB_NO AS SUBNBR,

126 CLM_ADJ_ID AS CLMADJ,

127 CLM_TRANS_TYP AS TRANSTYP,

128 BILL_STATUS_CD AS BILLSTAT,

129 CLM_BGN_SRVC_DT AS HBEGDT,

130 CLM_END_SRVC_DT AS HENDDT,

131 SPON_STATUS AS SPSTAT,

132 DEERS_SPON_STATUS AS DEERSSPSTAT,

133 PATNT_SEX_REL_CODE AS PTSXREL,

134 PATNT_RLTNSHP_CD AS PTRELCD,

135 SETTLE_CUTOFF_DATE AS DTPROC,

136 SUPP_COV_DAYS AS SUPPCVDY,

137 DRG_LOS AS DRGLOS,

138 ADMIT_SRVC_DT AS ADMITDT,

139 DISCHG_LVIS_DT AS DISCHDT,

140 ALLOWED_CHRG AS HALLOW,

141 PATNT_ZIP_CODE AS BENEZIP,

142 T3_CNTRCT_IND AS T3IND

143

4 The SAS System 11:06 Thursday, February 8, 2018

144 FROM INST_CLM_LN LN

145 INNER JOIN

146 INST_CLM_HDR HD

147

148 ON CLM_BASE_ID = CLM_BASE_ID AND

149 CHAP_CLM_SUB_NO = CHAP_CLM_SUB_NO AND

150 CLM_ADJ_ID = CLM_ADJ_ID AND

151 CLM_TRANS_TYP = CLM_TRANS_TYP

152

153 WHERE SETTLE_CUTOFF_DATE BETWEEN &DATE1 AND &DATE3

154 );

ERROR: Teradata prepare: Syntax error: expected something between the word 'INST_CLM_LN' and the 'LN' keyword. SQL statement was:

SELECT CLM_LINE_ID AS CLMLN , MCS_AT_RISK AS RISKIND, DLT_SRVCS_NBR AS DLTSVCS, DLT_PYMT_AMT AS DLTPAID, DLT_ALOWD_CHRG_AMT

AS DLTALLW, TMA_PRCDR_CD AS TMAPROC, TMA_ENRLMT_HLTH_CD AS TMAENRCD, LTRIM(REV_CODE) AS REVCD, HOSP_PROF_SERV AS HOSOPSVC,

TMA_TYP_SRVC_CD AS LTMATOS, PRVDR_TXMY_CD AS PROVTXMY, CLM_BGN_SRVC_DT AS LBEGDT, CLM_END_SRVC_DT AS LENDDT, SAL_RES_SHARE

AS SALARYRS, PLAN_CVRG_OPTN_CD AS PLNCVOPT, CLM_BASE_ID AS CLMNBR, CHAP_CLM_SUB_NO AS SUBNBR, CLM_ADJ_ID AS CLMADJ,

CLM_TRANS_TYP AS TRANSTYP, BILL_STATUS_CD AS BILLSTAT, CLM_BGN_SRVC_DT AS HBEGDT, CLM_END_SRVC_DT AS HENDDT, SPON_STATUS AS

SPSTAT, DEERS_SPON_STATUS AS DEERSSPSTAT, PATNT_SEX_REL_CODE AS PTSXREL, PATNT_RLTNSHP_CD AS PTRELCD, SETTLE_CUTOFF_DATE AS

DTPROC, SUPP_COV_DAYS AS SUPPCVDY, DRG_LOS AS DRGLOS, ADMIT_SRVC_DT AS ADMITDT, DISCHG_LVIS_DT AS DISCHDT, ALLOWED_CHRG AS

HALLOW, PATNT_ZIP_CODE AS BENEZIP, T3_CNTRCT_IND AS T3IND FROM INST_CLM_LN LN INNER JOIN INST_CLM_HDR HD ON CLM_BASE_ID =

CLM_BASE_ID AND CHAP_CLM_SUB_NO = CHAP_CLM_SUB_NO AND CLM_ADJ_ID = CLM_ADJ_ID AND CLM_TRANS_TYP = CLM_TRANS_TYP WHERE

SETTLE_CUTOFF_DATE BETWEEN '2018-01-01' AND '2018-01-31'.

NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements.

155

156 %PUT &SQLXMSG &SQLXRC;

Syntax error: expected something between the word 'INST_CLM_LN' and the 'LN' keyword 3706

157

NOTE: The SAS System stopped processing this step because of errors.

NOTE: PROCEDURE SQL used (Total process time):

real time 0.12 seconds

cpu time 0.01 seconds

 

158 PROC PRINT DATA =NT02.DATA (OBS=10);

ERROR: Libref NT02 is not assigned.

159 TITLE1 "10 OBS FROM FACT003.A082633.NT02.NCT1801.SASS";

160 TITLE2 "ALL ADJ FOR SETTLEMENT DATES: &DATE1 - &DATE3";

161 TITLE3 "FACT003.ROUTINE.T3-OP8(NCT1801) - JS020";

162 RUN;

NOTE: The SAS System stopped processing this step because of errors.

NOTE: PROCEDURE PRINT used (Total process time):

real time 0.00 seconds

cpu time 0.01 seconds

 

163

164

165 *- FACT003.ROUTINE.T3-OP8(NCT1801) - JS030 -*;

166

167 %LET DATE1 = 01APR2011 ; *- SETTLEMENT FROM DATE OP2 -*;

168 %LET DATE3 = 31JAN2018 ; *- SETTLEMENT THRU DATE -*;

169

170 *- PUT FILES TOGETHER AND SET VARIABLES -*;

171

 

172 DATA &NAME..NT03;

173 LENGTH CONTRACT $4. TYPE $19. STATUSC $5.;

5 The SAS System 11:06 Thursday, February 8, 2018

174 SET NT01.DATA NT02.DATA;

ERROR: Libref NT01 is not assigned.

ERROR: Libref NT02 is not assigned.

175

176 IF HOSOPSVC='1' AND ("01JAN1960"D LE DISCHDT LE "&DATE3"D)

177 AND DISCHDT LE DTPROC

178 THEN DOD=DISCHDT;

179 ELSE

180 IF HOSOPSVC='1' THEN DOD=LENDDT;

181 ELSE

182 DOD=LBEGDT;

183

184 IF HOSOPSVC='1' THEN DOS=ADMITDT;

185 ELSE

186 DOS=LBEGDT;

187

188 IF SUBSTR(LTMATOS,1,1) IN ('I' 'M') THEN IPOP = 'IP';

189 ELSE

190 IPOP = 'OP';

191

192 IF TMAENRCD = 'U' THEN TYPE = 'CIVILIAN ENROLLED'; /*SPLIT MTF PRIME FROM NONPRIME FOR T2017*/

193 ELSE IF TMAENRCD = 'Z' THEN TYPE = 'MTF PRIME';

194 ELSE TMAENRCD = 'NON-PRIME';

195

196 IF T3IND = 'T3' THEN CONTRACT = 'T3';

197 ELSE

198 CONTRACT = 'TNEX';

199

200 IF SPSTAT = '1' AND PTSXREL IN ('1' '2') THEN STATUSC = 'ADSM';

201 ELSE

202 IF SPSTAT = '1' THEN STATUSC = 'ADFM';

203 ELSE

204 IF SPSTAT IN ('2' '3') THEN STATUSC = 'NADFM';

205 ELSE

206 STATUSC = SPSTAT!!PTSXREL;

207

208 IF DEERSSPSTAT IN ('A' 'G' 'J' 'N' 'S' 'T' 'V' 'Y') AND

209 PTRELCD = 'A' THEN STATUSD = '4';

210 ELSE

211 IF DEERSSPSTAT IN ('A' 'G' 'J' 'N' 'S' 'T' 'V' 'Y')

212 THEN STATUSD = '1';

213 ELSE

214 IF DEERSSPSTAT IN ('D' 'F' 'Q' 'R') AND

215 PTRELCD = 'A' THEN STATUSD = '2';

216 ELSE

217 IF DEERSSPSTAT IN ('D' 'F' 'Q' 'R')

218 THEN STATUSD = '3';

219 ELSE

220 IF DEERSSPSTAT IN ('1' 'B' 'C' 'E' 'H'

221 'I' 'K' 'L' 'M' 'O' 'P' 'U' 'Z'

222 'W' '') /* ADDED W & BLANK PER DARIA */

223 THEN STATUSD = '3';

224 ELSE

225 STATUSD = DEERSSPSTAT;

226

227 MOS = PUT(DOS,YYMMD7.);

228 MOD = PUT(DOD,YYMMD7.);

229 MOP = PUT(DTPROC,YYMMD7.);

6 The SAS System 11:06 Thursday, February 8, 2018

230

231 RUN;

NOTE: Numeric values have been converted to character values at the places given by: (Line)Smiley SadColumn).

188:19

NOTE: The SAS System stopped processing this step because of errors.

WARNING: The data set NCTTRI.NT03 may be incomplete. When this step was stopped there were 0 observations and 23 variables.

WARNING: Data set NCTTRI.NT03 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

 

232

233 *-REMOVED TNEX CLAIMS PER DAN 07/24/2013-*;

234 *-TRIANGLE SHOULD START ON 04/11-*;

235

236 DATA &NAME..NT04;

237 SET NT03.DATA NT04PRV.DATA;

ERROR: Libref NT03 is not assigned.

ERROR: Libref NT04PRV is not assigned.

238 WHERE CONTRACT = 'T3';

239 RUN;

NOTE: The SAS System stopped processing this step because of errors.

WARNING: The data set NCTTRI.NT04 may be incomplete. When this step was stopped there were 0 observations and 0 variables.

WARNING: Data set NCTTRI.NT04 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

 

240

241 PROC PRINT DATA =NT04.DATA (OBS=10);

ERROR: Libref NT04 is not assigned.

242 TITLE1 "10 OBS FROM FACT003.A082633.NT04.NCT1801.SASS";

243 TITLE2 "ALL ADJ FOR DOS: &DATE1 - &DATE3";

244 TITLE3 "SETTLED THROUGH &DATE3";

245 TITLE4 "FACT003.ROUTINE.T3-OP8(NCT1712) - JS030";

246 RUN;

NOTE: The SAS System stopped processing this step because of errors.

NOTE: PROCEDURE PRINT used (Total process time):

real time 0.00 seconds

cpu time 0.00 seconds

 

248 *- FACT003.ROUTINE.T3-OP8(NCT1801) - JS034 -*;

249

250 *- NEED TO SPLIT FILE TO GET THE SORT TO RUN -*;

251

 

252 DATA &NAME..NT05A &NAME..NT05B &NAME..NT05C;

253 SET NT04.DATA;

ERROR: Libref NT04 is not assigned.

254

255 IF '2011-04' LE MOS LE '2013-03' THEN OUTPUT NT05A.DATA;

__________

7 The SAS System 11:06 Thursday, February 8, 2018

455

ERROR 455-185: Data set was not specified on the DATA statement.

256 ELSE

257 IF '2013-04' LE MOS LE '2015-09' THEN OUTPUT NT05B.DATA;

__________

455

ERROR 455-185: Data set was not specified on the DATA statement.

258 ELSE

259 OUTPUT NT05C.DATA;

__________

455

ERROR 455-185: Data set was not specified on the DATA statement.

260 RUN;

NOTE: The SAS System stopped processing this step because of errors.

WARNING: The data set NCTTRI.NT05A may be incomplete. When this step was stopped there were 0 observations and 1 variables.

WARNING: Data set NCTTRI.NT05A was not replaced because this step was stopped.

WARNING: The data set NCTTRI.NT05B may be incomplete. When this step was stopped there were 0 observations and 1 variables.

WARNING: Data set NCTTRI.NT05B was not replaced because this step was stopped.

WARNING: The data set NCTTRI.NT05C may be incomplete. When this step was stopped there were 0 observations and 1 variables.

WARNING: Data set NCTTRI.NT05C 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

 

261

262 PROC SORT DATA= NT05A.DATA OUT= NT05D.DATA;

ERROR: Libref NT05A is not assigned.

ERROR: Libref NT05D is not assigned.

263 BY CLMNBR CLMLN CLMADJ;

264 RUN;

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

 

265

266

267 *- FACT003.ROUTINE.T3-OP8(NCT1801) - JS035 -*;

268

 

269 PROC SORT DATA= NT05B.DATA OUT= NT05E.DATA;

ERROR: Libref NT05B is not assigned.

ERROR: Libref NT05E is not assigned.

270 BY CLMNBR CLMLN CLMADJ;

271 RUN;

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

 

8 The SAS System 11:06 Thursday, February 8, 2018

272

273

274 *- FACT003.ROUTINE.T3-OP8(NCT1801) - JS036 -*;

275

 

276 PROC SORT DATA= NT05C.DATA OUT= NT05F.DATA;

ERROR: Libref NT05C is not assigned.

ERROR: Libref NT05F is not assigned.

277 BY CLMNBR CLMLN CLMADJ;

278 RUN;

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

 

279

280

281 *- FACT003.ROUTINE.T3-OP8(NCT1801) - JS037 -*;

282

 

283 DATA &NAME..NT05G.DATA;

NOTE: Line generated by the macro variable "NAME".

283 NCTTRI

______

211

ERROR 211-185: Invalid data set name.

284 LENGTH IPOP1 $2. TYPE1 $19. STATUSC1 $5.;

285 SET NT05D.DATA;

ERROR: Libref NT05D is not assigned.

286 BY CLMNBR CLMLN CLMADJ;

287

288 RETAIN IPOP1 TYPE1 STATUSC1 STATUSD1;

289

290 IF FIRST.CLMLN THEN DO;

291 IPOP1 = IPOP;

292 TYPE1 = TYPE;

293 STATUSC1 = STATUSC;

294 STATUSD1 = STATUSD;

295 END;

296 RUN;

NOTE: The SAS System stopped processing this step because of errors.

NOTE: DATA statement used (Total process time):

real time 0.00 seconds

cpu time 0.00 seconds

 

297

298 DATA &NAME..NT05H.DATA;

NOTE: Line generated by the macro variable "NAME".

298 NCTTRI

______

211

ERROR 211-185: Invalid data set name.

9 The SAS System 11:06 Thursday, February 8, 2018

 

299 LENGTH IPOP1 $2. TYPE1 $19. STATUSC1 $5.;

300 SET NT05E.DATA;

ERROR: Libref NT05E is not assigned.

301 BY CLMNBR CLMLN CLMADJ;

302

303 RETAIN IPOP1 TYPE1 STATUSC1 STATUSD1;

304

305 IF FIRST.CLMLN THEN DO;

306 IPOP1 = IPOP;

307 TYPE1 = TYPE;

308 STATUSC1 = STATUSC;

309 STATUSD1 = STATUSD;

310 END;

311 RUN;

NOTE: The SAS System stopped processing this step because of errors.

NOTE: DATA statement used (Total process time):

real time 0.00 seconds

cpu time 0.00 seconds

 

312

313 DATA &NAME..NT05I.DATA;

NOTE: Line generated by the macro variable "NAME".

313 NCTTRI

______

211

ERROR 211-185: Invalid data set name.

314 LENGTH IPOP1 $2. TYPE1 $19. STATUSC1 $5.;

315 SET NT05F.DATA;

ERROR: Libref NT05F is not assigned.

316 BY CLMNBR CLMLN CLMADJ;

317

318 RETAIN IPOP1 TYPE1 STATUSC1 STATUSD1;

319

320 IF FIRST.CLMLN THEN DO;

321 IPOP1 = IPOP;

322 TYPE1 = TYPE;

323 STATUSC1 = STATUSC;

324 STATUSD1 = STATUSD;

325 END;

326 RUN;

NOTE: The SAS System stopped processing this step because of errors.

NOTE: DATA statement used (Total process time):

real time 0.00 seconds

cpu time 0.00 seconds

 

327

328

329

330 *- FACT003.ROUTINE.T3-OP8(NCT1801) - JS038 -*;

331

332 PROC SORT DATA= NT05G.DATA OUT= NT05J.DATA;

ERROR: Libref NT05G is not assigned.

10 The SAS System 11:06 Thursday, February 8, 2018

ERROR: Libref NT05J is not assigned.

333 BY CLMNBR CLMLN CLMADJ;

334 RUN;

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

 

335

 

336 PROC SORT DATA= NT05H.DATA OUT= NT05K.DATA;

ERROR: Libref NT05H is not assigned.

ERROR: Libref NT05K is not assigned.

337 BY CLMNBR CLMLN CLMADJ;

338 RUN;

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

 

339

 

340 PROC SORT DATA= NT05I.DATA OUT= NT05L.DATA;

ERROR: Libref NT05I is not assigned.

ERROR: Libref NT05L is not assigned.

341 BY CLMNBR CLMLN CLMADJ;

342 RUN;

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

 

343

344

345 *- FACT003.ROUTINE.T3-OP8(NCT1801) - JS039 -*;

346

 

347 DATA &NAME..NT05.DATA;

NOTE: Line generated by the macro variable "NAME".

347 NCTTRI

______

211

ERROR 211-185: Invalid data set name.

348 SET NT05J.DATA NT05K.DATA NT05L.DATA;

ERROR: Libref NT05J is not assigned.

ERROR: Libref NT05K is not assigned.

ERROR: Libref NT05L is not assigned.

349 BY CLMNBR CLMLN CLMADJ;

350

351 DROP IPOP TYPE STATUSC STATUSD;

352 RUN;

11 The SAS System 11:06 Thursday, February 8, 2018

 

NOTE: The SAS System stopped processing this step because of errors.

NOTE: DATA statement used (Total process time):

real time 0.00 seconds

cpu time 0.00 seconds

 

353

354 PROC PRINT DATA =NT05.DATA (OBS=10);

ERROR: Libref NT05 is not assigned.

355 TITLE1 "10 OBS FROM FACT003.A082633.NT05.NCT1801.SASS";

356 TITLE2 "FACT003.ROUTINE.T3-OP8(NCT1801) - JS039";

357 RUN;

NOTE: The SAS System stopped processing this step because of errors.

NOTE: PROCEDURE PRINT used (Total process time):

real time 0.00 seconds

cpu time 0.00 seconds

 

358

359 *- DO SOME FREQS -*;

360

 

361 PROC FREQ DATA=NT05.DATA;

ERROR: Libref NT05 is not assigned.

362 TABLES STATUSC1*STATUSD1 LTMATOS / MISSING;

ERROR: No data set open to look up variables.

ERROR: No data set open to look up variables.

ERROR: No data set open to look up variables.

363 TITLE1 "FROM FACT003.A082633.NT05.NCT1801.SASS";

364 RUN;

NOTE: The SAS System stopped processing this step because of errors.

NOTE: PROCEDURE FREQ used (Total process time):

real time 0.00 seconds

cpu time 0.00 seconds

 

365

366

367 *- FACT003.ROUTINE.T3-OP8(NCT1801) - JS040 -*;

368

369 *- USE ALLOWED OBSERVATIONS FOR VISIT COUNTS BECAUSE -*;

370 *- NUMBER OF SERVICES VARIABLE DOESNT WORK FOR ADJUSTMENTS -*;

371

372 *- USE MOST RECENT ADJUSTMENT FOR ADMIT COUNTS BECAUSE -*;

373 *- TEDS USE MOST CURRENT ADJUSTMENT -*;

374

375 *--------------------------*;

376 *- VISIT COUNT DERIVATION -*;

377 *--------------------------*;

378

379 *- KEEP UNDERWRITTEN LINES WHERE DELTA ALLOWED IS > $0 -*;

380

 

381 DATA &NAME..NT06.DATA;

NOTE: Line generated by the macro variable "NAME".

12 The SAS System 11:06 Thursday, February 8, 2018

381 NCTTRI

______

211

ERROR 211-185: Invalid data set name.

382 SET NT05.DATA;

ERROR: Libref NT05 is not assigned.

383

384 WHERE RISKIND = 'Y' AND DLTALLW > 0;

385

386 VSTCNT = 0;

387

388 *- CALCULATE VISIT COUNT FOR ALLOWED LINES -*;

389

390 IF HOSOPSVC = '1' THEN DELETE;

391 ELSE

392 DO;

393 IF SUBSTR(LTMATOS,2,1) IN ('G' 'B' 'M') THEN VSTCNT = 0;

394 ELSE

395 IF ('90000' LE TMAPROC LE '90580' OR

396 '90594' LE TMAPROC LE '90595' OR

397 '90599' LE TMAPROC LE '92871' OR

398 '92898' LE TMAPROC LE '94999' OR

399 '95200' LE TMAPROC LE '97799' OR

400 '98900' LE TMAPROC LE '98922' OR

401 '99150' LE TMAPROC LE '99152' OR

402 '99155' LE TMAPROC LE '99195' OR

403 '99201' LE TMAPROC LE '99539' OR

404 '99551' LE TMAPROC LE '99601' OR

405 TMAPROC IN ('90590' '97810' '97813') )

406 THEN DO;

407 IF DLTSVCS > 99 THEN VSTCNT = 99;

408 ELSE

409 VSTCNT = DLTSVCS;

410 END;

411 ELSE

412 IF '95000' LE TMAPROC LE '95199' THEN VSTCNT = 1;

413 ELSE

414 VSTCNT = 0;

415 OUTPUT NT06.DATA;

_________

455

ERROR 455-185: Data set was not specified on the DATA statement.

416 END;

417

418 KEEP CONTRACT IPOP1 TYPE1 MOS MOP VSTCNT STATUSD1 STATUSC1

419 BENEZIP HBEGDT;

420 RUN;

NOTE: Numeric values have been converted to character values at the places given by: (Line)Smiley SadColumn).

393:19

NOTE: The SAS System stopped processing this step because of errors.

NOTE: DATA statement used (Total process time):

real time 0.00 seconds

cpu time 0.00 seconds

 

13 The SAS System 11:06 Thursday, February 8, 2018

421

422 *--------------------------*;

423 *- ADMIT COUNT DERIVATION -*;

424 *--------------------------*;

425

426 *- DETERMINE WHICH LINES ARE UNDERWRITTEN & ALLOWED -*;

427 *- AT MOST RECENT ADJUSTMENT TO GET ADMIT COUNTS -*;

428 *- KEEP ONLY INPATIENT FACILITY CLAIMS TOO -*;

429

430 DATA &NAME..NT07.DATA;

NOTE: Line generated by the macro variable "NAME".

430 NCTTRI

______

211

ERROR 211-185: Invalid data set name.

431 SET NT05.DATA;

ERROR: Libref NT05 is not assigned.

432 BY CLMNBR CLMLN CLMADJ;

433

434 IF FIRST.CLMLN AND

435 HALLOW GT 0 AND

436 RISKIND='Y' AND

437 HOSOPSVC = '1' AND

438 IPOP1 = 'IP';

439

440 VSTCNT = 0;

441 ADMTCNT = 0;

442

443 RUN;

NOTE: The SAS System stopped processing this step because of errors.

NOTE: DATA statement used (Total process time):

real time 0.00 seconds

cpu time 0.00 seconds

 

444

445 *- IDENTIFY CLAIMS WITH SPECIFIED REVENUE CODES -*;

446

447 DATA &NAME..REVS;

448 SET NT07.DATA;

ERROR: Libref NT07 is not assigned.

449 IF REVCD IN ('0655' '0656') THEN OUTPUT REVS;

____

455

ERROR 455-185: Data set was not specified on the DATA statement.

450 ELSE

451 DELETE;

452 RUN;

NOTE: The SAS System stopped processing this step because of errors.

WARNING: The data set NCTTRI.REVS may be incomplete. When this step was stopped there were 0 observations and 1 variables.

WARNING: Data set NCTTRI.REVS 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 11:06 Thursday, February 8, 2018

 

453

454 PROC SORT NODUPKEY DATA=REVS (KEEP=CLMNBR);

ERROR: The variable CLMNBR in the DROP, KEEP, or RENAME list has never been referenced.

455 BY CLMNBR;

456 RUN;

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

 

457

 

458 PROC SORT DATA=NT07.DATA OUT=NT08.DATA;

ERROR: Libref NT07 is not assigned.

ERROR: Libref NT08 is not assigned.

459 BY CLMNBR;

460 RUN;

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

 

461

 

462 DATA &NAME..NT09.DATA;

NOTE: Line generated by the macro variable "NAME".

462 NCTTRI

______

211

ERROR 211-185: Invalid data set name.

463 MERGE NT08.DATA (IN=INA) REVS (IN=INB);

ERROR: Libref NT08 is not assigned.

464 BY CLMNBR;

465 IF INA;

466

467 IF INA AND INB THEN REVCHK = 'Y';

468 ELSE

469 REVCHK = 'N';

470

471 INSTTYPE = SUBSTR(PROVTXMY,1,2);

472

473 /* DEFINE ADMISSION COUNT */

474

475 IF SUPPCVDY = 0 THEN ADMTCNT = 0;

476 ELSE

477 IF INSTTYPE = '70' THEN ADMTCNT = 0;

478 ELSE

479 IF (INSTTYPE IN ('78' '79') AND

480 REVCHK = 'N') THEN ADMTCNT = 0;

481 ELSE

482 IF BILLSTAT IN ('1' '2' '7' '3' '4') THEN ADMTCNT = 1;

15 The SAS System 11:06 Thursday, February 8, 2018

483 ELSE

484 ADMTCNT = 0;

485

486 RUN;

NOTE: Numeric values have been converted to character values at the places given by: (Line)Smiley SadColumn).

471:24

NOTE: The SAS System stopped processing this step because of errors.

NOTE: DATA statement used (Total process time):

real time 0.00 seconds

cpu time 0.00 seconds

 

487

488 *- COUNT ONLY ONCE PER CLAIM -*;

489

490 PROC SORT DATA=NT09.DATA OUT=NT10.DATA;

ERROR: Libref NT09 is not assigned.

ERROR: Libref NT10 is not assigned.

491 BY CLMNBR CLMLN;

492 RUN;

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

 

493

 

494 DATA &NAME..NT11.DATA;

NOTE: Line generated by the macro variable "NAME".

494 NCTTRI

______

211

ERROR 211-185: Invalid data set name.

495 SET NT10.DATA;

ERROR: Libref NT10 is not assigned.

496 BY CLMNBR CLMLN;

497

498 IF FIRST.CLMNBR THEN ADMTCNT = ADMTCNT;

499 ELSE

500 ADMTCNT = 0;

501

502 KEEP CONTRACT IPOP1 TYPE1 MOS MOP ADMTCNT INSTTYPE STATUSD1

503 STATUSC1 BENEZIP HBEGDT;

504

505 RUN;

NOTE: The SAS System stopped processing this step because of errors.

NOTE: DATA statement used (Total process time):

real time 0.00 seconds

cpu time 0.00 seconds

 

506

507 *--------------------------*;

16 The SAS System 11:06 Thursday, February 8, 2018

508 *- PAID AMOUNT DERIVATION -*;

509 *--------------------------*;

510

511 *- KEEP DELTA PAID AMOUNTS FROM NT05 -*;

512

513 DATA &NAME..NT12.DATA;

NOTE: Line generated by the macro variable "NAME".

513 NCTTRI

______

211

ERROR 211-185: Invalid data set name.

514 SET NT05.DATA;

ERROR: Libref NT05 is not assigned.

515 WHERE RISKIND = 'Y' AND DLTPAID NE 0;

516 KEEP CONTRACT IPOP1 TYPE1 MOS MOP DLTPAID STATUSD1 STATUSC1

517 BENEZIP HBEGDT;

518 RUN;

NOTE: The SAS System stopped processing this step because of errors.

NOTE: DATA statement used (Total process time):

real time 0.00 seconds

cpu time 0.00 seconds

 

519

520

521 *- FACT003.ROUTINE.T3-OP8(NCT1801) - JS045 -*;

522

523 *- PUT FILES TOGETHER -*;

524

525 DATA &NAME..NT13.DATA;

NOTE: Line generated by the macro variable "NAME".

525 NCTTRI

______

211

ERROR 211-185: Invalid data set name.

526 SET NT06.DATA

527 (KEEP=CONTRACT IPOP1 TYPE1 MOS MOP VSTCNT STATUSD1

528 STATUSC1 BENEZIP HBEGDT)

ERROR: Libref NT06 is not assigned.

529 NT11.DATA

530 (KEEP=CONTRACT IPOP1 TYPE1 MOS MOP ADMTCNT STATUSD1

531 STATUSC1 BENEZIP HBEGDT)

ERROR: Libref NT11 is not assigned.

532 NT12.DATA

533 (KEEP=CONTRACT IPOP1 TYPE1 MOS MOP DLTPAID STATUSD1

534 STATUSC1 BENEZIP HBEGDT);

ERROR: Libref NT12 is not assigned.

535 RUN;

NOTE: The SAS System stopped processing this step because of errors.

NOTE: DATA statement used (Total process time):

real time 0.00 seconds

cpu time 0.00 seconds

 

17 The SAS System 11:06 Thursday, February 8, 2018

536

537 *- NEED TO SPLIT FILE TO GET THE SORT TO RUN -*;

538

539 DATA &NAME..NT13A &NAME..NT13B &NAME..NT13C;

540 SET NT13.DATA;

ERROR: Libref NT13 is not assigned.

541

542 IF '2011-04' LE MOS LE '2013-03' THEN OUTPUT NT13A.DATA;

__________

455

ERROR 455-185: Data set was not specified on the DATA statement.

543 ELSE

544 IF '2013-04' LE MOS LE '2015-09' THEN OUTPUT NT13B.DATA;

__________

455

ERROR 455-185: Data set was not specified on the DATA statement.

545 ELSE

546 OUTPUT NT13C.DATA;

__________

455

ERROR 455-185: Data set was not specified on the DATA statement.

547 RUN;

NOTE: The SAS System stopped processing this step because of errors.

WARNING: The data set NCTTRI.NT13A may be incomplete. When this step was stopped there were 0 observations and 1 variables.

WARNING: Data set NCTTRI.NT13A was not replaced because this step was stopped.

WARNING: The data set NCTTRI.NT13B may be incomplete. When this step was stopped there were 0 observations and 1 variables.

WARNING: Data set NCTTRI.NT13B was not replaced because this step was stopped.

WARNING: The data set NCTTRI.NT13C may be incomplete. When this step was stopped there were 0 observations and 1 variables.

WARNING: Data set NCTTRI.NT13C 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

 

548

549 PROC SORT DATA= NT13A.DATA OUT= NT13D.DATA;

ERROR: Libref NT13A is not assigned.

ERROR: Libref NT13D is not assigned.

550 BY BENEZIP HBEGDT CONTRACT IPOP1 TYPE1 MOS MOP STATUSD1

551 STATUSC1;

552 RUN;

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

 

553

 

554 PROC SORT DATA= NT13B.DATA OUT= NT13E.DATA;

ERROR: Libref NT13B is not assigned.

ERROR: Libref NT13E is not assigned.

555 BY BENEZIP HBEGDT CONTRACT IPOP1 TYPE1 MOS MOP STATUSD1

18 The SAS System 11:06 Thursday, February 8, 2018

556 STATUSC1;

557 RUN;

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

 

558

 

559 PROC SORT DATA= NT13C.DATA OUT= NT13F.DATA;

ERROR: Libref NT13C is not assigned.

ERROR: Libref NT13F is not assigned.

560 BY BENEZIP HBEGDT CONTRACT IPOP1 TYPE1 MOS MOP STATUSD1

561 STATUSC1;

562 RUN;

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

 

563

 

564 DATA &NAME..NT14;

565 SET NT13D.DATA NT13E.DATA NT13F.DATA;

ERROR: Libref NT13D is not assigned.

ERROR: Libref NT13E is not assigned.

ERROR: Libref NT13F is not assigned.

566 BY BENEZIP HBEGDT CONTRACT IPOP1 TYPE1 MOS MOP STATUSD1

567 STATUSC1;

568 RUN;

NOTE: The SAS System stopped processing this step because of errors.

WARNING: The data set NCTTRI.NT14 may be incomplete. When this step was stopped there were 0 observations and 0 variables.

WARNING: Data set NCTTRI.NT14 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

 

569

570 PROC SUMMARY NWAY MISSING DATA=NT14.DATA;

ERROR: Libref NT14 is not assigned.

571 BY BENEZIP HBEGDT CONTRACT IPOP1 TYPE1 MOS MOP STATUSD1

572 STATUSC1;

573 VAR DLTPAID VSTCNT ADMTCNT;

ERROR: No data set open to look up variables.

ERROR: No data set open to look up variables.

ERROR: No data set open to look up variables.

574 OUTPUT OUT=NT15.DATA (DROP=_TYPE_ _FREQ_) SUM=;

ERROR: Libref NT15 is not assigned.

575

576

577 *- OK TO USE THE NEW ZIP AREA ASSIGNMENT TABLE SINCE -*;

578 *- IT IS ONLY SPLIT PRIME TRANSITIONAL / OTHER -*;

19 The SAS System 11:06 Thursday, February 8, 2018

579

580 *- READ IN MARKET AREA, MARKET & AREA FROM DB2 TABLE -*;

581

NOTE: The SAS System stopped processing this step because of errors.

NOTE: PROCEDURE SUMMARY used (Total process time):

real time 0.00 seconds

cpu time 0.00 seconds

 

582 proc sql ;

583 CONNECT TO Teradata as tera (authdomain="T2017_IW_Prod" TDPID="edwfsp.fs.centene.com");

584 CREATE TABLE &NAME..ZIPAREA AS

585 SELECT * FROM CONNECTION TO tera

586 (SELECT

587 ZIP_CD AS ZIP,

588 EFCTV_DT AS STARTDT,

589 AREA_TYP_DESC AS AREATYP,

590 AREA_NAME AS AREA,

591 MRKT_NAME AS MARKET,

592 MRKT_AREA_NAME AS MKTAREA,

593 TRMNTN_DT AS ENDDT

594

595 FROM ZIP_AREA_ASGNMT

596

597 );

ERROR: Teradata prepare: Column MRKT_NAME not found in IW_PRD_AV.ZIP_AREA_ASGNMT. SQL statement was: SELECT ZIP_CD AS ZIP, EFCTV_DT

AS STARTDT, AREA_TYP_DESC AS AREATYP, AREA_NAME AS AREA, MRKT_NAME AS MARKET, MRKT_AREA_NAME AS MKTAREA, TRMNTN_DT AS ENDDT

FROM ZIP_AREA_ASGNMT.

NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements.

598

599 %PUT &SQLXMSG &SQLXRC;

Column MRKT_NAME not found in IW_PRD_AV.ZIP_AREA_ASGNMT 5628

600

NOTE: The SAS System stopped processing this step because of errors.

NOTE: PROCEDURE SQL used (Total process time):

real time 0.08 seconds

cpu time 0.01 seconds

 

601 PROC SORT NODUPKEY DATA=ZIPAREA OUT=ZIPAREA.DATA;

ERROR: File WORK.ZIPAREA.DATA does not exist.

ERROR: Libref ZIPAREA is not assigned.

602 BY ZIP STARTDT ENDDT;

603 RUN;

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

 

604

605 *- NEED TO SPLIT FILE TO GET THE MERGE TO RUN -*;

606

 

607 DATA &NAME..NT16 &NAME..NT17 &NAME..NT18 &NAME..NT24 &NAME..NT26;

608 SET NT15.DATA;

20 The SAS System 11:06 Thursday, February 8, 2018

ERROR: Libref NT15 is not assigned.

609

610 IF MOP LE '2012-12' THEN OUTPUT NT16.DATA;

_________

455

ERROR 455-185: Data set was not specified on the DATA statement.

611 ELSE

612 IF MOP LE '2013-12' THEN OUTPUT NT17.DATA;

_________

455

ERROR 455-185: Data set was not specified on the DATA statement.

613 ELSE

614 IF MOP LE '2014-12' THEN OUTPUT NT18.DATA;

_________

455

ERROR 455-185: Data set was not specified on the DATA statement.

615 ELSE

616 IF MOP LE '2015-12' THEN OUTPUT NT24.DATA;

_________

455

ERROR 455-185: Data set was not specified on the DATA statement.

617 ELSE

618 OUTPUT NT26.DATA;

_________

455

ERROR 455-185: Data set was not specified on the DATA statement.

619 RUN;

NOTE: The SAS System stopped processing this step because of errors.

WARNING: The data set NCTTRI.NT16 may be incomplete. When this step was stopped there were 0 observations and 1 variables.

WARNING: Data set NCTTRI.NT16 was not replaced because this step was stopped.

WARNING: The data set NCTTRI.NT17 may be incomplete. When this step was stopped there were 0 observations and 1 variables.

WARNING: Data set NCTTRI.NT17 was not replaced because this step was stopped.

WARNING: The data set NCTTRI.NT18 may be incomplete. When this step was stopped there were 0 observations and 1 variables.

WARNING: Data set NCTTRI.NT18 was not replaced because this step was stopped.

WARNING: The data set NCTTRI.NT24 may be incomplete. When this step was stopped there were 0 observations and 1 variables.

WARNING: Data set NCTTRI.NT24 was not replaced because this step was stopped.

WARNING: The data set NCTTRI.NT26 may be incomplete. When this step was stopped there were 0 observations and 1 variables.

WARNING: Data set NCTTRI.NT26 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

 

620

621 PROC SQL;

622 CREATE TABLE &NAME..NT19 (SORTEDBY=_NULL_) AS

623 SELECT A.*, B.MKTAREA, B.MARKET, B.AREA, B.AREATYP

624 FROM NT16.DATA AS A LEFT JOIN ZIPAREA.DATA AS B

625 ON A.BENEZIP = B.ZIP AND

626 B.STARTDT LE A.HBEGDT LE B.ENDDT;

ERROR: Libref NT16 is not assigned.

ERROR: Libref ZIPAREA is not assigned.

21 The SAS System 11:06 Thursday, February 8, 2018

NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements.

627

NOTE: The SAS System stopped processing this step because of errors.

NOTE: PROCEDURE SQL used (Total process time):

real time 0.00 seconds

cpu time 0.00 seconds

 

628 PROC SQL;

629 CREATE TABLE &NAME..NT20 (SORTEDBY=_NULL_) AS

630 SELECT A.*, B.MKTAREA, B.MARKET, B.AREA, B.AREATYP

631 FROM NT17.DATA AS A LEFT JOIN ZIPAREA.DATA AS B

632 ON A.BENEZIP = B.ZIP AND

633 B.STARTDT LE A.HBEGDT LE B.ENDDT;

ERROR: Libref NT17 is not assigned.

ERROR: Libref ZIPAREA is not assigned.

NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements.

634

NOTE: The SAS System stopped processing this step because of errors.

NOTE: PROCEDURE SQL used (Total process time):

real time 0.00 seconds

cpu time 0.00 seconds

 

635 PROC SQL;

636 CREATE TABLE &NAME..NT21 (SORTEDBY=_NULL_) AS

637 SELECT A.*, B.MKTAREA, B.MARKET, B.AREA, B.AREATYP

638 FROM NT18.DATA AS A LEFT JOIN ZIPAREA.DATA AS B

639 ON A.BENEZIP = B.ZIP AND

640 B.STARTDT LE A.HBEGDT LE B.ENDDT;

ERROR: Libref NT18 is not assigned.

ERROR: Libref ZIPAREA is not assigned.

NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements.

641

NOTE: The SAS System stopped processing this step because of errors.

NOTE: PROCEDURE SQL used (Total process time):

real time 0.00 seconds

cpu time 0.00 seconds

 

642 PROC SQL;

643 CREATE TABLE &NAME..NT25 (SORTEDBY=_NULL_) AS

644 SELECT A.*, B.MKTAREA, B.MARKET, B.AREA, B.AREATYP

645 FROM NT24.DATA AS A LEFT JOIN ZIPAREA.DATA AS B

646 ON A.BENEZIP = B.ZIP AND

647 B.STARTDT LE A.HBEGDT LE B.ENDDT;

ERROR: Libref NT24 is not assigned.

ERROR: Libref ZIPAREA is not assigned.

NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements.

648

NOTE: The SAS System stopped processing this step because of errors.

NOTE: PROCEDURE SQL used (Total process time):

real time 0.00 seconds

cpu time 0.00 seconds

 

649 PROC SQL;

650 CREATE TABLE &NAME..NT27 (SORTEDBY=_NULL_) AS

22 The SAS System 11:06 Thursday, February 8, 2018

651 SELECT A.*, B.MKTAREA, B.MARKET, B.AREA, B.AREATYP

652 FROM NT26.DATA AS A LEFT JOIN ZIPAREA.DATA AS B

653 ON A.BENEZIP = B.ZIP AND

654 B.STARTDT LE A.HBEGDT LE B.ENDDT;

ERROR: Libref NT26 is not assigned.

ERROR: Libref ZIPAREA is not assigned.

NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements.

655

NOTE: The SAS System stopped processing this step because of errors.

NOTE: PROCEDURE SQL used (Total process time):

real time 0.00 seconds

cpu time 0.00 seconds

 

656 DATA &NAME..NT22;

657 LENGTH AREATYPE $22. FC $15.;

658 SET NT19.DATA NT20.DATA NT21.DATA NT25.DATA NT27.DATA;

ERROR: Libref NT19 is not assigned.

ERROR: Libref NT20 is not assigned.

ERROR: Libref NT21 is not assigned.

ERROR: Libref NT25 is not assigned.

ERROR: Libref NT27 is not assigned.

659

660 IF UPCASE(TRIM(AREATYP)) = 'PRIME TRANSITIONAL' THEN

661 AREATYPE = 'PRIME TRANSITIONAL';

662 ELSE

663 AREATYPE = 'NOT PRIME TRANSITIONAL';

664

665 IF UPCASE(TRIM(MARKET)) = 'FT CAMPBELL' THEN /**FT CAMPBELL CAN BE REMOVED FOR T2017**/

666 FC = 'FT CAMPBELL';

667 ELSE

668 FC = 'NOT FT CAMPBELL';

669

670 RUN;

NOTE: Numeric values have been converted to character values at the places given by: (Line)Smiley SadColumn).

660:22 665:22

NOTE: The SAS System stopped processing this step because of errors.

WARNING: The data set NCTTRI.NT22 may be incomplete. When this step was stopped there were 0 observations and 4 variables.

WARNING: Data set NCTTRI.NT22 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

 

671

672 *-REMOVED AREATYPE FROM OUTPUT PER DAN 07/24/2013-*;

673 *-PRIME TRANSITIONAL-*;

674

675 PROC SUMMARY NWAY MISSING DATA=NT22.DATA;

ERROR: Libref NT22 is not assigned.

676 CLASS CONTRACT IPOP1 TYPE1 MOS MOP STATUSD1 STATUSC1 FC;

ERROR: No data set open to look up variables.

ERROR: No data set open to look up variables.

ERROR: No data set open to look up variables.

ERROR: No data set open to look up variables.

ERROR: No data set open to look up variables.

ERROR: No data set open to look up variables.

23 The SAS System 11:06 Thursday, February 8, 2018

ERROR: No data set open to look up variables.

ERROR: No data set open to look up variables.

677 VAR DLTPAID VSTCNT ADMTCNT;

ERROR: No data set open to look up variables.

ERROR: No data set open to look up variables.

ERROR: No data set open to look up variables.

678 OUTPUT OUT=NT23.DATA (DROP=_TYPE_ _FREQ_) SUM=;

ERROR: Libref NT23 is not assigned.

679

NOTE: The SAS System stopped processing this step because of errors.

NOTE: PROCEDURE SUMMARY used (Total process time):

real time 0.00 seconds

cpu time 0.00 seconds

 

680 DATA _NULL_;

681 SET NT23.DATA;

ERROR: Libref NT23 is not assigned.

682 WHERE MOS GE '2011-04';

683 FILE NTO1 LS=200;

684

685 PUT CONTRACT +(-1)'$'

686 IPOP1 +(-1)'$'

687 TYPE1 +(-1)'$'

688 MOS +(-1)'$'

689 MOP +(-1)'$'

690 STATUSD1 +(-1)'$'

691 STATUSC1 +(-1)'$'

692 DLTPAID +(-1)'$'

693 VSTCNT +(-1)'$'

694 ADMTCNT +(-1)'$'

695 FC +(-1)'$';

696 RUN;

NOTE: The SAS System stopped processing this step because of errors.

NOTE: DATA statement used (Total process time):

real time 0.00 seconds

cpu time 0.01 seconds

 

697

698

699

700 GOPTIONS NOACCESSIBLE;

701 %LET _CLIENTTASKLABEL=;

702 %LET _CLIENTPROCESSFLOWNAME=;

703 %LET _CLIENTPROJECTPATH=;

704 %LET _CLIENTPROJECTNAME=;

705 %LET _SASPROGRAMFILE=;

706

707 ;*';*";*/;quit;run;

708 ODS _ALL_ CLOSE;

709

710

711 QUIT; RUN;

712


Ask a Question
Discussion stats
  • 1 reply
  • 142 views
  • 0 likes
  • 2 in conversation