CORNELLSASLAB

SAS output to EXCEL converter for Cornell/MIT Language and acquisition lab

Instructions:

This python code can be used to convert SAS outputs from the lang and ac lab into data tables for regression and factorial summaries. SAS formst varies by run, therefore you may have to do a little editing before the code works.

For example, a working data chunk for this program would look something like this:

                  Differences of CHILDAGE*TASK*TR Least Squares Means

                                                     Standard
CHILDAGE  TASK  TR  _CHILDAGE  _TASK  _TR  Estimate     Error     DF  t Value  Pr > |t|

1         2     1   8          1      1     -0.4167    0.1251   1544    -3.33    0.0009
1         2     1   8          1      2     -0.2917    0.1251   1544    -2.33    0.0199
1         2     2   7          2      3     -0.4375    0.1363   1544    -3.21    0.0014
1         2     2   8          1      1     -0.4583    0.1251   1544    -3.66    0.0003

The SAS System 15:01 Sunday, August 4, 2019 139

                                 The GLIMMIX Procedure

                  Differences of CHILDAGE*TASK*TR Least Squares Means

                                                     Standard
CHILDAGE  TASK  TR  _CHILDAGE  _TASK  _TR  Estimate     Error     DF  t Value  Pr > |t|

1         2     2   8          1      2     -0.3333    0.1251   1544    -2.66    0.0078
1         2     2   8          1      3     -0.5625    0.1251   1544    -4.50    <.0001
1         2     2   8          2      1     -0.5833    0.1363   1544    -4.28    <.0001
1         2     3   7          2      3     -0.4167    0.1363   1544    -3.06    0.0023
1         2     3   8          1      1     -0.4375    0.1251   1544    -3.50    0.0005
1         2     3   8          1      2     -0.3125    0.1251   1544    -2.50    0.0126
1         2     3   8          1      3     -0.5417    0.1251   1544    -4.33    <.0001

The SAS System 15:01 Sunday, August 4, 2019 140

                                 The GLIMMIX Procedure

                  Differences of CHILDAGE*TASK*TR Least Squares Means

                                                     Standard
CHILDAGE  TASK  TR  _CHILDAGE  _TASK  _TR  Estimate     Error     DF  t Value  Pr > |t|

1         2     3   8          2      1     -0.5625    0.1363   1544    -4.13    <.0001
1         2     3   8          2      2     -0.5208    0.1363   1544    -3.82    0.0001
1         2     3   8          2      3     -0.4583    0.1363   1544    -3.36    0.0008
2         1     1   2          1      2    6.66E-16   0.07654   1544     0.00    1.0000
2         1     1   2          1      3    -0.08333   0.07654   1544    -1.09    0.2764
2         1     1   8          2      1     -0.4583    0.1251   1544    -3.66    0.0003
2         1     1   8          2      2     -0.4167    0.1251   1544    -3.33    0.0009
2         1     1   8          2      3     -0.3542    0.1251   1544    -2.83    0.0047

The SAS System 15:01 Sunday, August 4, 2019 141

As you can see, every chunk starts with the same title, and ends with a date and page number in the bottom right corner. All of the chunks have the same format and same number of columns. If the format of the pasted chunks is wrong, the code likely won't work.

NOTE: when pasting the file path to your excel document, make sure excel is not running on your computer, or else there will be an error.

SAS output to EXCEL converter for Cornell/MIT Language and acquisition lab

Related tags

Overview

CORNELLSASLAB

Owner

Focal and Global Knowledge Distillation for Detectors

A PyTorch implementation of the continual learning experiments with deep neural networks

Implementation of BI-RADS-BERT & The Advantages of Section Tokenization.

GRF: Learning a General Radiance Field for 3D Representation and Rendering

Python interface for the DIGIT tactile sensor

Pytorch implementation of our paper accepted by NeurIPS 2021 -- Revisiting Discriminator in GAN Compression: A Generator-discriminator Cooperative Compression Scheme

RefineNet: Multi-Path Refinement Networks for High-Resolution Semantic Segmentation

Enabling Lightweight Fine-tuning for Pre-trained Language Model Compression based on Matrix Product Operators

A repo for Causal Imitation Learning under Temporally Correlated Noise

Happywhale - Whale and Dolphin Identification Silver🥈 Solution (26/1588)

Anatomy of Matplotlib -- tutorial developed for the SciPy conference

A commany has recently introduced a new type of bidding, the average bidding, as an alternative to the bid given to the current maximum bidding

An official implementation of "SFNet: Learning Object-aware Semantic Correspondence" (CVPR 2019, TPAMI 2020) in PyTorch.

This application is the basic of automated online-class-joiner(for YıldızEdu) within the right time. Gets the ZOOM link by scheduled date and time.

Face Mask Detector by live camera using tensorflow-keras, openCV and Python

Picasso: a methods for embedding points in 2D in a way that respects distances while fitting a user-specified shape.

Code for "Learning Canonical Representations for Scene Graph to Image Generation", Herzig & Bar et al., ECCV2020

[ICCV 2021] FaPN: Feature-aligned Pyramid Network for Dense Image Prediction

Data-depth-inference - Data depth inference with python

GCC: Graph Contrastive Coding for Graph Neural Network Pre-Training @ KDD 2020