@Kris18 wrote:
With exporting in SAS, what happens if the file type does not match the dbms? And what is a way to avoid this in general? Or an ingenious way to avoid this?
Say I want to import an EXCEL sheet with the following code:
PROC IMPORT OUT= AGR.myfirstdata DATAFILE= "&path.&XL_in" DBMS=xls REPLACE; RANGE="Data";*use either range or sheet but not both; *Sheet=CIR_02; GETNAMES=YES; RUN; proc print data=AGR.myfirstdata;run;
SAS isn't going to care about the file extension, it writes the file with the DBMS specified.
I'm assuming by 'file type' you mean extension? You can change that to whatever you want, it may or may not change the underlying data but that has nothing to do with SAS and more to do with how the file system and other applications work.
... View more