Fraud Blocker
Hopp til innholdet

Stat/Transfer

Stat/Transfer flytter data mellom regneark, databaser og statistikkprogrammer

Stat/Transfer sørger for rask, pålitelig og praktisk dataoverføring mellom statistikkpakker, databaser og regneark for tusenvis av brukere over hele verden. Stat/Transfer gjør jobben enkel fordi det har kunnskap om statistiske data - det håndterer manglende data, verdi- og variabeletiketter og alle de andre små detaljene, slik at du kan flytte så mye informasjon som mulig fra ett filformat til et annet.

  • Nøyaktig
    Flytter data fra ett program til et annet uten tap av presisjon.
  • Pålitelig
    Ledende forskere, universiteter, offentlige etater og programvareutviklere bruker stat/Transfer.
  • Rask
    De fleste overføringsoperasjoner tar noen sekunder og noen få museklikk.
  • Easy to use
    Raske overføringer er ikke raske hvis du bruker tid på å lure på hvordan du skal sette dem opp.
  • Reproduserbar
    Stat/Transfer kan automatisk skrive et program som reproduserer overføringen din.

Stat/Transfer har et brukervennlig menygrensesnitt og en kraftig batchfunksjon. Enten du skal flytte en enkel tabell fra Excel til SAS eller flytte megabyte med undersøkelsesdata mellom statistikkpakker, vil du spare både tid og penger.

Info

Hva er Stat/Transfer?

Stat/Transfer OEM Customers

Nøyaktig

Stat/Transfer flytter dataene dine fra ett program til et annet uten tap av presisjon, samtidig som du produserer så små datasett som mulig. Metadataene dine - verdietiketter, variabeletiketter og manglende verdier - blir nøyaktig og enkelt transformert.

Rask

De fleste overføringsoperasjoner tar noen få sekunder og noen få museklikk. Du kan selvfølgelig bruke andre verktøy for å gjøre det samme som Stat/Transfer, men det vil ta deg timer, dager eller til og med uker å kopiere det Stat/Transfer gjør på noen få sekunder. Hva er tiden din verdt?

Enkel å bruke

Raske overføringer er ikke raske hvis du bruker tid på å diskutere hvordan de skal settes opp. Med Stat/Transfers intuitive brukergrensesnitt kan de fleste overføringer utføres med bare noen få museklikk. For mer kompliserte operasjoner er kontekstsensitiv hjelp bare et klikk unna. Det er utformet fra topp til bunn for å spare deg for verdifull tid.

Fleksibel

Med Stat/Transfer kan du produsere akkurat de resultatene du trenger. Det er enkelt å velge variabler, tilfeller og datatyper. En rekke alternativer (alle med fornuftige standardverdier) gjør at du kan skreddersy overføringen slik at den passer til dine nåværende og fremtidige behov.

Reproduserbar

Stat/Transfer kan automatisk produsere en logg som dokumenterer overføringen. Den kan også produsere en kommandoprocessorfil som gjør det mulig å kjøre overføringen på nytt med bare noen få klikk. Fordi programmet gjenspeiler alle opsjonsinnstillingene og all annen informasjon som er lagt inn i brukergrensesnittet, kan du dokumentere dataoverføringen på en grundig måte.

Supported Formats

1-2-3 Files
Stat/Transfer will read files from any version of 1-2-3. It writes Version One files, which can be read by any version of 1-2-3. These were once a universal format for PC software data interchange. Multiple page worksheets are supported on input.

Access (Windows only)
Stat/Transfer will read and write Microsoft Access databases through the most current versions. Although the data are transferred through the Microsoft Access ODBC driver, Access files are treated like a normal Stat/Transfer file type. You can thus choose the file from the normal Open or Close dialog boxes, and you need not be concerned with the process of configuring an ODBC data source for each file.

Stat/Transfer can either read single tables or multiple tables that are joined in an Access “view”. On output, new data may be appended to an existing table, tables can be created in a new file, new tables can be created in an existing file, or existing tables can be overwritten with a new table.

