DATA Step, Macro, Functions and more

ERROR Message Regarding a Variable "ACKEY"

Accepted Solution Solved
Reply
Contributor
Posts: 37
Accepted Solution

ERROR Message Regarding a Variable "ACKEY"

1           OPTIONS LS=250 NOCENTER PS=32000 NOLABEL MSGLEVEL=I MPRINT MLOGIC;  
2                                                                               
3           ***************************************************************;    
4           ** JS020: PROCESS DATA.                                      **;    
5           ***************************************************************;    
6                                                                               
7             ** DEFINE REPORTING PERIOD **;                                    
8             %LET STARTDT = '01APR2017'D; ** FIRST DAY IN REPORTING QUARTER **;
9             %LET ENDDT   = '23JUN2017'D; ** LAST DAY IN REPORTING QUARTER  **;
10                                                                              
11          ***************************************************************;    
12          ** DEFINE ADDITIONAL AUTHORIZATION VARIABLES.                **;    
13          ***************************************************************;    
14                                                                              
15            DATA MMS1 (DROP=AFROMDATE ATODATE ASTARTPROC AENDPROC             
16                            RFROMDATE RTODATE RSTARTPROC RENDPROC             
17                            MEMBERID );                                       
18              SET MMS.DATA;                                                   
19                                                                              
20              FORMAT EDIPN $10.;                                              
21              IF SUBSTR(MEMBERID,11,1) = "-"                                  
22                 THEN EDIPN = SUBSTR(MEMBERID,1,10);                          
23                 ELSE EDIPN = "";                                             
24              LASTNAME  = UPCASE(LASTNAME);                                   
25              FIRSTNAME = UPCASE(FIRSTNAME);                                  
26                                                                              
27              ** DEFINE DATES, SERVICES **;                                   
28              FORMAT SERVICEFROMDATE DATE9.                    
29                     SERVICETODATE   DATE9.;                   
30              IF TRIM(CURRENTSTATUS) = "A1" THEN DO;           
31                  SERVICEFROMDATE = AFROMDATE;                 
32                  SERVICETODATE   = ATODATE;                   
33                  STARTPROCCODE   = ASTARTPROC;                
34                  ENDPROCCODE     = AENDPROC;                  
35                  END;                                                        
36              ELSE DO;                                                        
37                  SERVICEFROMDATE = RFROMDATE;                                
38                  SERVICETODATE   = RTODATE;                                  
39                  STARTPROCCODE   = RSTARTPROC;                               
40                  ENDPROCCODE     = RENDPROC;                                 
41                  END;                                                        
42            RUN;                                                              
                                                                                
NOTE: THERE WERE 233834 OBSERVATIONS READ FROM THE DATA SET MMS.DATA.           
NOTE: THE DATA SET WORK.MMS1 HAS 233834 OBSERVATIONS AND 15 VARIABLES.          
NOTE: THE DATA STATEMENT USED 0.36 CPU SECONDS AND 14539K.                      
                                                                                
NOTE: THE ADDRESS SPACE HAS USED A MAXIMUM OF 636K BELOW THE LINE AND 14984K ABO
                                                                                
                                                                                
43                                                                              
44          ***************************************************************;    
45          ** REMOVE DUPLICATES                                         **;    
46          ***************************************************************;    
47                                                                              
48            PROC SORT DATA=MMS1 OUT=MMS2 NODUPKEY;                            
49              BY AUTHNUM CHCSORDERNUM CURRENTSTATUS CLOSEDATE EDIPN           
50                 EDIPN SPONSORSSN LASTNAME FIRSTNAME PATIENTDOB STATE         
51                 SERVICESTATUS SERVICEFROMDATE SERVICETODATE                  
52                 STARTPROCCODE ENDPROCCODE;                                   
53            RUN;                                                              
NOTE: DUPLICATE BY VARIABLE(S) SPECIFIED. DUPLICATES WILL BE IGNORED.           
NOTE: HOST SORT WAS USED.                                                       
NOTE: 91890 OBSERVATIONS WITH DUPLICATE KEY VALUES WERE DELETED.                
NOTE: THERE WERE 233834 OBSERVATIONS READ FROM THE DATA SET WORK.MMS1.          
NOTE: THE DATA SET WORK.MMS2 HAS 141944 OBSERVATIONS AND 15 VARIABLES.          
NOTE: THE PROCEDURE SORT USED 0.69 CPU SECONDS AND 14898K.                      
                                                                                
NOTE: THE ADDRESS SPACE HAS USED A MAXIMUM OF 1640K BELOW THE LINE AND 21444K AB
                                                                                
                                                                                
54                                                                              
55          ***************************************************************;    
56          ** LIMIT DATA TO INITIAL ASSESSMENTS (CODE 0359T ONLY).      **;    
57          ***************************************************************;    
58                                                                              
59            DATA ASSESS (KEEP=AUTHNUM)                                        
60                 OTHER  (KEEP=AUTHNUM);                                       
61              SET MMS2;                                                       
62              IF TRIM(STARTPROCCODE) = '0359T'                                
63                 OR TRIM(ENDPROCCODE) = '0359T' THEN OUTPUT ASSESS;           
64                                                ELSE OUTPUT OTHER;            
65            RUN;                                                              
                                                                                
