BookmarkSubscribeRSS Feed
TestingSAS
Obsidian | Level 7

Hi All,

 

in myproject, if i override few values, can i export and import in another project?

i don't want to copy and paste the data but want to export into a file and then want to import it into the project.

4 REPLIES 4
wandas
SAS Employee
We are currently working on new forecast override functionality for the next release. Importing external overrides is a requirement under consideration. As Product Manager of SAS Forecasting (Forecast Server, Forecast Studio, FSC, etc), I'd like to talk with you about this topic. Please contact me directly to discuss. Thanks!
TestingSAS
Obsidian | Level 7

sue let me know how and where

mitrov
SAS Employee

Hi:

 

I can think of two ways of doing it.

  1. Simply make a copy of the project. The copy operation will preserve the overrides. Then change the project settings you want. This is the easiest way. 
  2. The second method requires some simple coding that uses the batch macro %FSSETOVR to add the overrides to the new project.

The flow for method 2 is as follows:

  1. set your libraries corresponding to the hierarchy of your source project. You can copy the code from "libraries_declaration.sas" in your project folder roor directory
  2. Either gather all the OUTVRD data sets from the hierarchy levels into one data set, or loop over the hirerarchy levels
  3. Use the %FSSETOVR macro to apply the overrides to the new project.

This is just an example of the code where the original project has OUTOVRD data set at three levels.

 

**********************************************************************                                                                  
* DECLARING LIBRARIES.                                                                                                                  
*********************************************************************;                                                                  
                                                                                                                                        
%let HPF_LIBNAME_OPTIONS=;                                                                                                              
                                                                                                                                        
%let HPF_PROJECTDIR = C:\SAS\SASForecastServer14.1\Default\Projects\myOldProject\;                                                      
libname _project "&HPF_PROJECTDIR" &HPF_LIBNAME_OPTIONS;                                                                                
libname _top "&HPF_PROJECTDIR\hierarchy\top" &HPF_LIBNAME_OPTIONS;                                                                      
libname _HPF0 "&HPF_PROJECTDIR\hierarchy\regionName" &HPF_LIBNAME_OPTIONS;                                                              
libname _HPF1 "&HPF_PROJECTDIR\hierarchy\productLine" &HPF_LIBNAME_OPTIONS;                                                             
libname _HPF2 "&HPF_PROJECTDIR\hierarchy\productName" &HPF_LIBNAME_OPTIONS;                                                             
libname mylib "c:\FS";                                                                                                                  
                                                                                                                                        
                                                                                                                                        
                                                                                                                                        
**********************************************************************                                                                  
* GATHER OVERRIDES                                                                                                                      
*********************************************************************;                                                                  
                                                                                                                                        
data mylib.allovrd;                                                                                                                     
   set _hpf2.outovrd _hpf0.outovrd _top.outovrd ;                                                                                       
run;                                                                                                                                    
                                                                                                                                        
                                                                                                                                        
**********************************************************************                                                                  
* APPLY OVERRIDES TO NEW PROJECT                                                                                                        
*********************************************************************;                                                                  
                                                                                                                                        
                                                                                                                                        
%fslogin (user     = yourSASUserName,                                                                                                           
          password = yourSASPassword,                                                                                                         
         );                                                                                                                             
                                                                                                                                        
%fssetovr(ovrds=mylib.allovrd,                                                                                                              
          projectName=myNewProject,                                                                                                     
          environment=default,                                                                                                          
          reconcile=YES,                                                                                                                
          outfailed=IHopeNone                                                                                                           
         );                                                                                                                             
                                                                                                                                        
                                                                                                                                        
%fslogout();                                                                                                                            
                                                     

 

SINNETIC
Calcite | Level 5
Hello.

Do you know if actually, the current version of SAS Forecast desktop has the functionality incorporated?

sas-innovate-2024.png

 

Time is running out to save with the early bird rate. Register by Friday, March 1 for just $695 - $100 off the standard rate.

 

Check out the agenda and get ready for a jam-packed event featuring workshops, super demos, breakout sessions, roundtables, inspiring keynotes and incredible networking events. 

 

Register now!

Multiple Linear Regression in SAS

Learn how to run multiple linear regression models with and without interactions, presented by SAS user Alex Chaplin.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 4 replies
  • 1347 views
  • 1 like
  • 4 in conversation