I have a dataset with the following columns:   Subject Date1 SBP1 DBP1 Date2 SBP2 DBP2 Date3 SBP3 DBP3 ..... Date30 SBP30 DBP30 =============== =============== =============== ..... ================== and I would like to normalise into the following:   Subje Date SBP DBP ---- ---- --- --- Subj1 Date1 SBP1 DBP1 Subj1 Date2 SBP2 DBP2 Subj1 Date3 SBP3 DBP3 ..... Subj1 Date30 SBP30 DBP30 Subj2 Date1 SBP1 DBP1 Subj2 Date2 SBP2 DBP2 Subj2 Date3 SBP3 DBP3 ..... Subj2 Date30 SBP30 DBP30   I can think of one solution where I Union the dataset 30 times so:   select subject, Date1, SBP1, DBP1 from ds union select subject, Date2, SBP2, DBP2 from ds union .... select subject, Date30, SBP30, DBP30 from ds   But hopefully there is a better way? ... View more

Hi,   In the report designer is it possible to implement an "order by" clause across several columns? So for example:   Order by site, subject, visit, page   Or does this "order by" have to be implemented in a data prep query? Also, will this "order by" clause be correctly output when used in report designer ?   I want to fix the order in the report design and not have the user change it if possible. (Using v7.3.) Thanks. Mike     ... View more

Hi all,   I'm interested if anyone has had experience of creating a clinical patient profile report from SAS VA (Version 7.3) that they would be happy to share?   Typically this report would be exported to PDF or Excel (not a option for 7.3) and in a nested dataset order within a subject. I've researching this report and not I'm not convinced SAS VA has the control needed to generate the exported document when compared to base SAS.   I'm guessing there is a difference between a general purpose report tool (base SAS) and a visualisation tool such as VA that I didnt originally pickup on.   Any opinions/suggestions would be gratfully received. Thanks. ... View more

Hi,   Using SAS VA 7.3.   Is it possible to split a single dataset row across 2 lines in a list table?   So for example if a dataset had 10 columns and you wanted to fit 5 columns on line1 and 5 on line2:   Header1: Col1 Col2 Col3 Col4 Col5 Header2: Col6 Col7 Col8 Col9 Col10 ------------------------------------------------------- Dataset row1 - line1: Col1 Col2 Col3 Col4 Col5 Dataset row1 - line2: Col6 Col7 Col8 Col9 Col10 Dataset row2 - line1: Col1 Col2 Col3 Col4 Col5 Dataset row2 - line2: Col6 Col7 Col8 Col9 Col10   This is to resolve an issue where a dataset row is truncated in a PDF output as the row cannot fit on a single line on an A4 page.   2nd question: In v7.3 excel outputs cannot be produced (I believe?) - has this been resolved in later versions?   Many thanks for your help. ... View more

Whats the best way of controlling the x axis length when executing a proc sgplot across several iterations when using macro variables?     proc sgplot data=xxx_subj; format vdate date7.; title "Subject: &pt."; band x=studyday lower=nrlow upper=nrhigh / transparency=0.6 fill nooutline name='nr' legendlabel='Normal Range' ; series x=vdate y=xxx / x2axis markerattrs=(size=0); yaxis offsetmin=0.1 offsetmax=0.1 display=(noline noticks) grid label='xxx'; xaxis thresholdmin=0.25 values=(&minday to &maxday) grid label='Study Day'; x2axis thresholdmin=0.25 values=(&mindate to &maxdate) label='Study Date'; run;   So in this code the xaxis and x2axis lines have the option "values=(&min to &max)". I would like to us a "by 7" increment but when i do the x axis is either truncated or elongated based on the actual values for &min and &max and I want to avoid this.    A potential answer may be to increase the value of &max to the next multiple of 7 based from the &min value. Would this be a valid way to control the axis or is there a better alternative?   According to the 9.4 help when the "by" statement is not provide "The result can be unpredictable output." which sounds not good.   Thanks for your help. ... View more