One of my Proc Summary groupings includes a SAS Date variable named PAY_DATA_MONTH. So when I sum up to that SAS Date Level then the cell shows a . because there is no value. Is there a way to recode these missing values . to just appear as empty white space instead? (see the attached pic) If not in the Proc Summary itself than in following data step?
I'd appreciate any insights. Thanks in advance.
PROC SUMMARY DATA=&SITE._HCR_PD;
CLASS AREA HCRID PAY_DATA_MONTH ACTIVITY_DESCRIPTION;
TYPES () AREA*HCRID AREA*HCRID*PAY_DATA_MONTH AREA*HCRID*PAY_DATA_MONTH*ACTIVITY_DESCRIPTION;
VAR PAY_AMOUNT RATE UNITS;
OUTPUT OUT=&SITE._SUMS_ SUM=;
RUN;
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.