topic Re: How to skip rows in excel sheet while using DDE in SAS Programming

How to skip rows in excel sheet while using DDE

Karthik95 — Tue, 23 Jul 2019 07:55:23 GMT

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

Re: How to skip rows in excel sheet while using DDE

andreas_lds — Tue, 23 Jul 2019 08:06:31 GMT

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.

Re: How to skip rows in excel sheet while using DDE

Kurt_Bremser — Tue, 23 Jul 2019 08:37:46 GMT

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.

Re: How to skip rows in excel sheet while using DDE

Patrick — Tue, 23 Jul 2019 08:50:30 GMT

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/

Re: How to skip rows in excel sheet while using DDE

Karthik95 — Tue, 23 Jul 2019 08:59:11 GMT

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

Re: How to skip rows in excel sheet while using DDE

VDD — Tue, 23 Jul 2019 10:31:05 GMT

put '09'x;

that will skip one line.

Re: How to skip rows in excel sheet while using DDE

Reeza — Tue, 23 Jul 2019 15:13:14 GMT

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.