Change data format in dataset

[Gieorgie]

Hi everyone, I have a problem. I wanted to change the date format from as shown in the picture.

to this.

However, after using the format function, I get something like this. Why ? how to fix it

my code:

data pap_wart;
set bmd.pap_wart_spr_202203;
keep kod_isin;
keep WBIL_BRUTTO_PLN;
keep WYCENA_ROZNICA_PLN;
keep data_emisji;
keep data_zap;
format data_zap yymmdd10.;
run;

[japelin · Accepted solution]

how about this code.

data pap_wart;
  set bmd.pap_wart_spr_202203;
  keep kod_isin
       WBIL_BRUTTO_PLN
       WYCENA_ROZNICA_PLN
       data_emisji
       data_zap;
  data_zap=datepart(data_zap); // <-insert
  format data_zap yymmdd10.;
run;

[Kurt_Bremser]

Datetimes and times are counts of seconds in SAS, while dates are counts of days; so datetime = date * 86400.

Always keep this in mind when working with such values.

The functions you need for the conversions are

• DATEPART - extracts the date from a datetime
• TIMEPART - extracts the time from a datetime
• DHMS - builds a datetime from a date, hours, minutes and seconds; to build a datetime from a date and a time, use DHMS(date,0,0,time)