NOTE: THERE WERE 141944 OBSERVATIONS READ FROM THE DATA SET WORK.MMS2.          
NOTE: THE DATA SET WORK.ASSESS HAS 34771 OBSERVATIONS AND 1 VARIABLES.          
NOTE: THE DATA SET WORK.OTHER HAS 107173 OBSERVATIONS AND 1 VARIABLES.          
NOTE: THE DATA STATEMENT USED 0.09 CPU SECONDS AND 15282K.                      
NOTE: THE ADDRESS SPACE HAS USED A MAXIMUM OF 1640K BELOW THE LINE AND 21444K AB
                                                                                
                                                                                
66                                                                              
67            PROC SQL;                                                         
68              CREATE TABLE MMS3 AS                                            
69                SELECT DISTINCT A.*                                           
70                FROM MMS2 AS A                                                
71                  INNER JOIN ASSESS AS B ON A.AUTHNUM = B.AUTHNUM             
72                  LEFT JOIN  OTHER  AS C ON A.AUTHNUM = C.AUTHNUM             
73                WHERE C.AUTHNUM IS NULL;                                      
NOTE: TABLE WORK.MMS3 CREATED, WITH 7286 ROWS AND 15 COLUMNS.                   
                                                                                
74            QUIT;                                                             
NOTE: THE PROCEDURE SQL USED 0.86 CPU SECONDS AND 22906K.                       
                                                                                
NOTE: THE ADDRESS SPACE HAS USED A MAXIMUM OF 1640K BELOW THE LINE AND 23372K AB
                                                                                
                                                                                
75                                                                              
76          ***************************************************************;    
77          ** LIMIT INITIAL ASSESSMENTS TO BENEFICIARIES NEW TO ABA     **;    
78          ** PROGRAM, AND ACTIVE IN REPORTING QUARTER.                 **;    
79          ***************************************************************;    
80                                                                              
81            ** PRIOR CERTIFIED IN TOTAL AUTHORIZATION FOR ABA SERVICES **;    
82            PROC SORT DATA=MMS2                                               
83                      OUT=PRIOR (KEEP=EDIPN)                                  
84                      NODUPKEY;                                               
85              WHERE SERVICEFROMDATE < &STARTDT                                
86                    AND TRIM(CURRENTSTATUS) = "A1";                           
87              BY EDIPN;                                                       
88            RUN;                                                              
                                                                                
NOTE: HOST SORT WAS USED.                                                       
NOTE: 56172 OBSERVATIONS WITH DUPLICATE KEY VALUES WERE DELETED.                
NOTE: THERE WERE 62619 OBSERVATIONS READ FROM THE DATA SET WORK.MMS2.           
      WHERE (SERVICEFROMDATE<'01APR2017'D) AND (TRIM(CURRENTSTATUS)='A1');      
NOTE: THE DATA SET WORK.PRIOR HAS 6447 OBSERVATIONS AND 1 VARIABLES.            
NOTE: THE PROCEDURE SORT USED 0.22 CPU SECONDS AND 15755K.                      
                                                                                
NOTE: THE ADDRESS SPACE HAS USED A MAXIMUM OF 1640K BELOW THE LINE AND 23372K AB
                                                                                
                                                                                
89                                                                              
90            ** FILTER AND SORT CURRENT QUARTER **;                            
91            PROC SORT DATA=MMS3 OUT=MMS4;                                     
92              BY EDIPN ;                                                      
93                                                                              
94              ** DATES WITHIN REPORTING RANGE **;                             
95              WHERE (SERVICEFROMDATE BETWEEN &STARTDT AND &ENDDT)             
96                    OR (SERVICETODATE >= &STARTDT                             
97                        AND SERVICETODATE < '31DEC9999'D);                    
98            RUN;                                                              
                                                                                
NOTE: THERE WERE 1651 OBSERVATIONS READ FROM THE DATA SET WORK.MMS3.            
      WHERE (SERVICEFROMDATE>='01APR2017'D AND SERVICEFROMDATE<='23JUN2017'D) OR
NOTE: SAS SORT WAS USED.                                                        
NOTE: THE DATA SET WORK.MMS4 HAS 1651 OBSERVATIONS AND 15 VARIABLES.            
NOTE: THE PROCEDURE SORT USED 0.01 CPU SECONDS AND 16267K.                      
                                                                                
