@ballardw wrote: @Hasnan wrote: Hi Nandeep I would have used the proc freq method, but just an FYI with either method, it would take quite a while to run! Regards Approximately 0.22 sec to create a data set with 1,500,000 records randomly assigning 10 postcodes. 0.14 Seconds for proc freq to summarize. Of course that is my machine and your mileage may vary. But a proc freq for on the order of 1 or 2 million records for a single variable to a data set does not take very much time unless network or other performance issues arise. I would recommend NOPRINT if you only want a data set with proc freq to avoid potentials display time delays building largish html output tables if you have many codes. Hi, Yes the NOPRINT certainly seems to have sped up the process, and even on my slow machine the Proc Freq was completed within 45 seconds.
... View more