I am importing a dataset in Enterprise Miner which contains interval values. However, all the decimal points is formatted using ',' as opposed to '.', e.g. "42,0", so it could not accept it as interval. Is there a way to change the formatting of the decimals to '.' and change the nominal to interval variables for all the columns that has this problem? I have the example dataset attached. Edit: I have tried using the SAS code node and inputted this code: data &EM_EXPORT_TRAIN; set &EM_IMPORT_DATA; array vars [*] _character_; do i = 1 to dim(vars); vars[i] = compress(tranwrd(vars[i],"a","X")); end; drop i; run;  It changed all the ',' to '.', however I still do not know how to proceed as the next step shows error and the supposedly numerical variables are still counted as nominal. ... View more

Hello, I'm still relatively new to SAS. I got a dataset which needs to be cleaned. The dataset has several rows shifted to the left, so for example the age is in the name column, etc. Example: ID Name Age Sex 1001 Marcel 20 M . 25 M . Desired output: ID Name Age Sex 1001 Marcel 20 M . . 25 M How can I shift the affected rows to the right? Missing values are allowed. Thanks before.   Edit: I attached the Listings.csv dataset that I was given to be cleaned up and analyzed. I noticed some strange values in neighbourhood_group column and after looking at the records, I recognized that those records are shifted. The reason I want to shift these records is to retrieve any valuable data for analysis from these records to get a more accurate result. ... View more