comp.soft-sys.sas - The SAS statistics package.
Please note the change in my e-MAIL Domain from BIOCON.COM to CLINIGENEINTL.COM. All future correspondence to me should be addressed to XXXX@XXXXX.COM Dear All, I have a data set like this: (Embedded image moved to file: pic02082.jpg) I wanted the output in this format, (Embedded image moved to file: pic22929.jpg) Which Procedure to use. Thanks in Advance. Regards, Geetha. __________________________________________________________________________ Confidentiality Statement The Information attached herewith is strictly confidential and for the authorised use of the intended recipient only. If you are not the intended recipient, please notify the sender or Biocon Limited immediately. __________________________________________________________________________ BIOCON LIMITED, 20th K. M. Hosur Road, Electronic City P.O Bangalore-560 100, INDIA Website : www.biocon.com Phone: 00-91-80-2808 2808 Fax: 00-91-80-2852 34 23
Hi All, I need to create a report that has a table with columns. At the top of each page is the person's name. The table has 8 columns. The name of the subscale is at the top (right above the table) of each table to the far left. The first cell (A1) in the first column has the text "My Principal...", then right underneath that in cell A2 the items begin. Item 1 says, "exhibits an understanding..." Cell B1 has the text "Strongly Agree", cell C1 "Agree", cell D1 "Disagree', cell E1 "Strongly Disagree", cell F1 "Not Applicable". Item 2 begins in cell A3. Percentages are in cells B2, C2, D2, E2, and F2 for item 1. The table is the same for the other items that fall under that subscale. There are other tables just like what I described for the remaining 9 subscales. The last page of the report has a table that compares the assistant principal's percentages on each of the competencies to All school Principals in that school region and to All Principals in the entire school district. A! region is comprised of a number of schools. Our school system has 8 regions. I have one text file per school. I was told that I need to first transpose the data before using proc tabulate or proc report. I am fairly new at this and am having a hard time with proc transpose. I have copied the first line of a text file below so you can refer to it. N 405001 ABBBBBBBAABBBBABBBAABBBBBBAAAABBAAAAAAAABBBBBBBBBAAAAAAAAAAAABBBBBBBBBBBBBBBBB The data doesn't start until after the N. After the N, the first 3 digits are the school code followed by 001 or 002 indicating whether or not the respondent is classified staff or non-classified staff. I know I need to use either proc tabulate or proc report or both to come up with the finished product which would be tables in Word that summarizes the data. If anyone can help me, I would really appreciate it. I am a novice at this and need help getting started. Thanks so much, Carol
Hey, I am using proc tabulate very often in my current job. But I heard most people are using proc report to generate results. Does anyone have a preference paper discussing the difference between proc tabulate and proc report, Or any paper which has an overview of proc report? I have searched papers on google, but I am overwhelmed. Thanks a lot. Mindy
From one fish bowl to another.. An interesting problem on my part, but likely a simple answer. Background: I have variables from an input data set for which I assign a format and label. Ex. LABEL q1=If you plan on taking to trip to Europe, when do you intend to do so? q2=If you plan on taking to trip to Asia, when do you intend to do so? FORMAT (For both q1 and q2) 1 = One year from now 2 = Two years from now 3 = Three years from now 4 = Four years from now 5 = 5 years from now 6 = more than 5 years from now So when I run PROC FREQ DATA=blah TABLES q1 -- q2; RUN; I get a standard frequency table with a label to describe the variable AND the formats attached to their relative frequency (Ie. "If you plan on taking..." One year from now 1 ... More than 5 years 5 ) These tables are merely one-way frequency tables. PROBLEM: I've now been asked to take all of these variables and consolidate them into a table that would look like the following: Column 1 Column 2 .. Column 8 (Locale) One year from now ... More than 5 years Europe Asia Australia The requestor is basically asking that I flip the table and merge the results Is there a simple or straight-forward method of doing this? (Or am I going to be running multiple out options in Proc Freq followed by multiple Proc Transpose with a final data set to merge the results?) Signed a data step cruncher now lost in the wilds of SAS report writing.. Chris Amherst