Equivalent of split by in JMP to Base SAS

[triunk]

Hello SAS users:

A message from jmp lover cheating with base SAS: 

JMP has an option in Tables that is called "Split by" where you can split a column, mapping several rows on one column to one row in several columns.

Any examples on how to do the same thing in SAS?

[Reeza]

I think this is a TRANSPOSE task or PROC TRANSPOSE if I understand what you want correctly.

https://stats.idre.ucla.edu/sas/modules/how-to-reshape-data-long-to-wide-using-proc-transpose/

[PeterClemmensen]

What does "split a column" mean? 🙂

[triunk]

Wow that was fast response - thank you!

This is what JMP means by split by

https://www.jmp.com/support/help/14/split-columns.shtml

and this is the different feature they have on transpose

https://www.jmp.com/support/help/14/transpose-rows-and-columns.shtml

I think both concepts are related but there are subtle differences

[SuryaKiran]

It would be better if you can provide a sample data you have and how JMP "split by", so that someone here can give you the same result in SAS using your sample data as source.

[triunk]

Here is an example from JMP webpage:

https://www.jmp.com/support/help/14/examples-of-splitting-columns.shtml

Here is JSL

Data Table( "Popcorn" ) << Split(
Split By( :trial ),
Split( :yield ),
Group( :popcorn ),
Sort by Column Property
)

[SuryaKiran · Accepted solution]

I was able to get the example popcorn.jmp data and here is the SAS version of "Split by" as @Reeza mentioning. 

data popcorn;
infile datalines dlm='09'x missover;
input popcorn:$8.	oil_amt :$8.	batch:$8.	yield	trial;
datalines;
gourmet	little	large	8.2	2
gourmet	little	large	8.6	1
gourmet	little	small	12.1	1
gourmet	little	small	15.9	2
gourmet	lots	large	9.2	1
gourmet	lots	large	9.8	2
gourmet	lots	small	16	2
gourmet	lots	small	18	1
plain	little	large	8.2	1
plain	little	large	8.8	2
plain	little	small	9.9	1
plain	little	small	10.1	2
plain	lots	large	8.8	2
plain	lots	large	10.4	1
plain	lots	small	7.4	2
plain	lots	small	10.6	1
;
run;

PROC SORT DATA=POPCORN;
BY popcorn	oil_amt	batch	yield	;
RUN;
PROC TRANSPOSE DATA=POPCORN OUT=TRANSPOSE(drop=_name_ ) ;
BY popcorn	oil_amt	batch;
iD trial;
var yield;
RUN;

 

[Reeza]

I think that’s PROC TRANSPOSE or the TRANSPOSE task. 

To get the second one, don’t include any of the options. 

[triunk]

So in SAS PROC TRANSPOSE does both jobs of split by and transpose interesting!

Thank you!