17 Aug Create a SAS script and read the datasets into SAS for analysis.
While working on your inventory project, you realize that you need to read the data sets into SAS before you begin analysis. Your SAS program needs to read all the datasets that are necessary to predict store sales.
Reading in Dates: You can use import or infile to import the data. If you use infile, you will need to format the date fields in your input statement. Example: read in 3 fields; StoreID, Date1, Date2. Use a : prior to the MMDDYY10. to specify the input format in the input statement.
INPUT StoreID $ Date1 :MMDDYY10. Date2 :ANYDTDTE10. ;
An example is included in your SAS Studio shared folder, READDATES.SAS
Create a SAS script and read the datasets into SAS for analysis.
- train.csv
- test.csv
- stores.csv
- features.csv
Please submit ONE word doc with the following to the dropbox:
- Text of each SAS Script code (not a screenshot, I need to be able to run your code). You can include one document with all code included, clearly label each script.
- A screenshot of each SAS script OUTPUT, clearly labeled.