Apache Big Data
Stat/Transfer will read data from the four leading Big Data formats or query engines: Drill, Hive, Impala and Parquet. These transfers rely on the corresponding ODBC drivers.

Apache Parquet
Stat/Transfer has native support for writing datasets to Parquet. These are readable by Apache Spark, Apache Arrow, TAD and the Parquet viewer. Snappy and gzip data compression are both available.

ASCII – Delimited
Stat/Transfer will read and write delimited data files.

When reading delimited files, you can specify that Stat/Transfer automatically determine if the first row contains variable names, or you can manually control how the first row of the data set will be treated. You can also explicitly specify the delimiter character or you can allow the program to sense it automatically. Numerous options are available for controlling how dates are read, and how text fields are quoted. There are numerous options for controlling the character sets in which data are read or written.

Stat/Transfer will also read and write delimited ASCII files with its own Schema file format. This format is extremely convenient to use and allows for the specification of missing values, value labels and variable labels. By writing and then reading back data in this format, you can exert tight control over such things as the order of the variables, their names, labels and their formats.

ASCII / Text – Fixed Format
Stat/Transfer will read and write fixed format files with its own Schema file format. This format is extremely convenient to use and allows for the specification of missing values, value labels and variable labels. Stat/Transfer can also write fixed format data with programs for SAS, SPSS, or Stata. These are extremely useful for archiving data or passing data to your colleagues.

BeyesiaLab
BeysiaLab is an environment for machine learning, simulation analytics and optimization. Stat/Transfer will write sets of ASCII files that are ready to be loaded into this program. In addition to the data, variable and value labels are transferred.

Data Documentation Initiative (DDI) Schemas
The Data Documentation Initiative (DDI) is an open, international effort to provide a standard way of describing data from the social, behavioral and economic sciences. DDI schemas are in XML and can describe metadata across the life-cycle from questionnaire design through analysis. Stat/Transfer supports version 3.1 of the specification and will read and write XML schemas and associated delimited data files.

Data Documentation Initiative (DDI) Codebooks
The DDI codebook specification is a lightweight version or the life-cycle specification that is designed to document individual data sets, such as simple survey data for exchange or archiving. Stat/Transfer will read and write these files along with their associated delimited data.  

dBASE, FoxPro (and Compatible) Files
Stat/Transfer reads and writes files that are compatible with all versions of dBASE and compatible programs such as Foxpro, Clipper, and Alpha Four.

Epi Info
Epi Info is a free statistical program developed by the Center for Disease Control. Stat/Transfer supports all versions through Version Six. Because the file format includes enough information for the program to construct a data entry screen, Stat/Transfer uses variable labels, if available, to label the entry fields.

EViews
EViews is a package for economic analysis, forecasting and simulation. Stat/Transfer supports all field types including numeric series and compressed numeric series. Data can be read from any version higher than six.

Excel
Stat/Transfer will read files written by all versions of Microsoft Excel. It writes Version 2.1 files, files for Excel 97-2003 and those for Excel 2007 and higher. Multiple page worksheets are supported. You can choose a page of a multiple page workbook with a single click of your mouse. Multiple worksheet pages in the input file can be combined into a single output file.

Feather
Feater is a fast on-disk format for data frames for R and Python.

Gauss
Stat/Transfer reads and writes Gauss’s universal file format in addition to the older Gauss 89 format used for Windows.

GenStat
Genstat is a comprehensive statistical and data management package. Stat/Transfer will read and write both compressed and uncompressed workbooks containing multiple spreadsheets.

gretl
Stat/Transfer reads and writes gretl cross-sectional data files.

HTML Tables
Stat/Transfer will write HTML tables for use in Web pages.

JMP
Stat/Transfer fully supports files written on either the Windows or Macintosh platforms. All versions are supported as well as all of the newer numeric types.

JSON-Stat
The JSON-Stat format provides a simple, lightweight representation of tabular data. It is used by many national statistical agencies for data dissemination. Stat/Transfer support reading only. Version one and two are supported.

LIMDEP
Stat/Transfer reads and writes the native internal file format of all versions of LIMDEP for Windows.

