I have a two part question. How would I create the table below using proc report? I can't figure out how to split the cells underneath the targets!   Second question: In my dataset I have one variable 'Target' containing both the target and the strain (Pox S1, Pox S2, etc.) would I still be able to create this table keeping it like that, or should I reshape my data set?    Thanks for the help! ... View more

Hi everybody! I would like to create an additional variable that is the average of my duplicate target levels with my main target levels. I don’t want the 0’s to average with another sample though. For example on May 6, located at EU, there are two levels for the N.GIII target…I’d like to average those together, but on May 20, located at HU, the duplicate sample is a non-zero, I don’t want to average that value, with the zero in the main sample. Any guidance would be appreciated! ... View more

I have a data set that contains date of sample, site locations, main samples duplicate samples, and PH levels. I am trying to average the non-zero duplicate samples with the main samples, specific to the location (matching SA to SA, and AU to AU). Any advice would be appreciated! For example, Date location sample ph level 5/6 SA Main 2.5 5/7 SA Dup 6.467 5/6 AU Main .04 5/7 AU Dup 0 ... View more

Hi!  I'm not quite clear on how to visualize the spearman's correlation and p-value (as it is reporting the Pearson's correlation) into the legend on the scatter plot.  Here is my code and graph, any advice would be most appreciated!    proc corr data = Omni.Omi_sweeps spearman plots=scatter; var D_ww_cpL1000 D7_active; run;    ... View more

Hi everybody! I’m having trouble figuring out the problem with my code. I’m trying to set a character variable (disease) to missing (‘ ‘). Here is what I’ve done. Data ill.diseases_2000; Set ill.diseases2000; If (illness = ‘ADHD’ OR illness = ‘OCD’ OR illness = ‘Arthritis’ OR illness = ‘andropause’ OR illness = ‘Halitosis’ OR illness = ‘Alopecia’ OR illness = ‘Bronchitis’ OR illness = ‘celiac’ OR illness = ‘thrombosis’ OR illness = ‘diverticulitis’ OR illness = ‘epilepsy’ OR illness = ‘hepatitis C’ OR illness = ‘gout’ OR illness =‘hepatitisC’ Or illness = ‘mononucleosis’ OR illness = ‘flu’ OR illness = ‘nephropathy’ OR illness = ‘CJD’) then disease = ‘ ‘; run; Whenever I run the code the entire new variable (disease) is blank not just the ones I wanted. I thought maybe it’s too many in a row so I broke up the if, then statement and it’s the same thing. Any advice and guidance would be greatly appreciated! ... View more