The sort key is the same on both, and is formatted identically on both as a character with idential width. The merged dataset simply stacks one on top of the other.    Code: PROC SORT DATA=AE.LOG_AE; BY Subject; RUN; PROC SORT DATA=AE.Treatment;     BY Subject; RUN;   DATA AEListings; MERGE AE.Log_AE AE.Treatment; BY Subject; RUN;   Any and all help is welcome. Thanks. ... View more

Hi,    I wonder if anyone's running into this same issue that when I try to copy something, either a letter or a command or a bunch of things, from my code, SAS would freeze up, be not responding for some time (10-30sec). I tried to look up for similar issues, but only found this back in version 9.1, so I tried the solution to restart my computer and clear out my clipboard, doesn't seem to work.    Initially it was only my desktop having this issue, now both my laptop and my desktop are having this problem. I have reinstalled windows on both of my devices, doesn't seem to help. Used SAS unicode instead of SAS English, still no good. I suspect it's windows 11 updates but don't have any evidence and solution to this issue. It's kinda driving me nuts every time trying to copy just variable names.    Please let me know if anyone is having the same issue or know a bypass to this. Many thanks.  ... View more

Data almost never arrives in the format you need. As a result, data preparation often requires separating large text values into unique variables which are more meaningful for analysis. Whether you want to parse an address into its parts or extract a phone number from a chunk of contact information, the Parse Data step is here to help!   In this post, I'll demonstrate how to use the point-and-click Parse Data step to parse and extract pertinent information to make the most of your data. Click Read more to continue our data quality journey with SAS Studio Flows! ... View more

I have a scenario where while connecting to an external databases (for example) every user would create a connection to the database using his own libname statement. This create one connection for every user. I was wondering if Connection Pooling  is a feasible option. I was wondering if we could have a pool of database connections created may be in the metadata server. Whenever a user process needs to connect to an database, it takes a connection form the pool and then it is returned after use. No new connection for every user. Wondering if creating a library in the metadata server server serves this purpose? ... View more

Join this webinar to learn techniques for interpreting machine learning models and how to use them in SAS® Viya®.   You will learn: What are black box models? Why interpretability matters. When to distinguish between local and global explanations. Register Now   ... View more