topic Re: Local server expired problem in SAS Programming

Local server expired problem

Phil_NZ — Thu, 07 Jan 2021 20:29:30 GMT

Hi SAS Users!

Today I try to run the code from SAS EG and I got the notice that

I deem that it would be because of something expired or else.

I am wondering that when the Local server like this in SAS EG expires, whether I also cannot use the local server in SAS as well ?

If it is the case, the only solution is just to ask the administration for the license or else (I asked this question because my school is closed because of the holiday and only open after 4 days)?

Many thanks and best regards!

P/S: The local is from the code below:

options compress=yes reuse=yes;

options mergenoby=error;
/* If a MERGE statement used w/o a BY statement, the LOG presents error message*/
%macro ImportAndTranspose(
      File=
      , StartSheet=
      , EndSheet=
   );

	libname myxl xlsm "&File.";/*line changed*/
    
   %local i;
   
   %do i = &StartSheet. %to &EndSheet.;

    %if &i=1 %then %do;

	  set myxl.sheet&i.;/*line changed*/
      range= "Sheet1$A:X";
      getnames= yes;
	 run;

     proc sort data= sheet&i.;
      by Type;
     run;
	%end;
	/* A list of code afterwards to do while i <> 1*/

   %end;
   
%mend;

%ImportAndTranspose(
      File= C:\Users\pnguyen\Desktop\New folder\Argentina__.xlsm
      , StartSheet= 1
      , EndSheet= 5);

Re: Local server expired problem

AnandVyas — Thu, 07 Jan 2021 23:43:22 GMT

Hi @Phil_NZ

Local server usually means BASE/SAS installed on PC. Do you know if you connect to remote SAS server for execution of code or run it local on your machine? You can run below code to check license expiry.

proc setinit;
run;

Re: Local server expired problem

ballardw — Thu, 07 Jan 2021 23:49:55 GMT

Try running this:

Proc setinit;

run;

If that runs, and it typically will, copy the result from the Log and paste into a text box opened on the forum with the </> icon.

You should get a result similar to:

Original site validation data
Current version: 9.04.01M4P110916
Site name:    'Some organization name'.
Site number:  1234546.
Expiration:   30JAN2022.
Grace Period:  45 days (ending 15MAR2022).
Warning Period: 45 days (ending 29APR2022).
System birthday:   18MAY2017.
Operating System:   WX64_WKS.
Product expiration dates:
---Base SAS Software
                                        30JAN2022
---SAS/STAT
                                        30JAN2022
---SAS/GRAPH

The products are likely ti be different. The keyparts are the DATES. If the the date is past the grace period Then your license is expired.

The SETINIT mentioned in your red text is the license file.