NOTE: THE ADDRESS SPACE HAS USED A MAXIMUM OF 1640K BELOW THE LINE AND 23372K AB
                                                                                
                                                                                
99                                                                              
100           ** MARK BENES AS NEW THEY MEET ALL OF THE FOLLOWING CRITERIA **;  
101           **    NO CERTIFIED IN TOTAL ABA AUTH IN PRIOR MONTHS.        **;  
102           **    FIRST ASSESSMENT AUTH ACTIVE IN CURRENT QUARTER.       **;  
103           ** WILL LATER FILTER TO FIRST ASSESSMENT FOR NEW BENES.      **;  
104           DATA MMS5;                                                        
105             MERGE MMS4  (IN=CUR)                                            
106                   PRIOR (IN=OLD);                                           
107             BY EDIPN;                                                       
108             IF CUR;                                                         
109             IF OLD THEN FILTER = "1 EXISTING";                              
110             ELSE IF TRIM(CURRENTSTATUS) IN ('A1','A4')                      
111                  THEN FILTER = "2 KEEP";                                    
112             ELSE FILTER = "3 OTHER";                                        
113           RUN;                                                              
                                                                                
NOTE: THERE WERE 1651 OBSERVATIONS READ FROM THE DATA SET WORK.MMS4.            
NOTE: THERE WERE 6447 OBSERVATIONS READ FROM THE DATA SET WORK.PRIOR.           
NOTE: THE DATA SET WORK.MMS5 HAS 1651 OBSERVATIONS AND 16 VARIABLES.            
NOTE: THE DATA STATEMENT USED 0.01 CPU SECONDS AND 16267K.                      
NOTE: THE ADDRESS SPACE HAS USED A MAXIMUM OF 1640K BELOW THE LINE AND 23372K AB
                                                                                
                                                                                
114                                                                             
115           PROC SORT DATA=MMS5 OUT=MMS6;                                     
116             BY EDIPN FILTER SERVICEFROMDATE SERVICETODATE;                  
117           RUN;                                                              
                                                                                
NOTE: THERE WERE 1651 OBSERVATIONS READ FROM THE DATA SET WORK.MMS5.            
NOTE: SAS SORT WAS USED.                                                        
NOTE: THE DATA SET WORK.MMS6 HAS 1651 OBSERVATIONS AND 16 VARIABLES.            
NOTE: THE PROCEDURE SORT USED 0.00 CPU SECONDS AND 16395K.                      
                                                                                
NOTE: THE ADDRESS SPACE HAS USED A MAXIMUM OF 1640K BELOW THE LINE AND 23372K AB
                                                                                
                                                                                
118                                                                             
119           ** NOW THAT DATA IS SORTED BY BENE/DATE, LIMIT TO FIRST **;       
120           ** ASSESSMENT FOR NEW BENEFICIARIES.                    **;       
121           DATA MMS7;                                                        
122             SET MMS6;                                                       
123             BY EDIPN FILTER SERVICEFROMDATE SERVICETODATE;                  
124             IF FIRST.EDIPN                                                  
125               AND TRIM(FILTER) = "2 KEEP";                                  
126           RUN;                                                              
                                                                                
NOTE: THERE WERE 1651 OBSERVATIONS READ FROM THE DATA SET WORK.MMS6.            
NOTE: THE DATA SET WORK.MMS7 HAS 387 OBSERVATIONS AND 16 VARIABLES.             
NOTE: THE DATA STATEMENT USED 0.00 CPU SECONDS AND 16395K.                      
                                                                                
NOTE: THE ADDRESS SPACE HAS USED A MAXIMUM OF 1640K BELOW THE LINE AND 23372K AB
                                                                                
                                                                                
127                                                                             
128         ***************************************************************;    
129         ** PROCESS CLAIMS TO DETERMINE CLAIM DATE OF INITIAL         **;    
130         ** ASSESSMENT AND FIRST CLAIM DATE OF TREATMENT.             **;    
131         ***************************************************************;    
132                                                                             
133           ** KEEP LAST ADJUSTMENT FOR EACH CLAIM LINE **;                   
134           DATA CLAIM1;                                                      
135             SET NINST.DATA;                                                 
136             KEY = CLAIMBASEID !! CLAIMLINEID;                               
137           RUN;                                                              
                                                                                
NOTE: THERE WERE 576471 OBSERVATIONS READ FROM THE DATA SET NINST.DATA.         
NOTE: THE DATA SET WORK.CLAIM1 HAS 576471 OBSERVATIONS AND 9 VARIABLES.         
NOTE: THE DATA STATEMENT USED 0.33 CPU SECONDS AND 16395K.                      
                                                                                
NOTE: THE ADDRESS SPACE HAS USED A MAXIMUM OF 1640K BELOW THE LINE AND 23372K AB
                                                                                
                                                                                
138                                                                             
139           PROC SORT DATA=CLAIM1 OUT=CLAIM2;                                 
140             BY KEY CLAIMADJID;                                              
141           RUN;                                                              
                                                                                
