I am wondering if there aren't people with a higher level of skill/ experience with SAS at your institution who might be able to help you? One of the challenges here on SAS-L is that we don't see the data, or code, from which you are working. And, you probably don't want to post it out on a site like this for confidentiality reasons.

There are a number of ways to potentially solve your problem, include SAS reporting tools (PROC REPORT and PROC TABLULATE), as well as some other approaches involving creating data sets and merging them together.

Also, if I am not mistaken, you are affiliated with St Mary's in Baltimore, MD. You may want to take the MARC train down to DC on December 8th for the DC SAS users group meeting. It's right across the street from Union Station at the Bureau of Labor Statistics. See www.dc-sug.org for details.

Andrew Karp Sierra Information Services http://www.sierrainformation.com

On Oct 29, 11:21�am, dflow...@SAINTMARYS.EDU (Daniel R Flowers) wrote: > I apologize for the lack of clarity in the initial email. �As I mentioned, I am new to the list and was not aware of the specific goals and composition of the list you referenced based on what I had read from the list homepage. �There is code on our end that exists and we are able to edit and develop. �As we didn't want anyone to do our work, we had tried to make this a more general concept question (although beginning) then something very specific. �I apologize that this was out of the scope of the listserv and will be happy to reference other more introductory sources. �Thank you for your time and I apologize for the inconvenience. > > > > ----- Original Message ----- > From: "Gerhard Hellriegel" <gerhard.hellrie...@T-ONLINE.DE> > To: SA...@LISTSERV.UGA.EDU > Sent: Thursday, October 29, 2009 1:16:26 PM (GMT-0500) America/New_York > Subject: Re: Help with SAS code > > don't know how the others think about that, but many of the people which > share their knowledge here are consultants. They get their money for > writing applications for customers. It is great that they provide help for > some sophisticated problems (also for not sophisticated, if there are > some), but it is not the goal to do other's work! The only goal is to help > other's over some obstacles, which prevent them to do their work. > If I read something like "If the current SAS code would be helpful, feel > free to contact me on an individual basis" I don't have positive feelings! > One thing is, the code is to big to provide it here. Another is, there > seem to be no ideas about concrete problems, only "it does not do what we > want". A (for me) very important thing is: this list has NOT the goal to > provide INDIVIDUAL problem solutions, but should give everybody the chance > to participate. > > I have two "solutions": 1. look for a SAS-base course. 2. make a contract > with one of the SAS consultants to help you with concrete applications and > maybe give you enough informations to do it yourselve in future, if you > have time enough to do so. > > To be not missunderstood: if there is a question like "we have that kind > of data (example) and want to summarize them with that classification > (example) and expect that result (example), but get the following > (example). We tried it with the following code (code-part). How could we > do that better?" > or > "we have that code and get the following error which we don't > understand... - Why?" > > all that is ok and you'll get the best answers here, also for beginner's > questions. > > But not like "we want a report with that content, write it for us!" > > All only my personal opinion, maybe others think different. > > Gerhard > > On Thu, 29 Oct 2009 11:43:38 -0400, Daniel R Flowers > <dflow...@SAINTMARYS.EDU> wrote: > > >Hello, > > >This is my first post to the group. �Hello! �My director and I are > relatively new to the world of SAS code as we are more heavy users of > SPSS. �A SAS code existed in the office before our time that generated > course evaluation reports for individual faculty members and departments. > Essentially, we have code that generates individual reports by faculty > member and by department. �Within the individual faculty reports, we show > totals by response and provide an overall comparison to the college with > averages of all courses offered at the college (as we have a standard > evaluation form). �We would like to be able to add a departmental > comparison line (so in essence we would have the break-out for the > individual faculty, a comparison to the overall college average, and a > comparison to the departmental average). > > >Note: The SAS file is pulling from a text file generated from a scantron > of the evaluation form. > > >We have not yet been able to generate code to do this. �Any help would be > much appreciate. �If the current SAS code would be helpful, feel free to > contact me on an individual basis. �I very much appreciate any advice. > > >Daniel- Hide quoted text - > > - Show quoted text -