About ImVickie

ImVickie · ‎06-13-2016

Hi Ujjawal, I also faced the same problem, What i do for this i will share with u, U also Try and Let me know if its working or not 1. Load the table, make the report then save it. 2. Open new report > Click On Add Data Source > Add your new Excel with changes > Give the same name > Refresh the data 3. Close the new report > Open your Old Report > Refresh the Data. this steps work fine for me.. Thanks Vicky

Sam_SAS · ‎05-25-2016

Hi Vickie, As far as I know, there is not an easy way to do this. Many customers have requested that we better support fiscal year (and other alternative timeframes), so it is something the development team is looking into for the future. Thanks, Sam

BPD · ‎05-12-2016

Hi ImVickie, Yo don't mention whether this is a character or numeric 201305. The code shows how to do this with character but with the numeric option commented out. data a; * daten = 201305; * sasd = input(put(daten,6.),yymmn6.); datec = '201305'; sasd = input(datec,yymmn6.); newdt = put(month(sasd),monname3.)!!'/'!!PUT(Year(sasd),4.); run; Hope it's what you want. Regards

Online Status	Offline
Date Last Visited	‎06-16-2016 03:37 AM

Re: Report Connected with Updated File

YTD, MTD calculation for Fiscal Year

Date Conversion

Tip! Use containers to provide visual clues to user

How to get crosstab columns (monthly) to total 100%, instead of as a s...

Re: Report Connected with Updated File

Re: YTD, MTD calculation for Fiscal Year

Re: Date Conversion