06-21-2011 01:27 PM
06-21-2011 03:24 PM
06-22-2011 08:59 AM
06-22-2011 11:57 AM
06-22-2011 12:10 PM
06-22-2011 01:13 PM
06-22-2011 03:33 PM
06-22-2011 05:33 PM
06-23-2011 01:47 PM
After making the adjustments to fit my actual datasets, the code ran without problem, but when i look at the 'collections' table i get the initial record which is blank except for number_of_rows = 1
and the second record which is the information of my last data set (20110430).
I can't seem to figure out why it is not outputting the datasets in between..
I should have 7 datasets in there, from 20101031 to 20110430.
Thanks again for your replies.
06-24-2011 12:40 PM
it will add new entries, and only the latest
That seemed to be the intention - going forward - Add only for new rows.
Once the initial load of history is complete, the routine I offered would be appropriate.
Perhaps instead of loading the initial row of Collections with just that 1, I should have offered code to load the existing history, a bit like:
proc sql ; create table collect_history as
select memname as data_set_name, nobs as number_of_rows
, scan( memname,-1, '_' ) as date_received
and memname like 'INDICATORS_2%'
order by memname
* build "proper" collection ;
data collection ;
oldone = number_of_rows ;
set collect_history ;
format pct_change percent8.1 ;
pct_change = ifn( oldone > 0, number_of_rows/ oldone -1, . ) ;
drop oldone ;
(discovering the "investment" needed for "improvements" still to be discovered in the Forum - I might have to start a thread seeking some explanations! )