Sorry about that. I couldn't get the code to work right so I tried another approach. Here is the data which can be pasted in a txt file and saved as a csv, and then there is code to import the file. This won't match the screenshot in my original post. Please ignore that screenshot. The data below is what was intended. Thank you.
User_ID,Vst_dt1,Vst_dt2,Vst_dt3,Vst_dt4,Vst_dt5,Vst_dt6,Vst_dt7,Vst_dt8,Vst_dt9,Vst_dt10
1,1-Feb-23,1-Mar-23,1-Apr-23,1-May-23,1-Jun-23,1-Jul-23,1-Aug-23,1-Sep-23,1-Oct-23,1-Nov-23
2,.,1-Mar-23,1-Apr-23,1-May-23,.,.,1-Aug-23,1-Sep-23,1-Oct-23,.
3,.,.,1-Apr-23,1-May-23,.,.,.,.,.,.
4,.,.,.,1-May-23,1-Jun-23,1-Jul-23,.,.,1-Oct-23,1-Nov-23
5,1-Feb-23,1-Mar-23,1-Apr-23,.,.,.,1-Aug-23,1-Sep-23,.,.
proc import
datafile="your_path/Book1.csv"
dbms=csv
out=fake_data
replace;
run;
... View more