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