Hi   Run the this code libname sasuser list; It will give some details on SASUSER including the permission settings. this will explain the error you get. Whether you can change the permission for the directory, this depends on the setup.   Bruno ... View more

Hi   I do not know what the content of the start_date parameter looks like, so difficult to say   Also is invoice_date really a datetime value? If it is just a date, you do not need the datepart operator?   to test the outcome of your expressions, I suggest to create a new data item and then use the preview button to see the outcome of an expression, see also below. This should help with debugging.   Bruno ... View more

Hi   If you want to select a date range, then I suggest to use a slider in the section prompt area. Assign the right date variable to the slider, then your report objects are filtered automatically   See a screenshot below:   Bruno ... View more

Hi   You need to create a filter on your report object, the filter can use any parameter value. Please note a parameter can only be numeric or character.   So one approach could be: Create a new calculated date item like below. This will create a character item in form of 2016M05. Format('date'n[Raw], 'YYMM7.') Then put a dropdown list into the canvas area and assign this the calculated item from before to this dropdown list.   Create a parameter of type character and assign it to the dropdown list.   then create a filter on you bar chart similar to this: ( Year('date'n) = ( Parse(Substring('dateYYMM_p'p, 1, 4), 'F12.') - 1 ) ) OR ( Year('date'n) = Parse(Substring('dateYYMM_p'p, 1, 4), 'F12.') ) Now whenever to select a given month from the dropdown list, the bar chart will be filtered accordingly.   The example only covers filter for the selected year and year - 1, it needs to be adapted to also check for the month.   You then have data from two years and can use Periodic operators   Bruno ... View more

hi   this looks similar to https://communities.sas.com/t5/General-SAS-Programming/Difference-In-Dates-From-Data-Imported-SAS-Local-Data-Provider-9/td-p/170250   Bruno ... View more

Hi   check out the ODS EXCEL destination   code will look similar to   ods excel file="c:\temp\sample.xlsx" options(SHEET_INTERVAL= 'NONE'); proc print data=sashelp.class; where sex = "F"; run; proc print data=sashelp.class; where sex = "F"; run; ods excel close; Bruno ... View more

Hi To query which views are available you can use DICTIONARY.VIEWS.   As @LinusH pointed out, to actually figure out what tables and columns are coming from which tables/views you need to parse the output of the DESCRIBE statement from Proc SQL or the DATA Step.   Below are some code examples: data work.ds_view / view=work.ds_view; set sashelp.cars; run; proc sql; create table myviews as select * from dictionary.views ; quit; proc sql; describe view SASHELP.VTABLE; quit; data view=work.ds_view; describe; run; Bruno ... View more