Programming Tips 1

---

This project has more than 20 sections. 

In later sections, we often provide code that is based on tables created in previous sections.

For example, the code we run in the last section is based on the SALES_Q1 table created in the very beginning:

proc sql;
select 
  distinct 
    qtr(datepart(tran_date)) 
      as quarter, 
    year(datepart(tran_date)) 
      as year
from sales_q1;
quit;

If the SALES_Q1 table is not already created, you will see the error message below:

​ERROR: File WORK.SALES_Q1.DATA does not exist.

For your convenience, we include the code for the previously generated tables in the yellow box.

proc import datafile = "/folders/myfolders/Geo-targeting/Data Files/Sales_Q1.csv" out = Sales_Q1 dbms = CSV replace ; run;

Run the code in the yellow box if you see the error message above.

Okay. got it!