DATA CVA1819Q2; SET CVA.FY1819Q2_VOLUME CVA.FY1819Q2_MC (IN=MC); /* ADD LEADING 0 FOR PROCEDURES 1-9 IN ORDER TO SORT PROPERLY */ IF SUBSTR(PROCEDURE,2,1)='.' THEN PROCEDURE = '0'||PROCEDURE; IF MC=1 THEN PROCEDURE='11. Mitral Clip'; RUN; Can someone advise if the set statement is concatenating the 2 data sets ? also what is placing the in=mc marker doing in the set statement?       For the proc sql code below: what is outer union corr doing ?     PROC SQL; CREATE VIEW CVA_MS_LHIN_VIEW AS SELECT DISTINCT WAITLISTENTRYID, PROCEDURE, PATIENTLHINNAME, 'LHIN' AS SORTORDER FROM CVA1819Q2(WHERE=(MISSING(PATIENTLHINNAME)=0)) OUTER UNION CORR SELECT DISTINCT WAITLISTENTRYID, PROCEDURE, 'Ontario' AS PATIENTLHINNAME, 'PROV' AS SORTORDER FROM CVA1819Q2(WHERE=(MISSING(PATIENTLHINNAME)=0)); QUIT; ... View more

04APR2018:00:00:00 I have dates in the above format in the sas dataset that is datetime 20 but my code below does not extract the records for Q1 which should be any records that fall between and are equal 1st April 2018 to 30 June 2018 Please advise   data FY1819Q1; set EVT.SP440_FY2018Q2; if '01APR2018'D <= DISCH_DT <= '30JUN2018'D THEN output FY1819Q1; run; ... View more

