Using SAS Release 3.6(Basic Edition) in a browser with VirtualBox version 5.1.18 I have some data that I need to take to a mixed procedure. I am struggling with getting the data read correctly. I realize that the answer may be already posted, but I either could not find it or understand. As a dummy data set: Let: d1 = 23, d2 = 31, a1 = 1, a2 = 2, b1=3, b2 = 6, c1 = 5, c2 = 10 Which would yield: a = 1.5, b = 4.5, c = 7.5, d = 27 needed answer is (a+b+c)/d = 0.5 SDa = 0.707, SDb = 2.12, SDc = 3.53, and SDd = 5.66 the SD of (a+b+c) = 4.18 and the SD of the needed answer is 0.187 So I tried some code: Data one; */ order=data; input Variety $ Treatment $ @; Do original = 1 to 2; input d @; output; end; Do alpha = 1 to 2; input a @; output; end; Do beta = 1 to 2; input b @; output; end; Do gamma = 1 to 2; input c @; output; end; datalines; Var Treat 23 31 1 2 3 6 5 10 ; proc print data=one; which is not what I was hoping for --> hoping for something like this. Obs Variety Treatment Original d Alpha a Beta b Gamma c 1 Var Treat 1 23 1 1 1 3 1 5 2 Var Treat 2 31 2 2 2 6 2 10
... View more