Hi all, I am trying to rank transform a data by year (i.e., rank transformation within cross-section) such that the rank transformed that has a mean of 0 and a standard deviation of 1.  Here is what I have so far, but I am not able to force proc transform to rank transform the data so that SAS rank transforms the data by having mean=0 and std=1:     data work.have; infile cards expandtabs truncover; input id year value; cards; 1 2001 0.4 2 2001 0.3 3 2001 0.4 4 2001 0.8 5 2001 0.9 6 2001 0.8 7 2001 0.8 1 2002 0.3 2 2002 0.9 3 2002 0.1 4 2002 0.9 5 2002 0.2 6 2002 0.9 7 2002 0.9 ; run; /* I want to rank the variable "value" by year such that it has a mean=0 and a std=1 */ /* Please note that the rank needs to be performed within each year (i.e., within the cross-seciton) */ proc rank data=work.have out=work.have_ranked; by year; var value; ranks valueRank; run; /* Results */ proc sql; create table work.want as select distinct year, mean(value) as average, std(value) as standard_dev from work.have_ranked group by year; quit;     Any suggestions will be appreciated! ... View more

I am getting an error when I use &md as follows:   data have2; set have1; mdCO = &md; do mdValid = mdCO to mdCO + &rankBack - 1; output; end; run; My date variable is already formatted in date9., but I am still getting the following error:   202 data have2; set have1; 203 mdCO = &md; - 22 WARNING: Apparent symbolic reference MD not resolved. ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, a numeric constant, a datetime constant, a missing value, INPUT, PUT. 204 do mdValid = mdCO to mdCO + &rankBack - 1; 205 output; 206 end; 207 run; NOTE: The SAS System stopped processing this step because of errors. Any suggestions will be greatly appreciated!  ... View more

Is there any way to compress blank spaces of variable names of all variables without listing the variables individually? ... View more