Detect, predict, prevent and halt fraudulent activity

File Formats in SAS Visual Investigator

Accepted Solution Solved
Reply
Highlighted
Occasional Contributor
Posts: 14
Accepted Solution

File Formats in SAS Visual Investigator

Hi all

 

I am working with SAS VI 10.2.2 currently and dont have the access key for 10.3.1 documentation. I just wanted to check if anything has changed with the import files formats - i.e. whether other delimiters (semi-colons, or carats) are supported?

 

I currently convert data from asc files to a UTF-8 psv through a shell script so it isnt much of a problem, but just wanted to check anyways.

 

regards

Sundaresh

 


Accepted Solutions
Solution
a week ago
SAS Employee
Posts: 1

Re: File Formats in SAS Visual Investigator

Posted in reply to SundareshS

Hi Sundaresh,

 

I realize you don't have the Access key, but providing links for all to the latest. 

VI10.3.1 Doc Link

 

VI supports the following file formats via Import:

  • comma-delimited file (CSV)
  • semicolon-delimited file (CSV)
  • text file (TXT)
  • tab-delimited file (TSV)
  • pipe-delimited file (PSV)
  • Microsoft Excel data (XLS and XLSX)

Note: You get an error if you try to import a file that has an extension different from the ones listed above.

 

Microsoft Excel data files are imported without change and are not converted before processing.

 

For Microsoft Excel data, the following apply:

  • You can import only the first spreadsheet in the workbook.
  • You cannot import a Microsoft Excel report.
  • Files are limited to 3MB. If you try to import a larger spreadsheet, you are presented with a message to convert the file to CSV and try to import it again.

Cheers,
Rick

Rick Matthews
Senior Software Manager • Fraud and Security Intelligence
Tel: + 1 919 531 6945 • Mobile: + 1 919 995 3599 • Rick.Matthews@sas.com
Cary World Headquarters • 100 SAS Campus Drive • Cary, NC, 27513
www.sas.com/
SAS® … THE POWER TO KNOW®

View solution in original post


All Replies
Solution
a week ago
SAS Employee
Posts: 1

Re: File Formats in SAS Visual Investigator

Posted in reply to SundareshS

Hi Sundaresh,

 

I realize you don't have the Access key, but providing links for all to the latest. 

VI10.3.1 Doc Link

 

VI supports the following file formats via Import:

  • comma-delimited file (CSV)
  • semicolon-delimited file (CSV)
  • text file (TXT)
  • tab-delimited file (TSV)
  • pipe-delimited file (PSV)
  • Microsoft Excel data (XLS and XLSX)

Note: You get an error if you try to import a file that has an extension different from the ones listed above.

 

Microsoft Excel data files are imported without change and are not converted before processing.

 

For Microsoft Excel data, the following apply:

  • You can import only the first spreadsheet in the workbook.
  • You cannot import a Microsoft Excel report.
  • Files are limited to 3MB. If you try to import a larger spreadsheet, you are presented with a message to convert the file to CSV and try to import it again.

Cheers,
Rick

Rick Matthews
Senior Software Manager • Fraud and Security Intelligence
Tel: + 1 919 531 6945 • Mobile: + 1 919 995 3599 • Rick.Matthews@sas.com
Cary World Headquarters • 100 SAS Campus Drive • Cary, NC, 27513
www.sas.com/
SAS® … THE POWER TO KNOW®
Occasional Contributor
Posts: 14

Re: File Formats in SAS Visual Investigator

Posted in reply to RickMatthews

Thanks, that helps!

 

regards

Sundar

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 99 views
  • 1 like
  • 2 in conversation