Code: Select all
!year=2000+@right(@date,2)
wfcreate test m 2000 !year
import R:\Eviews\SAS_Data\nav_data_all_ts.sas7bdat @freq m 2000
delete date
Now, I am unsure how to setup the database and copy all the variables from the workfile called test (except for c and resid) into the database. This database should be able to be overwritten every month. I just want to be able to open the program and run it to update with new data. So:
1. Syntax to create the database without any "database already exists" errors (can be able to overwrite).
2. Copy variables into it.
Or do I even need to use a workfile at all? Can there be a direct import to a databse?
Thanks!