JSL Import CSV - change column data type to numeric

pii — Tue, 04 Jun 2019 16:20:56 GMT

Dear all,

First of all thank you for your support.

I am just getting started with JMP and am already facing the first challenge. I want to import multiple csv files( Pick file, multiple...) and want to concancate them into one. So far so good... As i wanted to run my first analysis, I checked the data types of the columns. Turns out I need to change the data type. I checked the column properties and tried to change the data type manually and by JSL. The result are empty cells with just a dot...not possible to further process the data. The values of the column contain mixed integers and float numbers.

Any ideas how to solve this issue?

Cheers

Martin

Re: JSL Import CSV - change column data type to numeric

SAS_Cares — Wed, 05 Jun 2019 14:01:42 GMT

Note that JMP has its own user community boards here https://community.jmp.com/ This discussion post may be helpful to you https://community.jmp.com/t5/JMP-Scripts/Combine-multiple-txt-or-csv-files/ta-p/24083

topic Re: JSL Import CSV - change column data type to numeric in New SAS User

JSL Import CSV - change column data type to numeric

Re: JSL Import CSV - change column data type to numeric