topic Re: Can I loop this process? in SAS Enterprise Guide

Can I loop this process?

matt23 — Wed, 08 Aug 2018 15:49:12 GMT

I have never done any loops so I don't know if this process can be done but Can I code this so I don't have to do it for all 12 Months?

Here's what I'm doing:

proc means data=have;
where Month in (1);
by Month hour;
var Lo Te De Wi CC Sr Rf;
output out=MeanJan mean=;
run;

proc means data=have;
where Month in (2);
by Month hour;
var Lo Te De Wi CC Sr Rf;
output out=MeanFeb mean=;
run;

data avrg;
merge 
	MeanJan(rename=(Lo=LeJan
					Te=TeJan
					De=DeJan
					Wi=WiJan
					CC=CCJan
					SR=SRJan
					RF=RFJan))
	MeanFeb(rename=(Lo=LoFeb
					Te=TeFeb
					De=DeFeb
					Wi=WiFeb
					CCr=CCFeb
					Sr=SRFeb
					Rfl=RFFeb))
;
by Hour;
keep LeJan TeJan.........;
run;

If I can loop this, how?

Re: Can I loop this process?

PaigeMiller — Wed, 08 Aug 2018 15:59:16 GMT

If you run the PROC MEANS with out the WHERE statement, you get one output data set containing the means of each month. There's no need to run 12 different PROC MEANS here.

When you try to create data set AVRG, this is where you start doing things that probably ought to be avoided. Turning a long data set into a wide data set usually is not a good idea, it doesn't help you in the future analyses you want to do (although I suppose there are always exceptions). So, without strong justification, there is no need to loop this either.

Re: Can I loop this process?

matt23 — Wed, 08 Aug 2018 16:20:22 GMT

I know but how would I make new variables for every month ?

Re: Can I loop this process?

PaigeMiller — Wed, 08 Aug 2018 16:25:27 GMT

Why do you want new variables for each month? What analysis are you going to do with all of these variables once you have them?

Re: Can I loop this process?

matt23 — Wed, 08 Aug 2018 16:31:22 GMT

I just need this for a basic sgplot with series. I know I can just use
group=month but my version of sas does not have the new options to play
with individual lines and stuff when it's grouped by month. So I'm trying
to do sgplot with individual series for each month.

Re: Can I loop this process?

PaigeMiller — Wed, 08 Aug 2018 16:41:35 GMT

If you mean options like GROUPLP, GROUPLC and GROUPMC in PROC SGPLOT, yes, they are not in older versions of SGPLOT. However the STYLEATTRS statement is still available in PROC SGPLOT to control line colors and line patterns and markers.

So, don't do the huge amount of work to make separate columns. Use PROC SGPLOT with GROUP= and STYLEATTRS. It's a huge amount simpler, and less error prone.

Re: Can I loop this process?

matt23 — Wed, 08 Aug 2018 16:43:22 GMT

Yea I know and I tried. But I have an older version of SAS EG so I don't
have styleattrs or mapattrs so I don't really have a choice. Thank you
though

Re: Can I loop this process?

PaigeMiller — Wed, 08 Aug 2018 16:51:57 GMT

If your version is really that old — PLEASE STATE THE VERSION NUMBER OF SAS THAT YOU HAVE by opening Enterprise Guide and the run the following statement: proc setinit; run; — you can then use PROC GPLOT and you still don't need to create all of these columns.

Re: Can I loop this process?

Astounding — Wed, 08 Aug 2018 16:52:09 GMT

Even with your restrictions, you would do better to keep the data in one data set. Just apply the WHERE statement later, in the plotting procedure. Even if using a BY statement isn't feasible, looping isn't all that difficult. Get a version that works for one month, and we can expand it to all 12 months, using just one summary data set.