<div>
Do you have a datetime as a character?<br />
<br />
data new; set old;<br />
date_time &nbsp;= input(char_date_time, datetime18.);<br />
date= datepart(date_time);<br />
format date &nbsp;yymmdd10.;<br />
run;<br />

</div>


Do you have a datetime as a character?

data new; set old;
date_time  = input(char_date_time, datetime18.);
date= datepart(date_time);
format date  yymmdd10.;
run;


<div>
<div class="content wysiwyg-content">
i have date which is Chracter 10 in format 20101107155504 i want it to be converted to YYMMDD10.
</div>
</div>


i have date which is Chracter 10 in format 20101107155504 i want it to be converted to YYMMDD10.

change chracter to yymmdd10.

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.