topic Re: Import text file into SAS in SAS Programming

Import text file into SAS

viollete — Mon, 10 Apr 2017 15:49:11 GMT

Hello,

I have a text file like this:

ID birth_date sex deathdate

1 21/02/1954 1

2 02/09/1978 2 03/04/2000

....

I use proc import to import text file into sas; however, cause deathdate in first observation is empty, sas assumes that it is character variable. How could I solve it?

Thank you

Re: Import text file into SAS

lakshmi_74 — Mon, 10 Apr 2017 15:59:39 GMT

After proc import again you can format the deathdate variable in to date format.

Re: Import text file into SAS

RW9 — Mon, 10 Apr 2017 16:00:49 GMT

Look at the log, you will find the datastep import code that proc import created. Copy this to yur program editor window, and change the informat of the date columns t a date format. E.g

input birth_date ddmmyy10.