DATA Step, Macro, Functions and more

Date format

Accepted Solution Solved
Reply
Contributor
Posts: 44
Accepted Solution

Date format

hi,

 

As i want to convert the sas date format.i have a masterdateset which variable'date1' attribute like:

Capture.PNG

but  in  my transdataset  the variable'date1' ,its attribute is ;

Capture1.PNG

 i need to conver the transdataset 'date1' format and informat and type to the corresponding masterdataset ' date1' format and informat and type.

 

besides,the date1 are now  display the same in the both dataset,like'09/11/2012' 

just different in the 'format,informat and type'

 

i have no idea about this.

Thanks!


Accepted Solutions
Solution
‎03-18-2017 04:17 AM
Super User
Posts: 17,823

Re: Date format

How are you creating your transaction dataset? Maybe you can fix it in that step. 

 

Or you can convert it using the function below. 

You can also apply the format, but it's not necessary. 

 

input(date1, mmddyy10.)

View solution in original post


All Replies
Solution
‎03-18-2017 04:17 AM
Super User
Posts: 17,823

Re: Date format

How are you creating your transaction dataset? Maybe you can fix it in that step. 

 

Or you can convert it using the function below. 

You can also apply the format, but it's not necessary. 

 

input(date1, mmddyy10.)

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 175 views
  • 0 likes
  • 2 in conversation