Hi Guys, sorry for the very noobish question i have just started to used SAS 2 days ago:) I want to run some data quality tests on one field in a very large table, such as looking the format and length of one field. So i have created the following code: Data New; SET SASHELP.CARS; x=length(MAKE); Run; proc freq data=new; table x; run; That work ok for the table CARS as that table is not that big, but the testing need to be done on a table conaining over 66million transaction so i am bit worried that the DATA steps would create a 66 million record in my working directiory. Is there a better way to carry out statistics on the length of one field? can this done be directy using a proc or do i need to create the field first in Data? Any help much appreciated! NB: If you guys are willing to share any scripts checking for table integrity (such as checking for not only length but special character that would be very helpful!) cheers, Tom
... View more