One more question about IF Statement.

IF Statement restricts the obs into the output data file only.

eg, one obs contains several variables.The whole obs will be removed or not if one of variables does not match IF statement.

Or the obs is still be read while the specific variable is read as missing value?

Hope everyone can understand what I am talking about.

最后一问。

TotalPassengers= sum (OrigPassengers, TransPassengers);

答案是100。正确的读取顺序应该是怎么样的呀？ 谢谢。

Q1: I get data3=FA1. i don't know what had happen to you.

Q2: yes, you can.you can read data into sas by using informat. when you want to print, you can use any data format to display.

Q3: form my understanding, the whole obs will be missing from the output data set.

Q4:

TotalPassengers= sum (OrigPassengers, TransPassengers); %so the total is .+100 = 100

Q1.

The following SAS program is submitted:

data work.staff;

JobCategory= 'FA';

JobLevel= '1';

jobCategory= JobCategory || JobLevel;

run;

Which one of the following is the value of the variable JOBCATEGORY in the

output data set?

A. FA

B. FA1

C. FA 1

D. ' ' (missing character value)

Answer : A

For IF Statement:

A raw data file is listed below:

----|----10---|----20---|----30

John McCloskey 35 71

June Rosesette 10 43

TinekeJones 9 37

The following SAS program is submitted using the raw data file as input:

data work.homework;

infile 'file-specification';

input name $ age height;

if age LE 10;

run;

How many observations will the WORK.HOMEWORK data set contain?

A. 0

B. 2

C. 3

D. No data set is created as the program fails to execute due to errors

Answer: C

if the whole obs will be removed from the output dat file if the condition doesnt match IF Statement, how answer is 3 obs?