About FollinLane

FollinLane · ‎02-15-2019

This helps a lot. I will need to study it more. Along with what ErikLund_Jensen posted I think I have the solution. Thank you very much!

FollinLane · ‎02-15-2019

Sorry for the omission but I was trying to output after processing each record. For the sake of getting too detailed I got some strange results where the output seemed to be missing records or showing a partial record. Thanks for the the additional help!

FollinLane · ‎02-14-2019

Hi, I'm reading in a file using the code below. I'm new as using the scan function and would like to know how to output to the record after each iteration of through the code. Thank you data testdata2; infile mysource lrecl = 6807 truncover scanover; input @'"UserEmail"|"metadata_value":"' user_email $100. @'"ProductVersion"|"metadata_value":"' prod_version $20. @'"SourceEvent"|"metadata_value":"' source_event $30. @'"ProcessTotalWaitTime"|"metadata_value":"' PT_WaitTime $10. ; user_email = scan(user_email,1,'"'); prod_version = scan(prod_version,1,'"'); source_event = scan(source_event,1,'"'); PT_WaitTime = scan(PT_WaitTime,1,'"'); run;

FollinLane · ‎05-10-2016

This seems to have worked. I will need a bit of time to review the results; and then will take time to understand the solution as I'm new to this type of processing. I may have some questions. Thank you again!

FollinLane · ‎05-10-2016

B1 is always last but after Element10 (again it may or may not appear). B1 contains ‘data Element 11’. In the true file, data Element11 appears/starts @44. To identify B1... it is a long label starting in column 1. Its literal value is: ‘Points Expiring By Next Billing Statement: 0’ I hope I’m being clear as it must be hard not dealing with the actual data. Thank you.

FollinLane · ‎05-10-2016

I tried my best to keep this simple. I hope it helps. Thanks. A1....................abcdefghijklmnop...........................efghijklmnopq A2............................ghijklmn.......mnopqrstuv A3.......................cdefghijklmnop..........................klmnopqrstuvw klmnop...................qrst...abcd..............jklm.........stuv B1.........................................rstuv A1....................abcdefghijklmnop...........................efghijklmnopq A2............................ghijklmn.......mnopqrstuv A3.......................cdefghijklmnop..........................klmnopqrstuvw klmnop...................qrst...abcd..............jklm.........stuv B1.........................................rstuv A1....................abcdefghijklmnop...........................efghijklmnopq A2............................ghijklmn.......mnopqrstuv A3.......................cdefghijklmnop..........................klmnopqrstuvw klmnop...................qrst...abcd..............jklm.........stuv A1....................abcdefghijklmnop...........................efghijklmnopq A2............................ghijklmn.......mnopqrstuv A3.......................cdefghijklmnop..........................klmnopqrstuvw klmnop...................qrst...abcd..............jklm.........stuv B1.........................................rstuv A1....................abcdefghijklmnop...........................efghijklmnopq A2............................ghijklmn.......mnopqrstuv A3.......................cdefghijklmnop..........................klmnopqrstuvw klmnop...................qrst...abcd..............jklm.........stuv B1.........................................rstuv A1....................abcdefghijklmnop...........................efghijklmnopq A2............................ghijklmn.......mnopqrstuv A3.......................cdefghijklmnop..........................klmnopqrstuvw klmnop...................qrst...abcd..............jklm.........stuv B1.........................................rstuv A1....................abcdefghijklmnop...........................efghijklmnopq A2............................ghijklmn.......mnopqrstuv A3.......................cdefghijklmnop..........................klmnopqrstuvw klmnop...................qrst...abcd..............jklm.........stuv A1....................abcdefghijklmnop...........................efghijklmnopq A2............................ghijklmn.......mnopqrstuv A3.......................cdefghijklmnop..........................klmnopqrstuvw klmnop...................qrst...abcd..............jklm.........stuv B1.........................................rstuv A1....................abcdefghijklmnop...........................efghijklmnopq A2............................ghijklmn.......mnopqrstuv A3.......................cdefghijklmnop..........................klmnopqrstuvw klmnop...................qrst...abcd..............jklm.........stuv A1....................abcdefghijklmnop...........................efghijklmnopq A2............................ghijklmn.......mnopqrstuv A3.......................cdefghijklmnop..........................klmnopqrstuvw klmnop...................qrst...abcd..............jklm.........stuv B1.........................................rstuv A1....................abcdefghijklmnop...........................efghijklmnopq A2............................ghijklmn.......mnopqrstuv A3.......................cdefghijklmnop..........................klmnopqrstuvw klmnop...................qrst...abcd..............jklm.........stuv B1.........................................rstuv A1....................abcdefghijklmnop...........................efghijklmnopq A2............................ghijklmn.......mnopqrstuv A3.......................cdefghijklmnop..........................klmnopqrstuvw klmnop...................qrst...abcd..............jklm.........stuv A1....................abcdefghijklmnop...........................efghijklmnopq A2............................ghijklmn.......mnopqrstuv A3.......................cdefghijklmnop..........................klmnopqrstuvw klmnop...................qrst...abcd..............jklm.........stuv

