topic Merge data, descriptive statistics, in SAS Programming https://communities.sas.com/t5/SAS-Programming/Merge-data-descriptive-statistics/m-p/163685#M300249 <HTML><HEAD></HEAD><BODY><P>Hi everyone</P><P>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.</P><P><SPAN style="text-decoration: underline; color: #333399;"><EM><STRONG>how to get rid of these empty columns??</STRONG></EM></SPAN><BR />* 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.<EM style="text-decoration: underline;"><SPAN style="color: #000080; text-decoration: underline;"><STRONG> i want a single table for all the variables and countries. is there any way i can get them ???</STRONG></SPAN></EM></P><P>please share some codes to do so &gt;</P><H5>I have also attached my data file which has two sheets. one for bank specific variables and other for country specific variables. kindly also<SPAN style="text-decoration: underline;"><STRONG style="color: #333399;"> share some codes to marge these two data sets</STRONG></SPAN> to make a one file so that i can run the regression and correlations and other statistical test.</H5><P>thanks for my help.</P></BODY></HTML> Sun, 18 May 2014 06:29:07 GMT raqthesolid 2014-05-18T06:29:07Z Merge data, descriptive statistics, https://communities.sas.com/t5/SAS-Programming/Merge-data-descriptive-statistics/m-p/163685#M300249 <HTML><HEAD></HEAD><BODY><P>Hi everyone</P><P>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.</P><P><SPAN style="text-decoration: underline; color: #333399;"><EM><STRONG>how to get rid of these empty columns??</STRONG></EM></SPAN><BR />* 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.<EM style="text-decoration: underline;"><SPAN style="color: #000080; text-decoration: underline;"><STRONG> i want a single table for all the variables and countries. is there any way i can get them ???</STRONG></SPAN></EM></P><P>please share some codes to do so &gt;</P><H5>I have also attached my data file which has two sheets. one for bank specific variables and other for country specific variables. kindly also<SPAN style="text-decoration: underline;"><STRONG style="color: #333399;"> share some codes to marge these two data sets</STRONG></SPAN> to make a one file so that i can run the regression and correlations and other statistical test.</H5><P>thanks for my help.</P></BODY></HTML> Sun, 18 May 2014 06:29:07 GMT https://communities.sas.com/t5/SAS-Programming/Merge-data-descriptive-statistics/m-p/163685#M300249 raqthesolid 2014-05-18T06:29:07Z Re: Merge data, descriptive statistics, https://communities.sas.com/t5/SAS-Programming/Merge-data-descriptive-statistics/m-p/163686#M300250 <HTML><HEAD></HEAD><BODY><P>No data is attached and not sure what the following means:</P><P></P><PRE __jive_macro_name="quote" class="jive_text_macro jive_macro_quote" modifiedtitle="true"> <P></P> <P>* 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.<EM style="text-decoration: underline;"><SPAN style="color: #000080; text-decoration: underline;"><STRONG> i want a single table for all the variables and countries. is there any way i can get them ???</STRONG></SPAN></EM></P> <P></P> </PRE></BODY></HTML> Sun, 18 May 2014 17:10:19 GMT https://communities.sas.com/t5/SAS-Programming/Merge-data-descriptive-statistics/m-p/163686#M300250 Reeza 2014-05-18T17:10:19Z