I am creating a vertical box plot and want to add some specific features. So far I have produced this code that creates the general structure that I want.   title "Diastolic Blood Pressure by Ethnicity/Race Group" bold; proc sgplot data = HypAnl.HypPrimanl; vbox DBP / group = EthRaceCd ; run;   I now want to add some specific features, but am unsure exactly where in code they actually go. For example, I want a reference line called "Hypertension Threshold" that runs at 90 on the Y-axis. Where in the code do I add these kind of features? ... View more

I am trying to create this output in my PROC REPORT:   Blood Pressure Summaries by Race     Average Pressures   Systolic Diastolic Race Code N MEAN STD MEAN STD Asian 11 117.1 11.1 69.1 9.0 Black 83 123.3 15.3 74.0 7.0 Other Race 30 115.2 15.5 69.8 11.0 White 449 120.8 15.5 70.0 7.6   573 120.8 15.4 70.6 7.8   *The format of this shows up kinda off. The systolic  and diastolic labels are supposed to be over the Mean and STD variables.    So far I have this code:   options fmtsearch = (HypTabs.HypFormats WORK LIBRARY); proc format; value $RaceCd ' ' = 'Unknown' 'A' = 'Asian' 'B' = 'Black' 'O' = 'Other Race' 'W' = 'White' other = 'Unexpected Value'; run; title 1 "Blood Pressure Summaries By Race"; proc report data = HypAnl.HypPrimAnl nowindows split = '/'; column RaceCd N ("Average Pressures" SBP DBP); define RaceCd / groip 'Race Code'; define SBP / analysis mean format = 5.1 'MEAN' analysis std format =4.1 'STD'; define DBP / analysis mean format = 4.1 'MEAN' analysis std format =4.1 'STD';   rebreak after / summarize; format RaceCd $RaceCd.; run;   The issue is getting the MEAN and STD variables split up in the table, because now only one is showing up. Any ideas? ... View more

I am trying to make an output dataset in this format:   Name Age Day Minutes 1 Ann 26 1 51 2 Ann 26 2 19 3 Ann 26 3 22 4 Bob 30 1 43 5 Bob 30 2 20 6 Bob 30 3 60   Here is the instream data I am using and the start of my DATA step. I am confused as to how I set up the array to accomplish the task of combining the Mon, Tue, Wed variable into a Minutes variable   data work.swimminutes; infile datalines delimiter = ','; input Name :$5. Age :2. Mon :2. Tues :2. Wed :2.; datalines; Ann,26,51,19,22 Bob,30,43,20,60 Chris,41,48,.,36 Dina,21,32,57,22 ; data Work.SwimLong2; set WORK.SwimMinutes; array ???; do Day = 1 TO 3; output; end; run; ... View more

I am trying to create a dataset called work.swimlong; from the dataset work.swimminutes. You can see the format for work.swimminutes below in the instream data. I am trying to make work.swimlong in the format that the Mon, Tues, Wed variables are in collected in one variable called "Day", with the appropiate minutes by each day, like this: Name    Age     Day   Minutes Ann       26        Mon     51 Ann       26        Tues     19 ....   data work.swimminutes; infile datalines delimiter = ','; input Name :$5. Age :2. Mon :2. Tues :2. Wed :2.; datalines; Ann,26,51,19,22 Bob,30,43,20,60 Chris,41,48,.,36 Dina,21,32,57,22 ; proc transpose data = work.swimminutes  out = work.swimlong;   Which Var or By statements do I need below to complete the code? ... View more