Some things are easy in Excel but can be very difficult to do in SAS. It would help if we could see the SAS data set DO NOT SHOW US THE EXCEL FILE. Please show us a portion of the SAS data set as working SAS data step code (examples and instructions).
SAS Datasets do not operate with 'cells'. What is your data source?
Then make the desired changes in Excel.
Some things are easy in Excel but can be very difficult to do in SAS. It would help if we could see the SAS data set DO NOT SHOW US THE EXCEL FILE. Please show us a portion of the SAS data set as working SAS data step code (examples and instructions).
Define "empty line". SAS data sets do not have a concept of "line" to work with.
If it means that you have a SAS data set where all of the variables are missing then something similar might work:
Data want; set have; if missing(var1) and missing(var2) and missing(var2) then delete; run;
The Missing function tests if a variable is missing and returns 1/0 (true or false) for a specific observation's values. Var1, Var2 and Var3 dummy names for the first, second and third variable ('column') to see if they are missing. Add more variables if those might be missing but other variables aren't. Delete is the data step instruction to remove an observation from the output (do not write to output set).
OR if you know how many variables there are in your data set you could use
data want; set have; if cmiss( of _all_) = <number of variables> then delete; run;
If the number of variables in the set is 12, as an example replace <number of variables> with 12.
@_el_doredo wrote:
Hello Experts,
I am having a data in which data starts at the third line in a single cell. Suppose in A1 cell my data has 2 empty lines(lines not space). 3rd line I am having data in A1 cell.
How to remove two empty lines and keep the data in the first line of the cell
Thanks in advance
Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!
Check out this tutorial series to learn how to build your own steps in SAS Studio.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.