topic Re: Convert date format yymmddn8 and informat yymmdd6 to format Best12 and informat 12 in SAS Programming

Convert date format yymmddn8 and informat yymmdd6 to format Best12 and informat 12

abdulla — Tue, 08 Oct 2019 19:48:54 GMT

Hi I have date which is in format yymmddn8 and informat yymmdd6. I want to convert them into format Best12 and informat 12. Can anyone help me by giving code for that?

I need to merge file by date but my date in two files are formated differently

Re: Convert date format yymmddn8 and informat yymmdd6 to format Best12 and informat 12

Reeza — Tue, 08 Oct 2019 19:56:18 GMT

Don't start a new question for this, stay with the previous one and post the example data as per my previous instructions please.

Re: Convert date format yymmddn8 and informat yymmdd6 to format Best12 and informat 12

abdulla — Tue, 08 Oct 2019 19:59:40 GMT

Mr Reeza. I am in a hurry to finish my work and seeking for help. I don't really have time now to go through so many things, Could you please give me code so that I can finish my things.

Re: Convert date format yymmddn8 and informat yymmdd6 to format Best12 and informat 12

VDD — Tue, 08 Oct 2019 20:42:09 GMT

@abdulla you could get your answers by trying to look at examples that meet your needs on the community. If you have work to do then why not learn how to do the work rather than commanding other to give you code for your needed results. I don't believe anyone here earns wages for assisting you in obtaining results so that you can learn besides SAS employees.

Re: Convert date format yymmddn8 and informat yymmdd6 to format Best12 and informat 12

ballardw — Tue, 08 Oct 2019 22:00:52 GMT

@abdulla wrote:

Hi I have date which is in format yymmddn8 and informat yymmdd6. I want to convert them into format Best12 and informat 12. Can anyone help me by giving code for that?

I need to merge file by date but my date in two files are formated differently

Provide a date

Provide the numeric value you expect them to be.

And them answer why this is a critical task.

Formats and informats are variable properties. You can change them with Format or Informat statements. But likely you mean to change the actual values but you aren't being explicit enough.