topic Re: Want to create 12 month report but I have data for few months want to populate zero value in oth in SAS Procedures

Want to create 12 month report but I have data for few months want to populate zero value in other

Sukhi1 — Tue, 23 May 2023 06:48:58 GMT

Hi all, I want to create report for 12 months but I will have data to up to current month only. so I want to populate default value for the months which does not have data.

I want something like this :

Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec

A 2 3 4 5 6 0 0 0 0 0 0 0

B 2 3 4 5 6 0 0 0 0 0 0 0

C 2 3 4 5 6 0 0 0 0 0 0 0

the A B C D E F are the some names

but I have data something like this

SRNo Account Month Init

1 0001 jan 1/23/23

2 0456 feb 2/15/23

3 0567 feb 2/27/23

4 0012 mar 3/3/23

5 0034 apr 4/5/23

6 0009 may 5/18/23

Please help me.

Re: Want to create 12 month report but I have data for few months want to populate zero value in oth

JosvanderVelden — Tue, 23 May 2023 09:16:26 GMT

Your question does not provide enough clues to be able to provide an answer. Please use your creativity and produce a better question with some sample code that clarifies your question. You can start with this:

data have;
   input idnumber account $ month $ init mmddyy8.;
   format init date9.;
datalines;
1 0101 jan 1/23/23
2 0306 feb 2/15/23
3 0405 mar 3/3/23
run;

data want;
    set have;
   .....
run;

Re: Want to create 12 month report but I have data for few months want to populate zero value in oth

PaigeMiller — Tue, 23 May 2023 13:48:34 GMT

the A B C D E F are the some names

which do not correspond in any way to your input data, so we can't possibly help you produce such a table from this input data. Also we don't know what the numbers in the cells are. A better explanation is needed.

If you want zeros, you can add zeros for the missing months into your input data.