Everyone sees something in data based on what they do the most.  If I were faced with this dataset, I would consider some sort of repeated measures using a generalized linear model.  For instance, if you were looking for estimates for each player, as a conditional value over time, you might try:   data long; set topnfl; year=20;value=s20/100;output; year=19;value=s19/100;output; year=18;value=s18/100;output; year=17;value=s17/100;output; year=16;value=s16/100;output; year=15;value=s15/100;output; keep player year value; run; proc glimmix data=long; class player year; nloptions maxiter=1000; model value=player year/dist=bin ddf=32; random year/residual type=ar(1) group=player; lsmeans player/diff ilink; run; I set the denominator degrees of freedom to 32, which is what the 'skeleton' ANOVA table (no RANDOM statement) provides in PROC GLM. I used the binomial distribution because the measures are the result of an undetermined number of Bernoulli trials (either made or missed).   SteveDenham ... View more

You're making it too hard. You have all the components already so just need to assemble them again in a different order. Start with what the columns of the table should be. ... View more

Looks right to me! ... View more

@Godzilla_Hat Make sure you spend the time reading what's in the article and links in it that @ballardw provided. If you want to use SAS then it's important that you understand how dates are stored and what functions there are to work with such SAS dates. data elvis; infile datalines truncover; input bdate:date9. ddate:mmddyy10.; format bdate ddate date9.; days_lived=ddate-bdate; datalines; 08JAN1935 08-16-1977 ; ... View more

I merged your questions dealing with the same homework.   Given that you want to read fixed-width data, you have to use positional input and the proper informats. Use @x (x being the position within a line, starting at 1) before the variable in question. Use a $w. (w being the width) to read the name, so that the blank(s) in the names don't interfere. Use MMDDYYw. and DATEw. informats for the dates.   ... View more

I merged your questions dealing with the same homework.   Given that you want to read fixed-width data, you have to use positional input and the proper informats. Use @x (x being the position within a line, starting at 1) before the variable in question. Use a $w. (w being the width) to read the name, so that the blank(s) in the names don't interfere. Use MMDDYYw. and DATEw. informats for the dates.   ... View more

You need to use if else statements to create the categorical variable. Otherwise, you could use proc format to create a new format and create a new variable with a put statement and apply the format to mpg variable. I prefer to just use the if-else statements.  data cars2; set cars; density = (wt* 100)/ vol; run; title "Density variable for obs 21 - 30"; proc print data=cars2 (firstobs=21 obs=30); var wt vol density; run; title; data categories; set cars; *create FuelEcon; if ^missing(MPG) and mpg < 20.0 then fuelecon=1; else if 20.0 <= mpg < 30.0 then fuelecon=2; else if 30.0 <= mpg < 40.0 then fuelecon=3; else if 40.0 <= mpg < 50.0 then fuelecon=4; else if mpg >= 50 then fuelecon=5; run; title "Check derivation of fuelecon variable"; proc means data=categories n nmiss min max; class fuelecon / missing; var mpg; run; title; title "Print model and fuelecon for categories ds"; proc print data=categories; var make fuelecon; run; title; ... View more