https://communities.sas.com/t5/SAS-Procedures/Need-some-help/m-p/62327#M17730 hi thanks very much Thu, 05 May 2011 05:24:46 GMT IV 2011-05-05T05:24:46Z https://communities.sas.com/t5/SAS-Procedures/Need-some-help/m-p/62325#M17728 Hi guys<BR /> <BR /> I need some help with a question coming from SAS base exam.<BR /> <BR /> The following SAS program is submitted:<BR /> <BR /> data work.total;<BR /> set work.salary(keep = department wagerate);<BR /> by department;<BR /> if first.department then payroll = 0;<BR /> payroll + wagerate;<BR /> if last.department;<BR /> run;<BR /> <BR /> <BR /> Question:<BR /> The SAS data set WORK.SALARY, currently ordered by DEPARTMENT, contains 100 observations for each of 5 departments. Which one of the following represents how many observations the WORK.TOTAL data set contains?<BR /> <BR /> <BR /> From what i seen the answer is 5.<BR /> <BR /> But i really need some explaination on this.<BR /> <BR /> thanks in advance<BR /> <BR /> IV Thu, 05 May 2011 04:02:36 GMT https://communities.sas.com/t5/SAS-Procedures/Need-some-help/m-p/62325#M17728 IV 2011-05-05T04:02:36Z https://communities.sas.com/t5/SAS-Procedures/Need-some-help/m-p/62326#M17729 Yes .it is five.<BR /> because<BR /> if last.department; means if last.department then output; So only five obs be output.<BR /> <BR /> Ksharp Thu, 05 May 2011 04:41:50 GMT https://communities.sas.com/t5/SAS-Procedures/Need-some-help/m-p/62326#M17729 Ksharp 2011-05-05T04:41:50Z https://communities.sas.com/t5/SAS-Procedures/Need-some-help/m-p/62327#M17730 hi thanks very much Thu, 05 May 2011 05:24:46 GMT https://communities.sas.com/t5/SAS-Procedures/Need-some-help/m-p/62327#M17730 IV 2011-05-05T05:24:46Z