I have this data    data KK; input sub_id complain_id dept_id; datalines; 101 1 11 102 2 12 104 4 13 105 5 15 107 7 14 108 8 16 109 9 17 ; run;     data PK; input sub_id dept_id duration; datalines; 104 13 10 101 11 20 102 12 30 107 14 40 105 19 50 0 14 100 0 13 60 0 15 70 0 11 80 0 12 90 ; run;     and now I want to join these two datasets with two diff conditions.   Condition 1: If dataset 'PK' contains sub_id=0 then join should on dept_id    condition 2: if dataset 'PK' sub_id != 0 then join should on sub_id      If any solution you have then please share the code for this query. ... View more

While importing QKB I am getting exception error in vocabulary section i.e. Failed to load files: Exception of type: 'DataFlux.QKB.QKBException' was thrown. Attaching the error message that I am getting.  ... View more

Hello everyone,   I am new to SAS DQ Tool. Actually, I am working on two datasets where I got one or two variables which are partially same. So my concern is to match those records and make golden dataset which is used for next process.     suppose I have datasets A and B which have variable as below,   A                      B Name              Name  Address          Postal Address  Phone No.       Father's Name  Gender       Variable Name and Addresses can be matched exactly or partially.     How can I get one final dataset using SAS DQ? Which Node should I use and what would logic for getting final result?     Any information link, document or any solution will be appreciated.      Thanks..           ... View more

I have a varible which is numeric and format of  the varible is "SIZEKMG" And then after uploading on VA LASR the variable got converted in Category(Character). I want variable to be in numeric only after uploading on LASR. ... View more

Hi everyone, Actually, I am trying to solve one problem, I have one dataset which will update daily (automatically).. (Dataset "B"). and my ETL works on that dataset. Now my new requirement is to work on only delta record. .. requirements: 1) In that dataset one column(i.e. DATEofComplaint) will updated (on which I want to work) and I want only those observations which were updated till yesterday from lasttime ETL Runs. even if ETL was not run for few days . 2) even if ETL runs two or more times in a day, then also data will get until yesterday .. and then 3) I am appending output data to permanant Dataset (i.e. "F") so in that duplicate observations are not allowed and I can't use NODUP or NODUPKEY for that permanent dataset because dataset is very large. .....................................................................................................................   I am exporting system date to know on which Day ETL runs last time. (Suppose this ETL last time RUNS on 28AUG2017 then "lastETLDate" will 27AUG2017 ) STEP 1: Data sasdata.SystemDate; format LastETLDate date9.; LastETLDate=today()-1; run;   .............. Step 2: then importing that date (27AUG2017) .............. Step 3: Suppose today's date is 01SEP2017 data kk; A=today()-1; run; A=31AUG2017 .............. Step 4: data QueryFoRB; set sasdata.B; where DateofComplaint between LastETLDate and A; run; .. Now, what should I do to overcome the problem of appending duplicate records when ETL runs two or more time in day.... because in last step of ETL I made code that will append data to a permanant dataset which comes from Step 4. for reference, I have attached a rough diagram of SAS EG.   program or any suggestion will be appreciated. Thank you very much.         ... View more

03JAN2011:00:00:00.000 which format should I use to read this date ?   ... View more

Hello, I have one query, I am working on observations which are automatically updated in the Oracle database (obs will be updated in only one table and that is used in ETL) And then runs ETL on that data-set at the specific time.   I already made ETL which runs at night which takes two hours. now I want to change in  ETL which runs only on newly updated Observations from last used data and give final output. coz I have to save time by working only on those observations which are updated instead of processing the whole observations. e.g. ETL runs at 2 AM and ends at 4 AM now if I am running ETL manually at 3 PM then this ETL only works on Updated observations(i.e. only on 2 AM to 3 PM data and gives output. ) ..What should I do for this task. ... View more