hi, i try with a flow to insert rows. First, I create a table (APPEND) and after, a seconde table (APPEND_NEW) with the same column. It's a very simple case but it's to understand because it can be very helpful and I don't want to use program. But, I have this error. The flow say :  An error occurred while the system was executing the ‘Flux.flw’ flow. The ‘Insert rows’ node has no matching columns between the source and the target How can I fix it? thanks for your help ... View more

Hello, I’m trying to measure a time interval between two dates in business days. I know I’m supposed to use the INTCK function, but I don’t understand what it is actually calculating. It gives me a result of 1700, which doesn’t make sense.    It's the difference between DATE_DER_EVT and today. I have used this synthax :  INTCK('WEEKDAY',DATEPART(TODAY()),DATEPART(t1.DATE_DER_EVT))   If you can help me     ... View more

  Hi, I try to clean a dataset of adress. There are not good. I know that the best practice is to geolocalise every adress but i have to clean quickly. The first thing I want to to is to change AV by AVENUE, BLD by BOULEVARD,etc... I know that I can use TRANWRD but i can change only one WORD. So, my idea was to use multiple CASE WHEN.... in a query. But i have this error. And I don't really understand Why. Can you help me? I use SAS STUDIO     ... View more

Hi, I try to find some documentation on interaction effect, Spline effect and partition on SAS Visual statistics or analytics. Someone can help me please?   ... View more

Hi,   Someone can help me. Why I have a synthax error. I'm surprised to see that Datepart is not colored in Blue. My variable is in date format.   It's a FEDSQL     ... View more

Hi, i have a trouble with SAS STudio.  When i Want to do that on a flow with CAS table at the beginning and at the end (With a lightning on both side). I have an error. I know that in some case, i have to chose SQL or FEDSQL and write CASAUTO. But it never match.    ... View more

Hi,Happy new year.   I remember reading a post in this section that explained how to create adjustable intervals in a bar chart in VA. But I can't find it anymore. I want to compare the distribution of two data sets, but the histogram doesn't allow it. So I need to find a solution.   Can you help me ... View more