https://communities.sas.com/t5/New-SAS-User/How-to-create-a-line-of-Patient-id-Sex-and-First-dose-in-the/m-p/632692#M21122 <P>I have uploaded the dataset also u can use it</P> Tue, 17 Mar 2020 15:14:10 GMT Rakesh93 2020-03-17T15:14:10Z https://communities.sas.com/t5/New-SAS-User/How-to-create-a-line-of-Patient-id-Sex-and-First-dose-in-the/m-p/632613#M21110 <P>Please refer to attachment of mock shell<span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Capture1.PNG" style="width: 600px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/36926iE94ECF106A9100E6/image-size/large?v=v2&amp;px=999" role="button" title="Capture1.PNG" alt="Capture1.PNG" /></span>Please refer ti above mock shell.</P> Tue, 17 Mar 2020 15:12:39 GMT https://communities.sas.com/t5/New-SAS-User/How-to-create-a-line-of-Patient-id-Sex-and-First-dose-in-the/m-p/632613#M21110 Rakesh93 2020-03-17T15:12:39Z https://communities.sas.com/t5/New-SAS-User/How-to-create-a-line-of-Patient-id-Sex-and-First-dose-in-the/m-p/632615#M21111 <P>Hi&nbsp;<a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/294186">@Rakesh93</a>&nbsp;</P> <P>There is no attachement?</P> Tue, 17 Mar 2020 11:04:31 GMT https://communities.sas.com/t5/New-SAS-User/How-to-create-a-line-of-Patient-id-Sex-and-First-dose-in-the/m-p/632615#M21111 ed_sas_member 2020-03-17T11:04:31Z https://communities.sas.com/t5/New-SAS-User/How-to-create-a-line-of-Patient-id-Sex-and-First-dose-in-the/m-p/632622#M21112 <P>If you want to make a report from a dataset, you have to show us this dataset (in a data step with datalines, please) so we have something to experiment with.</P> Tue, 17 Mar 2020 11:30:14 GMT https://communities.sas.com/t5/New-SAS-User/How-to-create-a-line-of-Patient-id-Sex-and-First-dose-in-the/m-p/632622#M21112 Kurt_Bremser 2020-03-17T11:30:14Z https://communities.sas.com/t5/New-SAS-User/How-to-create-a-line-of-Patient-id-Sex-and-First-dose-in-the/m-p/632623#M21113 My rule of thumb is that it should take you at least as much time to ask the question as it takes me to answer it. Tue, 17 Mar 2020 11:46:45 GMT https://communities.sas.com/t5/New-SAS-User/How-to-create-a-line-of-Patient-id-Sex-and-First-dose-in-the/m-p/632623#M21113 Patrick 2020-03-17T11:46:45Z https://communities.sas.com/t5/New-SAS-User/How-to-create-a-line-of-Patient-id-Sex-and-First-dose-in-the/m-p/632675#M21121 <P>So what do we do with the "mock shell"?</P> <P>&nbsp;</P> <P>Write code to read data that comes in that sort of format? I can't write code to read an image. And if that is expected to be read you really should go to the source and get a more tabular layout as that sort of format has many possible variations that showing us one example may not be able to extend to other similar with more or fewer lines, missing values and such.</P> <P>&nbsp;</P> <P>Write a report that looks like that? Need a data set to read values from.</P> <P>&nbsp;</P> <P>&nbsp;</P> Tue, 17 Mar 2020 14:23:04 GMT https://communities.sas.com/t5/New-SAS-User/How-to-create-a-line-of-Patient-id-Sex-and-First-dose-in-the/m-p/632675#M21121 ballardw 2020-03-17T14:23:04Z https://communities.sas.com/t5/New-SAS-User/How-to-create-a-line-of-Patient-id-Sex-and-First-dose-in-the/m-p/632692#M21122 <P>I have uploaded the dataset also u can use it</P> Tue, 17 Mar 2020 15:14:10 GMT https://communities.sas.com/t5/New-SAS-User/How-to-create-a-line-of-Patient-id-Sex-and-First-dose-in-the/m-p/632692#M21122 Rakesh93 2020-03-17T15:14:10Z https://communities.sas.com/t5/New-SAS-User/How-to-create-a-line-of-Patient-id-Sex-and-First-dose-in-the/m-p/632695#M21123 <P>I want the SAS code of SAS Report so that i can have the output as per the mock shell</P> <P>&nbsp;</P> Tue, 17 Mar 2020 15:16:37 GMT https://communities.sas.com/t5/New-SAS-User/How-to-create-a-line-of-Patient-id-Sex-and-First-dose-in-the/m-p/632695#M21123 Rakesh93 2020-03-17T15:16:37Z https://communities.sas.com/t5/New-SAS-User/How-to-create-a-line-of-Patient-id-Sex-and-First-dose-in-the/m-p/632700#M21124 <A href="https://support.sas.com/resources/papers/proceedings/pdfs/sgf2008/173-2008.pdf" target="_blank">https://support.sas.com/resources/papers/proceedings/pdfs/sgf2008/173-2008.pdf</A><BR /><BR />Example 8 goes through this in detail and here's the link to the code:<BR /><BR /><A href="https://support.sas.com/rnd/papers/sgf2008/complex_reports.zip" target="_blank">https://support.sas.com/rnd/papers/sgf2008/complex_reports.zip</A> Tue, 17 Mar 2020 15:22:27 GMT https://communities.sas.com/t5/New-SAS-User/How-to-create-a-line-of-Patient-id-Sex-and-First-dose-in-the/m-p/632700#M21124 Reeza 2020-03-17T15:22:27Z https://communities.sas.com/t5/New-SAS-User/How-to-create-a-line-of-Patient-id-Sex-and-First-dose-in-the/m-p/632741#M21129 <BLOCKQUOTE><HR /><a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/294186">@Rakesh93</a>&nbsp;wrote:<BR /> <P>I have uploaded the dataset also u can use it</P> <HR /></BLOCKQUOTE> <P>NOW you need to supply some information as to which value, either from the data set or calculated goes where. Your "mock shell" shows what appear to be many different dates and times&nbsp;without any clear description of what that date might be, which variable it comes from or any rules. Since your data has 12 date variables and 11 datetime variables that is a pretty serious shortfall. Especially when you have what might be different variables stacked over each other.</P> <P>&nbsp;</P> <P>Your headings in the "mock shell" do not match variable labels in the data set so we can't be sure where the values may be coming from. And then the image is also cutoff to the right, so perhaps we don't even see all the desired columns.</P> Tue, 17 Mar 2020 17:31:20 GMT https://communities.sas.com/t5/New-SAS-User/How-to-create-a-line-of-Patient-id-Sex-and-First-dose-in-the/m-p/632741#M21129 ballardw 2020-03-17T17:31:20Z