by saspower | Nov 28, 2022 | Python Online Course
Python function widely used during writing the complex or lengthy code. Python function is block of code which only runs whenever you calling the function. Python function derived from C concept but in case of python function variables are not declared but in case of...
by saspower | Nov 24, 2022 | Power BI Course
VLOOKUP, pivot table and Power pivot commonly used in data mining and pulling the data from different table giving the meaningful insight. VLOOKUP and pivot table commonly used in excel but power pivot comes under the Power BI software. Power Pivot is most powerful as...
by saspower | Nov 22, 2022 | SAS Online Course in India
SQL CASE statement is used to provide conditional type of logic in SQL.in this syntax we are using the if else and then statement.in normal SAS no need to use the case statement but in case of proc SQL case statements are required for performing the logical operation....
by saspower | Nov 22, 2022 | SAS Online Course in India
Constraints are used to limit the type of data that can go in table. Constraints can be specified when a table is created (with create table statement) or alter the table is created (with alter table statement).Integrity Constraints are very important tools which...
by saspower | Nov 21, 2022 | SAS Online Course in India
SQL Joining added the table horizontally whereas set operator joining the table vertically. There are four type of set operator named as except, intersect, union and outer union. Three of the four set operators (EXCEPT, INTERSECT, and UNION) combine columns by...
