> If they are formatted dates, just change the format.
> If they are character strings, there are several
> character functions that will do it; SUBSTR and ||
> is sort of brute force, but will work.
Brute Force - Love it.
I have to put in a good word for this book that is well-worn along with my SAS course books I've collected... It's available in the SAS bookstore and other places.
The Essential Guide to SAS Dates and Times
By: Derek Morgan
Publisher: SAS Press
Copyright Date: June 2006
Why does SAS use January 1, 1960, as its arbitrary reference date? How do you convert a value such as 27 January 2003 into SAS dates? You'll find the answers to these questions and much more in Derek Morgan's Essential Guide to SAS Dates and Times, which makes it easy to understand how to use and manipulate dates, times, and datetimes in SAS. Novice-to-intermediate users will find the clear, task-focused examples and explanations of formats and functions invaluable; experienced users will appreciate discussions of topics such as intervals and international date and time formats. Included is a bonus "Quick Reference Guide" listing all the formats (with examples) on one handy page.
format M $2. Y $4.;
M=substr(var, 1,2); *** this will give you the 99 before the slash ***;
Y=substr(var, 4,4); *** this will give you the 9999 after the slash ***;
newdate=(M||Y); *** this will concantenate the two variables to give you 999999 ***;