Hi all. I'm trying to find a way to speed up SAS analysis by minimizing the amount of manual labour.
Let's say you have a very simple code like below:
proc mixed data = mydata;
model total_mg = stand_type;
I'm trying to find a way to automatically substitute "total_mg" in the model statement with other variables (e.g., total_c, total_n, total_k etc.) found in the same dataset so that I only have to execute the program once, and all the variables in MYDATA is analysed by the proc mixed model provided.
Anytime you talk about "automating" SAS code, you get, eventually, to advice about using the SAS Macro Facility. For a good overview of the SAS macro facility, this is an excellent place to start: http://www2.sas.com/proceedings/sugi28/056-28.pdf