look up table

RyanB — Thu, 15 Oct 2009 21:45:22 GMT

I've been researching and experimenting using a lookup table with variable definitions (e.g. datatype, length, in range values, recodes...) to count out of range and unknown values and to clean some large datasets. I was hoping to be able to reference the look up table via an array using a macro program but I haven't been able to get it to work. One problem is that I can't create and retain multiple variables used to store my counts (e.g. sex_unknown=sex_unknown+1). I've also researched using hashes but I'm not very familiar with them. I'm not necessarily looking for a solution for a specific problem as much as a point in the right direction. What is the best way to use another table to instruct my code to collect the information described and to clean the data?

Thanks in advance for your help.

Re: look up table

CurtisMack — Thu, 15 Oct 2009 22:01:52 GMT

Are you familier with the RETAIN statement? It would help you keep those counts.

Re: look up table

CurtisMack — Thu, 15 Oct 2009 22:34:50 GMT

Actualy, if you just did:
---------------------------------------
sex_unknown + 1;
-----------------------------------
It would automatically be retained.

topic Re: look up table in SAS Programming

look up table

Re: look up table

Re: look up table