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: http://support.sas.com/kb/56/049.html
-------------------------------------------------------------------------
Four tips to remember when you contact SAS Technical Support
Creating Beautiful Reports
SAS Visual Analytics Learning Center
Thanks! will look into this.
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.
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.
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.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 16. Read more here about why you should contribute and what is in it for you!
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.