DSXchange

I used successfully QS7.01 for almost two years. We have just installed QualityStage 7.5.1. I copied the sample project QUALITY, and removed all the stages, but keep the DEM06. I modified it to a MATCH job. renamed the INPUT to INPUTA, and copied it to INPUTB. removed all the setting in Report set t...

Thanks for all the response. I verified: all are imported into QS 7.5 designer from QS 7.0. All the setings: check box selection, file definition, Cutoff ... are the same. I have the extract file MATCH for match and get the records. But the extract file DUPA for dup fom source file A has no records....

I have both QS 7.5 and QS 7.0 server installed on different UNIX computers, and both client on my XP computer. I import the Project from QS 7.0 client into QS 7.5. I ran the matching process with the same setting as I did for QS 7.0, Same input files (copied) . All the setting are the same : cutoff,...

Ohlala. Fortunately, I am not the administrator, but I am the only user of the QualityStage in my company, and I will take some installation and configuration work. I am also confident on the application server configuration. We are going to install QS 8 in a new computer, Solaris 10. It is welcomed...

We purchased a perpetual license from Vality (previous name of QualityStage) years ago for both Windows and Solaris, but are currently only using the Solaris version. The last time that version was updated was in December, 2004, and we are still using that version, which is Release 7.0.1. Vality was...

I want a Nysiis program in SAS to create Nysiis code for first name and last name. Could anybody share the Nysiis program?

I work for a no-profit company. But profit company may use our data. The Nysiis code is used for match only, not go into final dataset.

Thanks.
daxinz@yahoo.com

I change the missing SSN in file A to a unique integer as of format 9ABCDEFGH. In both file A and file B, all other SSN's are not started by 9.

But the overflow message is still the same.

Thanks,

Since you said in previous reply, the overflowed records goes into next passes either, I would like to allow this overflow. SSN is a match field in later passes as integer, I use cnt_diff, para1=1. The records in file B all have good SSN. My last question for this topic: is there any possible proble...

Thanks JRodriguez for the reply.
For "Convert to null", I use SAS, and the file is in flat text file. I do not know how to convert missing values to null. Could you please forward more instruction?

Thank you again

Please keep helping. If I only run the pass 1 only, block on SSN. There are sill overflow message in jobName.MTC.StepFREQLDA.log, and only in this file. 50% of the records in my file A has no SSN, and a lot of them are illegal. SSN is duplicated in some records. In file B SSN are unique, and all pas...

Last night, I ran the match with the first 2 passes only. It started at 10:30 last night, and ended at 09:07 AM this morning. At advanced running options, I increased all the buffers to 5 times larger. It is successful. No error mesage. But there are still overflow related messages in two log files:...

Thank so much for your help. the following is the match/block: pass 1 Block: SSN. Match: Last name(UNCERT), First name (UNCERT), Initial, Birth YY, Birth MM pass 2 Block: Last name (char), First name (char), Birth YY, Match: Birth MM, Initial, SSN, Birth DD, ZIP pass 3 Block: Birth YYMM, Last Name, ...

Hi Experts: Please help on these questions. My file A has 36Million+ rows, and file B has 20Million+ rows. UNIX QS 7.0. Default output. 1) Overflow: In log/jobName.MTC.StepFREQLDA.log, there is a message: "937 number of overflow areas allocated", in jobName.MTC.StepFREQLDB.log: "695 n...

I get the result. In the jobName.MTC.StepFREQLDA.log, I see freqld(1823):Sat 30 Jan 2010 03:00:33 PM PST LOG: 937 number of overflow areas allocated in jobName.MTC.StepFREQLDB.log, I see freqld(17532):Sat 30 Jan 2010 03:24:06 PM PST LOG: 695 number of overflow areas allocated This process has 7 pass...

I have no idea on the special bytes as this. But I have just solved the same error: "Incomplete record... ". I would like the share some ideas. 1) In both data file, use the same format. For example, if the 3/9/2007 is 20070309 in one file, and another file is 2007 3 9, try to make them th...