Hello SAS Community,   I need your help for the following problem.   Dataset1; ID         Var1 123          0 123          0 123          1 123          1 456           0 456           0 456           0 456           0 789           0 789           1 789           1 789           0   The output datasets should look like ID     Var1 123         0 123         0  789         0   ID     Var1   123          1 123          1 789          1 789          1 789          0   Logic: 1) Include only if the ID has at least one occurrence of 1 under var1.     ... View more

Hi SAS community,    I have 4 datasets that have data on same population across 6 time points.   I want to know how to perform the occurrence as show below.   Dataset 1   ID       Var 1 1           0 2           0 3           0 4           0 5           0   Dataset 2   ID       Var 1 1           0 2           0 3           1 4           0 5            0   Dataset 3   ID       Var 1 1           1 2           0 3           1 4           0 5           0   Dataset 4   ID       Var 1 1           1 2           0 3           0 4           1 5           0   I want to find of all the people who had an occurrence of 1 at-least once across the 4 time points or Datasets.  ... View more

Hi SAS Community,   I am trying to solve this issue with date formatting. I just want to make the Enddate variable in a date format. I tried anydtdte and worddate. But all those end up with an error that the format doesnot exist.     data abcd ; set abc ; Informat Enddate : anydtdte20.; run;     Code Enddate A4466 December 31, 2016 A7011 December 31, 2015 A7042 December 31, 2014 A7043 December 31, 2014 A9544 December 31, 2016 A9545 December 31, 2016 B9000 December 31, 2016 C1204 December 31, 2013 C1300 December 31, 2014 C1879 June 30, 2013     Any help much appreciated. ... View more

    Hi SAS Community, I need you help in the following problem. I have a dataset that looks like this   NDC PHARM_CLASSES 21434 GLP-1 Receptor Agonist [EPC],Glucagon-Like Peptide 1 [Chemical/Ingredient],Glucagon-like Peptide-1 (GLP-1) Agonists [MoA] 21445 . 21975 Androgen [EPC],Androgen Receptor Agonists [MoA],Androstanes [Chemical/Ingredient] 21977 Androgen [EPC],Androgen Receptor Agonists [MoA],Androstanes [Chemical/Ingredient] 23004 . 23227 Norepinephrine Reuptake Inhibitor [EPC],Norepinephrine Uptake Inhibitors [MoA]   and I am hoping to get an output like this    NDC EPC MoA Chemical Ingredient 21434 GLP-1 Receptor Agonist  Glucagon-like Peptide-1 (GLP-1) Agonists  Glucagon-Like Peptide 1  21445 . . . 21975 Androgen  Androgen Receptor Agonists Androstanes 21977 Androgen  Androgen Receptor Agonists Androstanes 23004 . . . 23227 Norepinephrine Reuptake Inhibitor  Norepinephrine Uptake Inhibitors . I have got help for the same problem previously but, I get a WARNING: 2761 observations omitted due to missing values in the ID variables due to PROC TRANSPOSE. I don't want to loose any observation.  Can anyone help me with this problem.   Thank you in advance data middle; set NDCdata(Keep= PHARM_CLASSES NDC); length term $150 tag $20 ; do i=1 by 1 until (term=' '); term=strip(scan(PHARM_CLASSES,i,',')); tag=scan(term,2,'[]'); if term ne ' ' then output; end; run; proc sort data=middle ; by NDC tag ; run; data middle2 ; set middle ; by NDC tag ; rep+1; if first.tag then rep=1; run; proc transpose data=middle2 out=want(drop=_name_) ; by NDC; id tag rep ; var term ; run; data cc; set want (Keep = NDC Chemical_Ingredient1 EPC1 MoA1); run; proc sort data = b out = bsort Tagsort nodupkey; by NDC; run; proc sort data = cc out = ccsort Tagsort nodupkey; by NDC; run; data dd ; merge bsort ccsort ; by NDC ; where NDC ^= '.' ; drop productID; run ... View more

Hello SAS Community,   Thank you in advance for responding.   I was wondering if anyone could help me with plotting 3 variables namely Top Medium and Lowon X axis and Counts of those variables on Y-axis.  Each variable( Top, Medium and Low) are expected to have 0 1 2 3 observations and I want to plot all 3 variables on X axis and the frequency of 0 1 2 3 on Y axis.    Data dsn1; input UID $2. Top Medium Low ; cards; WW 1 1 1 O 1 1 1 FF 2 1 0 D 2 1 0 Y 1 2 0 BB 0 1 2 R 1 1 1 E 1 2 0 AA 1 1 1 OO 1 1 1 T 0 0 3 CC 1 0 2 ; run; proc sgplot data = dsn1; vbar Top/ stat = freq ; run; proc sgplot data = dsn1; vbar Medium/ stat = freq ; run; proc sgplot data = dsn1; vbar Low/ stat = freq ; run; Please comment the possibility.   Thanks.           ... View more

         Hello SAS users,   I have a question on how to get this right. I have a 10 digit NDC code in 3 formats as shown below. I need to add a '0' in specified places based on the format. Below is my code to solve this but I keep getting errors with the use of substring. I do know I can use scan to complete the process. But, I want to know if there is an efficient way to do this.     NDC packagecode is same as NDC code.   seq1endpos = find ( ndcpackagecode , "-") ; seg1 = substr ( ndcpackagecode , 1 , seq1endpos - 1 ) ; seq2endpos = find ( substr ( ndcpackagecode , seq1endpos + 1 , 10 ) , "-") ; seg2 = substr ( ndcpackagecode , seq1endpos + 1 , seq2endpos - 1 ) ; seg3 = substr ( ndcpackagecode , seq1endpos + seq2endpos + 1 , 2 ) ; compressedcode = compress ( ndcpackagecode , "-" , "") ; if length(trim(seg1)) = 5 then do ; if length(trim(seg2)) = 4 and length(trim(seg3)) = 2 then do ; ndccode = trim(seg1) || trim(seg2) || trim(seg3) ; ndcmod = 0 ; end ; if length(trim(seg2)) = 4 and length(trim(seg3)) = 1 then do ; ndccode = trim(seg1) || trim(seg2) || '0' || trim(seg3) ; ndcmod = 1 ; end ; if length(trim(seg2)) = 3 and length(trim(seg3)) = 2 then do ; ndccode = trim(seg1) || '0' || trim(seg2) || trim(seg3) ; ndcmod = 1 ; end ; if length(trim(seg2)) = 3 and length(trim(seg3)) = 1 then do ; ndccode = trim(seg1) || '0' || trim(seg2) || '0' || trim(seg3) ; ndcmod = 1 ; end ; end ; if length(trim(seg1)) = 4 then do ; if length(trim(seg2)) = 4 and length(trim(seg3)) = 2 then do ; ndccode = '0' || trim(seg1) || trim(seg2) || trim(seg3) ; ndcmod = 1 ; end ; if length(trim(seg2)) = 4 and length(trim(seg3)) = 1 then do ; ndccode = '0' || trim(seg1) || trim(seg2) || '0' || trim(seg3) ; ndcmod = 1 ; end ; end ; if length(ndccode) ne 11 then ndcbadlength = 1 ; else ndcbadlength = 0 ;   NDC Conversion: 10-digit to 11-digit   If 10-digit NDC format is: Then add a zero (0) in: Report NDC as: 4-4-2 9999-9999-99 1st position 09999-9999-99 09999999999 5-3-2 99999-999-99 6th position 99999-0999-99 99999099999 5-4-1 99999-9999-9 10th position 99999-9999-09 99999999909   Here is another example of how the end result should be:  Can some one help. Thank you in advance.   ... View more