Wednesday, November 12, 2008

2 logics (Where also and Subsetting IF)

1. if City =: 'B';

It selects the observation if the data values of CITY variable starts with 'B' character (i.e,'B' at the first position in the City variable value).
Egg: City= "Bangalore", "Bahrain" etc., but not "bombay"

2. Where also Salary > 10000;

In general we cant use 2 where statements in a single data step. Means, if you executed a datastep which contains 2 where statements, then only the 2nd where statement will work. In this case you need to use where also statement instead of 2nd where statement.

Before:
data b;
set a;
where gender='M';
where salary > 10000;
run;

After:
data b;
set a;
where gender='M';
where also salary > 10000;
run;

1 comment:

Sristu said...

Hi,


Please find the job profile followed:

IMMEDIATE REQUIREMENT -STATISTICIAN
Designation Statistician

Experience 2+ years

Academics M.Sc . / PHD in Mathematics or Statistics

Statistic Tools Experienced on SPSS / SAS

Other Specifications Experience in Econometric Modeling and Extracting data from

Oracle DB writing SQL Queries and Experience / expertise in

dealing with very large data files.


Primary Responsibilities 1. Supporting the operations team in troubleshooting of

econometric modeling productions issues

2. Performing ad hoc diagnostic and exploratory queries and

analysis


Job Description Work on mathematical modeling for forecasting product prices.

Ability to write SQL Queries to extract data from Oracle Data

base. Analyze exceptions in prices and investigate causes.


PS: KNOWLEDGE OF ETL - INFORMATICA WOULD BE AN ADDED ADVANTAGE.



Contact for further details



Sirisha

HR Executive

040-64573037
Tauraweb Technologies Pvt. Ltd.