Hi All, I have an issue, maybe small but something that has bugged me through experimentation. I have a data set which contains a variable which contains a list of date variables concatenated (I originally got all date variables using the vcolumns options for each data set and stored them in a variable) : E.g. Dataset Dates X1 DT1, DT2, DT3 X2 DT1, DT3, DT4, DT5 X3 DT1, DT2 X4 DT1 I then want to have a min function to find the minimum of all the date fields in the dataset:, using dataset X1 as an example; data testX1; set X1; mindt = min(dates); run; Now this falls over as states it doesn't contain enough arguments. I can see the issue in that "dates" is only a single variable. How can I modify this to read the contents of the variables as the argument e.g. dates testX1; set X1; mindt = min(DT1,DT2,DT3); run; This works, but as I have to do this dynamically for a number of datsets, I tried storing the values as a variable and read this variable in, any suggestion please? I assume a do loop, or create a macro variable but unsure as to how this works as to passing in a function. Kind regards,
... View more