Hello Giorgio, In using Visual Basic coding with the SAS Add-in, we do not have the ability to "reset" the report in Visual Basic coding.  You will have to select it manually.   Let me know if you have any additional questions regarding this issue. ... View more

Hello Grudos20,   There is not an easy way to get the data items detail from the Information Map studio.  You can use PROC INFOMAPS and the LIST statement to write that information to a file and then read in that file using other SAS code.  You can use PROC DOCUMENT to render the ODS output to a CSV file by reading in the log that is generated to a file.  /* Redirect the log to a file*/ proc printto log="c:\temp\tempmap.log"; run; /* Run Proc Infomaps to list the dataitems information */ proc infomaps metauser="sasdemo" metapass="XXXXXXX" metaserver="machine.com" metaport=8561 mappath="/Shared Data/Information Maps/"; update infomap "Prdsale Map"; list; save; quit; /* Turn off the Proc Printto */ proc printto; run; /* Proc Document to read in the log file and write it to a CSV file using ODS */ proc document name=logfile(write); import textfile="c:\temp\tempmap.log" to ^; run; ods csv file="c:\temp\map.csv"; replay; run; quit; ods csv close;  I have included links to some documentation as well. Documentation to Proc Infomaps  Documentation to Proc Document  ... View more

  There is no method to run the code directly in the VBA. However, if you have already defined the SAS Program, executed it in the SAS Add-in and you have results in the workbook,  you could save the workbook, and use the Refresh method to refresh the workbook or a sheet in the workbook that contains the location of the code results.    However, the first suggestion of placing your code in a stored process and executing the store process from the VBA would be a good solution to this question. ... View more

It sounds like you were opening the SAS data set directly from your local file system.   In order to keep date and/or time values formatted in pivot tables, you need to open it from a SAS library, either defined in SAS Management Console or a simple LIBNAME statement in the SAS Programs window.  ... View more