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

SAS VA - Importing CSV and Column Format issue

Reply
Contributor
Posts: 25

SAS VA - Importing CSV and Column Format issue

Hello all!

 

I have a situation that I hope has an easy fix. I need to write a Data query in SAS VA that uses a CSV and a database table and joins them to produce a LASR table as output.

 

I have a csv file with 3 columns, they should all be treated as character columns, however, because two of those columns have numbers in them, the Import tool in SAS VA decides to turn them into numeric columns.

 

The issue with this is that i need to join this table to another table and I need to use one of those character columns as a key, the foreign key is of character type and i cannot change this.

 

I was wondering if there was a way to "force" the input tool to recognize that column as character instead of numeric.

 

I tried using an excel file instead of csv, and changed the column types to character but that did not help at all

SAS Super FREQ
Posts: 590

Re: SAS VA - Importing CSV and Column Format issue

In the Excel version, enter a blank value in each column that is otherwise all numeric.

 

This SAS note might be helpful: http://support.sas.com/kb/56/049.html

Contributor
Posts: 25

Re: SAS VA - Importing CSV and Column Format issue

Posted in reply to Madelyn_SAS

Thanks! will look into this.

Super User
Posts: 4,034

Re: SAS VA - Importing CSV and Column Format issue

In my opinion, the best way to control CSV data coming into VA, would be to write a DATA step program in VA's SAS Studio coding interface. The DATA step allows you to enforce your required data types. 

Contributor
Posts: 25

Re: SAS VA - Importing CSV and Column Format issue

I do agree with you, however, non-technical users will be using VA and will expect to be able to import csv's and join them to pre-existing tables in SAS without the use of Base SAS.

Super User
Posts: 4,034

Re: SAS VA - Importing CSV and Column Format issue

I checked the VA import process and there isn't an option to enforce data type - not in VA 7.4 anyway. The only option I can think of is to put a dummy row of data at the start of the CSV to get the type you require, then delete it once it is imported.  

Ask a Question
Discussion stats
  • 5 replies
  • 143 views
  • 0 likes
  • 3 in conversation