sas tools employed in analysing import activity influences on … · sas tools employed in...
TRANSCRIPT
SAS tools employed in analysingSAS tools employed in analysingimport activity influences on the homeimport activity influences on the home
market based on the customs entrymarket based on the customs entrydeclarationsdeclarations
Paweł TrembaczCentral Board of Customs
Subject
Sebastian ProtBazy i Systemy Bankowe
2
Bazy i Systemy Bankowe
COMPUTING SERVICES• Projects, execution, implementation
• Outsourcing• Software and Hardware Backup
• IT Security• Technical Service
• Consulting and Training
Central Board of Customs
CUSTOM ANALYSIS AND STATISTICS• Data Collecting• Analysis and Forecast Study
4
! Introduction
! Actual data source
! Information demand
!Research Application „SAD Analysis”! SAS Tools Employment
! Application Development
! Benefits
Agenda
5
Introduction
Goal
! Information For Government Administration
Execution
! Information Collecting and Monitoring
7
Actual Data Source
Central Statistical Office (GUS) has been the source of
foreign trade turnover data until now.
8
Actual Data Source
! statistical forms of SAD documents sending
! data conversion of SAD documents to a file system
! verifying data in their paper format
! verified data conversion to a file system
! data file verification
! reporting
9
Actual Data Source
Central StatisticalOffice
Customs Office
CentralBoard of Customs
Sending of statistical forms
Conversion to a file system
Files sending
Sending of correction forms
Correction files sendingList of error data
Statistical Office
Verification
Customs Office Customs Office
10
Actual Data Source
Getting the Information from the Central Statistical Office
in that way takes about 90 days following a particular
reports time.
13
Demand for Information
Information scope:
! imported goods - type trends
! directions of goods flow
! trends in (increasing / decreasing) customs duties andtaxes value
! detailed information about Customs Administration, i.e.
– amount of customs declarations
– value of goods cleared
– duties
14
Demand for Information
The best solution for creating and using of foreign tradeturnover data bases was looked for among differentsystems. The system was required to provide:
• the short waiting time for query
• effectiveness of searching
• good tools for representing final results.
17
The main goals of the application are: „ data collecting and
processing”, „data analysis”, „ data reporting”.
Research Application „SAD Analysis”
18
Text files (SAD, SAD correction) are the main data sources
to create collective SAS data base. Central Board of
Customs gets these text files from Central Statistical Office.
Research Application „SAD Analysis”
SAS TXT Files
Data supply
19
Basic Functions:
! data base supply
! correction of supplied data
! analysis and dynamic generation of forms
Research Application „SAD Analysis”
20
Application allows:
! searching for information according to the specificparameters and accumulation on different levels
! applying specific parameters to all fields of SAD forms
! calculating of statistical values
! looking through individual documents
! looking through detailed good items
Research Application „SAD Analysis”
26
Actual SAS data base
! contains
– 19 customs offices
– 12 months of 1999.
! contains
– 40.300.000 records
– 5,5GB
„SAD Analysis” PRESENTATION
28
SAS Tools Employment
SERVER:
! SAS/BASE
! SAS/FSP
! SAS/CONNECT
! SAS/ACCESS to PC File Formats
! SAS/SHARE
29
USER WORKSTATION:
! SAS/BASE
! SAS/FSP
! SAS/CONNECT
! SAS/AF
! SAS/EIS
! SAS/ASSIST
! SAS/GRAPH
SAS Tools Employment
30
Application advantages:
! multidimensional reports generating
! information monitoring
! information visualisation by different types of diagramsand charts
! information reporting
! Central Board of Customs - other departments
! Customs Offices
! other recipients (Ministry of Finance, Police, InternalRevenue)
SAS Tools Employment
31
! automate data processing
! convert data into easy to understand information
! get the information rapidly
! analyse collective data
! report and present information as diagrams and charts
Application of the SAS Tools makes it possible to:
SAS Tools Employment
33
Benefits
! On line access to collected data both individual andaccumulated ones
! Quicker decision making process on the management aswell as the operation level.
! Monitoring of functionality of particular CustomsAdministration units.
! Investigating trends of goods flow and their results -forecasting
! Revealing dangers
35
Development View
! Application functionality - „SAD Analysis”
! Reporting system and CustomsAdministration
36
Development View
! Application functionality - „SAD Analysis”
! Change of supplying source - automatic supply fromtransaction system.
! Additional sources of data
! Functionality, monitoring, forecast.