Exploring, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

Server Error uploading csv file

Reply
Regular Learner
Posts: 1

Server Error uploading csv file

I've been having trouble uplodading some csv files into SAS. Others I have trouble getting in. I don't know if the file is too big or the format is off. I've attached the error code message. Please help

Super User
Super User
Posts: 9,838

Re: Server Error uploading csv file

Well, not going through the full log, however there are warnings in there about data not matching input format:

NOTE: Invalid data for dispensing_provider_identifier in line 5506983 15-18.RULE:     ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0                      5506983   2803549,78124,<UK>,66685100101,15.50 36id=2803549 issuer_identifier=78124 dispensing_provider_identifier=.
national_drug_code=66685100101 allowed_total_cost_amount=15.5

 

The drug_dispensing variable is numeric, expecting a number, you have <UK> which is character, therefore this will fail.  

Ask a Question
Discussion stats
  • 1 reply
  • 99 views
  • 0 likes
  • 2 in conversation