Beautiful article! Is it possible to manage the job frequency by considering the outcome of the job itself? E.g. schedule a job every hour, but it should only start if the execution of the previous hour is completed.
... View more
You can use SUBSTR function:
data want; set have; if substr(Case_Dx,1,4) in ("S720","S721","S722") then Type="A"; else if substr(Case_Dx,1,4) in ("S525","S526") then Type="B"; else if substr(Case_Dx,1,3) in ("805","806") or substr(Case_Dx,1,4) in ("S220","S320","S221") then Type="C"; run;
... View more
You can use the PROC JSON, probably with the NOSASTAGS and PRETTY options: proc JSON documentation
Alternatively, you can compose it manually with a date step, as shown in this other post: JSON export post
... View more
