BookmarkSubscribeRSS Feed
MarkLurie
Calcite | Level 5

I spent all night loading a teradata table from a SAS dataset (approx 344K records in ds) but only 332K on the table (soo close) but had to kill the process to get to the office.

I am new to SAS (last couple of days) so I am still getting up to speed with the syntax but I was wondering if I could run a PROC Compare between the two (I have libnames for both) and then capture the delta in another SAS Dataset?

1 REPLY 1
Tom
Super User Tom
Super User

Check you logs.  Teradata tools like FASTLOAD will eliminate duplicate records, but it should report that in the log.

You might check your SAS data for duplicate rows.  Or it is possible that the variables in your TD table have transformed one or more variables and caused records to appear to be duplicates.

You can use PROC COMPARE , but it will mean that SAS will have to pull all 344K records out of TD to compare.

Might be easier to summarize on key variables (patient id, date, etc) and compare the summaries to see if there is a pattern to the loss.

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 1 reply
  • 991 views
  • 1 like
  • 2 in conversation