About Julie99999

Julie99999 · ‎08-27-2022

thanks a lot Ksharp for your reply!!! I'm using SAS/EG

Julie99999 · ‎08-27-2022

thank you so much!!!!!! it worked!!!!! I was going to manually check line by line and your trick nailed it. I was able to find the non-ascii using the way you suggested. problem solved in 10 seconds literally!!! thanks a ton

Julie99999 · ‎08-26-2022

HI SAS community, I have this peculiar running error that states "failure to transcode" while I attempted to run SAS on one go. I tried run my SAS code block by block and it run successfully. I probably introduced some non-English character. Anyone know how to fix this without going through my code line by line, which is 2000 lines? Is there any "encoding= " option I can use that solves this problem? TIA!!!! Error: Integration technologies failed to submit the code. [Error] Failed to transcode data from U_UTF8_CE to U_LATIN1_CE encoding because it contained characters which are not supported by your SAS session encoding. Please review your encoding= and locale= SAS system options to ensure that they can accommodate the data that you want to process. A portion of the source string, in hex representation is: [None] 2b8b496b1b24: 3b 2a 27 3b 2a 22 3b 2a 2f 3b 71 75 69 74 3b 72 |;*';*";*/;quit;r| [None] 2b8b496b1b34: 75 6e 3b 0d 0a 4f 50 54 49 4f 4e 53 20 50 41 47 |un;..OPTIONS PAG| [Error] Some code points did not transcode.

Julie99999 · ‎08-24-2022

thank you so much, the documentation you attached is really helpful. I learned a lot from it.

Julie99999 · ‎08-24-2022

Thank you so much, it helps hugely. I searched everywhere but couldn't find the answer. Your response is really helpful, I now understand that Perl regular expression

Julie99999 · ‎08-24-2022

I understand \s means "Matches any white-space character." but what does s/ and /o mean? In the regular expression you wrote, 's/\s/ /o', I get \s, but not s/ and / /o. Any input is appreciated greatly

Julie99999 · ‎08-24-2022

thanks, I think using regular expression really solves the problem in one line of code. Can you please kindly help me understand what does this line of code work? prxchange('s/\s/ /o',-1,strip(ind_coast))) I googled it but didn't help

Julie99999 · ‎08-24-2022

thanks for your reply. I didn't post my complete call execute code here, my call execute can run with no problem. The problem is hidden characters in the text string "PITTSBURGH PA PMSA ", which won't work for strip()

Julie99999 · ‎08-15-2022

the output for "put cbsa_title $hex. ;" is as follows: 42455448455344412D524F434B56494C4C452D46524544455249434B2C204D44092020202020202020202020202020202020 I believe it's '09'x (TAB)

Julie99999 · ‎08-15-2022

thank you so much. I didn't know about invisible character before. I think like what you said, they're not space. I searched whole afternoon online trying to learn more about this special character. I guess in my case, the special character is generated in data creation input step. I tried the code cbsa_title = translate(cbsa_title,' ','090A0DA0'x); you've listed. It didn't work in my case. Is it likely due to the fact that special characters in my case is not in '090A0DA0'x format? These stuff are very new to me, I'm trying to digest. I searched translate function online, didn't find much about what I can put in the third argument https://support.sas.com/documentation/cdl/en/lefunctionsref/63354/HTML/default/viewer.htm#p05ww22zp7lcg3n1bjk7v93tscyo.htm Thank you very much

Julie99999 · ‎08-15-2022

removing trim is the same. I initially only put strip. Thanks anyway.

Julie99999 · ‎08-15-2022

Hi friends, I have one line of code like this: call execute('if cbsa_title ="'||trim(strip(cbsa_title))||'" then IND_COAST = '||strip(ind_coast)||' ;'); but when SAS runs this code, it shows: + if cbsa_title ="PITTSBURGH PA PMSA " then IND_COAST = 0 ; As you can see, the strip function in call execute doesn't work as it still contains trailing blanks. I tried many times even adding another trim function and still doesn't work, Anyone has any idea? Greatly appreciate it!!!!

Julie99999 · ‎07-29-2022

data Heart / view=Heart; set sashelp.heart; select (Smoking_Status); when ('Non-smoker') Smoking_Cat=1; when ('Light (1-5)') Smoking_Cat=2; when ('Moderate (6-15)') Smoking_Cat=3; when ('Heavy (16-25)') Smoking_Cat=4; when ('Very Heavy (> 25)') Smoking_Cat=5; otherwise Smoking_Cat=.; end; run; Hi all! I have a question on the code above using select(). Is there anyway to select two variables for the condition? what if I want to select Smoking_Status = "Heavy" and Age > 30, is there way to use select() when in this case for multiple conditions? TIA!!!!!

Julie99999 · ‎07-28-2022

thanks for the succinct take-away!

Julie99999 · ‎07-28-2022

Astounding, I see your point. That's smart! That would work and solves exactly my question, how come I didn't realize by simply switching to "b a" would solve the problem. update b a; thanks for the "A ha" moment you've brought to me. 🙂

Online Status	Offline
Date Last Visited	‎09-09-2022 09:54 PM

Re: failture to transcode

Re: failture to transcode

failture to transcode

Re: strip in call execute doesn't work

Re: strip in call execute doesn't work

Re: strip in call execute doesn't work

Re: strip in call execute doesn't work

Re: strip in call execute doesn't work

Re: strip in call execute doesn't work

Re: strip in call execute doesn't work

Re: failture to transcode

Re: strip in call execute doesn't work

Re: strip in call execute doesn't work

Re: strip in call execute doesn't work

Re: strip in call execute doesn't work

Re: failture to transcode

Re: failture to transcode

failture to transcode

Re: strip in call execute doesn't work

Re: strip in call execute doesn't work

Re: strip in call execute doesn't work

Re: strip in call execute doesn't work

Re: strip in call execute doesn't work

Re: strip in call execute doesn't work

Re: strip in call execute doesn't work

Re: strip in call execute doesn't work

strip in call execute doesn't work

select multiple in SAS data step

Re: data step equivalent of proc sql coalese

Re: data step equivalent of proc sql coalese