Tag: programming languages

proc sql nodup; select membertype from sasuser.frequentflyers;

proc sql; select distinct(membertype) as MemberType from sasuser.frequentflyers;

proc sql; select unique membertype from sasuser.frequentflyers group by membertype;

proc sql; select distinct membertype from sasuser.frequentflyers;

ID Salary Bonus 123 70000 5000 456 80000 7000 978 55000 3500

ID Salary Bonus 123 70000 5000 456 80000 7000 744 . 3500

ID Salary Bonus 123 70000 5000 456 80000 7000 744 55000 3500

ID Salary Bonus 123 70000 5000 456 80000 7000 978 55000 .

Table aliases must be used when referencing identical table names from different libraries.

Table aliases can be referenced by using the keyword AS.

Table aliases (or full table names) must be used when referencing a column name that is the same in two or more tables.

Table aliases must be used when using summary functions.

WHERE address is missing

WHERE address not exists

WHERE address is null

both a and c

proc sql; select name, spent, 120-spent as calculated Balance from Company.Absences where balance <= 0;

proc sql; select name, spent, 120-spent as Balance from Company.Absences where calculated balance <= 0;

proc sql; select name, spent, 120-spent as Balance from Company.Absences where balance <= 0;

proc sql; select name, spent, 120-spent as calculated Balance from Company.Absences where calculated balance <= 0;

df

def

deef

deeef

all the above

$&

$%

$_

$@

$^

123

123ce

Cant modify constant item in translation

12d3e

None of the above

Hello world HELLO WORLD.

Hello World HELLO WORLD.

Hello world HELLO world.

hello world HELLO WORLD.

BA

AB

Compilation Error

Null point reference error