NOTE: HOST SORT WAS USED.                                                       
NOTE: THERE WERE 576471 OBSERVATIONS READ FROM THE DATA SET WORK.CLAIM1.        
NOTE: THE DATA SET WORK.CLAIM2 HAS 576471 OBSERVATIONS AND 9 VARIABLES.         
NOTE: THE PROCEDURE SORT USED 0.76 CPU SECONDS AND 68107K.                      
                                                                                
NOTE: THE ADDRESS SPACE HAS USED A MAXIMUM OF 2640K BELOW THE LINE AND 74668K AB
                                                                                
                                                                                
142                                                                             
143           DATA CLAIM3;                                                      
144             SET CLAIM2;                                                     
145             BY KEY CLAIMADJID;                                              
146             IF FIRST.KEY                                                    
147                AND CLMBEGINDATE >= &STARTDT                                 
148                AND ALLOWEDAMT > 0                                           
149                AND CPTCODE IN ('0359T','0360T','0361T','0364T',             
150                                '0365T','0368T','0369T','0370T');            
151                                                                             
152           RUN;                                                              
                                                                                
NOTE: THERE WERE 576471 OBSERVATIONS READ FROM THE DATA SET WORK.CLAIM2.        
NOTE: THE DATA SET WORK.CLAIM3 HAS 135941 OBSERVATIONS AND 9 VARIABLES.         
NOTE: THE DATA STATEMENT USED 0.69 CPU SECONDS AND 16139K.                      
                                                                                
NOTE: THE ADDRESS SPACE HAS USED A MAXIMUM OF 2640K BELOW THE LINE AND 74668K AB
                                                                                
153                                                                             
154           ** LIMIT DATA TO ONLY BENES WITH CERTIFIED IN TOTAL AUTHS **;     
155           ** RUNNING INTO SIZE CONSTRAINTS.                         **;     
156           PROC SORT DATA=CLAIM3 OUT=CLAIM4; BY EDIPN; RUN;                  
                                                                                
NOTE: HOST SORT WAS USED.                                                       
NOTE: THERE WERE 135941 OBSERVATIONS READ FROM THE DATA SET WORK.CLAIM3.        
NOTE: THE DATA SET WORK.CLAIM4 HAS 135941 OBSERVATIONS AND 9 VARIABLES.         
NOTE: THE PROCEDURE SORT USED 0.22 CPU SECONDS AND 16139K.                      
                                                                                
NOTE: THE ADDRESS SPACE HAS USED A MAXIMUM OF 2640K BELOW THE LINE AND 74668K AB
                                                                                
                                                                                
157           PROC SORT DATA=MMS7 OUT=BENENODUP (KEEP=EDIPN) NODUPKEY;          
158             WHERE TRIM(CURRENTSTATUS) = "A1";                               
159             BY EDIPN;                                                       
160           RUN;                                                              
                                                                                
NOTE: THERE WERE 237 OBSERVATIONS READ FROM THE DATA SET WORK.MMS7.             
      WHERE TRIM(CURRENTSTATUS)='A1';                                           
NOTE: SAS SORT WAS USED.                                                        
NOTE: 0 OBSERVATIONS WITH DUPLICATE KEY VALUES WERE DELETED.                    
NOTE: THE DATA SET WORK.BENENODUP HAS 237 OBSERVATIONS AND 1 VARIABLES.         
NOTE: THE PROCEDURE SORT USED 0.00 CPU SECONDS AND 16139K.                      
                                                                                
NOTE: THE ADDRESS SPACE HAS USED A MAXIMUM OF 2640K BELOW THE LINE AND 74668K AB
                                                                                
161                                                                             
162           DATA ASSESS ONGOING;                                              
163             MERGE CLAIM4    (IN=CLM)                                        
164                   BENENODUP (IN=AUTH KEEP=EDIPN);                           
165             BY EDIPN;                                                       
166             IF CLM AND AUTH;                                                
167                                                                             
168             IF CPTCODE = '0359T' THEN OUTPUT ASSESS;                        
169             ELSE IF CPTCODE IN ('0360T','0361T','0364T','0365T',            
170                                 '0368T','0369T','0370T')                    
171                                  THEN OUTPUT ONGOING;                       
172           RUN;                                                              
                                                                                
NOTE: THERE WERE 135941 OBSERVATIONS READ FROM THE DATA SET WORK.CLAIM4.        
NOTE: THERE WERE 237 OBSERVATIONS READ FROM THE DATA SET WORK.BENENODUP.        
NOTE: THE DATA SET WORK.ASSESS HAS 68 OBSERVATIONS AND 9 VARIABLES.             
NOTE: THE DATA SET WORK.ONGOING HAS 335 OBSERVATIONS AND 9 VARIABLES.           
NOTE: THE DATA STATEMENT USED 0.12 CPU SECONDS AND 16139K.                      
                                                                                
