I have a data have 3 avariles:  ID AMOUNT year 8888 50 110 8889 1.10 110 8889 2.99 111 8890 3.48 110 8891 34.08 110 8891 144.87 110 8891 2.24 111 8892 0 110 how to sum over multiple records for amont and keep ID and most recnt year if the obervation has multiple records in SAS? 8888 50 110 8889 4.09 111 8890 3.48 110 8891 181.19 111 8892 0 110 ... View more

i have a data s follows: there are only 2 variables, age group (age) and survival time (time). there is no censoring observations.   input age $ time ; cards; "<=40" 2 "<=40" 3 "<=40" 6 "<=40" 6 "<=40" 7 "<=40" 10 "<=40" 15 "<=40" 15 "<=40" 16 "<=40" 27 "<=40" 30 "<=40" 32 ">40" 1 ">40" 1 ">40" 1 ">40" 1 ">40" 2 ">40" 3 ">40" 3 ">40" 9 ">40" 22 ;   i have two questions: 1) did i enter the data correctly? 2)  how do i conduct a log-rank test to compare survival curves between 2 age groups? ... View more

data temp1; input teacher $ class $ score; cards; A C1 70 A C2 80 B C3 90 B C4 99 C C5 76 D C6 95 ; run; data temp2; input teacher $ class $ weight ; cards; A C2 0.5 B C2 0.5 B C3 0.333 C C3 0.333 D C3 0.333 ; run; from temp1,Class C1, C4, C5 and C6 are taught independently by teacher A , B, C and respectively. from temp2, Class C2 is co-taught by teacher A and B (weight 0.5 each), but data temp1 only has A's data not B's. Class C3 is co-taught by teacher B, C, and D (weight 0.3333 each), again but data temp1 only has B's data not C D. I wan to create a new data set to copy the co-teach (class and score) information as follows: variables are teacher class score and weight(only co-taught courses have weights) A C1 70 . A C2 80 0.5 B C2 80 0.5 B C3 90 0.333 C C3 90 0.333 D C3 90 0.333 B C4 99 . C C5 76 .  D C6 95 . ... View more

I have an excel files with 3 work sheets  for year 106, 107 and 108. each year has 100 observations with the same varoables. I wrtoe an macro, but WORK.a has only 100 observations. how do I merge the 300 obsevations together into work.a ?   %macro pim(sheet); proc import out= WORK.a datafile = 'G:\data\106_108.xlsx' DBMS=EXCEL replace; sheet = "&sheet"; GETNAMES=YES; run; %mend pim; %pim(106); %pim(107); %pim(108); proc print data= WORK.a ; run; ... View more

I have a data as follows: Class 1 and 2 have single row, that means these two class taught independently by A and B respectively.   Class 3 and 3 have multiple  rows, that means these two class co-taught independently by several teachers. for example, class 3 was  co-taught by teachers A, C, and D.  class 4 was  co-taught by teachers B, C, and D.    I want to creat two variables "coteach" "N_teacher" and  make the data as follows: the variable "coteach" is an indicator variable,  and "N_teacher" counts number of teahcers teach the class        ... View more

Dear all : I have a data as follows:     college ID x1 x2 A 1 10 15 A 2 11 18 A 3 12 21 A 4 13 26 B 5 18 20 B 6 20 22 B 7 22 24 B 8 24 26   I use "proc means" to get the mean and standard deviation of X1 and x2 by college.  proc means;  var x; by by college; run; However, I need to create a new data set with means and standard deviations (by colleges)  as 4  new variables, as follows:  college ID x1 x2 x1mean x1std x2mean x2std A 1 10 15 11.5 1 20 4.69 A 2 11 18 11.5 1 20 4.69 A 3 12 21 11.5 1 20 4.69 A 4 13 26 11.5 1 20 4.69 B 5 18 20 21 2.58 23 2.58 B 6 20 22 21 2.58 23 2.58 B 7 22 24 21 2.58 23 2.58 B 8 24 26 21 2.58 23 2.58   11.5 is the mean of X1 for college A, 21 is the mean of X1 for college B,  1  is the std  X1 for college A, 2.58 is the std of X1 for college B, etc    How do I write the program and rename the mean and std?  thank you!   ... View more