topic Re: Export to Access Database feature in SAS EG7.1 in SAS Programming

Export to Access Database feature in SAS EG7.1

ArshiaGupta91 — Mon, 21 Sep 2020 09:54:28 GMT

I was using SAS EG4.3 to export big datasets using Microsoft Access 2002-03 but with the migration from 4.3 to 71, I am not able to use the feature. I have also tried to export the data using proc export procedure but it did not work. Need some solution to resolve this.

Re: Export to Access Database feature in SAS EG7.1

andreas_lds — Mon, 21 Sep 2020 09:59:00 GMT

"did not work" can mean anything, so you will have to provide more details, an error-message is a good starting point. But, i would talk to my local sas-admin first.

Re: Export to Access Database feature in SAS EG7.1

ArshiaGupta91 — Wed, 23 Sep 2020 10:07:43 GMT

I was using SAS EG 4.3 as legacy process where I was using manual export feature available to export larger datasets to access database to connect the same with Microsoft excel for data analysis. Since EG 4.3 is decommissioning and we have migrated to EG 7.1 using SAS 9.4, we want to use the same feature of 4.3 but cannot use. I have tried proc export procedure as well and it is not working.

Re: Export to Access Database feature in SAS EG7.1

andreas_lds — Wed, 23 Sep 2020 11:10:33 GMT

@ArshiaGupta91 wrote:

I was using SAS EG 4.3 as legacy process where I was using manual export feature available to export larger datasets to access database to connect the same with Microsoft excel for data analysis. Since EG 4.3 is decommissioning and we have migrated to EG 7.1 using SAS 9.4, we want to use the same feature of 4.3 but cannot use. I have tried proc export procedure as well and it is not working.

So you just replaced a very outdated version with an outdated one. Well, some decisions are harder to understand than others. To provide some real help, i just repeat what i have already said:

"did not work" can mean anything, so you will have to provide more details, an error-message is a good starting point. But, i would talk to my local sas-admin first.

Re: Export to Access Database feature in SAS EG7.1

ArshiaGupta91 — Wed, 23 Sep 2020 15:49:26 GMT

There is no error message while doing manual export. If we try to export the dataset using export functionality is menu bar, exporting dataset to Access data base is not available in SAS 7.1 Please let me know if you need further clarification.

Re: Export to Access Database feature in SAS EG7.1

andreas_lds — Thu, 24 Sep 2020 07:50:15 GMT

This could be caused by the configuration of the enterprise guide role. You have to talk about this with your local sas-admin and he/she has no valid explanation, you should contact sas tech support. Maybe the feature has been removed due to incompatibility with ms access.

Re: Export to Access Database feature in SAS EG7.1

Vince_SAS — Thu, 24 Sep 2020 12:28:40 GMT

Please open a track with our Technical Support Department:

https://support.sas.com/en/technical-support/submit-a-support-request.html

Vince DelGobbo

SAS R&D