07-23-2015 03:21 PM
Here is one way to do it, I'm not familiar with fedsql but this will work for you:
create table want as
select *,input(put(num_date,8.),YYMMDD8.) as date format = yymmddn10.
07-23-2015 03:33 PM
Thank you for the response. I am aware of how to do the conversion in proc sql, however I was asking about proc fedsql. As part of SAS 9.4 proc fedsql is new and has some new functions that proc sql does not have, but it also has some disadvantages as input is not an available function.
07-24-2015 02:42 AM
fedsql has a quite different goal. That one has those changes to get more aligned in what RDBMS systems are doing. (different data types).
As your data conversion will be normally doen by SAS/ACCESS interfaces the manual numeric/string conversion is a non-question.
Temporal manipulations is added in SQL:2011 https://en.wikipedia.org/wiki/SQL:2011 SAS is not using that instead kept on sql:99