NOTE: THE ADDRESS SPACE HAS USED A MAXIMUM OF 2640K BELOW THE LINE AND 74668K AB
                                                                                
                                                                                
173                                                                             
174           PROC SQL;                                                         
175             CREATE TABLE MMS8 AS                                            
176               SELECT                                                        
177                 A.ACKEY,                                                    
178                 A.AUTHNUM,                                                  
179                 A.CHCSORDERNUM,                                             
180                 A.CURRENTSTATUS,                                            
181                 A.CLOSEDATE,                                                
182                 A.EDIPN,                                                    
183                 A.SPONSORSSN,                                               
184                 A.LASTNAME,                                                 
185                 A.FIRSTNAME,                                                
186                 A.PATIENTDOB,                                               
187                 A.STATE,                                                    
188                 A.SERVICEFROMDATE,                                          
189                 A.SERVICETODATE,                                            
190                 A.STARTPROCCODE,                                            
191                 A.ENDPROCCODE,                                              
192                 A.SERVICESTATUS,                                            
193                 MIN(B.CLMBEGINDATE) AS CLMASSESSDATE,                       
194                 MIN(C.CLMBEGINDATE) AS CLMTREATDATE                         
195               FROM MMS7 AS A                                                
196                 LEFT JOIN ASSESS AS B                                       
197                   ON (TRIM(A.EDIPN) = TRIM(B.EDIPN)                         
198                       AND A.SERVICEFROMDATE <= B.CLMBEGINDATE)              
199                 LEFT JOIN ONGOING AS C                                      
200                   ON (TRIM(A.EDIPN) = TRIM(C.EDIPN)                         
201                       AND A.SERVICEFROMDATE <= C.CLMBEGINDATE)              
202               GROUP BY                                                      
203                 A.ACKEY,                                                    
204                 A.AUTHNUM,                                                  
205                 A.CHCSORDERNUM,                                             
206                 A.CURRENTSTATUS,                                            
207                 A.CLOSEDATE,                                                
208                 A.EDIPN,                                                    
209                 A.SPONSORSSN,                                               
210                 A.LASTNAME,                                                 
211                 A.FIRSTNAME,                                                
212                 A.PATIENTDOB,                                               
213                 A.STATE,                                                    
214                 A.SERVICEFROMDATE,                                          
215                 A.SERVICETODATE,                                            
216                 A.STARTPROCCODE,                                            
217                 A.ENDPROCCODE,                                              
218                 A.SERVICESTATUS;                                            
ERROR: COLUMN ACKEY COULD NOT BE FOUND IN THE TABLE/VIEW IDENTIFIED WITH THE COR
ERROR: COLUMN ACKEY COULD NOT BE FOUND IN THE TABLE/VIEW IDENTIFIED WITH THE COR
ERROR: COLUMN ACKEY COULD NOT BE FOUND IN THE TABLE/VIEW IDENTIFIED WITH THE COR
ERROR: COLUMN ACKEY COULD NOT BE FOUND IN THE TABLE/VIEW IDENTIFIED WITH THE COR
ERROR: COLUMN ACKEY COULD NOT BE FOUND IN THE TABLE/VIEW IDENTIFIED WITH THE COR
ERROR: COLUMN ACKEY COULD NOT BE FOUND IN THE TABLE/VIEW IDENTIFIED WITH THE COR
NOTE: PROC SQL SET OPTION NOEXEC AND WILL CONTINUE TO CHECK THE SYNTAX OF STATEM
219           QUIT;                                                             
NOTE: THE SAS SYSTEM STOPPED PROCESSING THIS STEP BECAUSE OF ERRORS.            
NOTE: THE PROCEDURE SQL USED 0.00 CPU SECONDS AND 16139K.                       
                                                                                
NOTE: THE ADDRESS SPACE HAS USED A MAXIMUM OF 2640K BELOW THE LINE AND 74668K AB
                                                                                
220                                                                             
221           DATA DETAIL.DATA;                                                 
222             SET MMS8;                                                       
ERROR: FILE WORK.MMS8.DATA DOES NOT EXIST.                                      
ERROR: FILE WORK.MMS8.DATA DOES NOT EXIST.                                      
ERROR: FILE WORK.MMS8.DATA DOES NOT EXIST.                                      
223             FORMAT CLMASSESSDATE DATE9.                                     
224                    CLMTREATDATE  DATE9.;                                    
225             IF CLMASSESSDATE >= &STARTDT AND CLMASSESSDATE < TODAY()        
226               THEN DAYSTOASSESS = CLMASSESSDATE - SERVICEFROMDATE;          
227             IF CLMTREATDATE >= &STARTDT AND CLMTREATDATE < TODAY()          
228               THEN DAYSTOTREAT = CLMTREATDATE - SERVICEFROMDATE;            
229           RUN;                                                              
                                                                                
NOTE: THE SAS SYSTEM STOPPED PROCESSING THIS STEP BECAUSE OF ERRORS.            
NOTE: SAS SET OPTION OBS=0 AND WILL CONTINUE TO CHECK STATEMENTS. THIS MAY CAUSE
WARNING: THE DATA SET DETAIL.DATA MAY BE INCOMPLETE.  WHEN THIS STEP WAS STOPPED
NOTE: THE DATA STATEMENT USED 0.01 CPU SECONDS AND 16139K.                      
                                                                                
