Hello, I'm a beginner on SAS and I have a question of writing a macro. Basically I want to write a macro to read several files with the same name in different folders. For example, folder a and b both have a file name x. What I want to do is to read append the two files and create another observation which indicates which folder the part of new combined file comes from.      Thank you so much    XB ... View more

Hello, guys. I'm doing a project which requires to implement a model with adjustment for mean-reverting. Basically, the model is like y(t)-y(t-1)=beta + (gamma_1 +gamma_2*x+gamm_2*x*z+gamma_3*z*l )*l+(lambda_1+lambda_2*k+lambda_3*k*n)*n+u I'm wondering whether there is a quick way to run this regression with an estimate p-value. Thank you so much in advance XB ... View more

Hello, guys. I'm doing a project which requires to implement a model with adjustment for mean-reverting. Basically, the model is like y(t)-y(t-1)=beta + (gamma_1 +gamma_2*x+gamm_2*x*z+gamma_3*z*l )*l+(lambda_1+lambda_2*k+lambda_3*k*n)*n+u I'm wondering whether there is a quick way to run this regression with an estimate p-value. Thank you so much in advance XB ... View more

Hello, guys. I'm trying to replicate a empirical paper and I stick in a data step. Basically, I have a list of ID, dates, industry and firm ratios. What I wan to do is to locate another company with different id but the same date in another larger data set, Also, this matching company should be in the same industry and have similar ratios (within the range of plus and minus 10% of the companies in the original list). I'm wondering anyone can help? Thank you so much XB ... View more