topic Re: date format in SAS Procedures

date format

BrahmanandaRao — Sat, 29 Feb 2020 13:39:39 GMT

proc sql;
create table cust_orders(ord_no num(8),purch_amt num(10,2),ord_date num format=yymmdd10.,customer_id num(6),salesman_id num(6));

insert into cust_orders values (70001   ,   150.5     ,  '2012oct05'd , 3005  , 5002);
insert into cust_orders values (70009   ,   270.65    ,  '2012sep10'd , 3001  , 5005);
insert into cust_orders values (70002   ,   65.26     ,  '2012oct05'd , 3002  , 5001);
insert into cust_orders values (70004   ,   110.5     ,  '2012aug17'd , 3009  , 5003);

quit;

Re: date format

ed_sas_member — Sat, 29 Feb 2020 14:01:53 GMT

Hi @BrahmanandaRao

The date should be entered like this: 'DDmonYYYY'd

e.g.

'05oct2012'd

You can also simplify you code as follows (by using 1 INSERT INTO statement)

proc sql;
	create table cust_orders(ord_no num,purch_amt num, ord_date num format=yymmdd10.,customer_id num,salesman_id num);

	insert into cust_orders
		values (70001   ,   150.5     ,  '05oct2012'd , 3005  , 5002)
		values (70009   ,   270.65    ,  '10sep2012'd , 3001  , 5005)
		values (70002   ,   65.26     ,  '05oct2012'd , 3002  , 5001)
		values (70004   ,   110.5     ,  '17aug2012'd , 3009  , 5003);

quit;

NB: PROC SQL enables you to specify a column width for character columns but not for numeric columns.

Re: date format

ballardw — Mon, 02 Mar 2020 17:35:03 GMT

SAS date literals must be in the appearance of something displayed using the SAS DATE. format.

Examples:

Date7.: 'ddMONyy'd

Date9.: 'ddMONyyyy'd

Date11.: 'dd-MON-yyyy'd

Re: date format

Tom — Mon, 02 Mar 2020 20:39:55 GMT

@ballardw wrote:

SAS date literals must be in the appearance of something displayed using the SAS DATE. format.

Examples:

Date7.: 'ddMONyy'd

Date9.: 'ddMONyyyy'd

Date11.: 'dd-MON-yyyy'd

Or more accurately something that the DATE **informat** can read.