Let’s see how to get into the SAS information catalog in the first place.

The very first thing we’re going to do is show you how to get into the SAS information catalog in the first place so I’m going to go to my applications’ menu in the top left corner and I’ll click on discover information assets and that will take me to SAS information catalog we’re also going to check our release information so in the top right corner I have a c because I’m signed in as a user called Christine I’ll click on that icon then I’ll click on about and this is nice because it shows me my product it shows me my version shows me my release my site name my site number this is really important if you’re talking to tech support but it’s also nice to know if you’re looking at the documentation.

My version is long term support 2021.1 so if you pay attention to that’s pleasantsantsantsant because over time the product will update you can see how things are going to change when you’re looking at the right documentation so I’ll click close and now let’s take a look at information catalog itself we’re going to start by doing some user tasks so lots of you watching this will be looking at different assets that have already been cataloged by your administrator so we’ll start there first let’s get the lay of the land in the left-hand IoolIar I can see that I’m on my catalog item if you’re a user that might be all you see which is fine so we’re going to start there and notice on the left left-hand side here we have a welcome area that gives us little information how to use information catalog so if you’re just getting started that’s nice to look at in the middle here we have our collections.

I can see things I’ve recently searched for and also my favorites we’ll take a closer look at these a little bit later but it’s nice i can go back to old tables that I’ve looked at recently at the top I have my search bar so I can look for different assets and I can also see how many assets are cataloged in my environment here I have 317 assets cataloged, so those can be tables files anything in a library or a cast lib that I’ve cataloged we’ll take a look at searching that in just a minute and then finally in the top right corner I can import data so if I find that I’m missing a table that I expect to be in a library or a cast lib I can click on import data and that will take me to the environment manager application where I can add data to a cad slide.

Let’s take a look at how we can search through our assets there are two types of searches and we’re going to start with the standard search, so the standard search is a more general search it’s going to allow us to search not only table information but also column information things like the region the data is from the library so it’s a literalIoing GoingiGoing customer data we’re going to focus on customers here so I’m going to type in the word customer and hit my search icon so we get a list of tables back that have customer and either the table properties the column properties the library the region something about this table was associated with the word customer the standard search has an implicit wild card and it also has fuzzy searching so for example if we have a table named customers or bank customers even though I just searched the word customer we had this implicit wildcard so if we contained customer that also returned those table names so the very top here I have customers i IIIISIESIEcustomers credit card customers.

These are all tables that I Iould expect to get back from the customer search but like i said the table name and table top-level table properties aren’t the only thing that we’re searching here, for example, we have a table called products clean that came back so why did this come back for a custom search I’ll click on this and let’s take a look at why that might have happened so we’ll take a closer look at all of these cool metrics that we see here in just a little bit but right now let’s just focus on why this came back for a search of customer I’ll click on column analysis and then I’ll click on metadata measures and this shows me the entire list of columns and column descriptions for this table and if i scroll down we have a column called customer underscore id with a label of customer id.

If the column has that name customer or there’s a column label that has that name that actually counts towards the search for the standard search i’m going to go back to my search results notice that products clean is actually at the bottom of the list here so column and column description have less of a weight to them in the search results than a table name would customers not only has the table name that includes customer but also has many columns that include the word customer so that’s weighted most heavily okay so standard search is really nice if you’re trying to look at your assets and you’re maybe not sure exactly what’s in your catalog you can see a lot of information come back that you might not have expected you can find columns you might not have expected in different tables it’s a really nice search when you’re just getting started but what if you have a table that you’re specifically looking for you definitely want one or two tables and you don’t want a bunch of other stuff coming back there’s another type of search that’s a lot more precise called the syntax search.

Let’s take a look at that i’ll click catalog home and let’s switch my search type to syntax search i’ll click on the down arrow next to my search bar the advanced search and i will click syntax search this is really cool because underneath the search bar you get a syntax example so you can see the syntax for the syntax search underneath that search bar you have the piece of information you’re looking for and then you describe what type of that information you’re looking for so for example name car with an asterisk after it is going to look for any name that contains car importantly the syntax search only searches table properties so columns are not searched the region’s not searched the library name is not searched we’re just looking at things like table name the date the tables modify table descriptions table labels that sort of thing so you’re not going to get extra columns coming back you’re not going to get tables that have different names coming back you’re just going to get searches on that table information so let’s take a look at how we can use this syntax search.

I’m going to start with a simple search and then we’re going to get a little bit more complicated so i’m going to start by just searching name colon customer so this will search tables with a name of customer and i’ll click on my start search and i don’t get anything back why is that the standard search has an implicit wildcard so it’s going to search things that contain customer but the syntax search is much more precise so if we want a wild card if we want this contains then we have to do it ourselves so to search for things that contain the word customer specifically to search for table names that contain the word customer i’ll add an asterisk after the customer word there and if i hit my start search again now we get four results back earlier we got a lot more tables back because we were also searching column properties right here we’re only getting table names that contain the word customer back so name customer asterisk is going to give us customer focus group customers credit card customers bank customers all of that good stuff what if i want to narrow down my results more we can use and in or operators to change our searches.

I’m going to use an and so I’m going to add and then I’ll also type in the description i want the description to contain the word bank so let me click start to search and i have two tables that come back with that particular search criteria so we’ve got credit card customers and bank customers if I click on bank customers, for example, the business description says contains the bank’s customers and their personal information so that was relevant to my search I’ll go back to my search results you can see how we can get specific with our syntax search and that can be helpful.

Leave a Comment