Hello, I'm still looking for this information: Why sometimes compression is disabled and sometimes it doesn't? NOTE: Compression was disabled for data set WORK.ONE because compression would increase the size of the data set. NOTE: Compressing data set WORK.ONE increased size by 100.00 percent. THANKS !!!!!! ... View more

Hello,   Is there a way to deal with this error? it shouldnt return code 0. The main doubt is the return code and not the error message.   The sas code didnt run, the following error message was echoed in the log and its return code was 0. ERROR: Access denied. ERROR: Access denied.   This code was submitted when the environment wasnt ok. /example/example/sasgsub -GRIDSUBMITPGM /example/code.sas -GRIDCONFIG /example/sasgsub.cfg -GRIDWAITRESULTS -GRIDWATCHOUTPUT -GRIDJOBNAME code.sas -GRIDSASOPTS '( -nodms -nonews -noterminal -errorabend)' -GRIDJOBOPTS '(-QUEUE=Batch)' -METAPROFILE /example/metadataConfig.xml   ... View more

Hello,   PROBLEM: in the first execution only, occurs the following: The jobs do execute in parallel but they get the same LSF ID, in the same machine. If execute it again, then it goes ok: The jobs also will run in parallel but with different LSF ID (the correct way) and random machines.   PROBABLY CAUSE NOTE: Accessing the SAS Metadata Repository produced: ERROR: No terminal connected to the SAS session. NOTE: Retrieving login information based on AuthenticationDomain from the SAS Metadata Server failed. NOTE: SAS application server not found; the local machine will be used.   CODE: %LET RC=%SYSFUNC(GRDSVC_ENABLE(_ALL_, RESOURCE=SASApp)); options autosignon ; RSUBMIT S1 WAIT=NO; %put Remote S1 SO ID: &sysjobid. ; %put Remote S1 LSF ID: %sysget(LSB_JOBID); ENDRSUBMIT; RSUBMIT S2 WAIT=NO; %put Remote S2 SO ID: &sysjobid. ; %put Remote S2 LSF ID: %sysget(LSB_JOBID); ENDRSUBMIT; %put Main Session SO ID: &sysjobid. ; %put Main Session LSF ID: %sysget(LSB_JOBID);   MAIN LOG: NOTE: Connecting to SAS Metadata Server produced: WARNING: No logins found. NOTE: Accessing the SAS Metadata Repository produced: ERROR: No terminal connected to the SAS session. NOTE: Retrieving login information based on AuthenticationDomain from the SAS Metadata Server failed. NOTE: SAS application server not found; the local machine will be used.   Main Session SO ID: 20889 Main Session LSF ID: 325069   Remote S1 SO ID: 28418 Remote S1 LSF ID: 325069   Remote S2 SO ID: 25121 Remote S2 LSF ID: 325069 ... View more

ERROR: Lock held by process 346   I'd like to know directly who is using the Dataset and not the JOB_ID Is it possible to retrieve like: "Lock held by user 1234" (that &SYSUSERID macro variable)??   SAS Enterprise Guide 6.1 X command unabled Thanks! ... View more

Hello,   Is there a way to get the last access of some Data Set? I know its possible to get last modified date, create date, file size, etc...   Could we know the last day someone opened or read this Data Set, by clicking or using FROM, SET, APPEND, etc?   Thanks ... View more

hi, i'd like to increase a variable (payday) + 1 while it isn't a working day how can i do something like that, using while and sql? e.g:      create table new_payday as select           (while payday in ((select holiday from holiday_table),weekday(1),weekday(7)) then payday+1) as payday      from old_payday;      quit; thanks ... View more