IF conditions in SQL

deleted_user — Mon, 07 Jan 2008 10:16:53 GMT

This is Microsoft SQL Server Query, can SAS SQL can do something like this?
USE AdventureWorks;
GO
SELECT ProductNumber, Name, 'Price Range' =
CASE
WHEN ListPrice = 0 THEN 'Mfg item - not for resale'
WHEN ListPrice < 50 THEN 'Under $50'
WHEN ListPrice >= 50 and ListPrice < 250 THEN 'Under $250'
WHEN ListPrice >= 250 and ListPrice < 1000 THEN 'Under $1000'
ELSE 'Over $1000'
END
FROM Production.Product
ORDER BY ProductNumber ;
GO

Re: IF conditions in SQL

Cynthia_sas — Mon, 07 Jan 2008 21:40:42 GMT

Hi:
I believe the CASE clause is ANSI standard SQL. PROC SQL (the SAS implementation of SQL) does support use of the CASE clause. For more help on SAS and PROC SQL and the CASE clause, you might look in the PROC SQL documentation or consult with Tech Support for more help.

cynthia

topic Re: IF conditions in SQL in SAS Health and Life Sciences

IF conditions in SQL

Re: IF conditions in SQL