First thing I would say is to provide any examples in the form of text. Copy text from a file using any text editor and on the forum open a text box using the </> icon that appears above the message box and paste the text. Better would be to paste a working data step that will create a SAS data set with values that you have. It is next to impossible to write code to read from a picture.
Second: do the same pasting of text of what you want for a result from the given example.
Third is to show the code that you have attempted so far, again pasted into a text box. Since you didn't show any of the requirements I have to assume are a, b and c it is hard to tell if part of the solution may involve those.
... View more