Merge data, descriptive statistics,

[raqthesolid]

Hi everyone

i am new sas user. i have two types of data one is related to company and other related to banks. when i import these two excel data files into the sas i see some of the empty data files which are not the part of my data set??? hide all the extra columns and rows in the excel but still i am getting these files.

how to get rid of these empty columns??
* there are more than 15 variables and 10 countries. when i run a sas code for calculating the descriptive statistics i can found the so many tables one table for one set for each variables , which has further different tables for each country. i want a single table for all the variables and countries. is there any way i can get them ???

please share some codes to do so >

I have also attached my data file which has two sheets. one for bank specific variables and other for country specific variables. kindly also share some codes to marge these two data sets to make a one file so that i can run the regression and correlations and other statistical test.

thanks for my help.

[Reeza]

No data is attached and not sure what the following means:

* there are more than 15 variables and 10 countries. when i run a sas code for calculating the descriptive statistics i can found the so many tables one table for one set for each variables , which has further different tables for each country. i want a single table for all the variables and countries. is there any way i can get them ???