Read SAS files in the sas7bdat data format
In context of Clinical Development in Pharma, SAS is very much used for statistical analysis and preparation of datasets for submission. The submission datasets with the final results of a clinical trial are created as
Git integration for Datamart
Datamart (preview) is a great feature to enable business user-driven creation of data models and provisioning of data for reports.
With the recent introduction of Git integration of workspaces, it would be fantastic if also Datamarts could be stored and traced and reviewed in ...
Statistical functions as Direct Query
Statistical functions like mean and percentile calculations are very helpful to get an overview about distributions of a numeric attribute and to identify outliers.
Most databases support mean and percentile as SQL aggregations or window functions like SQL Server, HANA, Oracle...