FollinLane · ‎05-10-2016

I started a new post as the original problem was solved. For this, please see Astounding's (thanks) mention. The attached mock-up is how the latter files are generally formatted. Please note that line "B1" is the newer wrinkle. B1 does not always appear but if it does it is always on line 5. Thank you.

FollinLane · ‎05-10-2016

Ankit, Please see my response to RW9 concerning the data structure. I will be sending asap. Thank you.

FollinLane · ‎05-10-2016

Hi RW9, The file changed because it is part of a research project looking at historical data. Over the course of the years we are finding the additional line data had been included after a certain period. For you and others looking at this, I will need to mock-up a data file to attach as the information we are analyzing is sensitive (asap). Thank you.

FollinLane · ‎05-10-2016

Per the code below, is there a way to read in another sequential final line to capture data 'Element11' w/out changing its structure? After receiving help on this matter, the code worked great until the data file changed to include the additional line to process. I've tried to solve this several different ways w/out any luck. Thank you. DATA TEMP(drop=TYPE); INFILE IN1 end=done; INPUT @23 ID $16. @66 Element1 $13.; INPUT @31 Element2 $8. @45 Element3 $10.; INPUT @25 Element4 $14. @65 Element5 $12.; if not done then do; input @23 Type $1. @@; if type ne 'A' then input @1 Element6 $12. @25 Element7 $4. @32 Element8 $4. @50 Element9 $4. @63 Element10 $4.; end; run;

FollinLane · ‎05-03-2016

Astounding, Thanks for your help. It appears to be working well. A good thing to know.

FollinLane · ‎05-02-2016

Hi... yes the missing line is always the one that contains ELEMENT6 through ELEMENT10. Thanks.

FollinLane · ‎05-02-2016

Hi... the example was simplified but here are snapshots of actual data from same file. Thank you. Showing 4 rows per Account Number (Unique ID). Showing 3 rows per Account Number (Unique ID).

FollinLane · ‎05-02-2016

Hi, I have a mainframe dataset that is generally formatted as below. Each unique ‘ID’ has multiple consecutive rows associated with them. Row 1 ID Element1 Row 2 Element 2 Element 3 Row 3 Element 4 Element 5 Row 4 Element 6 Element 7 Element 8 Element 9 Element 10 Unfortunately, not all Unique IDs have 4 rows. About half of the Unique IDs have only 3 rows associated with them. This prevents me from using multiple input statements as I’ve tried here: DATA TEMP(drop=TYPE); INFILE IN1; INPUT TYPE $1. @; IF TYPE = 'A' THEN /* each ID begins with ‘A’ */ DO; INPUT @23 ID $16. @66 Element1 $13.; INPUT @31 Element2 $8. @45 Element3 $10; INPUT @25 Element4 $14. @65 Element5 $12; INPUT @1 Element6 $12. @25 Element7 $4 @32 Element8 $4 @50 Element9 $4 @63 Element10 $4; END; Ideally, I would like help with a data step before executing the above that would insert a blank 4th row as needed for things to work. Any immediate help is very much appreciated. Thank you.

FollinLane · ‎04-29-2016

Bruno, It seemed to have worked. Thanks again!

Online Status	Offline
Date Last Visited	‎02-15-2019 09:25 AM

Re: How to Output to One Record After Assiging Values

Re: How to Output to One Record After Assiging Values

How to Output to One Record After Assiging Values

Re: Another input line to process

Re: Another input line to process

Re: Another input line to process

Re: Another input line to process

Re: Another input line to process

Re: Another input line to process

Another input line to process

Re: How to Output to One Record After Assiging Values

Re: How to Output to One Record After Assiging Values

How to Output to One Record After Assiging Values

Re: Another input line to process

Re: Another input line to process

Re: Another input line to process

Re: Another input line to process

Re: Another input line to process

Re: Another input line to process

Another input line to process

Re: How to create a new data line via the data step

Re: How to create a new data line via the data step

Re: How to create a new data line via the data step

How to create a new data line via the data step

Re: How to read NULL values in flat file (HEX '00' on mainframe)