I've looked at a handful of other similar questions (here, here, and here), but have not had success with the accepted answers I found. I'm trying to transform a wide data set into a long data set, turning column names into rows with matching records adjacent to the old column names. I can't seem to get the original column names to appear using my current code. I have a wide dataset that looks like this: DBN Emp_ID FiscalYear Improvement_plan Action_Plan Timeline Support_Plan Assessment_Plan Meeting1 Meeting2 Meeting3 Meeting4 Meeting5 07B025 469849 2015 1) Developing strategies for consistently monitoring student behavior, setting clear expectations for behavior, and routinizing procedures to minimize disruptions. 1. For Developing strategies for consistently monitoring student behavior, setting clear expectations for behavior, and routinizing procedures to minimize disruptions: (Fall) a. Explain and model expectations for classroom behavior for students. (September) Refer to the timelines included at the end of each action step/ activity listed above. A Ramapo consultant will support you with differentiating instruction, pacing, and engaging students. In our second and third meetings, we will review the evidence from classroom observations and student work/learning 12SEP2014:00:00:00.000 22JAN2015:00:00:00.000 28MAY2015:00:00:00.000 . . 07B025 469849 2017 1E: Designing Coherent Instruction: Design lessons that cognitively engage students through content, support, and pacing. • Design lesson plans that are structured to support appropriate pacing within the lesson by including specific reasonable time frames for each portion of the lesson. (Fall) See above 1) You will schedule inter-visitations to observe your classes in their classrooms (with their primary teacher) with a focus on noticing the behavior management strategies and non-verbal cues used. In our second and third meetings, we will review the evidence from classroom observations and student work/learning 16SEP2016:00:00:00.000 12JAN2017:00:00:00.000 25MAY2017:00:00:00.000 . . 02Q512 964702 2015 1) Developing strategies for consistently monitoring student behavior, setting clear expectations for behavior, and routinizing procedures to minimize disruptions. (2D) 2) Using questions and assessments regularly to diagnose evidence of learning.(3D) 3) Engage students in learning by monitoring pacing. (3C) a. Explain and model expectations for classroom behavior for students. (September) b. Post class rules in a visible place for students. Include visuals for each rule so students know what they are (since your kindergarteners are not yet readers).(September) c. Share standards of conduct with students' families. (September) Refer to the timelines included at the end of each action step/activity listed above. 1) Work with Deborah the Math coach, to develop your practice in differentiating instruction. She will support you in the cyclical practice of collecting data, using data to plan scaffolded supports and materials for students, and provide differentiated instruction. In our second and third meetings, we will review the evidence from classroom observations and student work/learning 12SEP2014:00:00:00.000 21JAN2015:00:00:00.000 27MAY2015:00:00:00.000 . . 01M515 140817 2016 1) Designing coherent instruction by differentiating to meet the needs of your learners thereby ensuring cognitive challenge. 1. For Designing coherent instruction by differentiating to meet the needs of your learners thereby ensuring cognitive challenge: Refer to the timelines included at the end of each action step/ activity listed above. 1) A Gifted and Talented coach will support you throughout the year with designing coherent instruction and engaging students in learning. In our second and third meetings, we will review the evidence from classroom observations and student work/learning 21SEP2015:00:00:00.000 22APR2016:00:00:00.000 23JUN2016:00:00:00.000 . . I need it to look like this: DBN Emp_ID FiscalYear Section Text Meeting1 Meeting2 Meeting3 Meeting4 Meeting5 07B025 469849 2015 Action_plan 1. For Developing strategies for consistently monitoring student behavior, setting clear expectations for behavior, and routinizing procedures to minimize disruptions: (Fall) a. Explain and model expectations for classroom behavior for students. (September) 12SEP2014:00:00:00.000 22JAN2015:00:00:00.000 28MAY2015:00:00:00.000 . . 07B025 469849 2015 Timeline Refer to the timelines included at the end of each action step/ activity listed above. 12SEP2014:00:00:00.000 22JAN2015:00:00:00.000 28MAY2015:00:00:00.000 . . 07B025 469849 2015 Support_Plan A Ramapo consultant will support you with differentiating instruction, pacing, and engaging students. 12SEP2014:00:00:00.000 22JAN2015:00:00:00.000 28MAY2015:00:00:00.000 . . 07B025 469849 2015 Assessment_Plan In our second and third meetings, we will review the evidence from classroom observations and student work/learning 12SEP2014:00:00:00.000 22JAN2015:00:00:00.000 28MAY2015:00:00:00.000 . . I've tried to do this with an array: data want;
set have;
array d ImprovementPlan -- AssessmentPlan;
do i = 1 to dim(d);
Section = d{i};
Text = d
output;
end;
keep DBN Emp_ID FiscalYear Section Text Meeting1 Meeting2 Meeting3 Meeting4 Meeting5;
run; But end up with this: DBN Emp_ID FiscalYear Section Meeting1 Meeting2 Meeting3 Meeting4 Meeting5 07B025 469849 2015 1) Developing strategies for consistently monitoring student behavior, setting clear expectations for behavior, and routinizing procedures to minimize disruptions. 12SEP2014:00:00:00.000 22JAN2015:00:00:00.000 28MAY2015:00:00:00.000 . . 07B025 469849 2015 1. For Developing strategies for consistently monitoring student behavior, setting clear expectations for behavior, and routinizing procedures to minimize disruptions: (Fall) a. Explain and model expectations for classroom behavior for students. (September) 12SEP2014:00:00:00.000 22JAN2015:00:00:00.000 28MAY2015:00:00:00.000 . . 07B025 469849 2015 Refer to the timelines included at the end of each action step/ activity listed above. 12SEP2014:00:00:00.000 22JAN2015:00:00:00.000 28MAY2015:00:00:00.000 . . 07B025 469849 2015 A Ramapo consultant will support you with differentiating instruction, pacing, and engaging students. 12SEP2014:00:00:00.000 22JAN2015:00:00:00.000 28MAY2015:00:00:00.000 . . 07B025 469849 2015 In our second and third meetings, we will review the evidence from classroom observations and student work/learning 12SEP2014:00:00:00.000 22JAN2015:00:00:00.000 28MAY2015:00:00:00.000 . . I appreciate any advice you have for me.
... View more