About MariaD

MariaD · ‎10-09-2018

Thanks again, @jebjur. So you said me that if we select "Import" menu, the .mdb type files appears but when we use "Export" menu don't?

MariaD · ‎10-09-2018

Hi @jebjur, Thanks for quickly answer. But we found some documents on SAS that says that we need to have the same version of office and EG to works. Please find below: Related, but applies to import rather than export... in the EG help (Help->SAS Enterprise Guide Help), the "Working with Data: File types that SAS Enterprise Guide reads and writes" topic has this note: "In the 64-bit version of SAS Enterprise Guide, you can import Microsoft Access files (*.mdb, *.accdb) only if the 64-bit version of Microsoft Access or the 64-bit version of the Microsoft Office System (ACE) Driver is installed. Similarly, if you are running the 32-bit version of SAS Enterprise Guide, then you must have the 32-bit version of Microsoft Access or the Microsoft Office System (ACE) Driver in order to import Microsoft Access files." Regards,

MariaD · ‎10-09-2018

Hi all, We recently upgraded to SAS EG 7.1, connection with SAS 9.4 M5. Now, we have installed SAS EG 64 bits. Because some users needs to export to Microsoft Access, after installed SAS EG 7.1 we removed Office 32 bits and change it to Office to 64 bits. But after this changed, we still don't see .mdb options in import/export menu. We installed Access 2010 64 bits and we remove completed the 32 bits version. Any idea why? Regards,

MariaD · ‎10-08-2018

Thanks @SASKiwi. One last question. The path where the file will be create is on Windows (where PCFF is installed or visible through network)? Or is it possible to define a path on my SAS Unix server too?

MariaD · ‎10-05-2018

Thanks, we have PC Files licensed. Is it possible to install PC File Server on every client computer in addition to SAS EG? Or only in one Windows computer?

MariaD · ‎10-05-2018

Hi folks, We have EG 7.1 64 bits connecting with our Unix server (SAS 9.4 M5). I know that you can export to .mdb using point-and-click options if you have Office 64 bits installed or Microsoft ACE 64-bits. We have license PC Files but we don't have it configure in a Windows machine. So, there is any way to export, using programming, to .mdb? For example, for Microsoft Excel exists the option to "export" using ODS Excel. Regards,

MariaD · ‎10-05-2018

@JuanS_OCS, now we are analysing all suggestions and the implications to make a final decision. At the moment, we don't have any threshold applied.

MariaD · ‎10-04-2018

Thanks all for the suggestions!

MariaD · ‎10-04-2018

Thanks @FredrikE!

MariaD · ‎10-03-2018

Hi @FredrikE. Thanks! If is it possible to store the parameter in automatically way (without human intervention), yes there is no problem.

MariaD · ‎10-02-2018

Hi @nhvdwalt, Thanks for your answer. We are running on AIX 7.1 and we are not using SAS Grid. Our customer like to add some priority for SAS EM process. On this server we have user running reports, data exploration, data manipulations and some users use SAS EM to build models. Regards,

MariaD · ‎10-01-2018

Hi folks, As far I know, there is no way to define a threshold for user or process no SAS. There is any way to add priority to SAS EM process on a server? Regards,

MariaD · ‎10-01-2018

Hi folks, We have EM 14.3 installed on AIX 7.1 (SAS 9.4 M5). We are testing HP Forest node. If we ran with small number of records or small number of variables the nodes runs ok. If we increase the number of records or variables, it stop running. Any idea what the message means? Is memory problem? NOTE: The HPFOREST procedure is executing in single-machine mode. NOTE: HPFOREST TRACE line 1032 file 14 NOTE: HPFOREST TRACE line 941 file 13 ERROR: Message file "t7w7en" is not found. NOTE: View WORK.HPDMFOREST_TRAINDATA.VIEW used (Total process time): real time 16.14 seconds user cpu time 5.34 seconds system cpu time 4.71 seconds memory 201769.62k OS Memory 211792.00k Timestamp 09/28/2018 06:35:08 PM Step Count 1 Switch Count 76 Page Faults 0 Page Reclaims 47768 Page Swaps 0 Voluntary Context Switches 1618 Involuntary Context Switches 2108 Block Input Operations 0 Block Output Operations 0 I don't know if this SAS Notes apply: SAS Note 61527 because we have EM 14.3. Regards,

MariaD · ‎09-28-2018

Hi Folks, Is there any way to add a variable date to a title (text object)? As I found, I only add measure variables on text object. And I expected to display the month's name on title not the number. Regards,

MariaD · ‎09-28-2018

Finally, we find the solution. For some strange reason, the sas-environment.xml has a hide character. We replace the file with version used for link connections and now it's working fine.

Online Status	Offline
Date Last Visited	‎09-23-2024 06:47 PM

SAS Access to Postgres | Error

SAS Studio Login

SAS EG License - How it works

SAS Horizontal Web Cluster: disable or remove a cluster

Re: Access to BigQuery | Disconnect when execute query

Re: Access to BigQuery | Disconnect when execute query

Re: Access to BigQuery | Disconnect when execute query

Access to BigQuery | Disconnect when execute query

Add-in for Excel: Pivot table error when numeric variable has missing ...

Access to BigQuery | Token

Re: SAS EG License - How it works

Re: SAS Web App Server unable to start

Re: SAS Web App Server unable to start

Re: Import XML file

Re: Integration with FICO Falcon

Unable to update SID on MetadataServer

Re: saspy - Execute SAS from Python

Re: Unable to update SID on MetadataServer

Re: SAS Web App Server unable to start

Re: ERROR: Expecting page, got page -1 instead

Re: SAS EG 7.1 64bits - Export .mdb

Re: SAS EG 7.1 64bits - Export .mdb

SAS EG 7.1 64bits - Export .mdb

Re: SAS EG 7.1 - Export to .mdb by code (Unix Server)

Re: SAS EG 7.1 - Export to .mdb by code (Unix Server)

SAS EG 7.1 - Export to .mdb by code (Unix Server)

Re: SAS 9.4 M5 - Threshold for user or process

Re: SAS 9.4 M5 - Threshold for user or process

Re: SAS VA | Add date variable to title (text object)

Re: SAS VA | Add date variable to title (text object)

Re: SAS 9.4 M5 - Threshold for user or process

SAS 9.4 M5 - Threshold for user or process

SAS EM 14.3 - HP Forest Error

SAS VA | Add date variable to title (text object)

Re: SAS EM - The application has encountered an unexpected problem

Risk & Finance Analytics