After I read an excel file into SAS,I found the variable were splited in to several rows, maybe there are something like ENTER keys in the excel file.
My question is how to remove these 'split' in sas data set and make the variable in one row? I want to do this because I can't use 'findw' function correctly to find a special character in it. the variable X looks like this:
I need x like this:
I have tried use compress(x) but still not work.
Pleas show exactly how your data is, do all those lines appear in one observation in SAS (post a sample of the excel file maybe)? I assume that this is on import, but when I did this, simple proc import on an Excel file, it put the whole record on one observation and removed alt+enters. So I don't see why you have this issue. Please explain your process further.
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.