Hi there!    I'm asked to do the below: for question d I was able to extract the string from the : to the , ;however, a couple of numbers (sometimes there are . at the end) trail after it and I want to know how to remove them (different lengths). when I try to parse using format f f I get . as the result. By parsing the function will it make question d (from_lat)a measure data item? When i didn't use the parse function for question e, from_lon was categorized as a category and the other option was for it to be geography.    WITHOUT PARSE function   WITH PARSE function           ... View more

Hi there!  I'm asked to do the following below in SAS Visual Analytics. I'm using SAS Viya for Learners 3.5.    This is what I have so far. it looks good in the beginning but once I reach the later parts of the data, the string I want isn't correctly extracted. I need assistance on how to extract part of a string before a delimiter. In this case, before the colon.  Thanks in advance.    ... View more