I am a graduate student and currently I switch hit between using SPSS and SAS. OF course I prefer SAS because it is more flexible but the ability to use both programs can come in handy. Currently I am trying to find a function in SAS that SPSS has called "Cases to variables (casetovars is the syntax)". The case to variables function is exactly what it says, I can define parameters for SPSS to move cases into a new variable. Does anyone know the name of this function in SAS so I can start reading about it and learn how to use it? Or is this something that SPSS can do but SAS cannot? I find that hard to believe but anything is possible. Thank you.
Family and Consumer Studies
University of Utah
I'm not exactly sure what "casestovars" does. If you're talking about recoding or creating value labels, then you probably want PROC FORMAT.
If you're talking about "reshaping" data (for example you have 3 observations or rows each with a measurement and you want to turn the 3 obs into 1 obs with 3 variables -- MEAS1, MEAS2, MEAS3, then you're probably looking at PROC TRANSPOSE to get started. You can also rearrange data and reshape it using a DATA step program usually with ARRAYS.