Hi All, I read excel file(xlsx) and i have one Date variable. When i read it using proc import i get strange values. Firs of all the Date variable was converted to character variable, The second, the values i get are very strange. For example, in excel date value was 28/09/2024 and it was converted to 45563 and not to 23647.(of course it character value). Please help... What's wrong? Thank you   ... View more

Hi All, Maybe somebody knows how to apply CUBIC SPLINE for yields to create Yield Curves, but not using proc iml? Thank you, Alexey ... View more

Hi All, I have two questions : 1. When i use ods excel to export excel, i want to update the height of rows. I tried two methods : absolute_row_height and row_heights. In both, i get the same result, The rows that comes directly after the data are different than the height i fixed. For example, if my data contains 100 rows, and i used absolute_row_height ='16' then the first 100 rows height will be 14.25 and the rows after the first 100, will be different. How can i fix the the height of row for all rows in excel?  2. Because i live in Israel, when i export to excel using ods excel, i get my data is from right to left. How can i change the data to left to right?   Thank you, Alexey ... View more

Hi All, I don't remember the name of SAS Procedure that run a lot of different regressions(transformations) based on specific variables(model) and choose the best. It can be linear regression or quadratic regression, it can contain different transformations of variables and so on. Thank you     ... View more

Hi All, Overall i  want to optimize my equations using Nelson Siegel  to build Hazard Rate Curves through proc model. I have a problem to define the following  equation:   HAZARDRate = Spread / (1 - RecoveryRate);  because i cannot calculate directly  HAZARDRate, i don't have a formula, so i calculate it like implied HazardRate as you can see here   PROC model data=input MAXITER=&Maxiter CONVERGE=0.0000001 SINGULAR=0.0000001 MAXSUBIT=&Maxsubit NOITPRINT noprint ; Price=sum(%hr(n=65)); PARMS HazardRate; BOUNDS HazardRate<=1; fit PredictedPrice start=(HazardRate=0.01) / OUTPREDICT OUTEST=predictedhr; run; quit; and hr defined like  %global j; %macro hr(n); %do i=1 %to &n; %let j=%eval(&i-1); %if &j=0 %then %do; (real_amount&i*exp(-HazardRate*tm_d&i/365)+remainingprincipal&i*((1-exp(-HazardRate*tm_d&i/365))*RecoveryRate))*df&i, %end; %else %do; (real_amount&i*exp(-HazardRate*tm_d&i/365)+remainingprincipal&i*((exp(-HazardRate*tm_d&j/365)-exp(-HazardRate*tm_d&i/365)))*RecoveryRate)*df&i, %end; %end; 0 %mend; So how can i define this equation? Is there any way?  RecoveryRate - parameter Spread - fixed Thank you, Alexey   ... View more

Hi,  I have to create the following report. I have attached excel file.   From my table   data sales; format date ddmmyy10.; date="22may2022"d; store="A"; Sales=50; Quantity=60; Expenses=40; output; date="23may2022"d; store="A"; Sales=60; Quantity=70; Expenses=40; output; date="22may2022"d; store="B"; Sales=10; Quantity=60; Expenses=30; output; date="22may2022"d; store="B"; Sales=20; Quantity=70; Expenses=30; output; RUN; Excuse me for many questions. I don't know how can i merge cells like "Total Parameters"(C1:D1) or "Total"(A5:B5) , how can i add subtotal and totals for each store for specific variables, how can i add formulas, for example : Contrib = Sales- Expenses (C5-E5), or in Total/Summary, how can  add a bold border between each store and of courses how can i add a colors.   Thank you   ... View more