topic Re: Concatenation Using the DATA Step: multiple WHERE expressions that are joined by logical operato in SAS Data Science

Concatenation Using the DATA Step: multiple WHERE expressions that are joined by logical operator

saviour — Tue, 31 Jan 2023 19:27:00 GMT

Hello all,

Need help with this class assignment for students which does not work properly.

Here is the SAS code:

/* example 1 */

data merge1;
input ID $ SEX $ BDATE SALARY NAME $  ;
informat BDATE mmddyy8. ;
format BDATE mmddyy8. ;
datalines;
1 M 10/21/46 70000 ivan
2 F 11/01/55 68000 judy
7 M 01/27/59 47000 ralph
;
run;
data merge2;
input ID $ SEX $ BDATE SALARY TAXRATE WITHHOLD NAME $ ;
informat BDATE mmddyy8. ;
format BDATE mmddyy8. ;
datalines;
3 F 01/01/33 78000 .36 23000 zoe
5 M 03/07/29 37000 .25 9000 marco
;
run;
data merge3;
input ID $ SEX $ BDATE SALARY HEIGHT WEIGHT NAME $ ;
informat BDATE mmddyy8. ;
format BDATE mmddyy8. ;
datalines;
4 M 10/23/49 65000 68 158 roger
6 F 07/04/65 55000 74 202 clara
;
run;

data all (keep= ID BDATE SALARY NAME rename=(NAME=NAME1)) ;
set merge1 merge2 merge3 ;
where BDATE <= 01/01/60 and SALARY GE 50000 ; 
format BDATE mmddyy8. ;
run;
proc print ;
run;

This is our output:

The problem is that it does not select ID 3 zoe from the dataset merge2.

Any ideas?

Best,

Alen

Re: Concatenation Using the DATA Step: multiple WHERE expressions that are joined by logical operato

Kurt_Bremser — Tue, 31 Jan 2023 21:08:34 GMT

What is the value of your YEARCUTOFF system option?

2-digit year values are dangerous and must not be used, period.

Re: Concatenation Using the DATA Step: multiple WHERE expressions that are joined by logical operato

saviour — Tue, 31 Jan 2023 21:19:40 GMT

Dear Kurt,

Thank you.

Best,

Alen

Re: Concatenation Using the DATA Step: multiple WHERE expressions that are joined by logical operato

saviour — Tue, 31 Jan 2023 21:24:34 GMT

Dear Kurt,

The value of your YEARCUTOFF system option was 1940.

That was the problem.

Thank you,

Alen

Re: Concatenation Using the DATA Step: multiple WHERE expressions that are joined by logical operato

Kurt_Bremser — Tue, 31 Jan 2023 21:30:47 GMT

No, the problem is the use of 2-digit years. After Y2K (but in fact, long before that), this should be a given.

I am working very hard to restrain myself from using the words that came to my mind, because then a moderator would have to delete my post for vulgar language.

Re: Concatenation Using the DATA Step: multiple WHERE expressions that are joined by logical operato

Tom — Tue, 31 Jan 2023 23:13:50 GMT

Using the value 0.0166666... instead of zero to represent the date 01JAN1960 was also a very strange choice.

789  data _null_;
790    xx = 1/1/60 ;
791    put xx= xx= date9. ;
792  run;

xx=0.0166666667 xx=01JAN1960