About Suzy_Cat

Suzy_Cat · ‎01-14-2020

Hi @Haris, I totally understand your need and wish we could get there with what we exactly want to achieve. Please do advise if you eventually find the best solution to your question. I am really keen….

Suzy_Cat · ‎01-13-2020

@Patrick Thanks for your suggestions. Really helpful. Any better solution to extract required information from the project log summary? if the info under Error & Warnings can be sent to who ever is maintaining the project, it will be quite handy to prioritize the task.

Suzy_Cat · ‎01-12-2020

SCAPROC - good direction to go. Thanks for the help!

Suzy_Cat · ‎01-12-2020

My point here is: the project will be handover and I will only be checking (or update) the project when there is issue with the code or outputs. I am not the one actually running after the handover.

Suzy_Cat · ‎01-12-2020

Hi there, Did some research, but haven't found the best way yet. Can anyone suggest how to get a list of errors and warnings (text message combined together) after a project completed where the project contains lots of sub-programes? syscc & syserr: &syswarningtext &syserrortext Cheers

Suzy_Cat · ‎01-12-2020

This is exactly what I wanted to achieve! Thank you sooo much for the help 🙂

Suzy_Cat · ‎01-12-2020

Looks like I got there successfully... %let STARTTIME =%sysfunc(time()); data want; STARTTIME=&STARTTIME; EndTIME=&STARTTIME+12400; Duration=&EndTIME-&STARTTIME; minute=INTCK('minute',STARTTIME,EndTIME ); hour=mod(minute/60,60); dur=put(hour,4.1)!!"Hr"; format STARTTIME EndTIME time.; run;

Suzy_Cat · ‎01-12-2020

getting closer.... 　　 data test; STARTTIME=&STARTTIME; EndTIME=&STARTTIME+9000; Duration=&EndTIME-&STARTTIME; minute=INTCK('minute',STARTTIME,EndTIME ); hour=mod(minute/60,60); format STARTTIME EndTIME time.; run;

Suzy_Cat · ‎01-12-2020

Hi , I need count the duration for how long it take the project to run and show the result in the format "2hr30min" or "2h30m" or "2.5Hr" if the project completed in 2.5 hours. However, I could not figure out how to make the result correctly showing as how long it took the project to run. Can anyone give me a hand? Thanks. %let STARTTIME =%sysfunc(time()); 　 data want; STARTTIME=&STARTTIME; EndTIME=&STARTTIME+9000; Duration=&EndTIME-&STARTTIME; format STARTTIME EndTIME time. Duration $?.; run;

Suzy_Cat · ‎12-24-2019

testing... hope it works 🙂

Suzy_Cat · ‎12-24-2019

My bad. Operating System: LIN X64 .

Suzy_Cat · ‎12-24-2019

Suzy_Cat · ‎12-24-2019

XCMD The X Command is valid in this SAS session. NOTE: PROCEDURE OPTIONS used (Total process time): real time 0.00 seconds cpu time 0.00 seconds 18 19 %put &=SYSHOSTINFOLONG; WARNING: Apparent symbolic reference SYSHOSTINFOLONG not resolved. SYSHOSTINFOLONG

Suzy_Cat · ‎12-24-2019

Sounds like a good solution - Thank you @Patrick , I will test if it works at my end. Any chance to provide the code to copy/back up data to a different folder by SAS option XCMD ? Cheers Sue

Suzy_Cat · ‎12-23-2019

my SAS is running on a server.

Online Status	Offline
Date Last Visited	‎09-22-2021 10:16 AM

Re: Hyperlink not work in email

Re: Hyperlink not work in email

Re: Hyperlink not work in email

Re: Hyperlink not work in email

Re: Hyperlink not work in email

Hyperlink not work in email

Re: Email drafted but on hold for a human check - do not send

Email drafted but on hold for a human check - do not send

Re: Data step first.variable equivalent in Proc SQL

Re: Select records with key words - prxmatch or any other functions

Re: Hyperlink not work in email

Re: Hyperlink not work in email

Re: Hyperlink not work in email

Re: Email drafted but on hold for a human check - do not send

Re: Data step first.variable equivalent in Proc SQL

Re: Data step first.variable equivalent in Proc SQL

Re: Data step first.variable equivalent in Proc SQL

Re: Data step first.variable equivalent in Proc SQL

Re: Export to CSV : some records have correct date, some not

Re: Export to CSV : some records have correct date, some not

Re: How to embed all SAS code into SEG project?

Re: syscc & syserr: How to get a list of errors and warnings after a p...

Re: syscc & syserr: How to get a list of errors and warnings after a p...

Re: syscc & syserr: How to get a list of errors and warnings after a p...

syscc & syserr: How to get a list of errors and warnings after a proje...

Re: Time duration

Re: Time duration

Re: Time duration

Time duration

Re: Project failed due to CSV file being used/opened by other user or ...

Re: Project failed due to CSV file being used/opened by other user or ...

Re: Project failed due to CSV file being used/opened by other user or ...

Re: Project failed due to CSV file being used/opened by other user or ...

Re: Project failed due to CSV file being used/opened by other user or ...

Re: Project failed due to CSV file being used/opened by other user or ...