Is there a specific maximum number of coordinates in one row? ... View more

Kurt Why not introduce the OP to what has neen referred to as the DoW loop, eliminating the need for initialising and first. Code The following assumes only that data is in ID order and any score above 10 is enough. Data want ; Do until( last.ID ) set rawdata ; BY id ; if score > 10 then touch11 = sum( 1, touch11 ) ; end ; If touch11 ; Run; ... View more

Another feature of infile might be helpful here : The DLM= option can name a variable as well as a constant of more than one character - each character is respected as a delimiter - so both blank and semicolon can be used DLM= ' ;' With dlm as a variable, its value could be changed from blank to semicolon once the final ) in coordinates is detected. ... View more

Do those ((( psrentheses imply a hierarchical structure that needs to be captured? ... View more

Could a solution not be simpler? Separate the roles of this data field 1 key 2 some data to be anonymised I assume the environment which holds the original is separate from the environment to hold the "generated" data. Create a unique key (row number on original data?) and keep this with the personal data on a "translate table" (to enable reversal from key to personal data) in the original environment where this personal-ish data is stored. Release the "generated" non-personal data keyed with simple unique key to the target environment. ... View more

If verify( cats(of flag: ), 'yY' ) then final_flag = 'Y' ; ... View more

Didn't expect to see a smiley icon. What was intended there "flag:" without these quotes ... View more

There is an old function VERIFY() which is useful for checking the existence of specific characters.... like if verify( cats( of flag:), "yY") then final_flag ="y" ; VERIFY() operates on a single string, seeking the first occurrence of any character in the second parameter of tge function and returns 0 if none are found. It is case sensitive, so providing both upper and lower y makes the search case-insensitive. The CATS() function returns a concatenation of the flagN vars. It requires a list of the variables to concatenate - the " of flag:" works neatly to achieve that. One way this VERIFY() approach might fail, arises when the flags contain other strings than just a y or n - for example , if a flag var holds the 3 chars "MAY" then that Y would result in final_flag set to y ... View more