SAS Training with placement in India | Difference Between where and If statement in SAS

 Where and If statements both are same only used for data mining and cleaning but few key differences are there which are arranged in tabular manner.


S. No

Where statement

If statement

1

Used for data Mining

Used for data Mining

2.

Cannot create new variable in SAS

Can create new variable in SAS

3.

Can apply in proc steps directly in SAS

Can not apply in proc steps in SAS

4

Can apply in operators like between

Can not apply in operators like between

5.

Can not apply in multiple statements

Can apply in multiple statements in SAS so many times we will write if statements

6

Only filtered observations read from filtered data

All observations are read from input data

All those steps are cleared by using sashelp.class data which are by default present in the SAS library. It’s very tricky and useful difference.

SAS Certification Course Training Online


 We offer best SAS Certification Course Training Online in India and Aboard  and you can experts in analyses and data and report on data and export result to these format like Excel, PDF, HTML and understand the concept of the SAS programming language. Learn Full SAS Course Online from Durga Online Trainer.


You can join also online classes-


best clinical sas training institute in india

sas certification course online in india

Power bi online training course in india.

Comments

Post a Comment

Popular posts from this blog

Clinical Trials phase and SAS process

Image
  Research data sources software suit which is used to manage the data, to visualise the data and analyse the data.  SAS is Very powerful tool in the management, analysis and visualisation of data. So many Competitors for science like R, Python, SPSS, Informatica SQL, etc. But among all those, SAS has around 36% of total job openings when compared to all other competitors like our SQL economy as well. SAS Is widely used in financial sector and clinical sector as well. There are many other competitors for size and financial sector like R Python etc. There is no other competitive process till date. So, sizes most widely used software in analysing the clinical trial data in the clinical sector. So before going to tell you what is meant by clinical trial, let me give a brief introduction about the product development process. To get into the market, it should pass through the experimental phases and then it should come to the market so that the data acquired from the experimental ...
Read more

SAS Courses Online | Analysis of Variance (ANOVA) explained with example

Image
you set up an experiment with three groups of people. The first group gets water to drink. The second group gets some sugary fruit juice and the third group gets coffee. Now you test everyone’s reaction time. Myself wants to know if there’s any difference in reaction time between the groups. The null hypothesis says that the mean reaction time for all three groups is the same. If there were only two groups, you could use a T test to find out if there’s a difference between them. But when you have three groups or more, you need to use a different approach, the analysis of variance. When you do the experiment, the scores won’t all be the same. The total variation of all the scores is made-up of two parts, the variation within each group because the people in each group have different reaction times. And the variation between the groups because the drinks you gave each group are different. Here’s an example. Look at this set of scores. They’ve been sorted into order to make it easier to s...
Read more

SAS Online Certification Training | Infile options in SAS

Image
  Infile options are used to read the raw data which are located in external file. A raw data file is an external text file whose records contain data values that are organized in fields. Mostly SAS by default recognize the blank space as a delimiter apart from this SAS unable to recognize and give the error. For that purpose, DLM and DSD options are used for recognizing the delimiters other than blank space. DLM and DSD write along with infile statements. To read the raw data file, the DATA step must provide the following instructions to SAS:  the location or name of the external text file  a name for the new SAS data set  a reference that identifies the external file  a description of the data values to be read. DLM DLM= delimiter(s) where  delimiter(s)  specifies a delimiter for list input in either of the following forms:   ‘list-of-delimiting-characters’  specifies one or more characters (up to 200) to read as delimit...
Read more