Need help in coding the program for a particular questions

[Linto_1]

Clinical wants a report that shows a collected value by center, visit, and planned time.Visit 1 has only one planned time:00:00.Visit 2,3, and 4 have three planned times:00:00,0:15, and 0:30.Clinical wants to see the all possible planned times with the corresponding visits. However, you discover that one centre for some reason does have all the possible combination of planned NESUG 15 Corner 2 times for the corresponding visits.  Also,the new PRELOADFMT option will not handle this type of problem because it will give visit 1 all PTM values instead of just 00:00

[andreas_lds · Accepted solution]

And the question is?

[LinusH]

Please provide available data (have) and desired output (want).

[ballardw]

---

@Linto_1 wrote:

Clinical wants a report that shows a collected value by center, visit, and planned time.Visit 1 has only one planned time:00:00.Visit 2,3, and 4 have three planned times:00:00,0:15, and 0:30.Clinical wants to see the all possible planned times with the corresponding visits. However, you discover that one centre for some reason does have all the possible combination of planned NESUG 15 Corner 2 times for the corresponding visits.  Also,the new PRELOADFMT option will not handle this type of problem because it will give visit 1 all PTM values instead of just 00:00

---

The highlighted text above assume some specific code is to be used because PRELOADFMT is only available in a very small number of procedures. So wheres the example code? and the Format?

Preloadfmt also is not very "new". So I sort of wonder where that statement comes from.

And you might be surprised what PRELOADFMT with a MULTILABEL format can do.

DATA, DATA, DATA.

Expected results for some provided data.