BookmarkSubscribeRSS Feed
Obsidian | Level 7

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


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


This SAS note might be helpful:

Obsidian | Level 7

Thanks! will look into this.

Opal | Level 21

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. 

Obsidian | Level 7

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.

Opal | Level 21

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.  



Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.

If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website. 

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
  • 5 replies
  • 3 in conversation