Hi,   I have some data in which students are tracked between schools and years--observations with the same student ID and same school ID are assumed to be the same person (i.e. person A in school 65 in year 2007 = person A in school 65 in year 2008). But person A in school 65 is not the same as person A in school 64, regardless of year. I need to calculate the average score over years. Some students appear in multiple years, and some only appear in one (in which case their average score would just be their score from last year). Additionally, students can appear    Here is what my data currently looks like: data test;    infile datalines;    input studentID $ schoolID year score; datalines; a 123 2000 78 a 123 2000 78 a 123 2001 80 a 123 2001 80 a 123 2001 80 b 123 2002 95 b 456 2003 91 c 456 2003 90 c 456 2004 98 c 456 2006 92 ; run;   Basically i want another column with average score, that should be 79, 79, 79, 79, 79, 95, 91, 93.3, 93.3, 93.3   I feel like I might need a combination of sql and by group processing but I'm getting stuck on calculating the average score vertically.   Thanks! ... View more

  Here is the scenario: I have a dataset with hospital identifiers, years, and a cost to charge ratio. For the year 2003, no cost to charge ratio is available. I need to take the ratio from 2004, multipy it by 1.04, and then merge by hospital ID to get cost to charge ratios for 2003. It might make more sense if you look at the code--I want to go from old to new.   data old; infile datalines; input Hospid $ Year Ratio; datalines; A 2003 . B 2003 . C 2003 . C 2003 . A 2004 .2 B 2004 .24 C 2004 .3 ; run;   and I want to get new by taking the ratio from 2004, multiplying it by 1.04 and then matching it by hospid:   data new; infile datalines; input hospid $ year ratio; datalines; A 2003 .208 B 2003 .2496 C 2003 .312 C 2003 .312 A 2004 .2 B 2004 .24 C 2004 .3 ; run;   I have tried two methods: 1. a proc sql left join, in which I made a separate dataset of 2004 observations and then tried to join by hospid. that still gave me missing values 2. also making a separate dataset of 2004 observations, sorting that and the original dataset, then merging by hospid. that mostly worked, except when hospital id appeared more than once in which case i only got a ratio for one of the occurances.   thanks for any advice!          ... View more

I am trying to do some analyses on a variable that SAS read in as character when it is numeric. I read it the data in as a csv with proc import. There are 100 variables but here is a snippet:   ID     BMI 1       25.987 2       23.192 3       29.901 4       21.009   And my code to read it in is  proc import datafile='~/dig_sas.csv' out=dig DBMS=csv replace; guessingrows=MAX; getnames=YES; run;   It reads in BMI as character. I couldn't get the correct informat/ format (should be 6.3) in further steps. I also tried doing an input statement but coudn't get it to work. I don't want to do a data step with an infile/input because there are so many variables.   thanks! ... View more