Try the COMPBL function.  From the docs: "The COMPBL function removes multiple blanks in a character string by translating each occurrence of two or more consecutive blanks into a single blank." ... View more

I had an old sas ballot item (seems not to have been carried over to the SAS product suggestions) asking for the XLSX engine to support the DBSASTYPE option.  That would help with problems like this.   But if the goal is to make data fit a pre-determined template in order to fit into legacy processing, seems like instead of a dynamic %num_to_char, you might consider writing a macro that allows you to read a data dictionary (with variable types, lengths, position, etc) and then transforms a dataset to fit that dictionary. ... View more

If you remove the NOAUTOLEGEND option, does it give you something reasonable?   proc sgpanel data=plot noautolegend;by Replicate; ... View more

Do you know what the correct date or date-time value is, which this value represents?  If it is a millisecond timestamp, is it number of milliseconds since what zero point?   If it's number of milliseconds, you could convert it to number of seconds, but you need to know the zero point.  If the  0 is Jan 1, 1960, then it would represent 24Apr2015 at 4:00am:   18 data a ; 19 x=1.7454672E12 ; 20 x=x/1000 ; 21 format x datetime19. ; 22 put x= ; 23 run ; x=24APR2015:04:00:00 NOTE: The data set WORK.A has 1 observations and 1 variables.       ... View more

Apologies @Kurt_Bremser .  When I moved this to visual analytics, I accidentally moved your reply first, so you're now the owner of the thread, instead of @P3 who asked the question.  I don't see a way to make the original question the question again.   ... View more

It looks like NOW() is a Visual Analytics function, not a SAS language function.  I'm going to try moving this question the visual analytics community. ... View more

I think it's important to define the scope of the reset.  To me, "resetting SAS" implies a fresh SAS session (empty work library, no user-created macro variables, no user librefs assigned, etc etc.) .     Are you really only interested in clearing the log window and results window? ... View more

Interesting. I’m pretty sure I heard rumors of it being on the roadmap for SAS 9. Will have to ask around the SAS 9 desk at innovate. : ) ... View more

@VincentRejany wrote: SAS/ACCESS Interface to DuckDB is coming in our July release, 2025.07. You can also already use the ODBC or JDBC drivers Do you know if SAS/ACCESS to DuckDB made it into 9.4M9? ... View more

It's very unlikely that you have variables names with a in them, like:  I10_DX1 If you run PROC CONTENTS on your data and look at the list of variables, you see | characters there in the variable name? ... View more

I suppose you could try to investigate this through simulation.   Since you already have the core logic in place to run a series of steps, and compare the actual run time to the sum of the reported run time, you could try running a program with 300,000 fast steps, and see how the times compare.  Then try maybe 100 very slow steps, and see how the times compare.  You also might get different results from running in interactive mode vs batch mode...   You could always ask tech support.  Maybe someone will dig through the source code... ... View more

@RANUSER_1337 wrote: Ok thanks. Do you by chance have any knowledge concerning the rounding vs. truncation issue I mentioned? I'm surprised milliseconds would matter.   And if you want to measure a step with millisecond precision, you'd have to think about things that won't be measured (time to write the log message?  time to send the results across the network if using a remote session, etc.)   That said, SAS was written by statisticians.  I would think it's safe to assume that they would round the time values rather than truncate them. ... View more

Great meeting content!  And that's awesome that the pre- and post- conference training is hybrid. ... View more

I like the Python idea.    And <advertisement> you cold use PROC FCMP to call Python functions, so you can still run it from SAS.  If you're curious to see PROC FCMP -> Python in action, BASUG's free webinar on Wed April 23 will feature Troy M. Hughes, the man who wrote the book on PROC FCMP, showing this approach.  Register at: https://www.basug.org/events   </advertisement> ... View more