Overseas Chinese Association for
Institutional Research
An AIR Affiliate That Supports IR Professionals Since 1996

  Sign In

Site Links
OCAIR Home
IR & Us
IR & Tools
IR Data Mining
IR & Statistics
IR & Humor
IR & HE
IR E-Resources
Fact Book Show
Friday Music Break
Willard's Corner
Member Publications
AIR Link
Join OCAIR
Member Sign-In
 
About OCAIR
History
Newsletters
Governance & Bylaws
Photograph and Memory
 
OCAIR Officers
Chair
Annie Lin
University Of Massachusetts Boston
Chair-Elect
Kang Bai
St. Mary's University
Coordinator
Ying Ling
University of Colorado at Boulder
Immediate-Past Chair
Faxian Yang
Middlesex County College
Member-at-Large
Yingxia Cao
University of La Verne/SUNY at Albany
OCAIR Staff
Treasury
Lily Hwang
Georgia Gwinnett
WebMaster
Sinji Yang
Eastern Michigan University

Below are summaries of OCAIR's Q&A regarding the tools we use in our work. The summaries are contributed by those who originally posed the question.

Categories

Data and Report Management in MS Access

  1. How to Join Two Access Tables and Have All Records from Both Tables? (8/24/2006)
  2. Reset Report Page Number with Each New Group (6/30/2004)
  3. How to Read SAS data in Access (for SAS Version 9) (6/30/2003)
  4. Grouping Report with Page Breaks In Access (2/28/2003)
  5. Net Discussion on Access
Back to Categories


Data Management in SPSS

  1. SPSS OMS, Output Management System (6/20/2008)
  2. Export SPSS Data with Fields More Than 256 Columns to Excel (1/25/2008)
  3. How to Save SPSS data into ASCII Fixed Width Text File (1/18/2008)
  4. How to Show Values and Labels together in SPSS Report? (6/22/2006)
  5. Comparison of Text Analysis Software (3/28/2006)
  6. Reading ODBC(Oracle) Data into SPSS
  7. Use SPSS to Get One Record Each for the Latest Semester If the Records Were Duplicated by Semester
  8. Split Files by Certain Variables
  9. How to deal with too many variables in a custom table in SPSS?
Back to Categories


Data Management in SAS, or Oracle SQL

  1. How to Use SAS for Stratified Random Sampling? (9/15/2008)
  2. How to Use SAS to Fix a Data Set? (7/22/2008)
  3. How to Left-Pad SAS data with 0? (6/26/2006)
  4. How to combine duplicated records into unique ones in SPSS or SAS? (1/12/2006)
  5. Using SAS Macro and Array to Improve the Program (10/31/2004)
  6. How to Fix/Convert the ID Variable (10/28/2004)
  7. How to Sum Multiple Variables into One Data File in SAS (9/30/2004)
  8. How to Link to an IBM Database through ODBC in SAS (9/30/2004)
  9. How to Select a Record Based on the Value of the Previous One? (2/28/2004)
  10. Stripping Characters in SPSS (and SAS) (3/31/2003)
  11. Turning Multiple Observations into Multiple Fields before Combining with Another File (3/31/2003)
  12. More Name Parsing Techniques (3/31/2003)
  13. Using SQL in SAS (10/31/2002)
  14. Cleaning Out Dashes from SSN (5/31/2002)
  15. Recoding and Change the Variable Type (6/30/2000)
  16. How to convert a data with multiple records for an individual to one that with one individual per record?
  17. How to Transpose Two Variables in SAS?
  18. How to Flag Cases with Duplicate ID Numbers and Duplicate Subject Codes
  19. How To Add HTML Formatting To Proc Tabulate Output?
  20. Name Parsing Techniques
  21. How to create ONE variable 'ethnicity' which contains 8 categories?
  22. How to Make SPSS/SAS Read Data Directly from MS Access via ODBC
Back to Categories


How to Create a Data Map?

  1. Federal School Code (3/7/2008)
  2. Adding the Map Function to Your Tool Bar (Excel 97 and 2000, NOT XP)
  3. Generating A Data Map in SPSS
  4. Generating A Data Map in SAS
  5. Getting External Data from MS Access to Excel (might take a long time to download)
  6. Download the Excel File As a Working Sample
  7. Creating A Data Map (might take a long time to download)
Back to Categories


Survey and Research Tools

  1. Online Courses Evaluation (10/24/2008)
  2. On-line Survey Software (1/29/2007)
  3. A discussion on Tableau: A Visual Analytical Tool (1/18/2007)
  4. Course Evaluation Software and Approach (12/1/2006)
  5. Question about Copyright on Survey items (8/24/2006)
  6. On-line Survey Software for Our Post-Secondary Institution (8/30/2005)
  7. On-line Survey Methods, Software and Rules (2/28/2004)
Back to Categories


Data Manipulation in MS Office

  1. How to Handle Survey Questions with Multiple Responses in Excel before Loading Them into SPSS for Analysis (5/10/2007)
  2. How to Remove Duplicat Labels in Excel? (9/30/2004)
  3. Switching the data in two rows
  4. Displaying Percent Without % Sign in Excel
  5. Using MS Word to Createa Business Reply Envelop
Back to Categories


How to Calculate…

  1. How to Calculate Student FTE for a Summer Term? (9/16/2008)
  2. How to Get Student:Staff Ratio in IPEDS? (4/2/2008)
  3. SAS Programming-Calculating Floating Median (9/5/2006)
  4. Student Age
  5. Class Size
