BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
Phil_NZ
Barite | Level 11

Hi SAS Users!

 

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

 

My97_0-1610051155075.png

 

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);
 
Thank you for your help, have a fabulous and productive day! I am a novice today, but someday when I accumulate enough knowledge, I can help others in my capacity.
1 ACCEPTED SOLUTION

Accepted Solutions
ballardw
Super User

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.

 

View solution in original post

2 REPLIES 2
AnandVyas
Ammonite | Level 13

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;
ballardw
Super User

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.

 

SAS Innovate 2025: Save the Date

 SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!

Save the date!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 847 views
  • 2 likes
  • 3 in conversation