About Chgo5

Chgo5 · ‎11-02-2021

Hi, Thanks for the code. I was able to keep all of the age groups. @Astounding Here is what the code looks like: PROC FORMAT; VALUE $AGEGPP ' 0' - ' 17' = '0-17' ' 18'-' 29' = '18-29' ' 30'-' 44' = '30-44' ' 45'-' 64' = '45-64' OTHER = '65+'; proc summary data=deaths_&year. completetypes nway; class racegp AGEGP1 sexgp/preloadfmt; format AGEGP1 $AGEGPP.; output out=TEST_totall;* n=n; run;

Chgo5 · ‎11-01-2021

Hi, @Reeza @PaigeMiller I've actually tried all of the suggestions including yours @Astounding and I'm still not getting the desired output. For example, I'm selecting for cervical cancer deaths for Chicago by the 5 age groups. In my dataset, the age groups '0-17' and '18-29' are missing because there are no cervical cancer deaths in these age groups. I basically need to figured how to keep/include the age groups even though they don't exist.

Chgo5 · ‎10-29-2021

Tried the Sparse and it didn't keep all the age groups. I will lookup the PRELOADFMT and see how that works.

Chgo5 · ‎10-29-2021

Hi, I have a SAS program that is reading in death(mortality) data by age and I created the following code for five age groups: IF AGE GE 0 AND AGE lt 17 THEN AGEGP1="0-17"; ELSE IF 18<=AGE<=29 THEN AGEGP1="18-29"; ELSE IF 30<=AGE<=44 THEN AGEGP1="30-44"; ELSE IF 45<=AGE<=64 THEN AGEGP1="45-64"; ELSE IF AGE ge 65 THEN AGEGP1="65+"; ELSE AGEGP1=" "; Next, I run the following Proc Freq: proc freq data=deaths_&year. noprint; tables RACEGP*AGEGP1*SEXGP/out=TEST_totall; run; I know I wouldn't see any deaths for example in "Alzheimers Disease" in the younger age groups(0-17, 18-29, 30-44), therefore they wouldn't show in the output dataset. However, I want to keep all of the age groups in the output dataset and assign 0 to the age groups that don't have any observations for a given cause of death. My final output dataset should display all 5 of the age groups. Can anyone please advise or suggest how to code for this? Thanks.

Online Status	Offline
Date Last Visited	‎11-05-2021 10:19 AM

Re: Keeping all variables and put zero when variables are blank

Re: Keeping all variables and put zero when variables are blank

Re: Keeping all variables and put zero when variables are blank

Keeping all variables and put zero when variables are blank

Re: Keeping all variables and put zero when variables are blank

Re: Keeping all variables and put zero when variables are blank

Re: Keeping all variables and put zero when variables are blank

Keeping all variables and put zero when variables are blank