Data Processing and Visualisation 2400-ZEWW182
The course is intended for individuals with basic knowledge of IT tools and who have completed the "Computer Science Fundamentals" course.
1. Data processing in 4GL – 4GL syntax, SAS libraries, the main loop, and the PDV vector.
2. Data processing – continued – reading data stored in other formats (Excel, Access, XML, Oracle, etc.).
3. Creating your own program code – data and proc steps, saving data to sets in other formats, ODS technology.
4. Data aggregation techniques, group processing, data conversion, and set transposition.
5. Set merging techniques, using and creating formats, informats, sorting sets, and indexes.
6. Data processing in SQL – basic queries, data aggregation, calculated items, and query nesting.
7. Data processing in SQL - combining sets, creating and modifying sets (tables) and views (views), using SQL queries in SAS Viya.
8. Data processing procedures and instructions: merge, set, import, export, content, format, print, plot, sort, infile, input, put, datalines.
9. Advanced data processing procedures and instructions.
10. Data aggregation procedures: freq, means, univariate, and others.
11. Graphical data visualization in SAS Viya, SAS Enterprise Guide, and SAS Add-In.
12. Publishing and presenting analysis results within the enterprise, using multidimensional structures, creating reports, using email in 4GL, programs stored on the server, and interoperability with office applications (Word, Excel).
13. Advanced techniques for reading and combining sets - referencing selected observations, concatenation of sets.
14. The process of creating programs that extend the system's capabilities.
15. A test-based assessment.
|
Term 2025Z:
None |
Type of course
Prerequisites (description)
Course coordinators
Learning outcomes
KNOWLEDGE
The student has knowledge of data processing and visualization, and is familiar with database processing methods, data set merging techniques, data aggregation, and data transposition. The student is familiar with procedures and instructions for data processing and aggregation. The student is familiar with multidimensional data analysis techniques.
The student knows and understands the basic programming constructs used in the 4GL language, including variables, functions, loops, and macros. The student has knowledge of the basics of SQL.
SKILLS
The student has the ability to create, modify, and combine data sets using the 4GL and SQL languages. The student is able to write programs that query databases in the 4GL and SQL languages. The student is able to analyze the correctness of code execution.
The student is able to create data processing programs in the 4GL and SQL languages. They are also able to test their correctness, analyze errors, and modify them. The student is able to read code written in the 4GL and SQL languages and explain its operation. The student is able to develop a data processing algorithm.
SOCIAL COMPETENCES
The student understands the role and importance of data processing. The student is able to identify the economic benefits of data processing and visualization. The student understands the importance of 4GL and SQL languages, which streamline data processing and facilitate analysis. The student is aware of the need to expand their knowledge. The student is aware of the role played by computer systems supporting data management processes.
Assessment criteria
The course is graded based on approximately seven short tests and activities completed online during the course, or equivalently, on a final test completed in the IT lab during the final class.
The grade obtained based on the tests and activities completed online may be improved. Students may take the final test or, in consultation with the instructor, prepare an additional project on data processing in SAS 4GL and SQL.
Bibliography
1. Painless Windows: A Handbook for SAS Users, Third Edition, Jodie Gilmore
2. The Little SAS Book: A Primer, Third Edition, Lora D. Delwiche, Susan J. Slaughter
3. SAS Programming by Example, Ron Cody, Ray Pass
4. SAS Functions by Example, Ron Cody
5. SAS Certification Prep Guide: Base Programming SAS
6. https://support.sas.com/en/knowledge-base.html
7. SAS OnLineDoc
Supporting materials for classes published on the e-learning platform https://elearning.wne.uw.edu.pl/
|
Term 2025Z:
None |
Additional information
Additional information (registration calendar, class conductors, localization and schedules of classes), might be available in the USOSweb system: