— Prints the code generated by the macro to your log. Invaluable for de-bugging. Delete this statement after your macro is churning away. Names the macro, gives it four required parameters – the date, start of FIRST\u00a0 class, time class finishes and teacher name<\/p>\n gives it six optional parameters, the start of the second class, finish of second class, teacher of second class, start of third class, etc.<\/p>\n *** mega-important here, I am also assigning default values for each of these so later in the program it doesn’t run into a null value and throw an error. If the record matches the value for day, and the start and finish times match the values given, the record is assigned to teacher1 ‘ s class.<\/p>\n else if (&start2 > 0) & (minutes > &start2) & minutes < &finish2\u00a0 then tclass = &teacher2 ;<\/em> For the next two possibilities, IF there is a value supplied for start2 (or start3), then the statement executes and looks for students who were logged on and answering questions during that time, and assigns their records to the appropriate teacher’s class. Here we end the DO-loop and then end the macro.<\/p>\n Data coded ; The section above creates a data set, assigns an appropriate length for teacher name and then shows two examples, calling the macro for a day with two class and another day when there were three classes. One immediate change I can see would be useful might be to change the input parameter from a SAS date value to something more comprehensible to humans. Maybe I’ll do that next week.<\/p>\n Tomorrow I have a slight problem with JavaScript animation to work out.<\/p>\n Yesterday and the day before, I gave an example of using SAS to sort student responses into the class they were in using the DATEPART function, TIMEPART function and a few DO-loops. After making sure my code runs, I decided it was pretty redundant and thus a classic case for a macro. What I want…<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"_kad_post_classname":"","_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[9],"tags":[],"class_list":["post-2725","post","type-post","status-publish","format-standard","hentry","category-software"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.thejuliagroup.com\/blog\/wp-json\/wp\/v2\/posts\/2725","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.thejuliagroup.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.thejuliagroup.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.thejuliagroup.com\/blog\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/www.thejuliagroup.com\/blog\/wp-json\/wp\/v2\/comments?post=2725"}],"version-history":[{"count":6,"href":"https:\/\/www.thejuliagroup.com\/blog\/wp-json\/wp\/v2\/posts\/2725\/revisions"}],"predecessor-version":[{"id":5587,"href":"https:\/\/www.thejuliagroup.com\/blog\/wp-json\/wp\/v2\/posts\/2725\/revisions\/5587"}],"wp:attachment":[{"href":"https:\/\/www.thejuliagroup.com\/blog\/wp-json\/wp\/v2\/media?parent=2725"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.thejuliagroup.com\/blog\/wp-json\/wp\/v2\/categories?post=2725"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.thejuliagroup.com\/blog\/wp-json\/wp\/v2\/tags?post=2725"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
\n%macro sched(the_day,start1,finish1,teacher1,start2=0, finish2=0, teacher2=” “, start3=0,finish3=0,\u00a0 teacher3=” “);<\/em><\/p>\n
\nif date_data = &the_day then do ;<\/em>
\n if minutes > &start1\u00a0 &\u00a0 minutes < &finish1 then tclass = &teacher1 ;<\/em><\/p>\n
\n\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0 else if &start3 > 0\u00a0 & (minutes > &start3) & minutes < &finish3 then tclass = &teacher3 ;<\/em><\/p>\n
\n\u00a0\u00a0 \u00a0end ;<\/em>
\n %mend sched ;<\/em><\/p>\n
\nattrib tclass length = $19 ;
\nset in.studentdata ;
\nset SASUSER.QUERY_FOR_INPUTFORMDATA ;
\n%sched(19290,800,850,”Flintstone”,start2= 850, finish2=900, teacher2= “Rubble”);
\n%sched(19292,790,840,”Elmo”,start2= 840, finish2=900, teacher2= “Bert”, start3=940,finish3=990, teacher3= “Snuffleupagus”);<\/p>\n![\"girl](\"http:\/\/www.thejuliagroup.com\/blog\/wp-content\/uploads\/2017\/11\/aztech_jungle.png\")
<\/a><\/p>\nIf you want to see what I do with JavaScript, check out our game AzTech: Meet\u00a0 the Maya , for your iPad<\/a><\/h3>\n","protected":false},"excerpt":{"rendered":"