NOTE: THE ADDRESS SPACE HAS USED A MAXIMUM OF 2640K BELOW THE LINE AND 74668K AB
                                                                                
                                                                                
                                                                                
230                                                                             
231           PROC SORT DATA=DETAIL.DATA OUT=FINAL NODUPKEY;                    
232             BY AUTHNUM;                                                     
ERROR: VARIABLE AUTHNUM NOT FOUND.                                              
ERROR: VARIABLE AUTHNUM NOT FOUND.                                              
ERROR: VARIABLE AUTHNUM NOT FOUND.                                              
233           RUN;                                                              
                                                                                
NOTE: THE SAS SYSTEM STOPPED PROCESSING THIS STEP BECAUSE OF ERRORS.            
WARNING: THE DATA SET WORK.FINAL MAY BE INCOMPLETE.  WHEN THIS STEP WAS STOPPED 
NOTE: THE PROCEDURE SORT USED 0.00 CPU SECONDS AND 16139K.                      
                                                                                
NOTE: THE ADDRESS SPACE HAS USED A MAXIMUM OF 2640K BELOW THE LINE AND 74668K AB
                                                                                
234                                                                             
235         ***************************************************************;    
236         **    THE AVERAGE AND MEDIAN NUMBER OF DAYS FROM THE FIRST   **;    
237         **    ISSUED AUTHORIZATION (BENEFICIARY NEW TO THE ACD) TO   **;    
238         **    CLAIM DATE OF INITIAL ASSESSMENT (0359T).              **;    
239         **    CERTIFIED IN TOTAL AUTHORIZATIONS ONLY.                **;    
240         ***************************************************************;    
241         **    FEW NEW ASSESSMENTS WILL HAVE CLAIMS GIVEN RUNOUT      **;    
242         **    THAT WE WILL ALSO PROVIDE STATS ON HOW MANY            **;    
243         **    HAVE CLAIMS, TO PROVIDE ADDITIONAL CONTEXT.            **;    
244         ***************************************************************;    
245                                                                             
                                                                                
                                                                                
246           PROC SUMMARY NWAY MISSING DATA=FINAL;                             
247             CLASS STATE;                                                    
ERROR: VARIABLE STATE NOT FOUND.                                                
ERROR: VARIABLE STATE NOT FOUND.                                                
ERROR: VARIABLE STATE NOT FOUND.                                                
248             VAR   DAYSTOASSESS;                                             
ERROR: VARIABLE DAYSTOASSESS NOT FOUND.                                         
ERROR: VARIABLE DAYSTOASSESS NOT FOUND.                                         
ERROR: VARIABLE DAYSTOASSESS NOT FOUND.                                         
249             OUTPUT OUT=ASSESS1 MEAN=AVERAGE MEDIAN=MEDIAN                   
250                                MIN=MINDAYS  MAX=MAXDAYS                     
251                                N=AUTH_W_CLM NMISS=AUTH_NO_CLM;              
252           RUN;                                                              
                                                                                
NOTE: THE SAS SYSTEM STOPPED PROCESSING THIS STEP BECAUSE OF ERRORS.            
WARNING: THE DATA SET WORK.ASSESS1 MAY BE INCOMPLETE.  WHEN THIS STEP WAS STOPPE
NOTE: THE PROCEDURE SUMMARY USED 0.00 CPU SECONDS AND 16532K.                   
                                                                                
NOTE: THE ADDRESS SPACE HAS USED A MAXIMUM OF 2640K BELOW THE LINE AND 74668K AB
                                                                                
253                                                                             
                                                                                
                                                                                
254           DATA ASSESS_FINAL (DROP=_TYPE_ _FREQ_ MINDAYS MAXDAYS);           
255            RETAIN STATE AVERAGE MEDIAN RANGE AUTH_W_CLM AUTH_NO_CLM;        
256             SET ASSESS1;                                                    
257             FORMAT RANGE $9.;                                               
258             IF MISSING(MINDAYS) THEN RANGE = MINDAYS;                       
259             ELSE RANGE = PUT(MINDAYS,$2.) !! " TO " !! PUT(MAXDAYS,$3.-L);  
WARNING: VARIABLE MINDAYS HAS ALREADY BEEN DEFINED AS NUMERIC.                  
WARNING: VARIABLE MAXDAYS HAS ALREADY BEEN DEFINED AS NUMERIC.                  
260           RUN;                                                              
NOTE: NUMERIC VALUES HAVE BEEN CONVERTED TO CHARACTER VALUES AT THE PLACES GIVEN
      258:39                                                                    
