SAS Comparing a Packed decimal date and normal date

balaji.edu · New User Joined: 09 Aug 2008 Posts: 7 Location: Hyderabad

Hi i am trying to read the date from a parmcard and compare it with date on the input file.

reading date from Parm card and converting it in 6 digit date.Parm card date is yyyymmdd:

Robert Sample · Posted: Thu Mar 12, 2009 9:06 pm

Why are you using the COMPRESS function? You don't need the statement with the COMPRESS function -- take it out and the code should run fine.

Post a few ACCTDATE and CYCLEDT values so we can see what they are, as printed by SAS.

balaji.edu · New User Joined: 09 Aug 2008 Posts: 7 Location: Hyderabad

Input parmcard

Robert Sample · Posted: Thu Mar 12, 2009 9:35 pm

1. SAS dates are always stored internally as the number of days since January 1, 1960. A negative sign means days before that date, positive means days after.

2. -18577 in SAS means February 20, 1909. It does not mean February 20, 2009.

3. If you are comparing February 20, 1909 to February 20, 2009 they are not going to be equal.

4. Uninitialized values in SAS are usually important -- in this case (as in most cases) it means your code is not correct.

5. There is a SAS option called YEARCUTOFF that you might want to verify (PROC OPTIONS) to see how it is set.

6. Your code needs more interaction between the DATA steps. I would expect to see something like this in your code and are not seeing it:

balaji.edu · New User Joined: 09 Aug 2008 Posts: 7 Location: Hyderabad

this is simplified SAS to i eam executing to print ans see the two dates which i am was comparing .I was retaing the varable in the begining of the SAS.

DATA _NULL_;
RETAIN CYCLEDT 0
CYCLEYY 0
CYCLEMM 0
CYCLEDD 0;

INFILE DATECARD;

IF _N_ = 1 THEN DO;
INPUT
@1 CYCLEDT 8.
@3 CYCLEYY 2.
@5 CYCLEMM 2.
@7 CYCLEDD 2.;
IF CYCLEDT = . THEN ABORT ABEND 16;
END;

DATA PROD1;
RETAIN CYCLEDT;
INFILE INLAWS;
INPUT @125 ODS_I4_DDT PD4.0;

ACCTDATE = INPUT(PUT(ODS_I4_DDT,Z6.),YYMMDD6.);
ACCTDATE = COMPRESS(PUT(ACCTDATE,YYMMDD8.),'-') ;

CYCLEDT2=MDY(CYCLEMM,CYCLEDD,CYCLEYY);
FORMAT CYCLEDT2 YYMMDD6.;
CYCLEDT2 = COMPRESS(PUT(CYCLEDT2,YYMMDD8.),'-') ;
PROC PRINT DATA=PROD1;

as your mail suggest that the year s wrongly ca;calcuated as 1909 instaetd of 2009 can you please explain what does the compress funstion do to changed is back ot 090220 form.

Robert Sample · Posted: Thu Mar 12, 2009 10:43 pm

The COMPRESS is not required because you are putting the date as YYMMDD8. (which includes dashes); you would better be served by using YYMMDDN8. which puts out the year as 4 digits but has no dashes in the date.

Try this:

balaji.edu · New User Joined: 09 Aug 2008 Posts: 7 Location: Hyderabad

The follwin g code i givinig a SA error of
NOTE: The SAS System stopped processing this step because of errorThis may cause NOTE: No observations in data set
NOTE: SAS set option OBS=0 and will continue to check statements.
When this step was stopped there were 0 observations and 49 variables.

DATA RUNDATE;
INFILE DATECARD;

INPUT
@1 CYCLEDT 8.
@3 CYCLEYY 2.
@5 CYCLEMM 2.
@7 CYCLEDD 2.;
IF CYCLEDT = . THEN ABORT ABEND 16;

IF _N_ = 1 THEN SET RUNDATE;
RETAIN CYCLEDT;

CYCLEDT2=MDY(CYCLEMM,CYCLEDD,CYCLEYY);
FORMAT CYCLEDT2 YYMMDD6.;

Anuj Dhawan · Posted: Fri Mar 13, 2009 2:20 pm

Hi,

Can you notice the difference the way code is posted by you and Robert. Please use BBcode when You post some code/error, that's rather readable.

Robert Sample · Posted: Fri Mar 13, 2009 4:52 pm

I'm not sure if you're deliberately ignoring what I'm posting or not, but one more time ... based on your earlier posted code, here's what your code should look like: