Task [2-4]
The sales department in France has submitted their data to you to combine with the master ONLINE_RETAIL data set. The data set is called FRANCE_SALES_201110.
france_sales_201110.sas7bdat
File Size: 196 kb
File Type: sas7bdat
Download File
  1. Run a PROC COMPARE with the LISTVAR and NOVALUES options to compare the October 2011 French data with the main ONLINE_RETAIL data set. What differences do you notice?

  2. Using Data Step, use any functions and SAS code necessary to standardize the French October 2011 data to match the structure of the ONLINE_RETAIL data set. Create a new data set called FRANCE_SALES_201110_CLEAN.

  3. Run a PROC COMPARE again to verify that the structure of FRANCE_SALES_201110_CLEAN and ONLINE_RETAIL are equal (you can ignore any differences in informats).
    ​
  4. Once you have verified that the structures are equal, append the October 2011 French data to the main dataset, and create a new dataset, ONLINE_RETAIL_NEW.
Do you need help?