Proc sql

[Kurt_Bremser]

The proper way of dealing with issues is not starting with the tools. You start with the issue itself, and then select the tool most suited for the task.

So what for would you use this list of 10000 items?

[tomrvincent]

10,000 records. Only 37 values.

[katkarparam]

yaa

[ChrisBrooks]

There’s a nice introduction to the subject here https://support.sas.com/resources/papers/proceedings15/3024-2015.pdf 

[katkarparam]

thank you.. I will refer it

[tomrvincent]

How many distinct state values are there in your dataset?

[katkarparam]

for this dataset I have 37 distinct values.