BookmarkSubscribeRSS Feed
doylel33
Calcite | Level 5

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

1 REPLY 1
RW9
Diamond | Level 26 RW9
Diamond | Level 26

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.  

sas-innovate-2024.png

Don't miss out on SAS Innovate - Register now for the FREE Livestream!

Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.

 

Register now!

Tips for filtering data sources in SAS Visual Analytics

See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.

Find more tutorials on the SAS Users YouTube channel.

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