A
A
Andrey2020-06-05 13:10:11
excel
Andrey, 2020-06-05 13:10:11

Sas enterprise guide. How to split a cell into multiple lines?

During the import (not by code, but by built-in import), an excel table of 5 columns was imported into sas eg (let's conditionally denote the work.sheet1 table, columns f1-f5). Column 4 contains data whose delimiter is a space.
It is necessary to create a work.sheet2 table in which you need to split the cells in column f4 according to the separator into several lines, but so that the lines include all the other columns f1, f2, f3, f5. Actually, this is how the split cells function works in excel, only columns are created there, and here you need to multiply the rows.

Answer the question

In order to leave comments, you need to log in

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question