topic Re: How to skip rows with retain statment? in SAS Procedures

How to skip rows with retain statment?

Elenatec — Mon, 06 May 2013 09:39:09 GMT

Hi,

I am new to SAS very much appreciated from your reply. My client gave me a txt file which look like the file I have attached, I would like to know how use SAS to capture valid data or skip unessary rows from the raw files and replace those empty column such as date and area.

Re: How to skip rows with retain statment?

Ksharp — Mon, 06 May 2013 12:44:23 GMT

OK.

filename x  'c:\temp\query1.txt';
data x;
 infile x  expandtabs  pad ;
 input @;
 if left(_infile_) in: ('FIles' 'Date' '======') or missing(_infile_) then delete;
  else  input date $ 8-16 area $ 22-28 id $ 31-39 type $ 40-44 country $ 47-65;
run;
data want;
 set x;
 retain _d _a '            ';
 if not missing(date) then _d=date;
 if not missing(area) then _a=area;
 date=coalescec(date,_d);
 area=coalescec(area,_a);
 drop _d _a;
run;

Ksharp

Re: How to skip rows with retain statment?

Elenatec — Tue, 07 May 2013 00:27:42 GMT

Hi Ksharp,

Thanks for your quick reply, I will try and learn your code atm.So late on I recieved another txt file from the client again now all the "tab" changed to "space" does the expandtabs effected with your code?

Ong

Re: How to skip rows with retain statment?

Ksharp — Tue, 07 May 2013 01:31:58 GMT

NO. You can use it without change.

Re: How to skip rows with retain statment?

Elenatec — Tue, 07 May 2013 02:37:13 GMT

Hi Ksharp,

Many Thanks, I am totally new to this SAS even I have basic programming languages knowledge still can't complete my work, very much appreciated from your help. one last questiong about the code

retain _d _a ' ';

whats the purpose of the last ' ' section?

Ong

Re: How to skip rows with retain statment?

Ksharp — Tue, 07 May 2013 03:41:27 GMT

Assign ' ' as initial value of _d and _a