This sounds a lot like homework. As such a general "how to do x" request may get you answers that involve things not covered by your course work yet. Have you encountered Proc Means? Proc Report? Proc Tabulate? These procedures are quite often used for summaries instead of writing data steps.   The actual structure and content of data set you have does make a big difference in what approach is taken. From your "description" I am not sure that you are describing the data or the requirement. If that is the requirement then without data examples I have no clue how to start. If there is data, then some example records helps.   It sounds like you need to group results by Customer_id and Bill_account and then SUM several other variables (names not provided). If you have been exposed to Proc Report the previous sentence could be providing a very large economy sized hint on one solution. ... View more

This sounds a lot like homework. As such a general "how to do x" request may get you answers that involve things not covered by your course work yet. Have you encountered Proc Means? Proc Report? Proc Tabulate? These procedures are quite often used for summaries instead of writing data steps.   The actual structure and content of data set you have does make a big difference in what approach is taken. From your "description" I am not sure that you are describing the data or the requirement. If that is the requirement then without data examples I have no clue how to start. If there is data, then some example records helps.   It sounds like you need to group results by Customer_id and Bill_account and then SUM several other variables (names not provided). If you have been exposed to Proc Report the previous sentence could be providing a very large economy sized hint on one solution. ... View more

Here is an example where the dates are stored as character strings - you'll need to create a new numeric date variable & then you can use where statement on the numeric variable:   /* Creating a dataset with a character date variable */ data mons_char; input dt $7.; datalines; jul2022 jun2022 aug2022 jan2022 feb2022 ; run; /* Creating a numeric date variable using the input function - using formats to show how that new variable can be displayed */ data mons2; set mons_char; format dt_num2 monyy7. dt_num3 date9.; dt_num = input(dt,monyy7.); dt_num2 = dt_num; dt_num3 = dt_num; run; /* Using numeric date variable in where statement */ proc print data=mons2; where '01jun2022'd <= dt_num <= '31aug2022'd; run; ... View more