How to skip rows in excel sheet while using DDE

[Karthik95]

I have wrote a program by using DDE where I'm unable to skip rows in the excel sheet . What function I should use to skip rows

[andreas_lds]

You are still using DDE? The technique is outdated for years, you should really switch to something more up to date, like libname xlsx, or ODS.

[Karthik95]

mine is sas 9.2 version so i have no choice so, please suggest me what delimter should i use to skip rows in excel sheet while using DDE

[Reeza]

Skipping a line the same way you would with a text file should work, have you tried just a blank put statement? Or some other method? You can also control what cells you access directly so it should be pretty straightforward, post your code if you're having issues.

[Kurt_Bremser]

The proper tool for manipulating MS Office files is VBA. Use that.

Skipping certain observations in SAS datasets is done with WHERE conditions or a subsetting IF.

[Patrick]

Adding to what @andreas_lds writes: You really should read below blog before writing any new SAS programs using DDE.

https://blogs.sas.com/content/sasdummy/2014/10/14/dde-is-doa/ 

[VDD]

put '09'x;

that will skip one line.