I had fewer issues updating Excel files once I switched to using the XLSX engine instead of trying to open and overwrite the spreadsheet directly. Also, make sure Excel isn't running in the background. If you're using the latest tools, the microsoft office 2024 download now includes better support for integrating with external applications like SAS, which might make things work smoother. ... View more

Are there cases in your data where num_PW=input(PW, 32.) does not contain the "correct decimal number", that is, where a check like 371 data _null_; 372 PW="7.0000000000000007E-2"; 373 num_PW=input(PW, 32.); 374 if num_PW=0.07 then put 'OK'; 375 run; OK would not yield "OK"? If so, I would use the ROUND function with an appropriate rounding unit in the definition of num_PW.   Example: 412 data _null_; 413 PW="7.0000000000000010E-2"; 414 num_PW=round(input(PW, 32.), 1e-14); 415 if num_PW=0.07 then put 'OK'; 416 run; OK   ... View more

@Kurt_Bremser wrote: Issue the ODS _ALL_ CLOSE immediately before ODS OUTPUT. No need to be that drastic.  Closing all of the ods outputs can cause havoc with environments like SAS/Studio that like to try and control the SAS session.   Instead you can just EXCLUDE the outputs you don't want printed. 1 ods exclude nlevels; 2 ods output nlevels=want; 3 proc freq data=sashelp.class nlevels; 4 tables _all_ / noprint; 5 run; NOTE: The data set WORK.WANT has 5 observations and 4 variables. NOTE: There were 19 observations read from the data set SASHELP.CLASS. NOTE: PROCEDURE FREQ used (Total process time): real time 0.00 seconds cpu time 0.00 seconds ... View more

I would make sense but ... it can't   See Solved: Regular expression search and replace in SAS EG is broken - SAS Support Communities ... View more

THIS IS AMAZING.  I spent hours trying to get this to work and another hour on the phone with tech support to no avail - this solution works perfectly!  Thank you!! ... View more

"whenever it reads from a new dataset, it resets the variables read by the SET statement to missing before reading the first record of the new dataset. (It doesn't actually reset the full PDV)." very very simple and concise, I'll write it down in my SAS learning notebook. thanks ... View more

Read for yourself: find  It's in the OPERATORS section. ... View more

By all means, avoid handling and/or storing credential information, particularly passwords, in code. Unless you intend to have a rather unpleasant conversation with your CISO. ... View more

That seems to work.    The extra assignment statement name=persona; will prevent the issue mentioned above about values of PERSONA that are longer than the 8 bytes reserved for the NAME variable used as the key in the hash object.   The assignment operation will truncate the value to fit into the NAME variable.   Note you could have done that in the .FIND() method call and avoided the need for the assignment statement.   If you know the length needed you could put PUT function with $ format. match1.find(key: put(persona,$8.) ) And if you don't then use VLENGTH() to find it and use the SUBSTRN() function to truncate. match1.find(key:substrn(persona,1,vlength(name)))     ... View more

There have been several Windows updates since my post. This issue seems to have been resolved with at least one of the updates, but I do not know which one. ... View more

Thanks everyone for the response and sorry for not including the sample data and the expected results. I will try to include more details next time. ... View more

To query a table in SAS Viya 4 (VA) without loading it into CAS, you can use the Proc FedSQL procedure. This allows you to query data directly from the source (e.g., a database) without first loading it into the in-memory CAS environment.   Palm Beach County Property Appraiser ... View more

Thank you all for the detailed suggestions. I will try the different approaches to see which one works best for our use case. ... View more

Thank you Ahmed - will take a look at the links!  ... View more

MLE is an 'internal product' created within TD using SAS Studio as the base. ... View more