Hello,   I need to display count of consumed spare parts per month.   I have already built a view of the date of consumption in month only format, I also have the count per material number of the parts. I just need to have the count broken down per month. How can I build those calculation in SAS Viya?   Thanks ... View more

Hi! I am using SAS 7.4 at the moment, we will migrate soon, but I have a date field that I am trying to turn into 2 columns: first date and last date when an observation was seen. I have tried agg. measure and calc item but I get type mismatch because of the date field. I figured I could change the date format (into a measure?) first and then build the other 2 custom categories. Any input on how to best perform all these steps or if my logic is wrong for the outcome I need? Thanks!   Example data set: Process Error 1   Severity 1  First Date Observed   Last date Observed   For columns, I have  1-minor error (to be used in the process error column (cat) 2-severity (cat) 3-localdate (cat) ... View more