Agree, please @NewUsrStat explain why you would want such a dataset. It's clearly a report. Even if you're using this dataset to validate someone else's report, I'm not sure it's a good idea. It's hard for me to come up with a good reason to create this sort of dataset.
If you're truly a New User as your screen name implies, one thing that takes time to learn is that sometimes as a programmer, your boss/statistician/analyst will ask you to do something that makes sense to how they're thinking about the problem, but doesn't make sense to implement that way in SAS. Part of growing into a senior programmer is learning how to identify those issues, and explain/adjust. For example, many analysts want to talk about longitudinal data as if it's in a wide format (one record per patient ID, with score_time1 score_time2 score_time3 etc. It's fine for them to think that way, and sometimes even write requirements that way. They don't need to know or worry that you actually store the data in a vertical format (with variables ID, Time, Score).
I've never worked in pharma (and don't know if you do). But sometimes I feel like pharma programmers often feel stuck programming whatever a spec asks for, instead of interpreting the spec, and suggesting changes to the spec.
... View more
