Desktop productivity for business analysts and programmers

PROC IMPORT variable

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 94
Accepted Solution

PROC IMPORT variable

Below is my code.

In file_a, there are 99 columnswith over 100K rows.

There is one column in this file that has either numeric or alpha data (not alpha-numeric) for each entry.  The format for this column in DATAROW=2 is numeric.  When I run this file, SAS thinks the column is numeric.  If it comes to a cell with ALPHA, it returns "." for missing.

How can I fix the code - without having to list EVERY INFORMAT, FORMAT and INPUT for all 99 variables?

Thanks!

********************************

PROC IMPORT OUT=LIBNAME.file_b

DATAFILE = 'file_a'

DBMS=CSV replace;

GETNAME=YES;

DATAROW=2;

RUN;


Accepted Solutions
Solution
‎01-15-2013 09:11 AM
Trusted Advisor
Posts: 2,114

Re: PROC IMPORT variable

You also might be able to address this using the GUESSINGROWS statement in PROC IMPORT.

View solution in original post


All Replies
Super User
Posts: 19,192

Re: PROC IMPORT variable

I think it might be DBTYPE option, see the documentation...

SAS/ACCESS(R) 9.2 Interface to PC Files: Reference, Second Edition

Solution
‎01-15-2013 09:11 AM
Trusted Advisor
Posts: 2,114

Re: PROC IMPORT variable

You also might be able to address this using the GUESSINGROWS statement in PROC IMPORT.

Frequent Contributor
Posts: 94

Re: PROC IMPORT variable

I didn't know how to use DBTYPE with PROC IMPORT.

I tried GUESSINGROWS with PROC IMPORT.  The results look like they match the input file - # of rows in dataset matches .csv file.  However, I got an error:

 

NOTE: Invalid data for Glob_Function_Id in line 94102 839-842.

 

Errors detected in submitted DATA step. Examine log.

108956 rows created in libname.file_b from file_a.csv.

 

ERROR: Import unsuccessful. See SAS Log for details.

I got many of the NOTE in the log.  I checked the line and everything looks good.  Any thoughts as to the error?  What do the numbers 839-842 mean?

Thanks!!!

Trusted Advisor
Posts: 2,114

Re: PROC IMPORT variable

839-842 are the columns for the variable that SAS had trouble reading.

Frequent Contributor
Posts: 94

Re: PROC IMPORT variable

I thought they refer to columns, but my file has 99 columns (variables).  So that confused me.

Anyway, I checked the entire row and everything matched with the original file.  So I am not sure what the error is.

🔒 This topic is solved and locked.

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

Discussion stats
  • 5 replies
  • 818 views
  • 0 likes
  • 3 in conversation