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;
Subscribe to:
Post Comments (Atom)
1 comment:
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.
Post a Comment