Hello, experts! I have problem with running proc infomaps. When I run simple code like:   proc infomaps; run; Then I get error:   Top Exception: [ com.sas.services.deployment.ServiceDeploymentException: A SAS foundation service failed to deploy. ] [ com.sas.services.ServiceException: Unable to obtain service from factory class com.sas.services.user.UserServiceFactory. ] [ java.lang.NoClassDefFoundError: com/sas/services/security/login/ExpiredCredentialException ] Root Exception: [ java.lang.ClassNotFoundException: com.sas.services.security.login.ExpiredCredentialException ] ERROR: The procedure was unable to log in the user. Is there a way to understand why the error is happening and fix it?     ... View more

Hi All,   When I tried to login to SAS recently I got an error saying "An error occurred. Please contact your system administrator", so I relaunched SAS by using the standard path to access VFL and I managed to login, HOWEVER, I couldn't find any of my saved work and reports etc in my SAS Drive!!! can someone help please ??   Thanks Abdel ... View more

Hello. I have the following 2 data sets with different variables that I need to merge into one. My problem is that the second file ID is different from the first. The common var is only VAR1. I am not giving examples for what is in the other variables in each set as I do not think they will give me an issue. Just listing the names here for an idea of what my outcome would look like. Is there a way to reassign a record ID based on a common var like this? I would imagine creating a new ID var - dropping var  record_ID and then renaming the new ID ID like in SET1. I can merge the file by VAR1 but it is not the output I am looking for, as I get 2 records per ID.   SET 1 input ID Var1 P1 $ P2 P3 P4 P5; Datalines; 1    3456 2   8796 3   2222 4  7689 ;   SET 2 Input record_ID VAR1  B1 B2 B3 $ B4 B5; Datalines; 10                3456 12                8796 15                2222 20               7689 ; What I need is to make record_id 10 12 15 20 become 1 2 3 4, based on that common VAR1 and have all variables in one record. Like this:   ID VAR1   P1 P2 P3 P4 P5 B1 B2 B3 B4 B5 1     3456 2    8796 3    2222 4    7689   Thank you! ... View more

  %Macro BasinXLS; libname storm xlsx "&path/BasinStorms.xlsx"; %if SYSLIBRC ne 0  %then %do; %put ERROR:Terminate Macro Execution; %end;   %else %do; Proc SQL noprint;     Select Distinct Basin,  compress(BasinName)     into :Basin1-, :BasinName-     From mc1.storm_basin_codes;      quit;      %do i=1  %to &sqlobs;     Title "Group: &&Basin&i ";  data=storm.&&basinname&i.._Storms; set mc1.storm_basin_codes; where Basin=&&Basin&i; run;   end; %mend BasinXLS; libname storm clear; options mprint mlogic;   %BasinXLS   ... View more