topic Re: can anyone solve this problem? in SAS Programming

Reading a date value from raw data - DD-MM-YYYY

learner3 — Wed, 04 May 2022 13:31:24 GMT

data kvb;

input date  withdraw balance;
datalines;

01-04-2022   .     671.00
08-04-2022  36.00 635.00
11-04-2022 72.00  563.00
16-04-2022 20.00  543.00
27-04-2022  30.00 513.00
27-04-2022  10.00 503.00
29-04-2022 75.00  428.00
29-04-2022  11.00 417.00
30-04-2022     .   517.0
;
run;

Re: can anyone solve this problem?

LinusH — Wed, 04 May 2022 07:13:54 GMT

You need to supply an informat to your date field.

Re: can anyone solve this problem?

learner3 — Wed, 04 May 2022 07:18:43 GMT

i tried

data kvb;
input date withdraw balance;
informat date ddmmyy10.;
datalines;

01-04-2022 . 671.00
08-04-2022 36.00 635.00
11-04-2022 72.00 563.00
16-04-2022 20.00 543.00
27-04-2022 30.00 513.00
27-04-2022 10.00 503.00
29-04-2022 75.00 428.00
29-04-2022 11.00 417.00
30-04-2022 . 517.0
;
run;

Re: can anyone solve this problem?

learner3 — Wed, 04 May 2022 07:21:46 GMT

in output i got this
1 22736 . 671
2 22743 36 635
3 22746 72 563
4 22751 20 543
5 22762 30 513
6 22762 10 503
7 22764 75 428
8 22764 11 417
9 22765 . 517

Re: can anyone solve this problem?

andreas_lds — Wed, 04 May 2022 07:34:31 GMT

@learner3 wrote:
in output i got this
1 22736 . 671
2 22743 36 635
3 22746 72 563
4 22751 20 543
5 22762 30 513
6 22762 10 503
7 22764 75 428
8 22764 11 417
9 22765 . 517

Exactly as expected, if you don't attach a format to a variable that could be a date, the number of days since 01Jan1960 is displayed.

Reading the docs about sas-dates is recommended before working with sas.

Re: can anyone solve this problem?

ChrisHemedinger — Wed, 04 May 2022 11:05:43 GMT

INFORMAT tells SAS how to interpret/read a raw value as it appears in the input source. FORMAT tells SAS how to display a raw value for appearance purposes. In this program you need both. I used DDMMYY10 here to match the input layout, but you could use DATE9. (ex: 08APR2022) if you prefer, as many people do with SAS.

data kvb; input date withdraw balance; informat date ddmmyy10.; format date ddmmyy10.; datalines; 01-04-2022 . 671.00 08-04-2022 36.00 635.00 11-04-2022 72.00 563.00 16-04-2022 20.00 543.00 27-04-2022 30.00 513.00 27-04-2022 10.00 503.00 29-04-2022 75.00 428.00 29-04-2022 11.00 417.00 30-04-2022 . 517.0 ; run;