data outst_amt; input prd_cat : $25. cus_cat & $20. Date_values & $20. Out_amount ; datalines; Hire-Purchase Business-banking 25thaug2010 234 Housing-Loans Consumer-banking 26-Aug-2010 243 Credit-card Business-banking 26-Aug-2010 342 Personal-Loan Consumer-banking 25-Aug-2010 456 Co-op-Personal-Loan Business-banking 27-Aug-2010 356 Share-Margin-Financing Consumer-banking 28-Aug-2010 123 Revolving-Credits Business-banking 25-Aug-2010 213 Syndicated-Loans Consumer-banking 24-Aug-2010 432 Trade-Financing Business-banking 29-Aug-2010 124 Term-Loans Consumer-banking 31-Aug-2010 145 Overdraft Business-banking 25-Aug-2010 234 Other-loans Consumer-banking 26-Aug-2010 187 ; run; I want the output as follows: Item Descriptions ------Date values------- 25-Aug 26-Aug 27-aug 28-Aug A.Loans by Business Segment Business banking 314 345 Consumer banking 234 213 Total Gross Loans B.Gross Loans by Products Hire Purchase 367 276 Housing Loans 342 Credit card Personal Loan 243 Co-op Personal Loan Share Margin Financing 234 567 Revolving Credits 546 Syndicated Loans Trade Financing Term Loans Overdraft 345 657 546 Other loans Total Gross Loans Can anyone help me on this, as I was strucked from morning onwards. Thanks in advance ... View more

I have four columns named prd_grp,prd-subgroup,prd_desc and loan_amount. The data is as follows: prd_grp prd_subgroup prd_desc loan_amount ASSETS All_Other Loans 234 ASSETS All_Other abc 345 ASSETS All_Other Quoted_Shares 213 LIABILIITES Deposits Current_Deposs 435 LIABILIITES Deposits Fixed 325 LIABILIITES Deposits NIDs & Repos 256 LIABILIITES Deposits Savings 218 Below is the output I needed Item Loan_amount ASSETS All_Other Loans 234 abc 345 Quoted_Shares Held 213 Total 692 LIABILIITES Deposits Current Deposits 435 Fixed 325 NIDs & Repos 256 Savings 218 Grand_Total 1234 Can anyone help me on this, as this is critical. Thanks in advance. Regards, Siddhartha ... View more

I have four columns named prd_grp,prd-subgroup,prd_desc and loan_amount. The data is as follows: prd_grp prd_subgroup prd_desc loan_amount ASSETS All Other Loans 234 ASSETS All Other abc 345 ASSETS All Other Quoted Shares Held 213 LIABILIITES Deposits Current Deposits 435 LIABILIITES Deposits Fixed 325 LIABILIITES Deposits NIDs & Repos 256 LIABILIITES Deposits Savings 218 Below is the output I needed Item Loan_amount ASSETS All Other Loans 234 abc 345 Quoted Shares Held 213 Total 692 LIABILIITES Deposits Current Deposits 435 Fixed 325 NIDs & Repos 256 Savings 218 Total 1234 Can anyone help me on this. Thanks in advance. Regards, Siddhartha ... View more

I am having a dataset with variables empcode,empname,sal,designation I want to find out the top 5 salaries based on the designation. Designation is a group variable. Can anyone help me on this using datastep and proc sql; Regards, Siddhartha ... View more

I am having a dataset with 100 observations. I want to read only 5th,19th,21st records using data step and proc sql. How can I do this? Regards, Siddhartha ... View more

I have a two datasets.I need to get the output as follows: data one; input x; 1 2 3 4 5 6; run; data two; input x; 1 3 6 7 8 9 ; run; the ouput is as follows: 4 5 6 7 8 9 ... View more

Hi, I am having the following variables as pr_num,week,product,total_rxn,total_rx,sbu,terri_state and district. I want to group the product by terri_state ,total_rxn,total_rx,district for the current month & previous month(here the date format is like this ddmmyyyy. I need to develop a report for the current month & previous month. Can anyone help me in this regard. Regards, Sid ... View more

Hi, I am having the following variables as pr_num,week,product,total_rxn,total_rx,sbu,terri_state and district. I want to group the product by terri_state ,total_rxn,total_rx,district for the current month & previous month(here the date format is like this ddmmyyyy. I need to develop a report for the current month & previous month. Can anyone help me in this regard. Regards, Sid ... View more

Can we limit the observations while joining two datasets with common id x like x<30. Could anyone help me which is efficient in joining the datasets, is it merge or proc sql. Regards, Sidhu ... View more

I got a requirement that is ,One data set contains 10obs. By using this dataset how can I create a data set with 1 million obs. Regards, Siddhartha ... View more

If I want to delete local macro variable within a macro, what is the process? Can any one explain me with an example. Regards, Sidhu ... View more