Can someone advise why im getting the array subscript out of range error   749 data Ischemic_stroke; 750 set CIHI.DAD1819Q2; 751 length STROKE_GROUP $ 40; 752 753 STROKE_ISC=0; 754 STROKE_CNT=0; 755 /* EXCLUDE UNDER 18 */ 756 IF AGE<18 THEN STROKE_ISC=0; 757 /* EXCLUDE NON-ONTARIO FUNDED PATIENT */ 758 IF PROVINCE_ISSUING_HCN ~='ON' OR RESPONSIBILITY_FOR_PAYMENT~='01' THEN STROKE_ISC=0; 759 /* EXCLUDE SURGICAL CASES */ 760 IF MCC_PARTITION='I' THEN STROKE_ISC=0; 761 762 /* ARRAY - DIAGNOSIS CODE */ 763 764 ARRAY DX_CODE [25] DIAG_CODE_01 - DIAG_CODE_25; 765 /* ARRAY - DIAGNOSIS TYPE */ 766 ARRAY DX_TYPE [25] DIAG_TYPE_01 - DIAG_TYPE_25; 767 768 769 /* SEARCH FOR STROKE DIAGNOSIS CODES AND EXCLUDE TYPE 3 */ 770 771 DO H=1 TO 25; 772 773 IF ((SUBSTR(DX_CODE[H],1,3) IN ('G45' 'I61' 'I63' 'I64') OR SUBSTR(DX_CODE[H],1,4) = 'H341'))and 773! SUBSTR(DX_CODE[H],1,4) NOT IN ('G454' 'I636') and DX_TYPE(H) NE '3' THEN DO 774 STROKE_ISC=1; 775 776 END; 777 END; 778 779 /* LIST OF 3-DIGIT STROKE DIAGNOSIS CODES - ISCHEMIC */ 780 IF STROKE_ISC=1 and SUBSTR(DX_CODE[H],1,3) IN ('I63' 'I64' 'H34') THEN DO; 781 STROKE_CNT+1; 782 STROKE_GROUP = 'Stroke - Ischemic'; 783 END; 784 DROP H ; 785 786 RUN; ERROR: Array subscript out of range at line 780 column 28. ... View more

proc sql; create table EVT_SP440_2a as select * from EVT_FY2018Q2 where FLAG_SP440=1; quit;*381 records had SP440 entry out of 387 EVT records;   How would I modify the code above to create an output with the following columns Fiscal Year Fiscal Quarter CIHI Key Indicator No The 1st three bolded fields are present in the EVT_FY2018Q2 dataset but Indicator No is for this datastep Subsequently i have further sql steps which will produce the other indictor results as  sas datasets All I need to do is create and output that lists each cihikey for every indicator  e.g.the following output CIHIKey1 2018 Q1 IndicatorNo1 CIHIKey2 2018 Q2 IndicatorNo2 CIHIKey3 2018 Q2 IndicatorNo2   ... View more

data pacemaker1617; set cihi.dad1617; ARRAY ARRAY_IC [20] INTERV_CODE_01- INTERV_CODE_20; if PROVINCE_ISSUING_HCN='ON' and RESPONSIBILITY_FOR_PAYMENT='01' and HCN_INDEX='H' and AGE >=18 ; DO I=1 TO 20; IF ARRAY_IC[I] in ('1YY55LANM') THEN output; END; RUN;   I have 25 more codes for which I need to create data extracts similar to the way done above What would be an easy way to modify the code above to do the same ... View more

How do I write an expression to say that  one date variable at fac A is equal to another date variable at fac B E.g. if REMOVAL_DT at SHS = TransferDate at MGH ... View more

MERGE statement has more than one data set with repeats of BY values.   218 data MGH_PCI; 219 merge MGH(IN=MGH) PCI(IN=PCI); 220 by HealthCardNumber; 221 if MGH and PCI; 222 run;   NOTE: There were 21423 observations read from the data set WORK.MGH. NOTE: There were 117715 observations read from the data set WORK.PCI. NOTE: The data set WORK.MGH_PCI has 7265 observations and 240 variables. NOTE: DATA statement used (Total process time): real time 0.21 seconds cpu time 0.15 seconds     Hello,  I understnad that the PCI data set has repeat entries for the by variable HealthCardNumber; and therefore I get the above message But i want to understand which records are used to merge in the case of a repeat entry i.e which records are put into the merged table. Would sas put the first time it encountered a matching HealthCardNumber into the table        ... View more

How would i write an if condition to group cases by the admission date for the 12 months in a year  ADM_DT field is in Numeric DATETIME20 format  i.e. I want to count the no of cases where ADM_DT would fall e.g. between 01 Jan and 31 Jan 2018 ... View more