WARNING: THE VARIABLE _TYPE_ IN THE DROP, KEEP, OR RENAME LIST HAS NEVER BEEN RE
WARNING: THE VARIABLE _FREQ_ IN THE DROP, KEEP, OR RENAME LIST HAS NEVER BEEN RE
NOTE: THE DATA SET WORK.ASSESS_FINAL HAS 0 OBSERVATIONS AND 6 VARIABLES.        
NOTE: THE DATA STATEMENT USED 0.00 CPU SECONDS AND 16532K.                      
                                                                                
NOTE: THE ADDRESS SPACE HAS USED A MAXIMUM OF 2640K BELOW THE LINE AND 74668K AB
                                                                                
                                                                                
261                                                                             
262           PROC PRINT DATA=ASSESS_FINAL;                                     
263             TITLE 'ASSESS_FINAL - REVIEW';                                  
264           RUN;                                                              
                                                                                
NOTE: THE PROCEDURE PRINT USED 0.01 CPU SECONDS AND 16803K.                     
                                                                                
NOTE: THE ADDRESS SPACE HAS USED A MAXIMUM OF 2640K BELOW THE LINE AND 74668K AB
                                                                                
                                                                                
265                                                                             
266         ***************************************************************;    
267         **    THE AVERAGE AND MEDIAN NUMBER OF DAYS FROM THE FIRST   **;    
268         **    ISSUED AUTHORIZATION (BENEFICIARY NEW TO THE ACD) TO   **;    
269         **    CLAIM DATE OF TREATMENT (0364T, 0368T, 0370T)          **;    
270         **    CERTIFIED IN TOTAL AUTHORIZATIONS ONLY.                **;    
271         ***************************************************************;    
272         **    FEW NEW ASSESSMENTS WILL HAVE CLAIMS GIVEN RUNOUT      **;    
273         **    THAT WE WILL ALSO PROVIDE STATS ON HOW MANY            **;    
274         **    HAVE CLAIMS, TO PROVIDE ADDITIONAL CONTEXT.            **;    
275         ***************************************************************;    
276                                                                             
277           PROC SUMMARY NWAY MISSING DATA=FINAL;                             
278             CLASS STATE;                                                    
ERROR: VARIABLE STATE NOT FOUND.                                                
ERROR: VARIABLE STATE NOT FOUND.                                                
ERROR: VARIABLE STATE NOT FOUND.                                                
279             VAR   DAYSTOTREAT;                                              
ERROR: VARIABLE DAYSTOTREAT NOT FOUND.                                          
ERROR: VARIABLE DAYSTOTREAT NOT FOUND.                                          
ERROR: VARIABLE DAYSTOTREAT NOT FOUND.                                          
280             OUTPUT OUT=TREAT1 MEAN=AVERAGE MEDIAN=MEDIAN                    
281                               MIN=MINDAYS  MAX=MAXDAYS                      
282                               N=AUTH_W_CLM NMISS=AUTH_NO_CLM;               
283           RUN;                                                              
                                                                                
NOTE: THE SAS SYSTEM STOPPED PROCESSING THIS STEP BECAUSE OF ERRORS.            
WARNING: THE DATA SET WORK.TREAT1 MAY BE INCOMPLETE.  WHEN THIS STEP WAS STOPPED
NOTE: THE PROCEDURE SUMMARY USED 0.00 CPU SECONDS AND 16803K.                   
                                                                                
NOTE: THE ADDRESS SPACE HAS USED A MAXIMUM OF 2640K BELOW THE LINE AND 74668K AB
                                                                                
284                                                                             
                                                                                
                                                                                
285           DATA TREAT_FINAL (DROP=_TYPE_ _FREQ_ MINDAYS MAXDAYS);            
286            RETAIN STATE AVERAGE MEDIAN RANGE AUTH_W_CLM AUTH_NO_CLM;        
287             SET TREAT1;                                                     
288             FORMAT RANGE $9.;                                               
289             IF MISSING(MINDAYS) THEN RANGE = MINDAYS;                       
290             ELSE RANGE = PUT(MINDAYS,$2.) !! " TO " !! PUT(MAXDAYS,$3.-L);  
WARNING: VARIABLE MINDAYS HAS ALREADY BEEN DEFINED AS NUMERIC.                  
WARNING: VARIABLE MAXDAYS HAS ALREADY BEEN DEFINED AS NUMERIC.                  
291           RUN;                                                              
                                                                                
NOTE: NUMERIC VALUES HAVE BEEN CONVERTED TO CHARACTER VALUES AT THE PLACES GIVEN
      289:39                                                                    
WARNING: THE VARIABLE _TYPE_ IN THE DROP, KEEP, OR RENAME LIST HAS NEVER BEEN RE
WARNING: THE VARIABLE _FREQ_ IN THE DROP, KEEP, OR RENAME LIST HAS NEVER BEEN RE
NOTE: THE DATA SET WORK.TREAT_FINAL HAS 0 OBSERVATIONS AND 6 VARIABLES.         
NOTE: THE DATA STATEMENT USED 0.00 CPU SECONDS AND 16803K.                      
                                                                                