In the attached file you will see a variable form which I need to be able to create three datasets 1st dataset(Missing) : find values that contain missing values in any of the 23 characters of the variable SP440 2nd dataset(Unknown) find values that contain 8 in the 1st character or 9 in any of the total 23 characters  3rd dataset (Invalid entries): find values that contain any value other than P,Y, N or 8 in the 1st character   Please advise how would I write a code to create these three datasets   Regards   ... View more

  I am getting an error Can someone advise how to correct this step   data DAD_N_1; set DAD_N_1a; /* ARRAY - ISCHEMIC STROKE DIAGNOSIS CODE */ ARRAY DX_CODE [25] DIAG_CODE_01 - DIAG_CODE_25; STROKE_CNT=0; DO I=1 TO 25; IF ARRAY DX_CODE[I] IN ('I63', 'I64', 'H34') THEN DO; STROKE_CNT+1; IF SUBSTR(DX_CODE[I],1,4) NOT IN ('I636')THEN DO; STROKE_CNT+1; /* COUNT NUMBER OF Ischemic stroke procedures */ run; ERROR: data DAD_N_1; 383 set DAD_N_1a; 384 /* ARRAY - ISCHEMIC STROKE DIAGNOSIS CODE */ 385 ARRAY DX_CODE [25] DIAG_CODE_01 - DIAG_CODE_25; 386 387 STROKE_CNT=0; 388 389 DO I=1 TO 25; 390 IF ARRAY DX_CODE[I] IN ('I63', 'I64', 'H34') THEN DO; ------- 22 ERROR 22-322: Syntax error, expecting one of the following: !, !!, &, (, *, **, +, -, /, ;, <, <=, <>, =, >, ><, >=, AND, EQ, GE, GT, LE, LT, MAX, MIN, NE, NG, NL, OR, [, ^=, {, |, ||, ~=. 391 STROKE_CNT+1; 392 IF SUBSTR(DX_CODE[I],1,4) NOT IN ('I636')THEN DO; 393 STROKE_CNT+1; 394 /* COUNT NUMBER OF Ischemic stroke procedures */ 395 run; NOTE: Character values have been converted to numeric values at the places given by: (Line):(Column). 390:14 1:1 ... View more

Hello folks,   I run the code below and get no errors but it is not resulting in the expected output Is the code technically correct?   data mitra1617; set dad.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 SUBSTR(ARRAY_IC[I],1,5) ='1HU80' THEN output; END; ... View more

Hello I am writing a query in Microsoft SQL Server management studio and not sas but am getting an error with the statement below I dont have training in SQL Wold someone be able to advise how to write the query corectly?     create table TAVIPx as select [WaitlistEntryID],[TAVIAccessSiteCD],[TransCathAorticValveInterventionIND]from [dbo].[CardiacReferralTAVIIntraProcedure]; ... View more

proc sql; create table DAD_CABG as select CIHI_KEY, INST_NO, Gender, Age, POSTAL_CODE, PATIENT_LHIN, Residence_Code, ADM_DT, ADM_TM, Inst_From_NO, Facility_NO, FACILITY_LHIN, FACILITY_NAME,Adm_category, MCC, MCC_PARTITION,ACUTE_LENGTH_OF_STAY,TOTAL_LENGTH_OF_STAY,HIG_CODE,HIG_WEIGHT, Diag_code_01, Diag_code_02, Diag_code_03, Diag_code_04, Diag_code_05, Diag_code_06, Diag_code_07, Diag_code_08, Diag_code_09, Diag_code_10, Diag_code_11, Diag_code_12, Diag_code_13, Diag_code_14, Diag_code_15, Diag_code_16, Diag_code_17, Diag_code_18, Diag_code_19, Diag_code_20, Diag_code_21, Diag_code_22, Diag_code_23, Diag_code_24, Diag_code_25, Diag_type_01, Diag_type_02, Diag_type_03, Diag_type_04, Diag_type_05, Diag_type_06, Diag_type_07, Diag_type_08, Diag_type_09, Diag_type_10, Diag_type_11, Diag_type_12, Diag_type_13, Diag_type_14, Diag_type_15, Diag_type_16, Diag_type_17, Diag_type_18, Diag_type_19, Diag_type_20, Diag_type_21, Diag_type_22, Diag_type_23, Diag_type_24, Diag_type_25, Interv_code_01, Interv_code_02, Interv_code_03, Interv_code_04, Interv_code_05, Interv_code_06, Interv_code_07, Interv_code_08, Interv_code_09, Interv_code_10, Interv_code_11, Interv_code_12, Interv_code_13, Interv_code_14, Interv_code_15, Interv_code_16, Interv_code_17, Interv_code_18, Interv_code_19, Interv_code_20, INTERV_OOH_IND_01, INTERV_OOH_IND_02, INTERV_OOH_IND_03, INTERV_OOH_IND_04, INTERV_OOH_IND_05, INTERV_OOH_IND_06, INTERV_OOH_IND_07, INTERV_OOH_IND_08, INTERV_OOH_IND_09, INTERV_OOH_IND_10, INTERV_OOH_IND_11, INTERV_OOH_IND_12, INTERV_OOH_IND_13, INTERV_OOH_IND_14, INTERV_OOH_IND_15, INTERV_OOH_IND_16, INTERV_OOH_IND_17, INTERV_OOH_IND_18, INTERV_OOH_IND_19, INTERV_OOH_IND_20, Interv_status_attrib_01, Interv_status_attrib_02, Interv_status_attrib_03, Interv_status_attrib_04, Interv_status_attrib_05, Interv_status_attrib_06, Interv_status_attrib_07, Interv_status_attrib_08, Interv_status_attrib_09, Interv_status_attrib_10, Interv_status_attrib_11, Interv_status_attrib_12, Interv_status_attrib_13, Interv_status_attrib_14, Interv_status_attrib_15, Interv_status_attrib_16, Interv_status_attrib_17, Interv_status_attrib_18, Interv_status_attrib_19, Interv_status_attrib_20, HCNE from DAD.DAD1617 where PROVINCE_ISSUING_HCN='ON' and RESPONSIBILITY_FOR_PAYMENT='01' and HCN_INDEX='H' and AGE >=18 and INTERV_CODE_01 in ('1IJ76DAXX', '1IJ76LAXX', '1IJ76LAXXA', '1IJ76LAXXG','1IJ76LAXXN','1IJ76LAXXQ'); quit;   How would I modify the above code to select cases such that the bold highlighted above are present in either of the 19 variables interv_code_02 to interv_code_20 and not in interv_code_01 ... View more