topic Re: DBMS type STATA not valid for export in SAS Procedures

DBMS type STATA not valid for export

comeon2019 — Sun, 19 May 2019 01:25:35 GMT

Hi,

I used to use the following code to export SAS data into Stata and it worked.

proc export data=WORK.US_rd39 outfile= "C:\Users\Desktop\research\projects\R&D\data1st\us_rd39.dta";

run;

But now it says

*ERROR: Unable to determine datasource type. Please use the DBMS= option.;

I used DBMS=Stata like below:

PROC EXPORT DATA= WORK.US_rd39

FILE= "C:\Users\Desktop\research\projects\R&D\data1st\us_rd39.dta"

DBMS=STATA REPLACE;

PUTNAMES=YES;

RUN;

But the ERROR message said DBMS type STATA not valid for export.

Could anyone please help me to look into this issue? Thank you.

Re: DBMS type STATA not valid for export

SASKiwi — Sun, 19 May 2019 04:25:09 GMT

According to the documentation DBMS = DTA is the correct option for exporting to STATA: https://documentation.sas.com/?docsetId=acpcref&docsetTarget=p1d0tocg3njhmfn1d4ld2covlwm0.htm&docsetVersion=9.4&locale=en

You will find answers a lot quicker if you search the documentation first.

Re: DBMS type STATA not valid for export

comeon2019 — Sun, 19 May 2019 22:11:05 GMT

Thanks SASKiwi.

I had a look at the documentation and tried DBMS = DTA, but it still shows the following error message

ERROR: DBMS type DTA not valid for export.

I don't know why.

Re: DBMS type STATA not valid for export

SASKiwi — Mon, 20 May 2019 00:31:03 GMT

DTA is a valid option only if you have SAS/ACCESS to PC Files licensed and installed. PROC SETINIT will show if it is in your licence and PROC PRODUCT_STATUS will show if it is installed.

Re: DBMS type STATA not valid for export

ballardw — Mon, 20 May 2019 15:41:43 GMT

@comeon2019 wrote:

Hi,

I used to use the following code to export SAS data into Stata and it worked.

proc export data=WORK.US_rd39 outfile= "C:\Users\Desktop\research\projects\R&D\data1st\us_rd39.dta";

run;

But now it says

*ERROR: Unable to determine datasource type. Please use the DBMS= option.;

So when did you "use to use" that code? Before a SAS license change, on a different SAS install, different computer?

Something has changed and will likely point to the reason code doesn't work.

Re: DBMS type STATA not valid for export

comeon2019 — Thu, 23 May 2019 13:41:48 GMT

Thank you SASKiwi.

As I checked, it seems “SAS/ACCESS Interface to PC Files” is not licensed or installed.

IT people in my organization helped me with the renewal of SAS last month. I am not sure how if he has installed all the components that we are entitled to, but I would personally reckon that he should have installed all the components by default.

According to your knowledge, do we need to purchase additional component?

Thank you.

Re: DBMS type STATA not valid for export

comeon2019 — Thu, 23 May 2019 13:45:55 GMT

Thank you ballardw.

I used that code early this year. It worked.

I renewed SAS last month after it was expired.

I not sure if the components in the licence have changed or not during the renewal.

Re: DBMS type STATA not valid for export

SASKiwi — Thu, 23 May 2019 20:14:50 GMT

Applying a SAS licence doesn't involve installing products unless the licence has changed to require it. Comparing your current SAS licence with the previous one should confirm if anything has changed. If nothing has then I'm mystified as to why STATA exports used to work but now don't.

Re: DBMS type STATA not valid for export

jcheng — Sun, 03 Oct 2021 21:34:46 GMT

Hi,

I also has the problem when I use sas(sas eg) import proc to import .dta file into sas. It either has the error"the physical file does not exist "