BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
Dil0424_ks
Calcite | Level 5

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

 

1 ACCEPTED SOLUTION

Accepted Solutions
Reeza
Super User

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

 


 

View solution in original post

2 REPLIES 2
Reeza
Super User

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

 


 

Dil0424_ks
Calcite | Level 5

Hi, Please find the attached file. 

Also Attached required output format.

 

Thanks 

 

sas-innovate-2024.png

Available on demand!

Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.

 

Register now!

SAS Enterprise Guide vs. SAS Studio

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 2 replies
  • 917 views
  • 0 likes
  • 2 in conversation