by saspower | Dec 7, 2022 | SAS Online Course in India
SDTM stands for study data tabulation model.it is very useful in the clinical and non-clinical trials’ concept was developed by CDISC (The clinical data interchange standards consortium).it is nonprofit organization which deals with medical research data. The idea of...
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...
by saspower | Nov 20, 2022 | SAS Online Course in India
In SAS joining the two or more tables done by interleave and merging method, but in this joining data should be sorted before adding. So, it will alter the original table until or unless you can use the out statement. So out statements are required during sorting...
by saspower | Nov 20, 2022 | SAS Online Course in India
Update statements are most useful in data science industries. It having following task which are listed below change the values of variables in the master data set add observations(rows) to the master data set add variable(column)s to the master data set. Rules In...