Back to Categories


Friday SAS Salon

  1. SAS PROC SQL statement (8/1/2008)
  2. SAS -- Using ARRAY (7/25/2008)
  3. SAS -- Merge More Than 2 Data Sets (7/18/2008)
  4. Sending Email by SAS (7/16/2008)
  5. SAS -- Create New Variables (7/11/2008)
  6. Compare SAS Data step with SAS Proc SQL. Merge 2 data sets (7/7/2008)
  7. SAS -- Remove Duplicate Records (7/3/2008)
  8. SAS -- Merge 2 Data Sets (6/27/2008)
  9. A Question About Multiple CLASS Statements (3/26/2008)
  10. How to remove certain number of records from a dataset (1/25/2008)
  11. Calculate the terms each student attended until the graduation (11/1/2007)
  12. Providing some useful SAS information (7/6/2007)
  13. How to Tracking Method of Retention and Graduation? (6/28/2007)
  14. How to clean up the messy data in SAS? (6/15/2007)
  15. How to Transpose data in SAS? (5/25/2007)
  16. How to get quartile from Proc Tabulate in SAS (3/7/2007)
  17. How to calculate Ohio Population in SAS? (1/25/2007)
  18. PROC SURVEYSELECT (1/5/2007)
  19. INFORMAT ZDW.d (12/15/2006)
  20. ODS STYLE ATTRIBUATES WITH PROC TABULATE (9/29/2006)
  21. Transform a large table generated by PROC FREQ to an excel table (9/1/2006)
  22. Converting Spreadsheet and SPSS to a SAS dataset (9/1/2006)
  23. Converting character to numeric and numeric to character (8/8/2006)
  24. Reading in XLS file to SAS (8/3/2006)
  25. SAS Library I (5/26/2006)
  26. SAS Library II (5/26/2006)
  27. SAS presentation in Chicago (I) (5/19/2006)
  28. How to fix the missing value problem using transaction table? (5/19/2006)
  29. SAS Column/Row Percent (colpctn/rowpctn) (5/5/2006)
  30. SAS MACRO %STR() FUNCTION (2/10/2006)
  31. SAS PROC TRANSPOSE FUNCTION (1/6/2006)
  32. SAS ZIPCITY FUNCTION (11/23/2005)
  33. SAS Common Commands on UNIX and Mainframe (10/21/2005)
  34. SAS Column Ruler Question (10/15/2005)
  35. SAS Talent Show Topics II (10/7/2005)
  36. SAS Talent Show Topics I (9/9/2005)
  37. PRXCHANGE Function (9/2/2005)
  38. SAS Salon on Joins (8/26/2005)
  39. Creating Data Sets (8/19/2005)
  40. Making Sort Macro (8/12/2005)
  41. Useful Functions in SAS (8/5/2005)
  42. Using Functions to Calculate Age (7/22/2005)
  43. PROPCASE function AND VALIDVARNAME OPTIONS (7/8/2005)
  44. Informat $UPCASEw. TRANWRD, and SELECT functions (6/24/2005)
  45. How To solve Proc Tabulate's Problem? (5/13/2005)
  46. How To Reshape Dataset From Columns to Rows? (5/6/2005)
  47. How To Use ANYDTDTE\FULL JOIN\COALESCE? (4/29/2005)
  48. How To Rank Schools? (4/22/2005)
  49. SAS PROC APPEND and SAS MACRO EMAIL (4/8/2005)
  50. Useful SAS links (4/1/2005)
  51. How to find the observations are closest to a given number(GPA)? (3/18/2005)
  52. How to clean data? (2/25/2005)
  53. How to calculate multiple cases GPA? (2/18/2005)
  54. How to do logistic regression by using SAS procedure? (2/11/2005)
  55. How to transform data in SPSS and SAS? (1/31/2005)
  56. How to generate the name of a program automatically? (11/5/2004)
  57. New functions in SAS version 9 (10/29/2004)
  58. How to create a subset of duplicates with some criterias? (10/22/2004)
  59. How to eliminate duplicate records? (10/15/2004)
Back to Categories


SPSS Tea Room

  1. Using SPSS Temporary Syntax (9/15/2008)
  2. SPSS Crosstab Command (5/5/2006)
  3. Intro to Pivot Tables in SPSS (4/14/2006)
  4. Using Lag Function to Code Major Changes with Term Record Data (3/22/2006)
Back to Categories


Other Nuts and Bolts

  1. DataTel Data Access Tools? (7/15/2008)
  2. Compare SAS to SPSS (5/12/2008)
  3. Optimizing Data Collection Tasks -- Reach to Most Students with Least Class Visits (3/7/2008)
  4. How to merge large numbers of files? (11/16/2005)
  5. Survey Incentives (9/30/2002)
  6. How to use Excel to pick the max value in each row?
  7. How to Print File Directories in Windows
  8. How to Insert Watermark in Excel - An Excel Download
Back to Categories


Banner Access and Reporting

  1. Calculating Cumulative GPA and Hours by Term in Banner (10/9/2008)
  2. What Type of Banner Access Is Needed for Institutional Researchers? (5/25/2007)
  3. Summary Of Banner Access and Reporting Tool
Back to Categories


Data Management

Back to Categories
© IRIM 2008. Maintained by:
 |  Sinji Yang |   |  Annie Lin |   |  Mike Tamada | 
Please send comments regarding this site to Sinji Yang. Thank you.