HI Teja ,     Thank your for the solution , its working out ...     regards Soman ... View more

Hi Teja ,   Thank u very much for u r support on the issue i have raised , have worked out on IF then else to stick on to the fixed date .   Rgds Soman ... View more

Thank U Peter ..   Done with the isuue ..     Rgds Soman ... View more

Hi Teja ,   I really thank u for trying to help me . i will try to explain u in detail  I have data set which gets updated daily of the sales hapening in the company. i have to now send a daily sales report of the sale updated in the dataset through SAS VA. so today that 14/12/2015 my system is showing the below sales item                      qty tooth brush -         1 paste          -          0 soap          -          1 pen           -           3   So i have to publish this report tommrow morning projecting tha sales of 14/12/2015   in the same way i have publish reports everyday i.e 15/15/2015 , 16/12/2015 , i have write a code where system picks data for the single day.   rgds soman ... View more

HI Teja   Date                 Sales 10/12/15            200 11/12/15            150 12/12/15            300 13/12/15              0 14/12/15            100   as per the above expample , i need to make automated reports which will be scheduled for each day .  one report will shoot on 10/12/15 , showing the sale of 200 next morning second report 11/12/2015 will shoot showing the sale of 150 in this way..   rgds soman   ... View more

Dear All,   Pls awating for help on the  question .. ... View more

HI Teja ,   Can u pls guide me step by step to work on date = asondate     rgds soman ... View more