264.TEMPLES OF INDIA DATASET ANALYSIS USING PROC PRINT | PROC CONTENTS | PROC SORT | PROC FREQ | PROC MEANS | PROC SQL | PROC TABULATE | PROC REPORT | PROC TRANSPOSE | PROC FORMAT | PROC RANK | PROC SGPLOT | MACROS

on
0

78.JULIAN DATES IN SAS

on

                         JULIAN DATES IN SAS


Function: DATEJUL

Purpose: To convert a Julian date into a SAS date.

Syntax: DATEJUL(jul-date)

      -->jul-date is a numerical value representing the Julian date in the form dddyy or dddyyyy.


Function: JULDATE

Purpose: To convert a SAS date into a Julian date.

Syntax: JULDATE(date)

      -->date is a SAS date.


Function: JULDATE7

Purpose: To convert a SAS date into seven-digit Julian date.

Syntax: JULDATE7(date)

      -->date is a SAS date.


CODE:

***Note: option YEARCUTOFF set to 1920;

options yearcutoff = 1920;

data julian;

input Date : date9. Jdate;

Jdate_to_sas = datejul(Jdate);

Sas_to_Jdate = juldate(Date);

Sas_to_jdate7 = juldate7(Date);

format Date Jdate_to_sas mmddyy10.;

datalines;

01JAN1960 2003365

15MAY1901 1905001

21OCT1946 5001

;

title "Listing of Data Set JULIAN";

proc print data=julian noobs;

var Date Sas_to_jdate Sas_to_jdate7 Jdate Jdate_to_sas;

run;


Explanation:

It is important to realize that Julian dates without four-digit years will be converted to SAS

dates, based on the value of the YEARCUTOFF system option. To avoid any problems, it is

best to use seven-digit Julian dates.


OUTPUT:

                                                   Listing of Data Set JULIAN


Date Sas_to_Jdate Sas_to_jdate7 Jdate Jdate_to_sas
01/01/1960 60001 1960001 2003365 12/31/2003
05/15/1901 1901135 1901135 1905001 01/01/1905
10/21/1946 46294 1946294 5001 01/01/2005

TRY THIS AND COMMENT...

-->PLEASE READ AND COMMENT THE BLOG...

--PLEASE FOLLOW THE BLOG FOR MORE UPDATES...

--FOLLOW US IN FACEBOOK SASALL4YOU AND JOIN ...

--JOIN US IN FACEBOOK AND TELEGRAM  CHANNEL FOR MORE UPDATES

   CLICK HERE: https://t.me/SasAll4You

Comments

Post a Comment