Thank you so much! This looks good! ... View more

@InêsMaximianosurahyaseenpdf wrote: I have a column named Cod_Sale, which should only be either null (there's no sale) or the code all in UpperCase Letters. Example: Cod_Sale IN (PRIM, SEC, THIRD, UP) ... etc, each month we can receive new Codes   I have to remove all data that don't have a sale cod, meaning Cod_Sale <> "".   However, when I do this it also selects some value that have Cod_Sale = "". I tried the functions compress, spit and trim to see if it had any blanks, but it still doesn't work.   Even if I select compress(Cod_Sale) <> "" or split(Cod_Sale) <> "" or trim(Cod_Sale) <> "" it still selects data with Cod_Sale in blank!   Can you please help me? To filter out invalid entries and keep only uppercase Cod_Sale values, try using the UPCASE function to ensure the code is uppercase and not blank. ... View more

@teresacorzo wrote: I'm working on a project in SAS Viya- Build Models, where I uploaded the data using a predefined partition variable. When I try to run the node with my rejected base and a manual partition variable, it doesn't work. I also tried uploading the rejected base without any partition variables   To troubleshoot issues with partition variables in SAS Viya's Reject Inference Node, ensure that your partition variable is correctly defined in both your data upload and the node settings. Check that the data types match and that there are no missing values in the partition variable. ... View more

Did you read the log? Some of the common "issues" with Merge create specific messages in the log. At least describe the unexpected results, we can't read your mind.   Or was this post just an excuse to post an advertising link or whatever that dollartree thing is?   MERGE in SAS, especially in a data step, has a very specific meaning and some people use the term "merge" without much detail of what is expected. Merge is a sort of side-by-side combination, typically using one or more variables to match records, to bring variables from multiple sets together. Limitations on the SAS Merge include but are not limited to: Only one data set can have multiple observations with the same values of BY variables and get expected results. Variables with same names that are not used for matching on a BY statement will have only one variable with a value similar to updating data. There are some complexities involved. Minor differences of values such as leading space " John" vs "John", or case "John" "JohN" are not equal and records won't match.   And sometimes people want to APPEND data, stack vertically, but use MERGE because of not being familiar with the difference in SAS.   So code of what was attempted and a clear description of what was expected are important to answer this sort of question. Example data is the best way to provide start data,  expected and actual results. ... View more