Date:         Fri, 2 May 2003 04:54:48 -0700
Reply-To:     Rune Runnestoe <rune@FASTLANE.NO>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Rune Runnestoe <rune@FASTLANE.NO>
Organization: http://groups.google.com/
Subject:      Formatting the output
Content-Type: text/plain; charset=ISO-8859-1

Hello,

The columns Year and SeqNo are both numeric. When I run the following code...

proc sql;
select SeqNo, Year
from Mytable
order by Year, SeqNo;

...the output shows like this:

SeqNo    Year
---------------
232      2003
233      2003

But I want it to look like this:

Missing Lopenr
---------------
000232/2003
000233/2003


How do I code that ? How do I fill up with leading zeros in the SeqNo ?

Regards
Rune Runnestoe