Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please help me with the below SAS steps. sample data Obs School Code Subject Percent Level 3 Percent Level 4 Percent Level 5 Percent Level

Please help me with the below SAS steps.
sample data
Obs School Code Subject Percent Level 3 Percent Level 4 Percent Level 5 Percent Level 3 Above (GLP) Percent Level 4 Above (CCR) YEAR
1600 Reading Grade 3-812.640.641.794.982.32023
2600 Reading Grade 3-817.218.99.645.728.52023
3600 Reading Grade 3-816.521.511.649.633.12023
4600 Reading Grade 3-817.83023.771.553.72023
5600 Reading Grade 3-817.112.9<533.916.82023
6600 Reading Grade 3-815.510.5<528.613.12023
7600 Reading Grade 3-88.8<5<514.55.72023
8600 Reading Grade 3-814.310.7<527.613.32023
9600 Reading Grade 3-818.119.910.248.230.12023
10600 Reading Grade 3-814.711.8<53015.32023
proc content of the dataset
Alphabetic List of Variables and Attributes
# Variable Type Len Format Informat Label
1 District Name Char 30 $30. $30. District Name
5 Grade Span Char 5 $5. $5. Grade Span
8 Not Proficient Char 4 $4. $4. Not Proficient
9 Percent Level 3 Char 4 $4. $4. Percent Level 3
10 Percent Level 4 Char 4 $4. $4. Percent Level 4
11 Percent Level 5 Char 4 $4. $4. Percent Level 5
12 Percent Level 3 Above (GLP) Char 4 $4. $4. Percent Level 3 Above (GLP)
13 Percent Level 4 Above (CCR) Char 4 $4. $4. Percent Level 4 Above (CCR)
2 School Code Char 6 $6. $6. School Code
3 School Name Char 40 $40. $40. School Name
4 State Board Region Char 14 $14. $14. State Board Region
6 Subgroup Char 37 $37. $37. Subgroup
7 Subject Char 17 $17. $17. Subject
14 YEAR Num 8
proc means data=task.cms_data nmiss;
var 'Percent Level 4 Above (CCR)'n 'Percent Level 3 Above (GLP)'n;
run;
1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
68
69 proc means data=task.cms_data nmiss;
70 var 'Percent Level 4 Above (CCR)'n 'Percent Level 3 Above (GLP)'n;
ERROR: Variable 'Percent Level 4 Above (CCR)'n not found.
ERROR: Variable 'Percent Level 3 Above (GLP)'n not found.
71 run;
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE MEANS used (Total process time):
real time 0.00 seconds
user cpu time 0.00 seconds
system cpu time 0.00 seconds
memory 1899.71k
OS Memory 24740.00k
Timestamp 05/19/202410:55:58 PM
Step Count 458 Switch Count 0
Page Faults 0
Page Reclaims 247
Page Swaps 0
Voluntary Context Switches 7
Involuntary Context Switches 0
Block Input Operations 0
Block Output Operations 0
72
73
74 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
84
/* Visualize data */
proc sgplot data=task.cms_data;
scatter x=Year y=Percent_Level_3_and_Above_GLP / group=Subgroup;
title "Reading Performance Over Years";
run;
proc sgplot data=task.cms_data_clean;
scatter x=Year y=Percent_Level_4_and_Above_CCR / group=Subgroup;
title "Math Performance Over Years";
run;
/* Linear regression for reading performance */
proc reg data=task.cms_data_clean;
model Percent_Level_3_and_Above_GLP = Year;
output out=task.pred_reading p=pred_reading;
run;
/* Linear regression for math performance */
proc reg data=task.cms_data_clean;
model Percent_Level_4_and_Above_CCR = Year;
output out=task.pred_math p=pred_math;
run;
/* Predict for 2024*/
data task.pred_2024;
set task.pred_reading task.pred_math;
if Year =2024;
run;
proc print data=task.pred_2024;
var Year pred_reading pred_math;
run;
/* Model evaluation */
proc glm data=task.all_data_clean;
model Percent_Level_3_and_Above_GLP = Year / solution;
output out=task.eval_reading p=pred_reading r=resid_reading;
run;
proc glm data=task.all_data_clean;
model Percent_Level_4_and_Above_CCR = Year / solution;
output out=task.eval_math p=pred_math r=resid_math;
run;

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Essentials of Database Management

Authors: Jeffrey A. Hoffer, Heikki Topi, Ramesh Venkataraman

1st edition

133405680, 9780133547702 , 978-0133405682

More Books

Students also viewed these Databases questions