cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
enigma84
‎09-01-2015
  • 3 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Data creation from raw text

by Calcite | Level 5 in SAS Programming
‎11-09-2014 12:27 PM
‎11-09-2014 12:27 PM
Hi Folks, Have attached 2 files, the txt file is a flat file which contains data in multiple rows. The good thing is that it is fixed width kind of a data. Have used input to gather information, but getting it beyond one row is turning out to be difficult. The way in which i need is in the attached excel. Will greatly appreciate any help. Regards, Ketan ... View more

Data manipulation issue

by Calcite | Level 5 in SAS Programming
‎11-03-2011 03:23 PM
‎11-03-2011 03:23 PM
Thanks...the way you did it is so simple...i was trying to complicate it by thinking about counting the commas and then creating variable basis highest number of occurence of comma...phew...thanks again ... View more

Data manipulation issue

by Calcite | Level 5 in SAS Programming
‎11-03-2011 03:01 PM
‎11-03-2011 03:01 PM
Hi Guys, I am trying to convert one dataset into another (example given below) Input Data Name Age String John 28 A,BB Jack 25 M,BM,M4m,44,65 Jill 26 Output Data Name Age String_Old String_New John 28 A,BB A John 28 A,BB BB Jack 25 M,BM,M4m,44,65 M Jack 25 M,BM,M4m,44,65 BM Jack 25 M,BM,M4m,44,65 M4m Jack 25 M,BM,M4m,44,65 44 Jack 25 M,BM,M4m,44,65 65 Jill 26 This is getting too complicated for the SAS skills that i have. Can anyone help solve the same? Regards, ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎09-01-2015 07:11 AM
Quick links