topic Re: Analytics Pro - Desktop in Administration and Deployment

Analytics Pro - Desktop

Gladis6680 — Thu, 17 Jun 2021 15:08:31 GMT

Hi I had a quick question. I have the Analytics Pro-Desktop. I was wondering what "Access to PC Files" does?

Thanks,

Gladis

Re: Analytics Pro - Desktop

Reeza — Thu, 17 Jun 2021 15:14:40 GMT

The documentation answer:

You can use SAS/ACCESS Interface to PC Files to read data from PC files for use in SAS reports or applications. You can use SAS data sets to create PC files in various formats. SAS/ACCESS Interface to PC Files includes accessing data in Microsoft Access database files and Microsoft Excel workbook files as well as in other PC file formats.

Basically, you need it to work with Excel files especially things like Access files or if you're using Excel as a 32 bit version and SAS 64 bit version.

https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/acpcref/n1wqgr4en68w78n1lzzhwqdb6m3y.htm#:~:text=You%20can%20use%20SAS%20data,in%20other%20PC%20file%20formats.

Are you looking for information beyond this?

Re: Analytics Pro - Desktop

Gladis6680 — Thu, 17 Jun 2021 15:18:40 GMT

Oh I see does it mean I can import files from eg excel and export files to excel.

Thanks,

Re: Analytics Pro - Desktop

Reeza — Thu, 17 Jun 2021 15:21:09 GMT

Basically, yes. There are some ways to export to Excel without this but they're all pretty painful.