NOTE: THE ADDRESS SPACE HAS USED A MAXIMUM OF 2640K BELOW THE LINE AND 74668K AB
                                                                                
                                                                                
292                                                                             
293           PROC PRINT DATA=TREAT_FINAL;                                      
294             TITLE 'TREAT_FINAL - REVIEW';                                   
295           RUN;                                                              
                                                                                
NOTE: THE PROCEDURE PRINT USED 0.00 CPU SECONDS AND 16803K.                     
                                                                                
NOTE: THE ADDRESS SPACE HAS USED A MAXIMUM OF 2640K BELOW THE LINE AND 74668K AB
                                                                                
296                                                                             
297         ***************************************************************;    
298         ** OUTPUT DATA.                                              **;    
299         ***************************************************************;    
300                                                                             
301           %INCLUDE 'FPCENRI.MACRO1.SAS(TILOUT1)'; * OUTPUT MACRO *;         
                                                                                
WARNING: RUN STATEMENT IGNORED DUE TO PREVIOUS ERRORS. SUBMIT QUIT; TO TERMINATE
NOTE: THE PROCEDURE FORMAT USED 0.00 CPU SECONDS AND 16876K.                    
                                                                                
NOTE: THE ADDRESS SPACE HAS USED A MAXIMUM OF 2640K BELOW THE LINE AND 74668K AB
                                                                                
                                                                                
                                                                                
WARNING: RUN STATEMENT IGNORED DUE TO PREVIOUS ERRORS. SUBMIT QUIT; TO TERMINATE
NOTE: THE PROCEDURE FORMAT USED 0.00 CPU SECONDS AND 16876K.                    
                                                                                
NOTE: THE ADDRESS SPACE HAS USED A MAXIMUM OF 2640K BELOW THE LINE AND 74668K AB
                                                                                
                                                                                
                                                                                
WARNING: RUN STATEMENT IGNORED DUE TO PREVIOUS ERRORS. SUBMIT QUIT; TO TERMINATE
NOTE: THE PROCEDURE FORMAT USED 0.00 CPU SECONDS AND 16876K.                    
                                                                                
NOTE: THE ADDRESS SPACE HAS USED A MAXIMUM OF 2640K BELOW THE LINE AND 74668K AB
                                                                                
                                                                                
WARNING: RUN STATEMENT IGNORED DUE TO PREVIOUS ERRORS. SUBMIT QUIT; TO TERMINATE
NOTE: THE PROCEDURE FORMAT USED 0.00 CPU SECONDS AND 16876K.                    
                                                                                
NOTE: THE ADDRESS SPACE HAS USED A MAXIMUM OF 2640K BELOW THE LINE AND 74668K AB
                                                                                
                                                                                
                                                                                
WARNING: RUN STATEMENT IGNORED DUE TO PREVIOUS ERRORS. SUBMIT QUIT; TO TERMINATE
NOTE: THE PROCEDURE FORMAT USED 0.00 CPU SECONDS AND 16876K.                    
                                                                                
NOTE: THE ADDRESS SPACE HAS USED A MAXIMUM OF 2640K BELOW THE LINE AND 74668K AB
                                                                                
                                                                                
                                                                                
WARNING: RUN STATEMENT IGNORED DUE TO PREVIOUS ERRORS. SUBMIT QUIT; TO TERMINATE
NOTE: THE PROCEDURE FORMAT USED 0.05 CPU SECONDS AND 16876K.                    
                                                                                
NOTE: THE ADDRESS SPACE HAS USED A MAXIMUM OF 2640K BELOW THE LINE AND 74668K AB
                                                                                
                                                                                
                                                                                
WARNING: RUN STATEMENT IGNORED DUE TO PREVIOUS ERRORS. SUBMIT QUIT; TO TERMINATE
NOTE: THE PROCEDURE FORMAT USED 0.00 CPU SECONDS AND 16876K.                    
                                                                                
NOTE: THE ADDRESS SPACE HAS USED A MAXIMUM OF 2640K BELOW THE LINE AND 74668K AB

Accepted Solutions
Solution
‎06-23-2017 07:26 PM
PROC Star
Posts: 7,363

Re: ERROR Message Regarding a Variable "ACKEY"

Check your original data. Are you sure that the variable ACKEY exists?

 

Art, CEO, AnalystFinder.com

 

View solution in original post


All Replies
Solution
‎06-23-2017 07:26 PM
PROC Star
Posts: 7,363

Re: ERROR Message Regarding a Variable "ACKEY"

Check your original data. Are you sure that the variable ACKEY exists?

 

Art, CEO, AnalystFinder.com

 

Super User
Posts: 10,500

Re: ERROR Message Regarding a Variable "ACKEY"

Run Proc Contents on the data set MMS7 and show us the result.

Suspect that the named variable is not in it. Misspelled Akey,AC_Key or something similar perhaps?

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 117 views
  • 0 likes
  • 3 in conversation