Create a Student table with studentnum, quarter, math, science, english marks?
data Student;
input studentnum $ quarter math science english;
datalines;
1001 1 70 80 76
1001 2 80 80 78
1001 3 90 85 80
;
run;
Add 4th quarter marks as a new record and create a new Student_1 table?
data Student_1;
set Student end=eof;
output;
if eof then do;
studentnum = '1001';
quarter = 4;
math = 88;
science = 90;
english = 88;
output;
end;
run;
Add the total for each quarter?
data Student_marks_total;
set Student_1;
total = math + science + english;
run;
Add the average for each column including the total as a new row in the bottom?
data Student_marks_avg;
set Student_marks_total end=eof;
drop sum_math sum_science sum_english sum_total;
retain sum_math sum_science sum_english sum_total 0;
sum_math = sum_math + math;
sum_science = sum_science + science;
sum_english = sum_english + english;
sum_total = sum_total + total;
output;
if eof then do;
studentnum = 'avg';
quarter = .;
math = sum_math / 4;
science = sum_science / 4;
english = sum_english / 4;
total = sum_total / 4;
output;
end;
run;
Sort the Student_1 table by reversing the quarter?
proc sort data=student_1 out=student_1_sort_by_quarter;
by descending quarter;
run;
Combine Sales, Delivery employee datasets as Marketing dataset?
data Sales;
input empno empname $;
datalines;
1001 Daniel
1002 Peter
;
run;
data Delivery;
input empno empname $;
datalines;
1003 Simon
1004 Chris
;
run;
data Marketing;
set Sales Delivery;
run;
Merge a Student's arts and groups marks into a single dataset?
data student_arts;
input studentnum english spanish latin;
datalines;
1001 80 70 78
;
run;
data student_groups;
input studentnum math science history;
datalines;
1001 88 78 89
;
run;
data student_arts_and_groups;
merge student_arts student_groups;
by studentnum;
run;
Is it possible to create a table in a simple way with couple of records and couple of columns?
data blah;
firstname = 'Sean';
lastname = 'Connery';
run;
Or with two records
data blah;
firstname = 'Sean';
lastname = 'Connery';
output;
firstname = 'Matt';
lastname = 'Damon';
output;
run;
Calculate average and grade the student based on this grading guidelines?
failed: below 35
ordinary: > 35 and <= 50
second: > 50 and <= 60
first: > 60 and <= 70
distinction: > 70
data Student;
input studentnum $ math science english;
datalines;
1001 40 50 46
1002 60 60 68
1003 90 85 80
1004 10 20 23
;
run;
data Student_grading;
set Student;
average = (math + science + english) / 3;
average = Round(average, 0.01);
length grading $ 12;
if average > 35 and average <= 50 then grading = 'ordinary';
else if average > 50 and average <= 60 then grading = 'second';
else if average > 60 and average <= 70 then grading = 'first';
else if average > 70 then grading = 'distinction';
else grading = 'failed';
run;
Based on Student marks, decide the grading and add some comments?
(
NOTE: more than one action in if-then statement, so you have to use do)
data student;
input studentnum marks;
datalines;
1001 49
1002 89
1003 34
1004 89
;
run;
data student_report;
set student;
if marks > 50 then do;
result = 'pass';
comments = 'eligible to go to next level';
end;
else do;
result = 'fail';
comments = 'not eligible to next level';
end;
run;
How to add a column with table name?
data report_card;
set student_grading indsname=name;
tablename=scan(name,2);
run;
Create a temp dataset out of Student dataset using SQL?
proc sql;
create table student_temp as
select * from student;
quit;
Add numbers 1 to 5 and give the sum?
data sum_1_to_5;
sum = 0;
do i = 1 to 5;
sum = sum + i;
end;
drop i;
run;
Nik has 10 dollars. Vik has 16 dollars. Keep giving Nik a dollar per day till they both have equal money?
(
Note: Use Do while loop)
data level_the_brothers;
nik_money = 10;
vik_money = 16;
do while (nik_money < vik_money);
nik_money = nik_money + 1;
end;
final_nik_money = nik_money;
final_vik_money = vik_money;
drop nik_money vik_money;
run;
Nik has 10 dollars. Vik has 16 dollars. Keep giving Nik a dollar per day till they both have equal money?
(
Note: Use Do until loop)
data level_the_brothers;
nik_money = 10;
vik_money = 16;
do until (nik_money = vik_money);
nik_money = nik_money + 1;
end;
final_nik_money = nik_money;
final_vik_money = vik_money;
drop nik_money vik_money;
run;
Find the total, average marks of students if all 6 subjects marks are provided for each student?
data array_example;
input studentnum s1 s2 s3 s4 s5 s6;
array s(6) s1-s6; /* Hint - array element names match column names */
marks_total = sum(of s(*));
marks_avg = round(mean(of s(*)), 0.01);
datalines;
1001 78 56 45 34 75 65
1002 56 67 78 89 45 34
;
run;
