Desktop productivity for business analysts and programmers

reading excel file in EG

Accepted Solution Solved
Reply
New Contributor
Posts: 2
Accepted Solution

reading excel file in EG

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

 


Accepted Solutions
Solution
‎01-19-2018 01:33 PM
Super User
Posts: 22,875

Re: reading excel file in EG

Posted in reply to 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

 


 

View solution in original post


All Replies
Solution
‎01-19-2018 01:33 PM
Super User
Posts: 22,875

Re: reading excel file in EG

Posted in reply to 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

 


 

New Contributor
Posts: 2

Re: reading excel file in EG

Hi, Please find the attached file. 

Also Attached required output format.

 

Thanks 

 

☑ This topic is solved.

Need further help from the community? Please ask a new question.

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