topic Re: lloop through a dataset in SAS Programming

lloop through a dataset

DarthSAS — Wed, 02 Sep 2009 19:54:02 GMT

Hi all,

First of all, i want to apologize for my poor english.

I want to loop through a SAS data set and i don't know how.
I pass the id to the macro updateValueById, but this not work because it pass a bundle of id, i just want to update id by id.

There is my code:

%MACRO UpdateData;
DATA dataset;
INFILE "c:\employes.txt"
DLM = '09'X
MISSOVER
FIRSTOBS = 2
DSD;
LENGTH id 8
firstname $ 25
lastname $ 25
hire_date 8;

INPUT id
firstname
lastname
hire_date;

%UpdateValueById(id=Id);

RUN;
%MEND UpdateData;

%MACRO %UpdateValueById(Id);
proc sql;
update dataset
set name = 'toto'
where id = &Id;
quit;
%MEND UpdateValue;

Thank you all

Re: lloop through a dataset

ChrisNZ — Wed, 02 Sep 2009 21:37:22 GMT

You can't call SQL statements to run inside a datastep.

You probably don't need a macro here. Use just SQL, or a merge statement in a data step if tables are/can be sorted, or a hash table if not.

Re: lloop through a dataset

milts — Thu, 03 Sep 2009 00:00:59 GMT

Hi Darth,

use the call execute statement in your statement

call execute('%UpdateValueById(id=' || id || ')');

hope this solves your problem.

Regards,
Milton

Re: lloop through a dataset

DarthSAS — Thu, 03 Sep 2009 12:48:05 GMT

Thanks a lot Milton, it work fine.

Best Regards Message was edited by: Darth SAS