On Mon, 30 Apr 2007 22:27:43 -0500, Ryan McNeill <RMcNeill@OKLAHOMAN.COM>
> I've got a problem I can't seem to solve using the SAS docs or
>Little SAS book. I need to concatenate three number fields. I know you
>use the || on a character string.
> Essentially, I have separate fields for years, months and days ---
>and I need to be able to deal with them. Of course, all this is
>contingent to minds smarter than me telling me I don't have to create a
>new column to figure out, say, an age with those three fields.
have a look at the examples in on-line help for the function
For concatenation, see the function
string= cats( 2007, 4, 30 );
(You might not like the result having only one character for the month)
To represent a numeric sas-date in yyyymmdd format, use function
string = put( date_var, yynnddN8. ) ;
To convert 3 numbers holding year, month and day into a sas date,
use function mdy() like:
date_var = mdy( monthvar, dayvar, yearvar );
But I think your best advice is to read some more books, and a lot
of on-line doc, and when you have any spare time, lurk on sas-L or
read through the SAS-L archives, which would have revealed all the
answers above, faster than I can type them !