Hi Everyone,    I am trying to create some forecasts (has to be calculated mathematically) in SAS. The sample data and forecasts' nature is shown attached. I can do it in Excel, but no able to do it in SAS. I am using the "Retain" statement in SAS but that doesn't seem to work for me. I get missing values in the forecast periods.  Here, month 0 is the last period of "actuals" and forecasts begin from month 1.     data want; set have; retain variable2; if month<=1 then do; variable2 = lag1(variable1); variable1_f=variable1; end; else do; variable4 = variable3*variable2; variable6 = variable5*variable2; variable1_f = variable2+variable6-variable4 end; run;   Excel output is attached (which works).       How can this be implemented in SAS? Thanks in advance!   ... View more

My dataset came from Excel and some columns which should be numbers got converted as characters in SAS. Apart from one column I want to convert all other character columns into number format. How do I do that?   Lets say variables  "x", "y", "z","b", and "a" came in as character variables (Type= Char and format = $7.). Only variable x is okay to be a charcter. How do I keep variable  x as is and conert y, z, and b to Type = Num and format = BEST. in a simple way?   Was trying to do something like this, but not working:   data new; set old; if variable not = 'x' and format = '$7.' then format best.; run;   Thanks!   ... View more

Hello,    When I try to run the following code it says library does not exist. I am doing something wrong in the libname out statement. But not sure what. Please advice. Thanks in advance.     %let portfolio = samplename; libname out '/folder1/folder2/folder3/&portfolio';   proc import Out=out.BT_EOP_Balance_import datafile= "/folder1/folder2/folder3/&portfolio/excelfile1_&portfolio..xlsx" Dbms=xlsx replace; Sheet=BT_EOP_Balance; run;     ... View more

Hello Everyone,     I have a time-series graph of two variables up and running. How do i add/display the cross correlation value to the graph? I already ran a proc corr prior to these graphs, and can see the correlation value in a table, but would love to add to the graph (if possible).   /****following is my code so far***/ title "Variable1 and Variable2 Bivariate Graph with Correlation"; proc sgplot data=out_libactuals_2; format month mmyy6.; series x = Month y = Variable1; series x = Month y = Variable2  y2axis; run; quit;     Thanks in advance!     ... View more

  What do I need to do to see the HAC p-values/t-values to this regression?   proc autoreg data = model_input_6; model depvariable= indpevariable; run;   Thanks, Umair   ... View more