I am trying in SAS to convert my column name BTH_DT to an age and used this code: bth_dt = int(datediff("m",[bth_dt],date())/12) this is contained in my proc sql statement which is proc sql; (select distinct memberid, fst_srvc_dt, bth_dt = int(datediff("m",[bth_dt],date())/12), member_gender_cd from inpatient rest of code the entire code works great if I take out the converting to age. It will give me all columns and the bth_dt column. but when i add this code in I get an error something expected between bth_dt and = just not sure how to code this quite right ... View more

I have a table that has multiple rows but within the table I have 2 columns. 1 is NoReadm and the other YesReadm The no has 0 and the Yes has 1. There are 774 rows in all. 39 of those rows have the 1 and the rest are 0. I want a chi square and am doing the following code off the table. proc freq data = readm..final tables noreadm * yesreadm/chisq; run; I am getting the output the freq procedure table of noreadm and yesreadm effective sample size = 0 frequency missing =774 Not sure what that means or how to fix this ... View more

I am exporting my report and it is not combining my fields like I would expect it to. The tables I am pulling are correct in that they will say: memberid        admitdt         count         state 1111                 1/1/2010            1                     ny 1111                 1/2/2010             1                    ny 1111                 1/2/2010            2                     ny the problem is when grouping in a report say the above it groups like this on the report memberid            admitdt            count            state 1111                     1/1/2010              1                         ny                               1/2/2010               3     I do not want any null items but if I use display after the column names it is totally funky. My code is like this columns     memberid state admitdt frequency define memberid/group 'member'; define state/group 'state'; define admitdt/group 'date'; define count/analysis sum 'frequency' center; The output is not giving me the memberid and the state code in each column as you see above. This makes it so I have to manually go thru my execl file and copy the memberid and state to the blank columns. I spent 3 hours yesterday trying to figure out the issue by playing with different report functions and nothing worked. I could have spent that 3 hours just manually fixing the about 500 rows that came over like this and been off at 6pm instead of getting off at 9pm. I have to run this every quarter and if I have to manually do it fine. I just do not want to spend 3 hours again researching why it does not work. Waste of time. If someone knows how I can fix this that is great. If not I am prepared to fix the 500 some odd rows that are blank every quarter ... View more

I am doing a case statement to calculate date1 to date2 for admissions. Some of them come back with an elapsed time like 527 or 15 but then others come back with a . because there is no elapsed time. I know SAS puts in a . when you are calculating for numeric and there is no value. I want to code my case statement so it will still calculate the elapsed time but if it finds a . it will make it just a 0. I tried the following but it does not work. case when admitdt2 is not null and (dischdt1 <> admitdt2) then (admitdt2 - dischdt1) end as time1 case when admitdt3 is not null and (dischdt2 <> admitdt3) then (admitdt3 - dischdt2) end as time2 This code has more cases for all admit and disch dates and goes up to time30. Because some have no numeric return it replaces it with a . because it does not have a value to return. I want to code in my case that if there is no numeric returned to put a 0 in instead of that . I thought maybe case when admitdt2 is not null and (dischdt1 <> admitdt2) then (admitdt2 - dischdt1)  end as time1 if time1 = . then 0 That does not work ... View more