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
Anand_V
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.

 

Ready to join fellow brilliant minds for the SAS Hackathon?

Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.

Register today!
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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

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