Matlab
Matrices from all versions of Windows, Macintosh, and Unix Matlab are supported. Matlab datasets are supported for versions greater than seven.

Mineset
Stat/Transfer reads and writes portable files for this data visualization package developed by Silicon Graphics.

Minitab
Stat/Transfer reads worksheets from any version of Minitab through Version Twenty. It will also read and write Version 19 Project Files. It fully supports the newer Date and Date/Time types. Minitab 20 project and worksheet files are fully supported for reading.

Mplus
Stat/Transfer supports exporting to Mplus for Windows.

NLOGIT
Stat/Transfer supports all versions of NLOGIT for Windows.

ODBC
Stat/Transfer can read or write data to any file type for which you have, or can obtain, an ODBC driver. These include such relational databases as Oracle, SQL Server, MySQL, Sybase, DB2 or Informix, or flat-file databases such as Btrieve. Apache Big Data formats, such as Drill, Hive, Impala and Parquet are supported through ODBC. When you select ODBC as an input or output file type, Stat/Transfer will present a list of installed data sources, instead of the Open or Save dialog boxes. If a password or other information is needed, you will be prompted automatically. You can also submit SQL for specialized transfers.

The Stat/Transfer command processor allows you to save connection information, so you can automate ODBC transfers.

OpenDocument Spreadsheets
The OpenDocument format for spreadsheets is an ISO standard XML format for spreadsheet data. It is supported by numerous applications, including OpenOffice.org, LibreOffice, and Google Docs. Stat/Transfer will read and write files compatable with all of these applications. The implementation is fully equivalent to that of Excel, and supports multiple sheets, range selections and all other options.

OSIRIS
Because of the quantity of early survey data data available in this now-obsolete format, Stat/Transfer offers read-only access to OSIRIS files. Variable and value labels are fully supported and Stat/Transfer can automatically read your data whether they are in EBCDIC or ASCII format.

Paradox
Stat/Transfer reads all versions of Paradox and writes Version 7 through 9 files.

Quattro Pro
All versions of Quattro Pro are supported. Stat/Transfer allows the selection of data from individual pages of a multiple page worksheet.

R
Stat/Transfer will read and write workspace files for all versions of R, as well as reading and writing single object rds files. Data can also be written to r tibbles for improved support of value and variable labels.

RATS
RATS (Regression Analysis of Timeseries), is a general-purpose econometric and time series analysis package. Stat/Transfer can read and write RATS version 7 files.

SAS Data Files
Stat/Transfer will read and write SAS Versions 6 through 9 data files for Windows and Unix platforms . For version 7 and above, all common data representations are supported. Obsolete PC/DOS files are supported on input.

SAS Program Files
Stat/Transfer can write data to fixed format ASCII files, together with a program file that can be used to read the data into SAS. A corresponding read feature supports the most common language elements that are used to describe data and which are used by data libraries for distribution.

SAS Value Labels
Stat/Transfer will transport value labels out of SAS for such packages as SPSS and Stata, and will, in addition, write a PROC FORMAT program for reading value labels from other packages into SAS. This feature is also handy if you are sending a SAS file with value labels to another user and do not want to send a whole format catalog. New in version 14, is the ability to write native SAS catalogs for Windows.

Value labels can be read from catalogs, CPORT files, SAS data files, and from transport files.

SAS CPORT Files
Stat/Transfer will read, but not write, Windows CPORT files for versions higher than SAS Seven.

SAS Transport Files
These files, which can be read or written by SAS’s XPORT engine, provide a convenient way to move data from mainframe SAS and other versions for which direct data file support is not provided. They have the distinct advantage of being readable by any version of SAS and of being the standard format for the submission of data to the FDA.

Version 17 of Stat/Transfer add supports for for Version 8 of this format. While less widely used, this format supports longer variable names and string values.

S-Plus
Stat/Transfer reads S-Plus matrices, lists and dataframes. It writes dataframes. Files can be read and written that are compatible with both Windows and Unix S-Plus versions.

SPSS Data Files
You can read and write SPSS native data files for Windows, Macintosh, and Unix platforms. Stat/Transfer supports all of the features in these files such as value and variable labels. It will read both compressed and uncompressed files and writes the smallest possible compressed data files. Stat/Transfer can read Version 21 compressed, .gsav files.

