topic Re: How to insert dates with proc sql insert into? in SAS Procedures

How to insert dates with proc sql insert into?

Datino — Tue, 17 Jan 2017 17:09:09 GMT

Greetings,

I'm trying to manually create some rows in a table, with the insert to statement, coded looks like this:

proc sql;
insert into lib.table values(
'OPEN',
10001,
10041,
10004,
'13',
'ACT');

quit;

My question is, how do I insert a date such as (01JAN2017) so that it is a valid SAS date?

Thanks in advance.

Re: How to insert dates with proc sql insert into?

Shmuel — Tue, 17 Jan 2017 17:49:36 GMT

Try next code:

proc sql;
insert into lib.table values(
'OPEN',
10001,
10041,
10004,
'13',
'ACT',

'01jan2017'd

);

quit;

Re: How to insert dates with proc sql insert into?

Datino — Tue, 17 Jan 2017 19:14:25 GMT

Thank you for your help, Shmuel, the answer you provided is correct.

However, it made me figure out that the column I'm trying to fill is actually datetime with a format of DATETIME22.3

I tried adjusting your solution to '01jan2017'dttm but it did not work.

Re: How to insert dates with proc sql insert into?

Shmuel — Tue, 17 Jan 2017 19:19:32 GMT

for datetime use '01jan2017:00:00:00'dt

Re: How to insert dates with proc sql insert into?

Datino — Tue, 17 Jan 2017 20:32:14 GMT

Thank you!

Re: How to insert dates with proc sql insert into?

ballardw — Tue, 17 Jan 2017 20:36:03 GMT

Please don't be a lazy programmer and name datetime values as dates. When crossing the boundary to SAS the values are quite different and functions/actions that will work on DATES will either fail or create very unexpected results when used with DATETIMES (and vice versa).

Re: How to insert dates with proc sql insert into?

Shmuel — Tue, 17 Jan 2017 20:41:13 GMT

@Datino - if you decide to convert datetime to date use next code to do it:

date_var = datepart(datetime_var);

format date_var date9.;