Hello All, Thanks to all who helped me! I encountered additional issue on my data but all your suggestions helped fix the issue. What i did was this: data want; set have (keep=FLEX_VALUE_1); translate=tranwrd(FLEX_VALUE_1,' ','|'); /*The issue of this is all of the length of my data is 200*/ translate2=tranwrd(FLEX_VALUE_1,' ',''); /*This was created to get the actual length needed in translate variable. This wasn't used in the first place bec., after testing, it will have an issue on scan function. the issue has something to do with the data itself*/ /*numb=length(translate2); This was used for testing*/ value=substr(translate,1,length(translate2));/*To only get the needeed value of translate*/ NAme= SCAN(value, 1, '|'); Account = PUT(INPUT(SCAN(value, 2, '|'), best.) , z11.); company = SCAN(value, -1, '|'); run; Feel free to share your kowledge if you have suggestions to improve my code or if you see some errors so i could learn from you guys. thanks you so much!
... View more