SPSS Portable Files
The Portable file format provides a convenient way to move data from your older mainframe systems. Stat/Transfer supports all of its features including value and variable labels and multiple missing values.

SPSS Syntax Files
Stat/Transfer can write data to fixed format ASCII files, together with a syntax file that can be used to read the data into SPSS. All features, including value labels and user missing data are supported. A corresponding read feature supports the most common language elements that are used to describe data and which are used by data libraries for distribution.

Stata
Stata files are completely portable across platforms (the same file can be used on Unix, the PC and on the Mac.) Stat/Transfer can read all Stata files through the latest, and all versions of Stata can read the files that Stat/Transfer writes. All features are supported, including value and variable labels, extended missing values and longer variable names. Variable length strings, or strls, for version 13 and above are supported for reading and writing. Older Stata file versions can optionally be written. For older versions, variable labels longer than Stata’s 80 character limit can be written to Stata “notes.”
Because Stata files are kept in memory, it is important to minimize the size of Stata datasets. With Stat/Transfer’s automatic optimization feature, you can be assured that you will have the smallest possible Stata file.

Statistica
Stat/Transfer fully supports Statistica Versions 5 and 7 through 14. Value and variable labels are fully supported, as are user-missing values.

SYSTAT
Stat/Transfer reads and writes files that are compatible with all versions of SYSTAT. All features, including subscripted variables, are supported.

Triple-S
Triple-S is an open standard for the interchange of data and metadata between survey research software packages. Stat/Transfer fully supports the latest XML Version 2.

Nyheter

Nye funksjoner i Stat/Transfer 17

Nye formater

  • SAS versjon 8 Transportfiler
  • Parkettfiler (skriving)
  • R Tibbles (skriving) for forbedret støtte for verdi- og variabeletiketter
  • R single object (RDS) filer (skriving)
  • JSON-stat V2-datasett (lesing)
  • Minitab 20 Project (MPX) filer (lesing)
  • Minitab 20 Worksheet (MWX)-filer (lesing)
  • Statistica 12-14
  • Data Documentation Initiative (DDI) Kodebøker og data

Det er ny støtte for lesing av Matlab-dato- og -klokkeslettstrenger, UTF16-tegnvektorer og matriser (cellearrayer som inneholder tegn- og tallvariabler).

Plattformstøtte

Stat/Transfer leveres nå med innebygd støtte for Mac M1-prosessorer og de nyeste versjonene av OS-X. Windows 11 støttes fullt ut.

Nye funksjoner i Stat/Transfer 16

Nye formater

Stat/Transfer versjon 16 støtter følgende nye formater:

  • Lesing av SPSS-syntaksfiler og ASCII-data
  • Lesing av SAS-programfiler og ASCII-data
  • Lese og skrive Minitab 19-prosjekt- og regnearkfiler
  • Lese de nyeste versjonene av Statistica.
  • Lesing av R-filer med enkeltobjekt (.rds)
  • Lesing av Apache Big Data gjennom ODBC-drivere for:
    – Drill
    – Hive
    – Impala
    – Parquet

Nye funksjoner i Stat/Transfer 16

  • Svært brukervennlige dato- og klokkeslettmasker i Stata-stil for lesing av ASCII-data
  • Lokaliserte månedsnavn for lesing av ikke-engelske datoer
  • Forbedret støtte for utvidede manglende verdier
  • Økt brukerkontroll over optimalisering av datasett
  • Økt brukerkontroll over håndteringen av nye linjer i ASCII-data
  • Støtte for verdier som mangler i Statistica

Støtte for ny plattform

Stat/Transfer leveres nå med innebygd støtte for Mac M1-prosessorer og full støtte for Big Sur og Monterey. Windows 11 støttes fullt ut.

Nyheter i Stat/Transfer 15

Formater i Stat/Transfer 15

