A quick tour of SAS operators

I want to understand the logic behind the answer to the following question:

The following DATA step is submitted:

data one;
 x=3;
 y=2;
 z=x**y;
 run;

What should be the value of the variable z in the output data set? Will you please explain what the ** symbol means, and how we solve the question?

-Too Many Asterisks

It is not intuitive that the ** symbol means exponentiation, as in X to the Yth power.  There are several arithmetic, comparison, and logical SAS operators (symbols), as well as miscellaneous operators for use in SAS functions and for grouping.  Let’s take a quick tour.

Arithmetic Operators

Symbol	Definition	Example	Result
**	exponentiation	a**3	raise A to the third power
*	multiplication1	2*y	multiply 2 by the value of Y
/	division	var/5	divide the value of VAR by 5
+	addition	num+3	add 3 to the value of NUM
-	subtraction	sale-discount	subtract the value of DISCOUNT from the value of SALE
1 The asterisk (*) is always necessary to indicate multiplication; 2Y and 2(Y) are not valid expressions.

Note:  If a missing value is an operand for an arithmetic operator, the result is a missing value.  You can use parentheses ( ) to control the order in which the expression is evaluated.

Comparison Operators

Symbol	Mnemonic Equivalent	Definition	Example
=	EQ	equal to	a=3
^=	NE	not equal to1	ane 3
¬=	NE	not equal to
~=	NE	not equal to
>	GT	greater than	num>5
<	LT	less than	num<8
>=	GE	greater than or equal to2	sales>=300
<=	LE	less than or equal to3	sales<=100
	IN	equal to one of a list	numin (3, 4, 5)
1 The symbol that you use for NE depends on your personal computer.
2 The symbol => is also accepted for compatibility with previous releases of SAS. It is not supported in WHERE clauses or in PROC SQL.
3 The symbol =< is also accepted for compatibility with previous releases of SAS. It is not supported in WHERE clauses or in PROC SQL.

Note:  You can add a colon (:) modifier to any of the operators to compare only a specified prefix of a character string (name =: ‘St’ would give you all the values of the name variable that start with a capital S followed by a lower case t).

In addition to the above comparison operators, there is the MIN (><) operator which returns the lesser of the two values. The MAX (<>) operator returns the greater of the two values. For example, if A is less than B, then A><B returns the value of A (the minimum or lesser value).

 Logical Operators

Symbol	Mnemonic Equivalent	Example
&	AND	(a>b & c>d)
|	OR1	(a>b or c>d)
!	OR
¦	OR
¬	NOT2	not(a>b)
∘	NOT
~	NOT
1 The symbol that you use for OR depend on your operating environment.
2 The symbol that you use for NOT depends on your operating environment.

Note:  Logical operators are also called Boolean operators.  For an AND expression to be true, both sides of the expression must be true (a must be greater than b as well as c must be greater than d, above).  For an OR expression to be true, only one side of the expression must be true (a must be greater than b or c must be greater than d, above).  The NOT logical operator is my favorite.  (Just listen to the name:  The not logicaloperator!  It’s what I tell my husband I’m being when I’m not following his rules of logic.)  Anyway, the NOT logical operator reverses the logic of the AND or OR expression (a cannot be greater than b, above).

Other Useful Symbols

The other useful symbol is the concatenation operator, which is represented by two vertical bars (||, Windows), two broken vertical bars (UNIX), or two exclamation points (!!).  Do remember, however, that the concatenation operator does NOT trim leading or trailing blanks from character values, which can lead to some bizarre results!

I hope this brief tour of some of the most used symbols in SAS code has been helpful.  I’m off now to use my NOT logical operator to good advantage. By the way, the answer to the question at the beginning is z is equal to 3 to the 2nd power or 9 (z=x**y;).

(courtesy: sasblogs)

SIGNETSOFT is the best Training center in Bangalore for SAS, SAS clinical, SAS projects, SAS Certification, Advanced Excel, VBA, Java, Clinical Data Management.

A practical approach! and real time expert faculty, good in placement record.

contact us: info@signetsoft.com

mob: 9844559330

Phone: 080-6547 2060

Website: http://www.signetsoft.com

Get a free copy of What’s New in SAS 9.4

 

What’s New in SAS 9.4

SAS 9.4 includes features that are beneficial to all users at your site.

• For IT departments, SAS 9.4 provides a simplified architecture, increased security, and more deployment options.
• For SAS administrators, SAS 9.4 provides new management capabilities and administration tools.
• For data administrators, the integration of the DataFlux products creates a more complete data management solution. Also, new programming languages enable you to manipulate your data and access relational data from various data sources. New programming languages enable you to update data on the database and access relational data from various sources.
• For SAS programmers, high-performance analytics enable you to quickly analyze large amounts of data. Multi-threading capabilities have also been added so that you can perform analyses on single-machine deployments.
•  For the business user, reports are available from a variety of mobile devices so that you have the information that you need, when you need it.

Each major SAS release contains new products and hundreds of new features and enhancements. So how do you discover the ones that will make the most difference for you? For SAS 9.4, the Publications team wants to help. For many years, Publications has produced a What’s New book that provides rich detail about the many new things in each SAS release. With so much new, the What’s New book has typically been several hundred pages long. Your challenge has been to glean from that information what the big ticket items are for you, whether you’re an analyst, an IT manager, a data architect, a scientist, etc.

