Hi,   I have a categorical variable that looks like this.        I would like to convert it to the date format so that I will create another variable to take the month and year part, looks like this:           I tried the parsing:   But I get missing values. What can I do in VA to solve this?   Thanks!     ... View more

Hello,   I have a dataset that has an ID column but some records are 4 digits and some are 5 on this column. I would like to add a 0 as the first digit when there are 4 digits in the record. Can I do that from VA interface? The variable type of the ID column is a mesure and I created a category variable changing the classification. I tried to use the Calculated Item and GetLength operator but since my column is not a string I cannot apply that operator. So, my question is how can I change a numeric variable to a string variable so that I can count the number of digits and add a 0 in the beginning when there are 4 digits, from VA interface?   If it is too complicated I would go to SAS Studio to write code but I don't want to do that because I would need to recreate my table with the new dataset because I have some calculations I have done previously.    Thanks!  ... View more

Hi, I have a log reg model on VA. I would like to do scoring on unseen data. I think Export Model is the right option to follow but how can I use the code hat appears when cilcking on that option? I copied and pasted it to SAS Studio, where I created a cas conection. When I run it, I get so many errors. Do I need any alterations/additions on the score cdeo? What is the step by step to see an output table with predictions?     ... View more

Hi,   I have a start and end date in my data set.  I calculated a new item called "number of days" as the number of days in between these two dates. I also calculated the average number of days using the median which is 59. Now, I would like to count how many of my records are above the average number of days and how many are below the average. What would be the calculated item formula for it?  For example, assuming I have these 5 records on my dataset: Number of Days  110 100 45 55 25   Then, my new calculated item "above average" would have the value 2. and My new calculated item "below average" would have the value 3. So, I could create a key value objects using these values as the measure.  ... View more

Hi,   I have a column on my dataset that has date values, but the variable is Catregorical. I am looking for a way to get the month values. For example, the data I have is Dec 08 2022 (categorical). I would like to get the 08, using VA interface. I'd use Calculated Item, and use Text operators but then they require numerical inputs. So, this idea didn't work.  Can I achieve what I am trying to do in VA? If yes, how?   Thank you!  ... View more