I'm a programmer trying to convert to EG for some projects where I start with reasonably clean data. In this case, I have patient level data that I want to summarize and report by facility and month.
I've got a query that pulls the variables I want and calculates 2 new columns. I include fac_id (facility) and disdate (discharge date) under "select data" and selected them as Summary groups. However, my selected table only reformats the discharge date to monyy5. Basically I want the format applied at the group-by line so that I only have
What do I need to do? Is it possible to summarize by month at this step or do I have to add another task to do this? (below is my generated SQL)
[pre]
PROC SQL;
CREATE TABLE WORK.Query1_for_analysis200808 AS SELECT analysis200808.fac_id,
analysis200808.DISDATE FORMAT=MONYY5.0 label="Discharge Month",
(MEAN(analysis200808.Nurse_Courtesy ,
analysis200808.Nurse_CallButton ,
analysis200808.Nurse_Attitude ,
analysis200808.Nurse_Attention ,
analysis200808.Nurse_KeptInformed ,
analysis200808.Nurse_Skill )) FORMAT=5.2 label="Nursing Section Score" AS Nurse_section,
(MEAN(analysis200808.Doc_TimeSpent ,
analysis200808.Doc_ConcernQuest ,
analysis200808.Doc_KeptInformed ,
analysis200808.Doc_Courtesy ,
analysis200808.Doc_Skill )) FORMAT=5.2 label="Physician Section Score" AS Doc_section,
analysis200808.Overall_Likelihood FORMAT=5.2 label="Overall Likelihood to Recommend"
FROM EC100035.ANALYSIS200808 AS analysis200808
WHERE analysis200808.type = "E"
GROUP BY analysis200808.fac_id, analysis200808.DISDATE;
QUIT;
[/pre]