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.
SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!
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.
Ready to level-up your skills? Choose your own adventure.