I have a summary table that summarizes data how I need it. I need to generate a table that has that same information summarized but into a new table (showing the actual summaries not each line of data used to create the summary report.  I don't know how to create a table in sas that only shows the sum of rows so I have used the summary table function (sum) then exported it into excel and attempted to cut and paste it into a spreadsheet with the correct formatting.  Can you help me create a new table (not summary data table function) that summarizes distinct rows based on certain criteria so I can then merge that summarized data into another spreadsheet? In the final summary table the posted date does not matter as the week is already present in the table, however there are multiple entries on any given date in that week, there for it needs to be summarized.  I need to know how many total units, per material, per plant, per week.   Example below: Data Table 1 currently in SAS: Material Code Plant Total Posted Date Week N384000 2001 100 1/1 1 N384000 2001 200 1/5 1 N384000 2001 300 1/3 1 N384000 2002 100 1/4 1 N384000 2003 150 1/4 1 N384000 2001 900 1/10 2 N384000 2002 50 1/11 2 N384000 2002 0 1/10 2 N384000 2003 75 1/10 2 N384000 2004 0 1/13 2 N463375 2001 100 1/1 1 N463375 2002 200 1/2 1 N463375 2003 100 1/4 1 N463375 2004 50 1/4 1 N463375 2004 75 1/6 1 N463375 2001 0 1/11 2 N463375 2002 150 1/11 2 N463375 2003 200 1/10 2 N463375 2003 200 1/10 2 N463375 2004 200 1/13 2 Data Table I need in SAS: Material Code Plant Total Sum Week N384000 2001 600 1 N384000 2002 100 1 N384000 2003 150 1 N384000 2004 0 1 N384000 2001 900 2 N384000 2002 100 2 N384000 2003 150 2 N384000 2004 0 2 N463375 2001 100 1 N463375 2002 200 1 N463375 2003 100 1 N463375 2004 125 1 N463375 2001 0 2 N463375 2002 150 2 N463375 2003 400 2 N463375 2004 200 2   Can you help me?     ... View more

How do I import a large number of .txt files into SAS Enterprise at once?  The import data function will take way too long.  The column names begin in B1 and the dataset for each begins in B4.  There's 3163 lines in each file. ... View more

I have about 500 columns and 150M records.  These are inspections and about half are duplicate rows for the same "unit" that has been inspected.  There may be up to five or six records for some units and they have different data that needs to be kept.  However there are many others that have 20 copies of the same inspections and only two of the records are different.  How do I do a query builder to eliminate all but unique records? Unit ID will always be the same Inspection date, record number, etc. may be different between two records for the same unit.  I need to keep both but I can't have 200M records for 6.4M units.  I would assume I'd have upwards of 30M with the different inspection records for each unit.  Example: Unit ID            Inspection Date             Finding Code 1                            2/14                                  A 1                            2/14                                  A 1                            2/15                                  B  1                            2/15                                  A   I would need to remove the second record from 2/14.  I want distinct rows only but I need to compare all of the columns not just one for each record.  If that makes sense     Help! ... View more