Matches in SemOpenAlex for { <https://semopenalex.org/work/W2186446556> ?p ?o ?g. }
Showing items 1 to 86 of
86
with 100 items per page.
- W2186446556 abstract "The U.S. Census Bureau performs an annual data collection for the National Center for Education Statistics. As part of the file documentation, the Census Bureau produces a summary table that shows the minimum, maximum, and mean value for each continuous variable, along with the number of records that have a value greater than or equal to zero, the number of records with missing values, and the number of records with “not applicable” values. The data collection has more than 140 variables. The output can be easily produced as HTML, which can be read by Microsoft Excel, but we need to use a variety of tricks to produce beautifully formatted Excel output. The little tricks include modifying the printer style, using the MSOFFICE2K tagset, and using the Microsoft Office style properties to format numbers and cell widths. If we need the output to be a native Excel file, we can use dynamic data exchange commands to automate that task as well. This paper shows what we can do with SAS® 9.1.3 and Excel 2000. Users who have access to Excel 2002 or more recent versions may want to learn more about the ExcelXP tagset, which is not covered in this paper. This paper assumes that the reader is comfortable with the DATA Step and PROC MEANS. THE DATA USED IN THIS PAPER The Census Bureau collects revenue and expenditure data from each state education agency for the National Public Education Financial Survey (NPEFS) each year. The National Center for Education Statistics (NCES) is the agency that sponsors the data collection. The revenue and expenditure data cover pre-kindergarten through grade 12. Each year, NCES publishes a report based on the data and makes the dataset available to the public. This paper uses the Excel file for the FY 2002 NPEFS, which is available at http://www.nces.ed.gov/ccd/stfis.asp. NCES also publishes documentation for each file. The FY 2002 NPEFS file documentation is available at http://nces.ed.gov/ccd/pdf/stfis02gen1c.pdf. The report based on the data is “Revenues and Expenditures for Public Elementary and Secondary Education: School Year 2001-02”, which is available at http://nces.ed.gov/pubsearch/pubsinfo.asp?pubid=2004341. The file is edited. Missing data are imputed. Appendix G of the file documentation has two tables. Table G-2 shows the minimum, maximum, and mean value for each item on the survey, along with a count of the number of missing values and the number of “not applicable” values." @default.
- W2186446556 created "2016-06-24" @default.
- W2186446556 creator A5001440949 @default.
- W2186446556 date "2007-01-01" @default.
- W2186446556 modified "2023-09-24" @default.
- W2186446556 title "How To Produce Almost Perfect Excel® Output" @default.
- W2186446556 cites W2184300695 @default.
- W2186446556 hasPublicationYear "2007" @default.
- W2186446556 type Work @default.
- W2186446556 sameAs 2186446556 @default.
- W2186446556 citedByCount "1" @default.
- W2186446556 crossrefType "journal-article" @default.
- W2186446556 hasAuthorship W2186446556A5001440949 @default.
- W2186446556 hasConcept C10138342 @default.
- W2186446556 hasConcept C105795698 @default.
- W2186446556 hasConcept C108170787 @default.
- W2186446556 hasConcept C111472728 @default.
- W2186446556 hasConcept C111919701 @default.
- W2186446556 hasConcept C119857082 @default.
- W2186446556 hasConcept C133462117 @default.
- W2186446556 hasConcept C138885662 @default.
- W2186446556 hasConcept C144024400 @default.
- W2186446556 hasConcept C149923435 @default.
- W2186446556 hasConcept C162324750 @default.
- W2186446556 hasConcept C171730128 @default.
- W2186446556 hasConcept C195487862 @default.
- W2186446556 hasConcept C199360897 @default.
- W2186446556 hasConcept C2776291640 @default.
- W2186446556 hasConcept C2908647359 @default.
- W2186446556 hasConcept C3019730874 @default.
- W2186446556 hasConcept C33923547 @default.
- W2186446556 hasConcept C41008148 @default.
- W2186446556 hasConcept C45235069 @default.
- W2186446556 hasConcept C52130261 @default.
- W2186446556 hasConcept C56666940 @default.
- W2186446556 hasConcept C77088390 @default.
- W2186446556 hasConceptScore W2186446556C10138342 @default.
- W2186446556 hasConceptScore W2186446556C105795698 @default.
- W2186446556 hasConceptScore W2186446556C108170787 @default.
- W2186446556 hasConceptScore W2186446556C111472728 @default.
- W2186446556 hasConceptScore W2186446556C111919701 @default.
- W2186446556 hasConceptScore W2186446556C119857082 @default.
- W2186446556 hasConceptScore W2186446556C133462117 @default.
- W2186446556 hasConceptScore W2186446556C138885662 @default.
- W2186446556 hasConceptScore W2186446556C144024400 @default.
- W2186446556 hasConceptScore W2186446556C149923435 @default.
- W2186446556 hasConceptScore W2186446556C162324750 @default.
- W2186446556 hasConceptScore W2186446556C171730128 @default.
- W2186446556 hasConceptScore W2186446556C195487862 @default.
- W2186446556 hasConceptScore W2186446556C199360897 @default.
- W2186446556 hasConceptScore W2186446556C2776291640 @default.
- W2186446556 hasConceptScore W2186446556C2908647359 @default.
- W2186446556 hasConceptScore W2186446556C3019730874 @default.
- W2186446556 hasConceptScore W2186446556C33923547 @default.
- W2186446556 hasConceptScore W2186446556C41008148 @default.
- W2186446556 hasConceptScore W2186446556C45235069 @default.
- W2186446556 hasConceptScore W2186446556C52130261 @default.
- W2186446556 hasConceptScore W2186446556C56666940 @default.
- W2186446556 hasConceptScore W2186446556C77088390 @default.
- W2186446556 hasLocation W21864465561 @default.
- W2186446556 hasOpenAccess W2186446556 @default.
- W2186446556 hasPrimaryLocation W21864465561 @default.
- W2186446556 hasRelatedWork W181964719 @default.
- W2186446556 hasRelatedWork W1829508832 @default.
- W2186446556 hasRelatedWork W2121132331 @default.
- W2186446556 hasRelatedWork W2181521621 @default.
- W2186446556 hasRelatedWork W2181967329 @default.
- W2186446556 hasRelatedWork W2184400348 @default.
- W2186446556 hasRelatedWork W2280320185 @default.
- W2186446556 hasRelatedWork W2481475473 @default.
- W2186446556 hasRelatedWork W2803549066 @default.
- W2186446556 hasRelatedWork W285199644 @default.
- W2186446556 hasRelatedWork W2908784132 @default.
- W2186446556 hasRelatedWork W2911130610 @default.
- W2186446556 hasRelatedWork W3143716751 @default.
- W2186446556 hasRelatedWork W2821537456 @default.
- W2186446556 hasRelatedWork W2908685000 @default.
- W2186446556 hasRelatedWork W2909453662 @default.
- W2186446556 hasRelatedWork W2909711766 @default.
- W2186446556 hasRelatedWork W2910503567 @default.
- W2186446556 hasRelatedWork W2910640051 @default.
- W2186446556 hasRelatedWork W2910928865 @default.
- W2186446556 isParatext "false" @default.
- W2186446556 isRetracted "false" @default.
- W2186446556 magId "2186446556" @default.
- W2186446556 workType "article" @default.