05-30-2013 12:05 PM
You need to do something pretentiously to the variable, for example:
format dt date9.;
create table want as
select dt+0 as dt from test;quit;
If it is char, depending on the contents, you can choose to use compress(), trim(), cats() etc. I prefer to using substr(var,1), seems more robust to me.
Need further help from the community? Please ask a new question.