My SAS is busy so I'm unable to create code and test but you could PROC SORT by id, A1, A2 and then PROC TRANSPOSE to make your long table wide like your example and then it would make the PROC REPORT easier to code. ... View more

Try the STRIP function to remove leading and trailing blanks: if STRIP(medications) IN( ...) then ...; else if STRIP(medications) IN( ...) then ...; else if STRIP(medications) IN( ...) then ...; else if STRIP(medications) IN( ...) then ...; else if STRIP(medications) IN( ...) then ...; else...; Actually, after re-reading,  I think you want the INDEX function: if INDEX(medications, "Atripla") >0 or INDEX(medications, "Zetia") >0 or INDEX(medications, "Combivir") >0 THEN med = 'HIV'; else if INDEX(medications, "Lisinopril") >0 THEN med = 'Blood Pressure'; else if INDEX(medications, "Pravachol") >0 THEN med = 'Cholesterol'; Or...if your trying to just flag them on each detail line... if INDEX(medications, "Atripla") >0 or INDEX(medications, "Zetia") >0 or INDEX(medications, "Combivir") >0 THEN hiv_med = 1; else if INDEX(medications, "Lisinopril") >0 THEN bp_med = 1; else if INDEX(medications, "Pravachol") >0 THEN chol_med = 1; ... View more

Maybe I'm not understanding the question but this might help get you closer (not understanding the Y/N part):   proc freq data=your.indata;    tables age*characteristic / list missing    out=your.outdata;    where characteristic='Tiny'; run; ... View more

hmmm, this issue seems to be an excel problem, not a SAS problem. It also sounds like you're doing it correctly in Excel to turn off the 'always create backup'. Is it an option to reinstall Excel? From stackoverflow.com: What you need to do is open any excel file and choose the "save as" option. When you are in the save as window, below the "File name" and "Save As Type" options, there is an option that reads "Tools" with a small drop down arrow next to it. Click on this drop down arrow and then from the dropdown list, choose "General Options". In the window that pops up next, check the box that reads " Always create Backup" ... View more

Have you had a chance to review previous postings regarding sending emails from SAS? https://communities.sas.com/message/56047#56047 https://communities.sas.com/message/46554#46554 ... View more

FriedEgg had posted a discussion about data masking and implementing a cipher: https://communities.sas.com/message/106874#106874 ... View more

You stated "If I've data with spaces before or after some text for a variable, do I need to use the compress function to make sure I'm selecting only the text part?" If that's the case and you don't care about spaces in between (i.e., you don't want the 'a bc'), you only want ' abc', 'abc ', 'abc' then you can just use the STRIP function. IF STRIP(text)='abc'; ... View more

Other options to search for are ANYPUNCT() for punctuation and ANYSPACE() for white space... ... View more

It that case, my guess is that you could possibly have character data on the spreadhseet...See if you can run the ANYALPHA() function on the columns to see what it's getting hung up on. ... View more

That is strange...have you tried find and replac[ing] the empty fileds with 0's and then PROC IMPORT? ... View more

What about defining the CPUCOUNT?: OPTIONS THREADS=YES CPUCOUNT=8; ... View more

What happens if you define: OPTIONS THREADS; ... View more

I'm not sure what you mean "how can I set EG..." You rename and change the properties of your C:\ drive in windows explorer and your libname statement goes in your SAS code. There's nothing to change in EG. ... View more