Date: Mon, 26 Feb 2001 09:08:56 GMT
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Andreas Grueninger <grueninger@IBGRUENINGER.DE>
Organization: Ingenieurbuero Grueninger
Subject: Re: SQL Dilemma
Content-Type: text/plain; charset=ISO-8859-1
Please post your error logs.
Otherwise it is too much speculation about the real errors.
I speculate you want to combine results of a bootstrapping process.
And the method to prdouce the layout of your desired final result
table is that what old fashioned SAS users would name as INTERLEAVING
and not as JOINING.
The main difference is that INTERLEAVING does not combine records of
two or more tables in ONE record of the output table but appends the
And this is very efficiently done with PROC APPEND.
Especially in bootstrapping is this of great importance concerning the
Before the starting the bootstrapping you create an empty table, with
SQL or a DATA STEP. Let us name it 'resultsFinal'.
* start of bootstrapping ;
* In the bootstrapping you make your calculations and create a table
with the same structure like 'resultsFinal' with your SQL statement
==> your SQL statement ;
create table resultsRound as
dur_rec as row_number,
sum(empl_1924)/1069 as pct_19_24 format=percent6.,
sum(emp_718)/560 as pct_7_18 format=percent6.,
sum(employ1924)+sum(emp_718) as curr_employ,
(calculated curr_employ/1924) as pct_7_24 format=percent6.,
group by row_main;
* or for hardcore SQL freaks, remove the following PROC APPEND if you
use this one ;
* INSERT INTO resultsFinal SELECT * FROM resultsRound;
PROC APPEND BASE=resultsFinal DATA=resultsRound;
* end of this round ;
>producing the desired output (any ideas would be great! ... Please
>Help!). Here's the tentative syntax of the program (for one table which
* --------------------------------- +
! Ingenieurbuero Grueninger !
! Andreas Grueninger !
! Uhlbergstr. 15 !
! 72631 Aichtal (Germany) !
! email: firstname.lastname@example.org !
+ --------------------------------- ;