But which of the 67 rows do you want? Perhaps you want to summarize the 67 rows? You might consider PROC SUMMARY (also known as PROC MEANS). For example to get the mean of all the numeric variables (like the two mentioned above in your example code). You can use a CLASS statement even if the data is not sorted by that variable. proc summary data=walmart7 nway ; class state ; var _numeric_ ; output out=means mean= ; run;
... View more
