H Folks,
I have 3sheets of excel in which 1st is Account Details as well Loan type(starting Loan date, emi dates, ending date, Loan against Asset, Asset Value, Sanctioned Loan Amount, ROI, Credit Ratings etc).
In 2nd Sheet , Poolid{1,2,...20}as Variables and Monthwise interest rate for e.g., first month 0.69% 2nd Month 0.79%...o.1% will be increased value in the subsequent months interest rates till 360 Months.
In 3rd Sheet , LGD{Poolid(1,2,..20) as Columns and Years(1,2,...10) as rows .
The problem is as follows:-
a)LGD table has to be........ For each Poolid's 10 observations has to come corresponding to their values.
b)Poolid table has to be For each Poolid's 360 observations has to come corresponding to their month and values.
As of now nothing to do with Account Details .
The problem is to create 3 DATASETs and in last append.
Thanks in advance for reply...
Regards,
Dil0424_KS
Welcome to SAS.
Can you please include sample data and illustrate how the calculations would work? This makes it easier to help you solve your problem.
@Dil0424_ks wrote:
H Folks,
I have 3sheets of excel in which 1st is Account Details as well Loan type(starting Loan date, emi dates, ending date, Loan against Asset, Asset Value, Sanctioned Loan Amount, ROI, Credit Ratings etc).
In 2nd Sheet , Poolid{1,2,...20}as Variables and Monthwise interest rate for e.g., first month 0.69% 2nd Month 0.79%...o.1% will be increased value in the subsequent months interest rates till 360 Months.
In 3rd Sheet , LGD{Poolid(1,2,..20) as Columns and Years(1,2,...10) as rows .
The problem is as follows:-
a)LGD table has to be........ For each Poolid's 10 observations has to come corresponding to their values.
b)Poolid table has to be For each Poolid's 360 observations has to come corresponding to their month and values.
As of now nothing to do with Account Details .
The problem is to create 3 DATASETs and in last append.
Thanks in advance for reply...
Regards,
Dil0424_KS
Welcome to SAS.
Can you please include sample data and illustrate how the calculations would work? This makes it easier to help you solve your problem.
@Dil0424_ks wrote:
H Folks,
I have 3sheets of excel in which 1st is Account Details as well Loan type(starting Loan date, emi dates, ending date, Loan against Asset, Asset Value, Sanctioned Loan Amount, ROI, Credit Ratings etc).
In 2nd Sheet , Poolid{1,2,...20}as Variables and Monthwise interest rate for e.g., first month 0.69% 2nd Month 0.79%...o.1% will be increased value in the subsequent months interest rates till 360 Months.
In 3rd Sheet , LGD{Poolid(1,2,..20) as Columns and Years(1,2,...10) as rows .
The problem is as follows:-
a)LGD table has to be........ For each Poolid's 10 observations has to come corresponding to their values.
b)Poolid table has to be For each Poolid's 360 observations has to come corresponding to their month and values.
As of now nothing to do with Account Details .
The problem is to create 3 DATASETs and in last append.
Thanks in advance for reply...
Regards,
Dil0424_KS
Hi, Please find the attached file.
Also Attached required output format.
Thanks
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 16. Read more here about why you should contribute and what is in it for you!
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.
Select SAS Training centers are offering in-person courses. View upcoming courses for: