Subscribe to DSC Newsletter

Error on proc import

Hi all,

I am trying to import a csv file on sas using proc import.

 

the file imports successfuly but wit an error due to data formart of a few variables.

 

how do i make my import process ignore this data format issue as am scheduling a flow process which cannot proceed because of this error.

 

N/B the import is still successful with the error but i need to get rid of the error for my process to continue flowing.

 

thanks in advance.

Views: 846

Replies to This Discussion

Permalink Reply by Ajay on June 21, 2012 at 2:14pm

Do you have characters in a mostly numeric field?  If so, write out the import like so:

data a;
infile "..." dsd delimiter=',' firstobs=2;
input
id :??
var1 :??
var2 :??

;

Permalink Reply by Mark Nasila (PhD) on June 21, 2012 at 11:58pm

Hey Ajay,

thank you very much.

it is working now.

regards

Permalink Reply by timothy vogel on June 21, 2012 at 10:24pm

use the proc import "save program" function from the GUI menu to save the SAS code it generates for you and then edit the "proc import" input statement directly. add specific informats for every variable;

var1:$mmddyy10 var2: $char20.

etc.

look into adding the following "infile" options as appropriate / dsd pad missing firstobs missover scanover 

then resubmit.

good luck.  TV

Permalink Reply by Mark Nasila (PhD) on June 21, 2012 at 11:59pm

Hey Timothy,

used Ajay's suggestion and followed your advice on formatting the variables and it worked perfectly.

many thanks.

Mark

RSS

Resources

On Data Science Central

© 2020   TechTarget, Inc.   Powered by

Badges  |  Report an Issue  |  Privacy Policy  |  Terms of Service