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 |
- 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?
- 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.
- 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).
- 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.