https://communities.sas.com/t5/SAS-Visual-Analytics/Importing-CSV-file-to-SAS-Visual-Analytics/m-p/290665#M5016 <P>Hello</P> <P>&nbsp;</P> <P>I have 2.5GB CSV file to import to SAS Visual Analytics. There are over ten columns and lots of rows.<BR />Although, some of them have invalid data fields. This causes error during SAS VA's importing process and I can't import file. I have change the encoding and number of rows to check the data types, but problem stays.</P> <P>&nbsp;</P> <P>Can you help me find the way to import csv-file to SAS VA? Because the size of source file is huge, it's not possible to change "invalid" values or delele rows.</P> Wed, 10 Aug 2016 10:12:02 GMT ksetala 2016-08-10T10:12:02Z https://communities.sas.com/t5/SAS-Visual-Analytics/Importing-CSV-file-to-SAS-Visual-Analytics/m-p/290665#M5016 <P>Hello</P> <P>&nbsp;</P> <P>I have 2.5GB CSV file to import to SAS Visual Analytics. There are over ten columns and lots of rows.<BR />Although, some of them have invalid data fields. This causes error during SAS VA's importing process and I can't import file. I have change the encoding and number of rows to check the data types, but problem stays.</P> <P>&nbsp;</P> <P>Can you help me find the way to import csv-file to SAS VA? Because the size of source file is huge, it's not possible to change "invalid" values or delele rows.</P> Wed, 10 Aug 2016 10:12:02 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/Importing-CSV-file-to-SAS-Visual-Analytics/m-p/290665#M5016 ksetala 2016-08-10T10:12:02Z https://communities.sas.com/t5/SAS-Visual-Analytics/Importing-CSV-file-to-SAS-Visual-Analytics/m-p/290668#M5017 <P>2,5 GB doesn't sound huge to me....</P> <P>Pre-process using base SAS programing, then load the corrected data to LASR.</P> Wed, 10 Aug 2016 10:22:28 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/Importing-CSV-file-to-SAS-Visual-Analytics/m-p/290668#M5017 LinusH 2016-08-10T10:22:28Z