BookmarkSubscribeRSS Feed
ArunSelja
Calcite | Level 5

Hello SAS Community,

 

I have couple of clarification. Please clarify on this

 

1.Is it possible import data from a file using data query in SAS VA library?

 

2.I will explain briefly about our scenario.

 

We have list of CSV file need to load everyday into SAS VA. This process is doing by manually, so we want load this file into VA automatically without manual interruption.

 

While loading we want check couple of conditions (e.g File exist, File name pattern, File Format, column format etc…) and send mail to relevant person based on result of the condition.

 

I know this we can implement easily in Base SAS. Is to possible to implement in SAS VA using data query? If yes, Please guide us how to implement it.

 

1 REPLY 1
JuanS_OCS
Amethyst | Level 16

Hi,

 

if you have an ETL server as SAS Data Integration / SAS Data Management, I would surely do it on that server with all the controls as I want, then I would schedule the load after the controls.

 

Besides this, and answering your question, I don't think you can implement those conditions directly on Data Query Builder. You can create the CSV load in Data Query Builder, then schedule the load and modify the result sas code... but this will need extra of your attention each time you will maintain the data loa, to re implement the conditions.

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

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
  • 1 reply
  • 1040 views
  • 0 likes
  • 2 in conversation