The What’s New in SAS 9.4 book provides an executive summary of the significance of SAS 9.4 in areas such as IT, big data, and analytics. Of course, you can still use the What’s New to find rich detail about the new products and hundreds of new features in SAS 9.4 too.

Get your free copy of What’s New in SAS 9.4 (available as a PDF file, an eBook for your eReader or tablet, or in HTML) here.

Making Information Easier to Find Also for SAS 9.4, the SAS Documentation home page has some new features to help you find information more quickly. For example, when you search, you can now specify up front which SAS product you are using. Doing so can dramatically reduce the number of search hits returned, bringing the information you seek closer to the top of your results. And, the SAS Programmer’s Bookshelf now detects if you’re accessing it from a mobile device and, if so, presents you with a more mobile friendly view.

Finally, a SAS Syntax Index has been added to the SAS Documentation home page. We recommend this index as the fastest way to quickly double-check the syntax for a proc or other SAS language element.

(courtesy: sasblogs)

SAS Training Expert

The best Training in Bangalore for SAS, SAS clinical, SAS projects, SAS Certification, Advanced Excel, VBA, Java, Clinical Data Management is Signetsoft. 

A practical approach! and real time expert faculty, good in placement record.

contact us: info@signetsoft.com

mob: 9844559330

http://www.signetsoft.com

Happy 1st Anniversary to SIGNETSOFT !!!

Hi Friends,

 

26th April

 

 

 This is really a proud & very exciting moment for us when our SIGNETSOFT has completed a year.

A year gone by in the blink of an eye,
training, conversations & laughing,
Wondering what the future holds for us,
We will look back years from now,
With gratitude for having all of you,
& we will know we had a good time.
happy first anniversary…

 

 

Signetsoft, The best place to learn SAS, CR, CDM, PV, EXCEL, VBA

Hi,

I am Arvind Dama. I hope u remembered me. Previously I worked as SAS trainer at GITS (malleswaram), UREACH (koramangal), and EMATIC (btm). 

As you know already, we started SIGNET INFO SOLUTIONS with Software Training and Consulting Services. With lots of support from students and friends, very soon SIGNET became one of the best institutes in the IT market. On behalf of the same, we, the SIGNET team is very much thankful to one and all.

It is our pleasure to announce you that SIGNET Info Solutions (is now SIGNETSOFT) is moved to a new IT office premises in Kundanahalli (ITPL main road) as we are planning to start SOFTWARE DEVELOPMENT. 

And SIGNETSOFT is now done with its Private Limited registration process.

And very soon we are going to start SAS, EXCEL projects (Analytics), and CDM projects as well.

And right now we are providing the training with placement assistance for the following courses:

SAS

SAS BI

Advanced Excel

VBA

Clinical Research

Clinical Data Management

Pharmacovigilance

Oracle Clinical

Medical Writing

Protocol Testing (Networking)

SAS ONLINE TRAINING 

Please refer SIGNET to your friends, if anyone is looking for the above courses.

Visit us  :

Email:  info@signetsoft.com

website:  www.signetsoft.com

mobile: 9844559330

Phone: 080-6547 2060

 

Once again, many thanks to everybody, who supported us in this regards.

 

Signetsoft Office Premises:

                                                                          

Students are you ready to get SAS certified?

Students are you ready to get SAS certified?

SAS has a long history of supporting the academic community in a variety of ways and that certainly includes support from the SAS Global Certification  program.  Did you know that students, faculty and staff of academic institutions can qualify for a 50% discount when taking a SAS exam?  When you are ready to take your exam attempt, you can submit a request for an Academic Discount by following the directions at http://support.sas.com/certify/discounts/detail.html#acad.  Just make sure you receive approval for the discount before you register to take the exam. Why do we offer a discount to students?  Simple – we see it as a win-win situation.  Students can attempt a SAS exam at a lower price than the general public.  And when students go through the process of preparing for a SAS exam, SAS benefits by having a more knowledgeable group of future SAS users. Most new SAS Global Certification exam candidates begin with the Base Programming for SAS 9  exam. Successful candidates will demonstrate the ability to:

• import and export raw data files
• manipulate and transform data
• combine SAS data sets
• create basic detail and summary reports using SAS procedures
• identify and correct data syntax and programming logic errors

If you pass the exam, you are awarded the credential of SAS Certified Base Programmer for SAS 9.  Many university students have earned this credential but until just recently it was rare for a High School student to even attempt this exam.  That is changing as we have seen software programming skills become more and more advanced at younger levels and the number of High Schools offering curriculums in SAS have increased. It’s a great time to focus on SAS and grow with us.  We have awarded over 49,000 SAS credentials to people all over the world and the program is still expanding rapidly.  This is a reflection of the global demand for SAS professionals – just go to any major job board and search for SAS Programmer.  The opportunities are limited only by your imagination.

(courtesy: sasblogs)


Pattern:

No. of Qstns: 70 
Duration: 120 minutes
To qualify : 65%  (Minimum 46 answers out of 70 should be correct )
No negative marks

For training and material related queries 
contact arvind.dama@gmail.com 

ALL THE BEST !!!