Calcite | Level 5

## 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.

Regards,

Dil0424_KS

1 ACCEPTED SOLUTION

Accepted Solutions
Super User

## Re: reading excel file in EG

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.

Regards,

Dil0424_KS

2 REPLIES 2
Super User

## Re: reading excel file in EG

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.

Regards,

Dil0424_KS

Calcite | Level 5

## Re: reading excel file in EG

Hi, Please find the attached file.

Also Attached required output format.

Thanks

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