topic Re: How to read date in this format in SAS Programming

How to read date in this format

jwill731 — Sun, 21 Feb 2016 22:38:37 GMT

Hi Everyone,

I'm have a text file with date of birth entered in the format of mm/yyyy in numbers. So for example 5/1985.

When I try to tell sas to read the data with informat - DOB monyy6. it says invalid data for DOB. I'm guessing that it's because it's not a 3 letter representation of a month.

What would be the other informat because I tried mmyy6. and that doesn't exist.

Here's my code:

data temp;
	infile 'C:\Users\wjeon\Desktop\Masters\Data to William\PEI data/PEItxt.txt' delimiter='09'x dsd missover firstobs=2;
	length Patient_ID $20;
	informat Patient_ID $20. Gender 1. DOB mmyy10. Postal_Code $3. Region 1. Date_of_Service mmddyy10. Facility_type_id 2. ICD_9 $4. Specialty 3. Paid_amt best32. Approved_amt best32. Fee_Code $4.;
	input Patient_ID Gender DOB Postal_Code Region Date_of_Service Facility_type_id ICD_9 Specialty Paid_amt Approved_amt Fee_Code;
run;

I also tried to make it read it as characters so that i can try to convert it later on but it still says invalid

Thank you in advance.

Re: How to read date in this format

mohamed_zaki — Tue, 23 Feb 2016 00:24:22 GMT

data test;
input DOB $ ;
dt = input('01/'!!DOB,ddmmyy10.);
format dt mmyys. ;
datalines;
3/2011
;
run;

Re: How to read date in this format

Reeza — Mon, 22 Feb 2016 01:39:03 GMT

Use the ANYDTDTE. informat.

data want;
informat dob anydtdte.;
format dob date9.;
input dob;
cards;
1/2016
5/2011
12/2010
;
run;

Re: How to read date in this format

Peter_C — Tue, 23 Feb 2016 07:37:18 GMT

Let SAS do the informat searching for you!
See the paper on the idea
VFORMAT Lets SAS® Do the Format Searching
http://support.sas.com/resources/papers/proceedings14/1744-2014.pdf