Hi Team We have recently migrated from SAS EG 4.1 to SAS EG 7.1. I have seen a thread with the same issue, but couldn't get much help from it. Hence starting new  thread. One of the user is getting the error "Unable to connect to the metadata server" when she is trying to "SET ACTIVE" the profile. The message did ask me to check few things and none of them matched to the issue. I have attached the screenshot for your reference, Request you to kindly advice. Thanks Raj ... View more

Hi Team We are currently doing UAT for migration from SAS EG 4.1 to SAS EG 7.1. One of the variable Application_Date has format DATETIME20. on SAS EG 7.1 whereas in the results from the SAS EG 4.1 Application_Date has format DATETIME22.3. Please advice on how to change the default value on SAS EG 7.1 to DATETIME22.3 . Thanks Raj ... View more

Hi Team We have recently migarted from SAS 4.1 to 7.1 . I am trying to send the data onto Excel using the option "Send To" . For the first time, the data gets exported and after that it errors out saying "microsoft excel has stopped working". This error is mostly seen in desktop users . VDI users do not have this issue. Any advice on why the application behaves differently on desktop and VDI ? Please advice. Regards Raj ... View more

Hi Team We are using SAS EG 7.1 version and had SAS Add-In for microsoft office installed. I am facing issue while trying to copy & paste an tabular output generated into MS EXCEL . I went through a couple of blogs and have tried using the Result Formats --> HMTL from SAS Report (which is the default). After changing the report formats to HTML, I am able to get the tabular format of the data, but the data is NOT indented properly into cell. The tabular data is getting copied and the cells gets merged.I am unable to compute the data in excel since the cells have merged. On SAS EG 4.1, I was able to copy-paste the data as is and the data used to get copied perfectly into each cell properly which helped me in computing the data in excel. Could you please advice and suggest for a workaround on this. Thanks Raj ... View more

Hi Team Request you to kindly provide steps on how to schedule a .sas file and .egp file in SAS Enterprise guide 7.1. I have gone through Chris's paper on scheduling but unfortunately I am unable to connect to steps with 7.1 version. Is there any pre-requisite for the same. Please help me. Apologies if this was a basic question, but I am new to SAS EG. Thanks Raj ... View more

Hi Team I have an issue while opening a project (.egp) file. The file was created in SAS EG 4.1 and I am opening it in SAS EG 7.1. Error says " An unknown error occurred while trying to create the project item with label 'XXXX'. This item has been removed from the project.". I can see that the SASApp server is connected with green tick mark and ensured that I am connected to workspace server.But, even then I am unable to opeen the project file. Could you please advice on this ASAP. Thanks Raj ... View more

Hi Team We have recently migrated from SAS EG 4.1 to SAS EG 7.1. In the older version (4.1), we have used PROC IMPORT to import a CSV file.While importing, if any variable had spaces, then the spaces would be replaced by _. For Eg: Account Number would be replaced by Account_Number. In the Newer version (7.1), the same code is importing the variable name with spaces. Eg: Account Number and it is NOT replacing spaces with _. I have tried options validvarname=V7; but it isn't working. Please advice. I am using the below code: options validvarname=v7; proc import  datafile="TT3.csv" out=HPI dbms=CSV; run; proc contents data= HPI; run; Thanks Rajesh ... View more

Hi Team We have recently migrated from SAS EG 4.1 to SAS Eg 7.1 On the new system, when we open a project and close, the file gets saved with older version Icon and it does not gets saved with the new version icon. So, I assume that it is still using the old ones. Could you please advice on how to save a project with latest version Icon. Thanks Rajesh ... View more

Hi Team We have recently migrated from SAS EG 4.1 to SAS EG 7.1. Have an issue with PROC IMPORT, the below code is able to import data onto xls sheet. We are using 32-bit MSOFFICE 2010. PROC IMPORT OUT= WORK.PathParameter             DATAFILE= "C:\TEST\XXX03.xls"             DBMS=xls REPLACE;      GETNAMES=YES;      MIXED=YES;      USEDATE=YES;      SCANTIME=YES;      SHEET="Path Parameter"; RUN; However, the code generates below error : 26              GETNAMES=YES; 27              MIXED=YES; 28              USEDATE=YES;                 _______                 180 29              SCANTIME=YES;                 ________                 180 ERROR 180-322: Statement is not valid or it is used out of proper order. 30              SHEET="Path Parameter"; 31         RUN; I tried browsing for different for a resolution on blogs/communities.But could not get a resolution for this. Could you please help me on this ? Thanks Rajesh ... View more

Hi Team I am new to SAS administration. I have to create a base engine SAS library in SAS Management console with readonly access to SAS datasets located at a particular path. How do make those SAS datasets readonly ? Kindly advice. Thanks Rajesh ... View more

Hi Team We are recently migrated from SAS EG 4.1 to SAs EG 7.1. I am facing below issues. Request you ot kindly advice. #1. I have an issue in copying and pasting program. Error says:   OpenClipboard failed (Exception from HRESULT:0x800401D0   CLIPBRD_E_CANT_OPEN )) #2. Trying to copy & paste the RESULTS from RESULTS VIEWER generated (from PROC FREQ/ PROC TABULATE) to an Excel sheet. After copying the data values are get copied properly onto excel sheet. The values does not get into the cell of an excel sheet. #3. While using the SEND TO EXCEL option in EG, the excel sheet gets generated for the first time. But if I use this option again, my system is getting crahed and I had to restart the system. Kindly advice. Thanks Rajesh ... View more