OCAIR

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

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. How to deal with too many variables in a custom table in 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. Reading ODBC(Oracle) Data into 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 Link to an IBM Database through ODBC in SAS (9/30/2004)
  8. How to Sum Multiple Variables into One Data File in SAS (9/30/2004)
  9. How to Select a Record Based on the Value of the Previous One? (2/28/2004)
  10. Turning Multiple Observations into Multiple Fields before Combining with Another File (3/31/2003)
  11. More Name Parsing Techniques (3/31/2003)
  12. Stripping Characters in SPSS (and SAS) (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 Make SPSS/SAS Read Data Directly from MS Access via ODBC
  17. Name Parsing Techniques
  18. How to Transpose Two Variables in SAS?
  19. How to Flag Cases with Duplicate ID Numbers and Duplicate Subject Codes
  20. How to convert a data with multiple records for an individual to one that with one individual per record?
  21. How To Add HTML Formatting To Proc Tabulate Output?
  22. How to create ONE variable 'ethnicity' which contains 8 categories?
Back to Categories


How to Create a Data Map?

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


Survey and Research Tools

  1. Options of Course Evaluations (8/27/2010) New
  2. Survey Tools (11/5/2009)
  3. Online Courses Evaluation (10/24/2008)
  4. On-line Survey Software (1/29/2007)
  5. A discussion on Tableau: A Visual Analytical Tool (1/18/2007)
  6. Course Evaluation Software and Approach (12/1/2006)
  7. Question about Copyright on Survey items (8/24/2006)
  8. On-line Survey Software for Our Post-Secondary Institution (8/30/2005)
  9. 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. Displaying Percent Without % Sign in Excel
  4. Switching the data in two rows
  5. Using MS Word to Createa Business Reply Envelop
Back to Categories


How to Calculate…

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


Friday SAS Salon

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


Banner Access and Reporting

  1. What Tools Are Required to Extract Data from Banner Tables? (8/16/2010)
  2. Calculating Cumulative GPA and Hours by Term in Banner (10/9/2008)
  3. What Type of Banner Access Is Needed for Institutional Researchers? (5/25/2007)
  4. Summary Of Banner Access and Reporting Tool
Back to Categories


Data Management

  1. Is It OK to Release Student Data to Graduate Students for Research? (5/27/2010)
  2. Tools for Interactive Web Reports (11/30/2009)
Back to Categories