SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

How to read and create new variable between two specific character variable values

Reply
N/A
Posts: 1

How to read and create new variable between two specific character variable values

I have txt files, Which has indexes and description, So i want to create index as variable and description as a variable value, i have same indexes on all txt files but different descriptions.

This is Sample txt file,

------------------------------------------------------------------

Profile Information

This is demo line to show the idea of my data

This is demo line to show the idea of my data,demo demo demo

This is demo line to show the idea of my dataThis is demo line to show the idea of my dataThis is demo line to show the idea of my dataThis is demo line to show the idea of my dataThis is demo line to show the idea of my dataThis is demo line to show the idea of my dataThis is demo line to show the idea of my dataThis is demo line to show the idea of my dataThis is demo line to show the idea of my dataThis is demo line to show the idea of my dataThis is demo line to show the idea of my dataThis is demo line to show the idea of my dataThis is demo line to show the idea of my data,demo demo

Work Information

This is demo line to show the idea of my data

This is demo line to show the idea of my data,demo demo demo

This is demo line to show the idea of my dataThis is demo line

how the idea of my dataThis is demo line to show the idea of my data

This is demo line to show the idea of my dataThis is demo line to show the idea of my data

This is demo line to show the idea of my dataThis is demo line to show the idea of my dataThis is demo line to show the idea of my dataThis is demo line


---------------------------------------------------------------------------------------------------------

My Output should be like this>>>>


Profile Information       |    Work Information

(Description of profile information)    | (Description of work information)

Super User
Posts: 5,260

Re: How to read and create new variable between two specific character variable values

Plain text isn't really a SAS killer app, unless you are into text mining.

Your sample data is quite confusing.

And what is your output? A database table or a report?

Do you consider all lines of data as one block of information (variable in SAS), or is each line a separate item.

If the later, you need some measure to match the profile line with its corresponding Work line...or...?

Data never sleeps
Ask a Question
Discussion stats
  • 1 reply
  • 223 views
  • 0 likes
  • 2 in conversation