The SAS Output Delivery System and reporting techniques

PROC IMPORT Numeric Characters

Accepted Solution Solved
Reply
Regular Contributor
Posts: 220
Accepted Solution

PROC IMPORT Numeric Characters

I am using PROC IMPORT to read in a .csv file.  I have a variable PATIENT that is a patient ID number.  My issue is that most of the entries are numbers, but the very last one has an "S" before it suggesting that this patient was screened from the study.  SAS hits that last record thinking that it should be a number, deletes it, and gives me an error message saying that import was unsuccessful.  Is there an option that I am not finding that will adjust the variable type if there are characters in a variable?


Accepted Solutions
Solution
‎08-12-2011 09:55 AM
PROC Star
Posts: 7,364

PROC IMPORT Numeric Characters

I think your easiest solution would be to grab the code that proc import creates and simply modify it so that you are reading the field(s) as characters.

A nice artice on the method can be found at: http://www2.sas.com/proceedings/sugi30/038-30.pdf

The article contains step-by-step instructions for accomplishing such a task.

View solution in original post


All Replies
Solution
‎08-12-2011 09:55 AM
PROC Star
Posts: 7,364

PROC IMPORT Numeric Characters

I think your easiest solution would be to grab the code that proc import creates and simply modify it so that you are reading the field(s) as characters.

A nice artice on the method can be found at: http://www2.sas.com/proceedings/sugi30/038-30.pdf

The article contains step-by-step instructions for accomplishing such a task.

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 2302 views
  • 0 likes
  • 2 in conversation