Stat/Transfer versjon 15 støtter følgende nye formater:

  • Feather (det raske filformatet for R og Python)
  • Minitab-prosjektfiler (lesing)
  • R-tabeller (lesing)
  • R versjon 3+ (lesing)
  • R komprimert binær (skriving)
  • Stata versjon 16

Støtte for Mac Catalina

Full støtte for Catalina med kodelagring og 64-biters støtte. Versjoner av Stat/Transfer tidligere enn 15 er problematiske på dette nye operativsystemet.

Lisensiering av produksjon

Stat/Transfer er nå tilgjengelig på webservere, SaaS-miljøer og repeterende batchprosesser. Ta kontakt med salgsavdelingen vår for informasjon om produktlisensiering.

Nyheter i Stat/Transfer 14

Formater

Stat/Transfer versjon 14 har lagt til støtte for følgende formater:

  • Stata 15- 16/MP
  • BayesiaLab (kun skriving)
  • JSON-Stat (kun lesing)

Utvidet støtte for attributter

Metadata på variabel- og filnivå støttes nå for lesing og skriving fra følgende formater:

  • Stata 15- 16/MP
  • SAS (utvidede attributter)
  • Stata (egenskaper)
  • JMP (attributter)
  • ASCII - statistikk-/overføringsskjemaer

Forbedret SAS-støtte

  • Value Labels kan nå skrives direkte til SAS-katalogfiler i Windows (sas7cat)
  • Valgfri kontroll over dato, klokkeslett og dato og klokkeslettformater som brukes for skriving.
  • Alle SAS' dato- og tidsformater gjenkjennes ved lesing.
  • Etiketter for SAS' utvidede manglende verdier støttes nå.

Andre nye funksjoner i Stat/Transfer 14

  • Katalogrekursiv er nå tilgjengelig i jokertegn-kopikommandoen
  • Ekstra variabler kan opprettes fra arknavnet når du kombinerer regneark
  • Ekstra strengvariabler kan opprettes fra verdietiketter når du skriver til avgrenset ASCII, beskrevet av et skjema. Disse kan deretter leses tilbake i et hvilket som helst format.
  • Mye raskere lesing av R-filer.
  • Støtte for Postgres i ODBC.

Større grenser

  • Excel Files > 4 GB
  • SAS files > 32K variables
  • Stata Files > 32K variables
  • dBASE > 2GB

Systemkrav

Systemkrav

Maskinvare

  • Intel- eller AMD x86-64-prosessor
  • 20 MB ledig diskplass
  • En skjerm på minst 1024*786

Windows

  • Windows XP, 7, 8, 10 and 11
  • 64 or 32 bit
  • Intel- eller AMD x86-prosessor
  • 25 MB ledig diskplass
  • En skjerm på minst 1024*786

Apple Mac OS

  • Apple Mac OS 10.10 eller nyere, 11 eller 12.
  • Intel- eller Apple M1-prosessor
  • 20 MB ledig diskplass
  • En skjerm på minst 1024*786

Linux

  • 64 bit
  • Kernel 4.1 eller høyere
  • glibc 2.19 eller høyere
  • gtk 2.24 eller høyere

Dataformater som støttes

Lisensiering

Lisensalternativer

  • Enkeltbrukerlisens
  • Volum-/Flerbrukerlisenser
  • Flytende nettverkslisenser (samtidig bruk)
  • Organisasjons- og avdelingslisenser (Site)

Support

Ressurser

Vi anbefaler disse nettbaserte støttesidene og ressursene for å hjelpe deg med å få mest mulig ut av produktet ditt.

Support

Vi tilbyr teknisk støtte til alle Alfasoft-kunder. Vi anbefaler at du besøker vårt hjelpesenter og vår kunnskapsbase, der du finner nyttige ressurser, inkludert løsninger på vanlige problemer og en mengde tilleggsinformasjon.

Hvis du ikke finner svaret, kan du opprette en supporthenvendelse i hjelpesenteret. Når du oppretter en henvendelse, ber vi deg oppgi så mange detaljer som mulig. Detaljer hjelper oss med å forstå problemet bedre og gi en mer nøyaktig løsning. Husk alltid å oppgi informasjon om produktversjon og operativsystem.