Show what you have already tried and where your problems are. Note: SAS date values are counts of days, so the 1000-day and 15-day intervals are simple to build.
... View more
Your script tries to write the log to this path:
/opt/sas/system_logs/cleanwork_log/
but the system then complains about writing to this path:
/opt/sas/system_logs/
without the sub-directory cleanwork_log.
Something is off here.
... View more
Disclaimer: I have no Viya experience.
SAS has always used an external client for database access. I think that your database clients on the Viya server have a wrong timezone configured.
... View more
You must turn your "energy saving" settings off when you need to run long batch jobs in the background, because the system might turn off resources (like disks) when no user interaction from mouse or keyboard is detected.
... View more
Python code depends on the layout to separate statements and identify blocks (through indentation).
Since a macro is tokenized upon compilation, this layout is lost and the Python code would become unusable. The %INCLUDE, OTOH, is executed when the macro executes, and will therefore result in the code being inserted as it is in the file, with the layout intact
This is the same reason that also prohibits use of DATALINES in a macro.
... View more
Also note that the communities website does not provide the usual online preview which would allow us to view the spreadsheet without downloading. This is suspicious.
... View more
@msrenee1984 wrote:
I'm getting an error message that says "ERROR: Variable HOURS in list does not match type prescribed for this list. I'm unsure how to convert the "hours" variable...
This means that your hours variable is most probably of type character.
Follow the instructions posted by @PaigeMiller and post the resulting code. This is mandatory!
Only then will we know important variable attributes (type, length, format) and the real content we have to work with.
Excel spreadsheets do not have this information, only what Excel thinks about it.
Also answer questions like where does the data originate from, and how do you read it into your SAS environment?
... View more
Your email configuration tries to use this server as SMTP relay, but it either does not exist at all or is not reachable from your SAS server.
... View more
You will always need a separate step to promote the changed version to the scheduler.
But it should be possible to promote a job without having to re-enter the whole job definition.
... View more
SAS will dutifully report everything it considers a WARNING or ERROR in the return code. But there are things which depend on the local definition of „error“, and the admin needs to take care of those. See my previous post about funny FTP messages.
... View more
