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);
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.
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;
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 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!
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.
Ready to level-up your skills? Choose your own adventure.