topic Re: sas homework in SAS Programming

sas homework

mary987 — Sat, 23 Oct 2021 11:01:06 GMT

FOR THE FOLLWING DATA SET AS AN EXAMPLE 001 01/12/85 002 12/24/96 003 11/24/96 004 9/11/07 005 7/1/08 006 01/12/85 007 12/24/16 008 11/24/06 009 9/11/17 010 7/1/18 ; *CALCULATE YEARS UNTIL 31th of DEC 2020 THEN FIND FREQUENCY FOR:; * LESS THAN 5 YEARS; * BETWEEN 5 AND 10 YEARS; * 10 YEARS AND ABOVE;

I write this syntax but I receive error : no datalines or infile

DATA Example;
DOS="31DEC20"d;
NDAYS=INTCK("DAY",DOS,TODAY());
NWEEKS=INTCK("WEEK",DOS,TODAY());
MONTHS=MONTH(DOS);
YEAR=YEAR (DOS);
diff=yrdif (DOS,DOB);
input @1 ID $3.
@5 DOB mmddyy10.
datalines;
001 01/12/85
002 12/24/96
003 11/24/96
004 9/11/07
005 7/1/08
006 01/12/85
007 12/24/16
008 11/24/06
009 9/11/17
010 7/1/18
;

RUN;
PROC PRINT DATA=Example;
FORMAT DOS DATE9.;
RUN;

Re: sas homework

Rick_SAS — Sat, 23 Oct 2021 11:14:49 GMT

Put a semicolon at the end of the INPUT statement

input @1 ID $3. @5 DOB mmddyy10.;

Re: sas homework

mary987 — Sat, 23 Oct 2021 11:19:52 GMT

tnx.

i want to find diff from 31DEC20 this date and the dates that are in datalines, I run this code for diff it shows period (.) for all observations.

Re: sas homework

Rick_SAS — Sat, 23 Oct 2021 11:23:48 GMT

Yes. The order of statements matter. Ask yourself what information has been read when you compute the DIFF variable. Are all the values that you need available at that time? Or perhaps you need to move that statement somewhere else in your program? Good luck!

Re: sas homework

Rick_SAS — Sat, 23 Oct 2021 11:24:32 GMT

BTW, the period (.) means "missing value".

Re: sas homework

mary987 — Sat, 23 Oct 2021 11:30:30 GMT

yes, missing values. I do not put correct syntax for diff,

Re: sas homework

Kurt_Bremser — Sat, 23 Oct 2021 11:47:09 GMT

Apart from the order of variables in the YRDIF function (which will cause negative values), the assignment statement is OK, but its place in the code is not. You need to put it where the value for DOB has been read by the INPUT statement.