BookmarkSubscribeRSS Feed
David_Billa
Rhodochrosite | Level 12
Is there a way that we can get the primary key details informations from SQL server table using implicit pass through method?
1 REPLY 1
Kurt_Bremser
Super User

If SQL Server provides a method to create a table from this information, you can retrieve that to SAS.

The equivalent to the SAS dictionary tables seem to be (I just googled a little) the system tables aka System Catalog Views in SQL Server. To know how to query them to find the primary keys, you best ask in a forum oriented on MS SQL Server.

hackathon24-white-horiz.png

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 725 views
  • 0 likes
  • 2 in conversation