cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
augustcrez
‎05-14-2019
  • 4 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Store value of a variable to reuse it anywhere else in data

by Calcite | Level 5 in SAS Programming
‎05-09-2019 05:46 AM
‎05-09-2019 05:46 AM
Hi all,    I have a data as following    Subj tpt grpid 1 24 bd 1 36 bid 1 72   And many more. I want when my tpt is 72 and irrespective of grpid missing or non missing should take grpid of tpt=24 So my data should look Subj tpt grpid 1 24 qd 1 36 bid 1 72 qd   Please help!    ... View more

Re: Compare two variables and output the matching string

by Calcite | Level 5 in SAS Programming
‎11-12-2018 04:16 AM
‎11-12-2018 04:16 AM
Hi ,   Both the solutions work fine for me in most of the rows but i also found a case which is as follows  data have; length VAR1 $50 var2 $50; input VAR1 $ VAR2 $; infile datalines dlm='|'; datalines; 1.LMK 2.ABCNM 3.XYZ|ABCNM, XYZ, NM 1.ABC|ABCNM, XYZ, NM 1.XYZ|ABCNM, XYZ, NM ; run;   here in my first now my resultant should be only "ABCNM, XYZ" but i get "ABCNM,XYZ,NM" which shouldnt be the case as im looking for exact matches Also can i apply formats to these drugnames at the same time?   Please help!   Thanks ... View more

Re: Compare two variables and output the matching string

by Calcite | Level 5 in SAS Programming
‎11-11-2018 11:49 PM
‎11-11-2018 11:49 PM
Hi ,   Both the solutions work fine for me in most of the rows but i also found a case which is as follows  data have; length VAR1 $50 var2 $50; input VAR1 $ VAR2 $; infile datalines dlm='|'; datalines; 1.LMK 2.ABCNM 3.XYZ|ABCNM, XYZ, NM 1.ABC|ABCNM, XYZ, NM 1.XYZ|ABCNM, XYZ, NM ; run;   here in my first now my resultant should be only "ABCNM, XYZ" but i get "ABCNM,XYZ,NM" which shouldnt be the case as im looking for exact matches Also can i apply formats to these drugnames at the same time?   Please help!   Thanks ... View more

Compare two variables and output the matching string

by Calcite | Level 5 in SAS Programming
‎11-06-2018 02:16 AM
‎11-06-2018 02:16 AM
Hi,   I have two columns: 1. is my list of treatment drugs given to a patient (multiple, can have the study drug or cannot have the study drug) and 2 is my list of drug related to the study(separated by a coma, constant/fixed). My requirement is i have to search for rows where my list of study drugs has been given to the patient. and display all those separated by coma. I have my main dataset to which each row i have merged my list of drug(combined into coma separated). VAR1                                                      VAR2                     WANT 1.LMK 2.ABC NM 3.ABC 4.XYZ           ABC, XYZ               ABC, XYZ 1.ABC                                                   ABC, XYZ               ABC 1.XYZ                                                   ABC, XYZ               XYZ   Please help!   Thanks. ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎05-14-2019 04:07 AM
Quick links