title: How to merge multiple csv files into 1 SAS file
body: <p>I just started using SAS 3 days ago and I need to merge ~50 csv files into 1 SAS dataset.</p>
  
  <p>The 50 csv files have multiple variables with only 1 variable in common i.e. "region_id"</p>
  
  <p>I've used SAS enterprise guide drag and drop functionalities to do this but it was too manual and took me half a day to upload and merge 47 csv files into 1 SAS file.</p>
  
  <p>I was wondering whether anyone has a more intelligent way of doing this using base SAS?</p>
  
  <p>Any advice and tips appreciated!</p>
  
  <p>Thank you!</p>
  
  <p>Example filenames:
  2011Census_B01_AUST_short
  2011Census_B02A_AUST_short
  2011Census_B02B_AUST_short
  2011Census_B03_AUST_short
  .
  .
  2011Census_xx_AUST_short</p>
  
  <p>I have more than 50 csv files to upload and merge. </p>
  
  <p>The number and type of variables in the csv file varies in each csv file. However, all csv files have 1 common variable = "region_id"</p>
  
  <p>Example variables:
  region_id, Tot_P_M, Tot_P_F, Tot_P_P, Age_0_4_yr_F etc...</p>