Hi All,   I have to code a logic that could find out list of similar defects from a defect dump and rank them on the basis of their similarity.   Example : Search Criteria: Unable to create reservation Expected: A list of all the defects regarding the create reservation issue should be displayed and they should be ranked in accordance to relation with  the search criteria.   Kindly suggest.   Note: search using "where" wont work as it is exact match of the text entered. ... View more

Hi All,   I have the data as follows:   data test; infile datalines MISSOVER dlm='|' dsd; input  YR_MTH_NBR YR_NBR MTH_NBR FAC_ID GST_TYP ENTERPRISE_ID STAY_GST_ID MEMBER_TYPE $ ENROLL_STY_IND $ SVY_SENT_DT mmddyy10. SVY_COMPLT_DT: mmddyy10. BRAND_MINOR_CD $ REGION_DESC $ MAIL_IND LANG_TYP $ CK_IN_DT: mmddyy10. CK_OUT_DT: mmddyy10. VERB_1a_v: $ 100. Confirmation_number: HBR1_Region: $ HBR2_SubRegion: $ HBR3_Country: $ BK_SOURCE_CD: $ @; format SVY_SENT_DT mmddyy10. SVY_COMPLT_DT mmddyy10. CK_IN_DT mmddyy10. CK_OUT_DT mmddyy10.; datalines; 201612|2016|12|9278|1|640242220|2286593523|CLUB|N|12/31/2016|12/31/2016|HIIS|AMERICAS|1|ENU|12/28/2016|12/29/2016|The cooked breakfast option was wonderful. It was nice to order from a menu vs eat from a hot/cold breakfast buffet bar.Room was clean and comfortable and plenty of space. We had restful sleep.|62099040|Americas|North America|United States|CRO 201612|2016|12|10822|1||2274029967|SPRE|N|12/03/2016|12/31/2016|HEXS|AMERICAS|4|ENU|11/30/2016|12/01/2016|Better quality breakfast food.|60958042|Americas|North America|United States|LMNCO ; run;     Concern:  1) I am not able to read the correct values. 2) The above code is not treating two consecutive delimiters as missing value.   Kindly suggest a code which can read through above values ... View more

data t1; input cinfno carte$; datalines; 1 caba 1 cb 2 cb 3 caba 4 cb 4 caba 5 caba ; run;   Using data steps write a code to display the number of customers having  carte: CB Carte: caba carte : both ... View more

we need to calculate the score for each day for each tweet. Where we have a word polarity sheet with score and a sheet with tweets data.     ... View more

Cough is identified using ICD-9/10 codes from the claims databases. Whereas, there is no ICD-9/10 code available to define the chronic stage of cough. The objective of the problem is to identify patients who have been diagnosed with chronic cough between 2007 and 2009. These patients will be then assessed for their demographic characteristics. The following algorithm is deigned to identify chronic cough patients: A patient having at least three inpatient/outpatient claims for cough within the time window of 120 days anytime, between 2007 and 2009. The following dataset has patients with service dates for cough from 2007 and 2009. Identify patients diagnosed with chronic cough between 2007 and 2009.   ... View more

I have a data set with two variables Enrolid and Index_Therapy. Under index_therapy i have data with duplicate values in the string for each record, I would need a code to remove duplicates from each string.   Sample data set is attached.     Output data set Enrolid        Index_Therapy 114101       Sorafenib,Erlotinib 2086103     Sorafenib 102950901 Sorafenib 117102901 Sorafenib,Radio    etc ... View more

Treatment Duration Assignment: Please find below a sample data set with three variables: PATID FILL_DT INDEX_DATE DAYS_SUPP 1 01-Jan-14 01-Jan-14 30 1 01-Mar-14 01-Jan-14 30 1 01-Feb-14 01-Jan-14 20 1 22-Mar-14 01-Jan-14 15 1 01-Apr-14 01-Jan-14 16 1 15-Apr-14 01-Jan-14 10 2 01-Jan-15 01-Jan-15 20 2 01-Apr-15 01-Jan-15 15 2 01-Feb-15 01-Jan-15 10 2 15-Jan-15 01-Jan-15 16 2 15-Apr-15 01-Jan-15 10 2 05-May-15 01-Jan-15 50 3 01-Jan-14 01-Jan-14 20 3 01-Mar-14 01-Jan-14 20 4 22-Mar-16 22-Mar-16 40 4 10-Apr-16 22-Mar-16 25 4 01-Apr-16 22-Mar-16 10   Where PATID = Patient ID;             FILL_DT = Date the prescription was filled by the pharmacy;            INDEX_DATE = Date of treatment initiation            DAYS_SUPP= Estimated day count the drug supply should last. Objective: Estimate the number of days with continuous treatment prescription (starting from the INDEX_DATE) for every patient Approach: Treatment will be considered as continuous when the subsequent FILL_DT of a patient lies immediately after/within the end day of the previous treatment (where END_DATE = FILL_DT + DAYS_SUPP). You need to start from the index date and find the number of days with continuous treatment for every patient. For this, continue following the above-mentioned condition as long as there is break in treatment prescription. Further, delete the records which do not comply with the continuation criteria. The last date with continuous treatment criteria will be the true end date for each patient. Outcomes of interest:  Two new variables: TRUE_END_DATE: The last date fulfilling the continuous treatment criteria for each patient TX_DURATION: Number of days with continuous treatment based on the above-mentioned criteria ... View more

In the below picture, TABLE A has brand and then first.brand loan row contains total.   What I am want to do is create a desired table where the (first.brand row value = first row current value – following rows value ) and if its not the first.brand then value as the current value as show in the table 2.         Regards BMW ... View more

how can we print the expected output using characters function   DATA TEST; INPUT DEPARTMENT $ PRODUCTS $; DATALINES; D1 X1 D1 X2 D2 Y1 D2 Y2 D2 Y3 D3 Z1 D3 Z2 D3 Z3 D3 Z4 ; RUN;   expected output Department Products D1               X1,X2 D2               Y1,Y2,Y3 D3               Z1,Z2,Z3,Z4 ... View more

What would be the output value for group when the age is not 14? and why   data test; set sashelp.class; if age = 14 and sex = 'M' then do; y =1; group = '2'; end; else do; y =2; group = '22'; end; run;     ... View more