DATA Step, Macro, Functions and more

Data transformation from rows to columns

Reply
N/A
Posts: 1

Data transformation from rows to columns

Hello,

I have a txt file that gives me the data as shown below, but even I try to import it into SAS JMP it only gave me two columns with the data. I'll like to know if there is  a way to use the first column as the column name and the second part after ":" as my data it self. I have multiple files and once I'm able to rearrange the data I'll concatenate them row after row.

Data from .txt:

Comment:         

Operator:           

BD:     D_C

TS:        2014-05-02T05:22:08.3119997

CFile:     C_2014_04_24-11_30_39_M2.ini

File:          20140423-PRD.ini

LTemp: 23.0

FCW:    

I :       -0.00047565

eta [%]:                NaN

M A [m2]:            0.65300

This is how I'll like to see it...

Comment:Operator:BD:TS:Cfile:File:Ltemp: FCW:Ieta[%]M A [m2]
D_C2014-05-02T05:22:08.3119997C_2014_04_24-11_30_39_M2.ini20140423-PDR.ini23NaN0.653

Thank you

Respected Advisor
Posts: 4,925

Re: Data transformation from rows to columns

If this is a question about JMP, you should post it to the JMP User Community at

Welcome | JMP User

PG

PG
Ask a Question
Discussion stats
  • 1 reply
  • 170 views
  • 3 likes
  • 2 in conversation