topic Re: Text to Column using EG in SAS Enterprise Guide

Text to Column using EG

gregor1 — Thu, 23 Jun 2016 19:46:51 GMT

I ran a query that returns a column of data that I want to go from text to column (much like I can do in Excel). For example, the returned data looks like this: "NV District 600" (all listed as one piece of data in a single column). However, I really only want the "NV" as a single piece of data in it's own column, the "District" as another piece of data in it's own column, and the "600" as a single piece of data in it's own column. What is the best way to accomplish this in EG?

Re: Text to Column using EG

Reeza — Thu, 23 Jun 2016 19:54:02 GMT

If you have a clear delimiter I'd use the scan function.

You can create a calculated column in query builder and use scan function.

If your data will have a variable number of items, a different method will be required.

Re: Text to Column using EG

gregor1 — Thu, 23 Jun 2016 20:17:41 GMT

Perfect! That is what I was looking for Reeza. I need to remember the SCAN function...Thanks!!