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

KaushalP — Fri, 28 Aug 2015 08:26:51 GMT

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)

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

LinusH — Fri, 28 Aug 2015 15:41:50 GMT

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...?

topic How to read and create new variable between two specific character variable values in SAS Data Management

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

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