How do you run start-up code the first time when creating a new forecast project?  My data source requires a LIBNAME statement to connect.  When I add the start and stop code and advance to select the data set, my new library is not an option and FS will not let me save and close the project without completing all the set up processes.   The only solution that have found so far is to create a project with a random data set, close and reopen it so the start-up code can actually run, and then rebuilding the project with the data I actually want to use.  Having my admin assign new libraries to the server config every time I have a new or modified data source is not a practical solution.   EM has a 'run now' capability that addresses this scenario making new data sources immediately available.   I am working in v9.4 M4 with all patches/hotfixes applied with FS v14.2 Thanks, Eric ... View more

I have a single xlxs file with multiple worksheets.  The same 3 variables are on each worksheet, but the worksheet name provides the group id the data belongs to.   I want to import the worksheets; append into a single datafile; and analyze.  ODBC connect to open and PROC APPEND do this easily.  My problem is there is there doesn't appear to be the option to add worksheet name as an additional output var in the appended data output table to provide a group id for analysis.   What I get from ODBC + PROC APPEND var1 var2 var3   What I want worksheet_name  var1 var2 var3   Know could just do create query for each worksheet and add the name variable there, then do append; but my actual file has 23 worksheets and trying to simplify.  Any ideas or direction to something I am missing are appreciated!  Thanks, Eric ... View more