topic Re: What's function format used for? in New SAS User

What's function format used for?

Qisheng-Xia — Tue, 28 Nov 2023 14:44:37 GMT

/* * Specify the libname */

libname walmart '/folders/myfolders/Walmart';

/* 1. Create two datasets data_a and data_b based on slide 4. */

data walmart.data_a;
input order_id order_time MMDDYY10.;
format order_time MMDDYY10.;
cards;
1001 10/5/2017
1002 10/5/2017
1004 10/7/2017
1003 10/6/2017
1005 10/8/2017
;
run;

Re: What's function format used for?

PaigeMiller — Tue, 28 Nov 2023 14:53:35 GMT

SAS dates are stored internally as the number of days since 01JAN1960, so for example 21915 is 01JAN2020. The FORMAT statement allows 21915 to be shown to humans as 01JAN2020, which humans can understand. Humans cannot understand 21915 as a date, although SAS does understand it as a date.

Try the code without the FORMAT statement to see what happens.

Re: What's function format used for?

Kurt_Bremser — Tue, 28 Nov 2023 17:37:37 GMT

This is not a function, it is the FORMAT Statement

A format in SAS is used to display values in a certain manner; in your particular case, the format displays the internal value of a SAS date (the count of days starting at 1960-01-01) in a human-readable manner.