DATA Step, Macro, Functions and more

look up table

Reply
N/A
Posts: 1

look up table

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.
Frequent Contributor
Posts: 102

Re: look up table

Are you familier with the RETAIN statement? It would help you keep those counts.
Frequent Contributor
Posts: 102

Re: look up table

Actualy, if you just did:
---------------------------------------
sex_unknown + 1;
-----------------------------------
It would automatically be retained.
Ask a Question
Discussion stats
  • 2 replies
  • 118 views
  • 0 likes
  • 2 in conversation