https://communities.sas.com/t5/SAS-Viya/Need-help-in-coding-the-program-for-a-particular-questions/m-p/795700#M1356 <BLOCKQUOTE><HR /><a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/416387">@Linto_1</a>&nbsp;wrote:<BR /> <P>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.&nbsp;<FONT color="#FF0000"><STRONG> 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</STRONG></FONT></P> <HR /></BLOCKQUOTE> <P>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?</P> <P>Preloadfmt also is not very "new". So I sort of wonder where that statement comes from.</P> <P>And you might be surprised what PRELOADFMT with a MULTILABEL format can do.</P> <P>&nbsp;</P> <P>DATA, DATA, DATA.</P> <P>&nbsp;</P> <P>Expected results for some provided data.</P> Fri, 11 Feb 2022 16:43:40 GMT ballardw 2022-02-11T16:43:40Z https://communities.sas.com/t5/SAS-Viya/Need-help-in-coding-the-program-for-a-particular-questions/m-p/795608#M1353 <P>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.&nbsp; 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</P> Fri, 11 Feb 2022 06:13:12 GMT https://communities.sas.com/t5/SAS-Viya/Need-help-in-coding-the-program-for-a-particular-questions/m-p/795608#M1353 Linto_1 2022-02-11T06:13:12Z https://communities.sas.com/t5/SAS-Viya/Need-help-in-coding-the-program-for-a-particular-questions/m-p/795613#M1354 <P>And the question is?</P> <P>&nbsp;</P> Fri, 11 Feb 2022 06:40:18 GMT https://communities.sas.com/t5/SAS-Viya/Need-help-in-coding-the-program-for-a-particular-questions/m-p/795613#M1354 andreas_lds 2022-02-11T06:40:18Z https://communities.sas.com/t5/SAS-Viya/Need-help-in-coding-the-program-for-a-particular-questions/m-p/795621#M1355 <P>Please provide available data (<EM>have</EM>) and desired output (<EM>want</EM>).</P> Fri, 11 Feb 2022 08:48:56 GMT https://communities.sas.com/t5/SAS-Viya/Need-help-in-coding-the-program-for-a-particular-questions/m-p/795621#M1355 LinusH 2022-02-11T08:48:56Z https://communities.sas.com/t5/SAS-Viya/Need-help-in-coding-the-program-for-a-particular-questions/m-p/795700#M1356 <BLOCKQUOTE><HR /><a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/416387">@Linto_1</a>&nbsp;wrote:<BR /> <P>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.&nbsp;<FONT color="#FF0000"><STRONG> 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</STRONG></FONT></P> <HR /></BLOCKQUOTE> <P>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?</P> <P>Preloadfmt also is not very "new". So I sort of wonder where that statement comes from.</P> <P>And you might be surprised what PRELOADFMT with a MULTILABEL format can do.</P> <P>&nbsp;</P> <P>DATA, DATA, DATA.</P> <P>&nbsp;</P> <P>Expected results for some provided data.</P> Fri, 11 Feb 2022 16:43:40 GMT https://communities.sas.com/t5/SAS-Viya/Need-help-in-coding-the-program-for-a-particular-questions/m-p/795700#M1356 ballardw 2022-02-11T16:43:40Z