05-18-2012 02:21 PM
Thanks for your swift response. How should my proc import statement look like if I were to import it as a 'view' rather than as a dataset? I apologize for my ignorance . .. We use SAS Enterprise Guide here and I do not have sufficient authorization to do DDE . ..
With kind regards,
Hui P. Liew, Ph.D.
1751 Earl Core Road
Morgantown, WV 26505
05-18-2012 03:00 PM
Drat -- they changed the option in EGuide 5.1. In 4.x, you could set a global parameter to create views instead of datasets (in tools --> options). Although there is a reference to in in the query builder help, I can't find it (In query builder, you can change the data type via the options button in the task). The import wizard does not allow the change for one file.
Since you are using EGuide, you could put the import in the autoexec process flow and it would update each time the project is opened.
Another approach if you are creating the data for others to use, which is more semi-automagic, would be to use a scheduled task to run the import activity that kicks off frequently.