BookmarkSubscribeRSS Feed
jflo36
Calcite | Level 5

Hi, 

I try importing a dat file into sas, but I keep getting  error.

 

This is my code:

DATA Device_check;
INFILE "\\sites\happy\Reporting\Other\Device Check Return Files 201510\one.top.out.20151015.dat";
INPUT phone_number 15. Source $ Product_ID $ Consumer_ID Alert_ID
RUN;

 

Error message:

 

WARNING: Limit set by ERRORS= option reached. Further errors of this type will not be printed.
RULE: ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+
NOTE: Invalid data errors for file
'"\\sites\happy\Reporting\Other\Device Check Return Files 201510\one.top.out.20151015.d";
201510\nuance.tcpa.out.20151015.dat"' occurred outside the printed range.
NOTE: Increase available buffer lines with the INFILE n= option.
phone_number=. Source="AM","12 Product_ID=Treat"," Consumer_ID=. Alert_ID=. RUN=. _ERROR_=1

1 REPLY 1
ballardw
Super User

Missing a ; after Alert_ID

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

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