It sounds like what you are saying about goof database maybe what is happening to me. Do you have any suggestion on how to fix it? ... View more

Hello @Tom  The sum syntax works. The only issue is it is counting for cases = 1 and zeros are not included.  ... View more

When I add else and null it, gives an error message saying: The following columns were not found in the contributing tables: null, sysid ... View more

Hello, sorry if I wasn’t clear. What I am trying to do is to count records by the cause. The variable “Cause” categorizes the records by fire-relatedness, and I am trying to count cases by that variable.  If you look at the first part of the code, I have categorized it so I want to know the number  CO poisoning which are fire-related or non-fire, or unknown. ... View more

Hello, everyone. I am getting the error below when trying to count CO cases. How can I fix it?  if CO_fire10 ~= 1 and CO_unknown_prelim1_10 = 1 then CO_unknown_prelim2_10 = 1; if CO_fire10 = 1 and CO_nonfire10 = 1 then CO_unknown_prelim3_10 = 1; if CO_unknown_prelim2_10 = 1 or CO_unknown_prelim3_10 = 1 then CO_unknown10 = 1; * sub-step f; if CO_fire10 = 1 then Cause = 1;*fire related ; if CO_nonfire10 = 1 then Cause = 2;*not fire related; if CO_unknown10 = 1 then Cause = 3;*Unknown mechanism or intent; if CO_fire10 = 1 and CO_nonfire10 = 1 then Cause = 3; if CO_fire10 = 1 and CO_unknown10 = 1 then Cause = 3; if CO_nonfire10 = 1 and CO_unknown10 = 1 then Cause = 3; HealthOutcomeID=3; MonthlyHosp=0; run; proc sql ; create table rr as select distinct Admission_Month ,AgeGroup , County , Ethnicity , Race , HealthOutcomeID , MonthlyHosp , Sex , Admission_Year , count(case when (Cause=1) then sysid end) as IncidentCountFire, count(case when (Cause=2) then sysid end) as IncidentCountNonFire, count(case when (Cause=3) then sysid end) as IncidentCountUnknown from count_CO group by Admission_Month , AgeGroup , County , Ethnicity , Race , HealthOutcomeID , MonthlyHosp , Sex , Admission_Year ; quit; NOTE: A CASE expression has no ELSE clause. Cases not accounted for by the WHEN clauses will result in a missing value for the CASE expression. ERROR: The following columns were not found in the contributing tables: sysid. ... View more

Thank you. ... View more

@PaigeMiller, if you don't mind, can you tell me the syntax? I have never created a table using SQL before, so I am trying it for the first time.  ... View more

