# Posts Tagged ‘ proc transpose ’

## Import Excel data, transpose, and plot it!

July 20, 2018
By

Of course you know how to create graphs ... But do you often find that preparing the data to plot is often the hardest part? Well then, this blog post is for you! I'll be demonstrating how to import Excel data into SAS, transpose the data, use what wer...

Tags: , , , , ,
Posted in SAS | Comments Off on Import Excel data, transpose, and plot it!

## “Wide” versus “Tall” data: PROC TRANSPOSE v. the DATA step

May 7, 2018
By

Datasets can present themselves in different ways. Identical data can bet arranged differently, often as wide or tall datasets. Generally, the tall dataset is better. Learn how to convert wide data into tall data with PROC TRANSPOSE. The post "Wid...

Tags: , , , ,
Posted in SAS | Comments Off on “Wide” versus “Tall” data: PROC TRANSPOSE v. the DATA step

## Example 2014.13: Statistics doesn’t have to be so hard! Resampling in R and SAS

November 17, 2014
By

A recent post pointed us to a great talk that elegantly described how inferences from a trial could be analyzed with a purely resampling-based approach. The talk uses data from a paper that considered the association between beer consumption and mosqu...

Tags: , , , ,
Posted in SAS | Comments Off on Example 2014.13: Statistics doesn’t have to be so hard! Resampling in R and SAS

## Example 2014.12: Changing repeated measures data from wide to narrow format

October 21, 2014
By

Data with repeated measures often come to us in the "wide" format, as shown below for the HELP data set we use in our book. Here we show just an ID, the CESD depression measure from four follow-up assessments, plus the baseline CESD.

`Obs    ID    CESD1 ...Read more »        `

Tags: , , , , , , ,
Posted in SAS | Comments Off on Example 2014.12: Changing repeated measures data from wide to narrow format

## Example 2014.1: "Power" for a binomial probability, plus: News!

January 14, 2014
By

Hello, folks! I'm pleased to report that Nick and I have turned in the manuscript for the second edition of SAS and R: Data Management, Statistical Analysis, and Graphics. It should be available this summer. New material includes some of our more po...

Tags: , , , , , ,
Posted in SAS | Comments Off on Example 2014.1: "Power" for a binomial probability, plus: News!

## Example 9.32: Multiple testing simulation

May 21, 2012
By

In examples 9.30 and 9.31 we explored corrections for multiple testing and then extracting p-values adjusted by the Benjamini and Hochberg (or FDR) procedure. In this post we'll develop a simulation to explore the impact of "strong" and "weak" control...

Tags: , , , , , , ,
Posted in SAS | Comments Off on Example 9.32: Multiple testing simulation

## A two-step transpose approach to reshape data

January 21, 2011
By

New in SAS 9.2, the TRANSPOSE procedure accepts multiple IDs in its ID statement. More than one IDs would automatically concatenate together as the new variable names. Previously, Proc Transpose usually only allows one ID. As the result, the concatena...

Tags: ,
Posted in SAS | Comments Off on A two-step transpose approach to reshape data

## My answer to a complex transpose question from SAS-L

June 16, 2010
By

The question is raised from http://www.listserv.uga.edu/cgi-bin/wa?A2=ind1005d&L=sas-l&F=&S=&P=11947proc sort data=indat out=one; by subjid vist;run;proc transpose data=one out=two ; var result; by subjid vist; run;proc transpose data=o...

Tags: ,
Posted in SAS | Comments Off on My answer to a complex transpose question from SAS-L

## Welcome!

SAS-X.com offers news and tutorials about the various SAS® software packages, contributed by bloggers. You are welcome to subscribe to e-mail updates, or add your SAS-blog to the site.