Date:         Mon, 24 Nov 2003 23:17:33 +0000
Reply-To:     SAS_L@LISTSERV.EDU.AU
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Laughing Beggar <laughing_beggar@HOTMAIL.COM>
Subject:      Query - missing leading zeroes
Content-Type: text/plain; format=flowed

Hi all;
My leading zeroes are missing !
Heres a sample of what I'm attemptiing;
*set the financial year;
%LET DATE=0001; *This means the 2000 to 2001 financial year;
*read in the data from the isc.isc0001 dataset;
data cc_cases;
    set isc.isc&DATE;
run;

*Age standardisation calculations here;
*create a dataset with the year, sex, astr in it;
data cc_asro2;
   set ozsum;
cc_astr=ozexpt*1000/ozpopt;
year=&DATE;
run;

*Since this is one of 4 runs (one for each year), I append the calculated
rate to the cc_asroz data set.

proc append base=cc_asroz data=cc_asro2;
run;

But when I print out the cc_asroz dataset
(proc sort  data=cc_asroz;
   by sex year;
run;

proc print data=cc_asroz;
   var year sex cc_astr;
run;

)
at the end it looks like this (followed by the female section);

                          Obs    year     sex      cc_astr

                           1          1    Male       0.14647
                           2      102    Male       0.13334
                           3     9899    Male       0.12770
                           4     9900    Male       0.12189

ie all the leading zeroes are gone and the order is not what I want (which
messes up my attempts to graph the results).

Any ideas, oh knowledgable ones ?

Cheers
laughing_beggar



"The beggar laughs in the face of the thief"

_________________________________________________________________
Hot chart ringtones and polyphonics. Go to
http://ninemsn.com.au/mobilemania/default.asp