Thanks for the response! I've added a sample and a screenshot below. The change in the number of variables is a result of there not being data present for every single oven within the reporting period. As a result, ovens without text in the cell for any of the reporting period dates don't need to be displayed. What do you mean by across? data work.SAMPLE;
infile datalines dlm=',';
input DATE date9. OVEN_0051 $ OVEN_0052 $ OVEN_0054 $;
datalines;
12OCT2021, , ,TT(F)
13OCT2021,CD(N), ,BL
14OCT2021, ,TT,
;
run; Thanks, Zac
... View more