Lola,
If you need to export to Excel, then you might want to try using AGGREGATE to crunch your frequency data. You can then easily export it to Excel. Otherwise you are stuck with cut and paste operations.
I'm assuming that you want to have a spreadsheet a unique SiteID in each row (with the SiteID in the first column and then your frequency data as variables in adjacent columns). Here's one approach using a simple macro to loop through three variables (using test data)...
DATA LIST FREE / SITEID V1 TO V3.
BEGIN DATA
123 2 3 2
123 2 1 2
123 2 2 2
321 3 1 3
321 2 2 2
321 3 3 2
456 2 1 2
456 1 2 1
456 3 3 3
END DATA.
DEFINE !LOLA (VLIST=!ENCLOSE("[","]"))
AGG OUT=* / BREAK SITEID
!DO !Z !IN (!VLIST)
!CONCAT("/",!Z,"_Mean") = MEAN (!Z)
!CONCAT("/",!Z,"_Median") = MEDIAN (!Z)
!CONCAT("/",!Z,"_Min") = MIN (!Z)
!CONCAT("/",!Z,"_Max") = MAX (!Z)
!CONCAT("/",!Z,"_StdDev") = SD (!Z)
!CONCAT("/",!Z,"_Sum") = SUM (!Z)
!DOEND.
DATASET NAME EXAMPLE WINDOW=FRONT.
!ENDDEFINE.
!LOLA VLIST [V1 V2 V3].
You are limited to the stats that AGG has available natively, but you can also create other stats you need first and then use AGG afterwards. HTH,
Bob Walker
Surveys & Forecasts, LLC
www.safllc.com
----- Original Message -----
From: Lola Coker
Date: Tuesday, May 15, 2007 9:50 am
Subject: Re: Looping with frequencies?
To:
[hidden email]
> Thank you so much for your reply
>
> Split file works except I also have some other commands I need
> to run
> along with frequencies--the outputs need to be saved in separate
> files and
> exported to excel (via syntax). I was hoping that I would be
> able to just
> create a loop of some kind...
>
> This is actually for a set of reports that have a deadline
> attached...Ireally would appreciate any and all help (mercy)
> that anyone is willing to
> give.
>
> Thanks again,
> Lola
>
Bob Walker
Surveys & Forecasts, LLC
www.safllc.com
Locked
