Dear All,   I am encountering an error while opening SAS EG, the screenshot is attached for your reference. Can anyone please help me to resolve the issue.   thanks   ... View more

Dear All,   I am unable to open SAS EG as a pop message says "The Version of SAS Enterprise Guide expired on December 1st, 2015"   I have activated new license key but the issue still persist. The SAS support team informed:   "This issue you are facing is documented in the following SAS note. This is due to the fact that Enterprise Guide has a built in “die date” depending on the release.  Customers can apply a hotfix to update the dates of their EGUIDE.    SAS® Enterprise Guide® expiration dates - http://support.sas.com/kb/33/359.html"   As the information security policy in my company doesnt allow me to download the .EXE file and to further execute it. Can anyone please help me to share other way around to have this issue fixed.   Appreciate your support in this regard.     Thanks Ather ... View more

  I am trying to access data from web and as a learning wrote following code into SAS EG:   filename seercode URL "https://www.google.com"; data siterecode; infile seercode truncover; input @1 bigline $char256.; run;   Unfortunately, encountered following error, can anyone please suggest best way to resolve this issue:   NOTE: Unable to connect to host www.google.com. Check validity of host name. ERROR: Hostname www.google.com not found. NOTE: The SAS System stopped processing this step because of errors. WARNING: The data set WORK.SITERECODE may be incomplete. When this step was stopped there were 0 observations and 1 variables. WARNING: Data set WORK.SITERECODE was not replaced because this step was stopped. NOTE: DATA statement used (Total process time): real time 2.46 seconds cpu time 0.04 seconds     Thanks   ... View more

Hi - I wrote following code to export results in excel, but I also want to retrieve query name along with the result. The code is as follows: proc export data = SASUSER.Check outfile = "C:\Documents\test\Alerts.xls" dbms = excel replace; sheet = "Check"; run; The above code generates the excel file and replace it every time when I run the code and it works fine but for reference I need to add query name. Please help thanks ... View more

Hi - I am unable to understand an error which I am continously getting while running a small code. Actually I am trying to access IBM AS400 table. Here is the code and error description LIBNAME AS400 ODBC DSN = 'C400'; SYSTEM = TABLE_X SCHEMA=DIRECTORY; PROC SQL;   Create Table SASUSER.TestRun AS   Select *   FROM AS400.TABLE_X   WHERE Me_ID EQ '0213456'   ; QUIT; ERROR: CLI prepare error: [IBM][Client Access Express ODBC Driver (32-bit)][DB2/400 SQL]SQL data        type argument out of range. SQL statement: SELECT * FROM TABLE_X. On the other hand, when I try to access other table in the same database, it gives me all the desired results.Here is the code: LIBNAME AS400 ODBC DSN = 'C400'; SYSTEM = TABLE_Y SCHEMA=DIRECTORY; PROC SQL;   Create Table SASUSER.TestRun AS   Select CDNO, ACLMT, STS, NAME, BAL   FROM AS400.TABLE_Y; QUIT The code is same except the table names of the same databse. Please help me to resolve the problem. thanks ... View more