topic Re: Change data format in dataset in SAS Programming

Change data format in dataset

Gieorgie — Wed, 18 May 2022 08:36:32 GMT

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;

Re: Change data format in dataset

japelin — Wed, 18 May 2022 08:48:54 GMT

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;

Re: Change data format in dataset

Kurt_Bremser — Wed, 18 May 2022 08:57:49 GMT

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)