How to create a line of Patient id Sex and First dose in the table?

[Rakesh93]

Please refer to attachment of mock shellPlease refer ti above mock shell.

[ed_sas_member]

Hi @Rakesh93 

There is no attachement?

[Rakesh93]

I have uploaded the dataset also u can use it

[ballardw]

---

@Rakesh93 wrote:

I have uploaded the dataset also u can use it

---

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 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.

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.

[Kurt_Bremser]

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.

[Rakesh93]

I want the SAS code of SAS Report so that i can have the output as per the mock shell

[Reeza]

https://support.sas.com/resources/papers/proceedings/pdfs/sgf2008/173-2008.pdf

Example 8 goes through this in detail and here's the link to the code:

https://support.sas.com/rnd/papers/sgf2008/complex_reports.zip

[Patrick]

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.

[ballardw]

So what do we do with the "mock shell"?

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.

Write a report that looks like that? Need a data set to read values from.