@Swati24 wrote: run should be there or not You include a RUN or QUIT statement to let SAS (and other programmers) know that you have reached the end of a procedure or data step.  But a data step that includes in-line data (signaled by the CARDS statement or as it has been renamed DATALINES) ends when the in-line data ends.  Any extra RUN statement after that will not have any effect other than confusing some novice programmers into thinking they can insert additional data step statements between the lines of data and the run statement. ... View more

@Jagadishkatam wrote: alternatively in a data step with end option and sum function   data want; set one end=eof; count_+count; if eof; run; Neat. Needs just a little code to create the wanted summary line text. ... View more

Hi ,   data one; infile datalines; input Group_Name: $12. Head_Name :$12. LastYear_Count BeforeLastYear_Count; datalines; R&D IT 1 2 R&D Testing 0 5 R&D Production 4 0 R&D Development 1 0 Sales Book 5 4 Sales Product 10 0 Sales Kit 1 1 Admin Marketing 4 1 Admin HR 5 2 Admin Project 6 3 ; run; proc report data=one out=want1; column group_name Head_Name LastYear_Count BeforeLastYear_Count; define group_name/order; define head_name/display; define LastYear_Count/sum; define BeforeLastYear_Count/sum; break after group_name/summarize; run; data final (drop=_break_); set want1; by group_name ; if last.group_name then group_name='totel'; run; Thanks 🙂  ... View more

If I will create date parameter as character then I will not be able to use this prompt for manipulation as I have to create a report for fortnight count for the Action. ... View more

In my case I have to get the report only for few restricted dates i.e 15,28,29,30 and 31 for all the years and months. If I use VA to generate the report I can select only these dates. ... View more