Hello, everyone. Can someone help me fix this code? I am trying to summarize data by the following variables: age group, county, year admitted admissionmonth, race, and sex. Below is a snippet of the data.  proc sql number; create table rr as select distinct AdmissionMonth, AgeGroup, County, Ethnicity, Race, HealthOutcomeID, MonthlyHosp, Sex, ADYEAR, count (case when ASTHMA_FLAG=1 from count_Asthma group by AdmissionMonth, AgeGroup, County, Ethnicity, Race, HealthOutcomeID, MonthlyHosp, Sex, ADYEAR; quit; ... View more

Can someone please help me fix this code loop? It Data temp (drop=z); set work.complete22; array DXS[18] $ dx1-dx18; CO_FLAG = 0; do z= 1 to 18; if substr(DXS {z},1,5) IN:('T5801' 'T5804' 'T5811' 'T5814' 'T5891' 'T5894' 'T5802' 'T5803' 'T5812' 'T5813')             or substr(DXS {z},1,6)IN:('T582X2' 'T582X3' 'T588X3' 'T5892' 'T582X1' 'T582X4' 'T588X1' 'T588X4') or DXS{z} in:('T5882X2')          then do CO_FLAG = 1; leave; end; end; run; is not working. It only flags Zero's  ... View more

Hello everyone,  Thank you all for the support. This is my first using the array and doing loops, so bear with me. I want this code to the checks applied to z=2, 3, so should I remove the LEAVE? Also, after correcting the issue with quotes, now it's a loop, not closed. I have tried to end and run twice, but both do not work.  258 Data temp (drop=z); 259 set work.complete22; 260 array DXS[18] $ dx1-dx18; 261 CO_FLAG = 0; 262 263 do z= 1 to 18; 264 265 if substr(DXS {z},1,5) IN:('T5801' 'T5804' 'T5811' 'T5814' 'T5891' 'T5894' 'T5802' 'T5803' 265! 'T5812' 'T5813') 266 267 or substr(DXS {z},1,6)IN:('T582X2' 'T582X3' 'T588X3' 'T5892' 'T582X1' 'T582X4' 267! 'T588X1' 'T588X4') 268 269 or DXS{z} in:('T5882X2') 270 271 then do; 272 CO_FLAG = 1; 273 leave; 274 end; 275 run; 275 run; - 117 ERROR 117-185: There was 1 unclosed DO block. NOTE: The SAS System stopped processing this step because of errors. WARNING: The data set WORK.TEMP may be incomplete. When this step was stopped there were 0 observations and 78 variables. WARNING: Data set WORK.TEMP 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 276 end; --- 180 ERROR 180-322: Statement is not valid or it is used out of proper order. 277 run; ... View more

1 data complete22; 2 set "C:\Users\hjt09632\Desktop\complete22.sas7bdat"; 3 run; NOTE: There were 750108 observations read from the data set C:\Users\hjt09632\Desktop\complete22.sas7bdat. NOTE: The data set WORK.COMPLETE22 has 750108 observations and 77 variables. NOTE: DATA statement used (Total process time): real time 1.82 seconds cpu time 0.45 seconds 4 Data temp (drop=z); 5 set work.complete22; 6 /* recoding age */ 7 if AGE_KEY >=0 and AGE_KEY <= 4 then agegroup=1; 8 if AGE_KEY >=5 and AGE_KEY <= 9 then agegroup=2; 9 if AGE_KEY >=10 and AGE_KEY <= 14 then agegroup=3; 10 if AGE_KEY >=15 and AGE_KEY <= 19 then agegroup=4; 11 if AGE_KEY >=20 and AGE_KEY <= 24 then agegroup=5; 12 if AGE_KEY >=25 and AGE_KEY <=29 then agegroup=6; 13 if AGE_KEY >=30 and AGE_KEY <= 34 then agegroup=7; 14 if AGE_KEY >=35 and AGE_KEY <= 39 then agegroup=8; 15 if AGE_KEY >=40 and AGE_KEY <= 44 then agegroup=9; 16 if AGE_KEY >=45 and AGE_KEY <= 49 then agegroup=10; 17 if AGE_KEY >=50 and AGE_KEY <= 54 then agegroup=11; 18 if AGE_KEY >=55 and AGE_KEY <= 59 then agegroup=12; 19 if AGE_KEY >=60 and AGE_KEY <= 64 then agegroup=13; 20 if AGE_KEY >=65 and AGE_KEY <= 69 then agegroup=14; 21 if AGE_KEY >=70 and AGE_KEY <= 74 then agegroup=15; 22 if AGE_KEY >=75 and AGE_KEY <= 79 then agegroup=16; 23 if AGE_KEY >=80 and AGE_KEY <= 84 then agegroup=17; 24 if AGE_KEY >=85 then agegroup=18; 25 else if AGE_KEY =. then agegroup =19; 26 27 /* *primary dx only;*/ 28 29 array DXS[18] $ dx1-dx18; 30 CO_FLAG = 0; 31 32 do z= 1 to 18; 33 34 if substr(DXS {z},1,5) IN:('T5801' 'T5804' 'T5811' 'T5814' 'T5891' 'T5894' 'T5802’ ‘T5803’ 34 ! ‘T5812’ ‘T5813’) 35 36 or substr(DXS {z},1,6)IN:(‘T582X2’ ‘T582X3’ ‘T588X3’ ‘T5892' 'T582X1' 'T582X4' 36 ! 'T588X1' 'T588X4') 37 38 or DXS{z} in: (‘T5882X2’) - 22 76 ERROR 22-322: Syntax error, expecting one of the following: a quoted string, a numeric constant, a datetime constant, a missing value, iterator, (. ERROR 76-322: Syntax error, statement will be ignored. 39 40 then CO_FLAG = 1; 41 42 leave; 43 44 END; 45 46 run; NOTE: The SAS System stopped processing this step because of errors. WARNING: The data set WORK.TEMP may be incomplete. When this step was stopped there were 0 observations and 79 variables. NOTE: DATA statement used (Total process time): real time 0.09 seconds cpu time 0.04 seconds ... View more