How to remove characters after a delimiter and how to use a parse function

[ngunan0921]

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

[ballardw]

First thing I would say is to provide any examples in the form of text. Copy text from a file using any text editor and on the forum open a text box using the </> icon that appears above the message box and paste the text. Better would be to paste a working data step that will create a SAS data set with values that you have. It is next to impossible to write code to read from a picture.

Second: do the same pasting of text of what you want for a result from the given example.

Third is to show the code that you have attempted so far, again pasted into a text box. Since you didn't show any of the requirements I have to assume are a, b and c it is hard to tell if part of the solution may involve those.