Hi, I'm currently using the smotesample action in SAS and encountering two unusual issues:   Unexpected Categorical Values: Some of the newly generated categorical variables—are returning large negative values (e.g., -1000000) that do not exist in the original dataset. Could you clarify why this might happen? Specifically, how does SMOTE handle categorical features, and is there a recommended approach to ensure realistic synthetic values? Amplification of Placeholder Values: My dataset uses placeholder values like -1 or -2 to represent missing data. After applying SMOTE, these placeholders seem to become more dominant in the sampled data. Is there a way to prevent SMOTE from oversampling these values or to exclude them from the interpolation process? Any guidance or best practices would be greatly appreciated. ... View more

Hi all,   I am trying to create a monthly report in SAS Visual Analytics, however I want to try and create some commentary to go with this report each month and by selecting the report control you would be able to get the right commentary displayed based off an excel or csv file. Is this even possible or is the only way to do it to get some basic commentary with calculated items?   Thanks in advance ... View more

Hi all,   I am building a report in SAS Visual Analytics, whilst using the crosstab object, however I am filtering my table by date - however I have noticed that the display will often leave blank space at the bottom. Is there a way get the crosstab to automatically fill the dead space? Another point is there a way to set the column widths in the right-hand side menus because I am trying to create multiple tables, however having to manually adjust the widths to standardize their size is very awkward.    Thanks in advance. ... View more

Hi,   I am using the proc fedsql to join two datasets - however they have multiple columns with the same name which isn't allowed is there an option to accept that there are these two columns and treat them as identical because it is just a bunch of ID and Product columns. Thanks in advance. ... View more

I want to create a multiple group bar chart (4 groups) with a line chart over the top - is there a way to do this in SAS Visual Analytics?     ... View more