topic Re: Date: Converting a character variable into numeric format in SAS Programming

Date: Converting a character variable into numeric format

RRzio11 — Tue, 11 Aug 2020 05:14:00 GMT

Hello,

I am needing to convert the "DATEINT" variable into a numeric, date format (mmddyy10.) however I am having trouble doing so.

DATA WAVE5_8LD;
SET WAVE5_8L;
NDATEINT= INPUT(DATEINT,DDMMYY10.);
FORMAT DATEINT MMDDYY10.;
RUN;

I want to be able to format "DATEINT" to match how variable "dod" is so that I can perform an analysis on them. This is from a pre-existing dataset.

Re: Date: Converting a character variable into numeric format

andreas_lds — Tue, 11 Aug 2020 05:48:41 GMT

It seems that you are using the wrong informat, ddmmyy requires the month to be a number from 1 to 12, not the abbreviated month name. Unfortunately you have not posted the data in usable form, so i won't provide code. Maybe reading those dates is possible with date9-informat after applying compress-function to dateint removing the hyphens.

Re: Date: Converting a character variable into numeric format

Kurt_Bremser — Tue, 11 Aug 2020 06:03:51 GMT

You can apply the DATE11. format directly:

data test;
dateint = "11-Aug-2020";
datenum = input(dateint,date11.);
format datenum yymmdd10.;
run;

Re: Date: Converting a character variable into numeric format

RRzio11 — Tue, 11 Aug 2020 06:15:21 GMT

attached is my dataset

Re: Date: Converting a character variable into numeric format

Kurt_Bremser — Tue, 11 Aug 2020 06:26:21 GMT

Read like this:

data test;
infile '/folders/myfolders/WAVE5_8L.csv' dlm=',' dsd firstobs=2;
input
  q_no $
  isdead
  agedie
  dod :mmddyy10.
  YSMOKE
  wave
  DATEINT :date11.
  UM
  UG
  TOTMMSE
  TOTADL
  sfrailcatb
  sex
  nfrac
  marstat
  ll
  lcancr
  khyper
  jstrok
  icardi
  cesdtot
  bmi
  age
  mdiab
;
format dod dateint yymmdd10.;
run;

Re: Date: Converting a character variable into numeric format

RRzio11 — Tue, 11 Aug 2020 06:38:54 GMT

Thank you so much! could you help me calculate the difference between "Dateint" and "DOD" in days?

Re: Date: Converting a character variable into numeric format

Kurt_Bremser — Tue, 11 Aug 2020 07:27:19 GMT

SAS dates are counts of days, so you only need a simple subtraction.