topic Re: HELP with Dates in SAS Procedures

HELP with Dates

ashleighlentz — Fri, 28 Sep 2018 01:50:41 GMT

How do I create a variable "AGE" when using an external SAS data set via infile statement? The data set already has DOB in it.

This is how far I've gotten...

libname HW3 'c:\users\christopher\desktop\HW3';

data HW3.HW3_F18;

label ID = "Subjects ID"

RACE = "Subjects Race"

DOB = "Subjects Date of Birth"

FEV = "Subjects Fev"

HEIGHT = "Subjects Height"

GENDER = "Subjects Gender"

WEIGHT = "Subjects Weight"

DURATION = "Subjects Duration"

WBCCOUNT = "Subjects WBCCount"

MARITAL = "Subjects Marital Status"

EDUCATION = "Subjects Education";

infile 'c:\users\christopher\desktop\HW3\hw3_f18.dat';

input ID Race $ DOB mmddyy10. FEV Height Gender $ Weight Duration WBCCOUNT Marital $ Education $20.;

run;

proc print data= HW3.HW3_F18;

run;

Re: HELP with Dates

Reeza — Fri, 28 Sep 2018 01:55:42 GMT

How do I create a variable "AGE" when using an external SAS data set via infile statement? The data set already has DOB in it.

It's not any different than if you were doing it with a SAS data set, is there some specific reason you think there is?

You can add the computation after the INPUT statement.

Re: HELP with Dates

VDD — Fri, 28 Sep 2018 09:57:22 GMT

age=int((today()-dob)/365.25);

age=intck('year',dob,today() "continuous" );

added the fourth argument to intck as @PGStats noted .

Re: HELP with Dates

PGStats — Fri, 28 Sep 2018 03:28:54 GMT

Let's not forget the fourth argument when calling intck to get the right result

age = intck('year', dob, today(), "CONTINUOUS");

Re: HELP with Dates

Kurt_Bremser — Fri, 28 Sep 2018 06:55:45 GMT

"external SAS data set" is an oxymoron.

It's either a SAS dataset, which is considered (in SAS speak) "internal", or an external file, which is not a SAS dataset. It is data, but it is not a dataset.

"SAS dataset" denotes a file with the extension .sas7bdat (in earlier days .ssd01 or .sd1) which resides in a directory for which you have a libname assigned.

Since, in your case, the library points to the same location where the external file resides, then after the data step you will have two files in c:\users\christopher\desktop\HW3:

hw3_f18.dat
hw3_f18.sas7bdat

the first is the external file, the second is the SAS dataset.