proc sql for date

scb — Tue, 20 Dec 2016 07:50:42 GMT

I have attached a sample dataset.

I can get the date format in date9. in data step.

DATA SAMPLE1;
FORMAT SAMPLE_DT1 DATE9.;
SET SAMPLE;
SAMPLE_DT1 = DATEPART(SAMPLE_DT);
RUN;

May i know how to get similar answer in PROC SQL? I used datepart in SQL but could not get it. Any idea? Thanks.

Re: proc sql for date

Kalind_Patel — Tue, 20 Dec 2016 08:34:25 GMT

Try this one:

PROC SQL;
SELECT * , DATEPART(SAMPLE_DT) AS  SAMPLE_DT1 FORMAT=date9.
FROM sample;
quit;