Help using Base SAS procedures

Proc Format : Picture Statement : Format/Informat of DateType Column

Reply
N/A
Posts: 0

Proc Format : Picture Statement : Format/Informat of DateType Column

Hi ,

I had to create new date format like YYYYMMDDHHMISS . so i created in the following way.

proc format;
picture yyyymmddhhmiss
other = '%Y%0m%0d %0H:%0M:%0S' (datatype=datetime);
run;

I got successed to create a New date format. but now i also have to create informat YYYYMMDDHHMISS.

but some one told me using picture stament i can't create INFORMAT.

so my first question to you that
1) while creating DI studio Job, Informat play a important role?. If No, then Can we put Informat of Date Column as NONE?.If I put it as NONE then in future will it not create problem while using this data set with another one?.
2)if YES, then How can i create a New date Format/Informat using Value / Invalue statment.
Ask a Question
Discussion stats
  • 0 replies
  • 104 views
  • 0 likes
  • 1 in conversation