Hi,
I am new to SAS. Now i come to know about SAS Viya to generate visual reports so I want to generate report using SAS Viya. I have done many demonstration with local files.(i.e. excel files, csv files, etc.) Now I want to retrieve data from Database using custom query and generate report. Is it possible ? How ? Give me some suggestion. Thank you.
Yes, it is very possible. You will need to setup a SAS library using the a libname statement to Hadoop or the RDBMS.
To do this you may need to have a specific SAS/ACCESS engine licensed. For example you may already have a SAS/ACCESS engine for ODBC which can be used to connect to any ODBC compliant source. You will need to have the proper userid/password permissions on the source setup by the Hadoop or database DBA in order for the libname statement to be successful.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.