Answered step by step
Verified Expert Solution
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 Percent Level Percent Level Percent Level Above GLP Percent Level Above CCR YEAR
Reading Grade
Reading Grade
Reading Grade
Reading Grade
Reading Grade
Reading Grade
Reading Grade
Reading Grade
Reading Grade
Reading Grade
proc content of the dataset
Alphabetic List of Variables and Attributes
# Variable Type Len Format Informat Label
District Name Char $ $ District Name
Grade Span Char $ $ Grade Span
Not Proficient Char $ $ Not Proficient
Percent Level Char $ $ Percent Level
Percent Level Char $ $ Percent Level
Percent Level Char $ $ Percent Level
Percent Level Above GLP Char $ $ Percent Level Above GLP
Percent Level Above CCR Char $ $ Percent Level Above CCR
School Code Char $ $ School Code
School Name Char $ $ School Name
State Board Region Char $ $ State Board Region
Subgroup Char $ $ Subgroup
Subject Char $ $ Subject
YEAR Num
proc means datatask.cmsdata nmiss;
var 'Percent Level Above CCRn 'Percent Level Above GLPn;
run;
OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
proc means datatask.cmsdata nmiss;
var 'Percent Level Above CCRn 'Percent Level Above GLPn;
ERROR: Variable 'Percent Level Above CCRn not found.
ERROR: Variable 'Percent Level Above GLPn not found.
run;
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE MEANS used Total process time:
real time seconds
user cpu time seconds
system cpu time seconds
memory k
OS Memory k
Timestamp :: PM
Step Count Switch Count
Page Faults
Page Reclaims
Page Swaps
Voluntary Context Switches
Involuntary Context Switches
Block Input Operations
Block Output Operations
OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;
Visualize data
proc sgplot datatask.cmsdata;
scatter xYear yPercentLevelandAboveGLP groupSubgroup;
title "Reading Performance Over Years";
run;
proc sgplot datatask.cmsdataclean;
scatter xYear yPercentLevelandAboveCCR groupSubgroup;
title "Math Performance Over Years";
run;
Linear regression for reading performance
proc reg datatask.cmsdataclean;
model PercentLevelandAboveGLP Year;
output outtask.predreading ppredreading;
run;
Linear regression for math performance
proc reg datatask.cmsdataclean;
model PercentLevelandAboveCCR Year;
output outtask.predmath ppredmath;
run;
Predict for
data task.pred;
set task.predreading task.predmath;
if Year ;
run;
proc print datatask.pred;
var Year predreading predmath;
run;
Model evaluation
proc glm datatask.alldataclean;
model PercentLevelandAboveGLP Year solution;
output outtask.evalreading ppredreading rresidreading;
run;
proc glm datatask.alldataclean;
model PercentLevelandAboveCCR Year solution;
output outtask.evalmath ppredmath rresidmath;
run;
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started