About vraj1

ChrisNZ · ‎06-01-2018

If you start adding such variations, you are better off with something like: STARTPOS = find(STR, 'The rate'); ENDPOS1 = find(STR, '.', STARTPOS); ENDPOS2 = find(STR, ', and execute ', STARTPOS) -1 ; NEWSTR = substr(STR, STARTPOS, min(ENDPOS1, ENDPOS2, length(STR)) - STARTPOS); Please alter to suit.

RW9 · ‎05-18-2018

"Doesn't work" - does not tell us anything. What does the log say? You should have three datasteps for each dataset in work. Is the where clauses correct?

RW9 · ‎05-02-2018

A simple couple of line just to illustrate is fine on the test data. Anyways, rename the in variables from the smaller, then do an if or coalesce: data exm_final (drop=tmp_lbtestcd tmp_lbdtc...); merge inc (in=b keep=usubjid lbtestcd lbdtc lbseq visit visitnum rename=(lbtestcd=tmp_lbtestcd lbdtc=tmp_lbdtc...)) inc2 (in=a); by usubjid lbtestcd LBDTC; if lbtestcd="" then lbtestcd=tmp_lbtestcd; if lbdtc="" then lbdtc=tmp_lbdtc; ...; if a; run; You could maybe to it with the update part of datastep; http://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/viewer.htm#a000202975.htm Up to you.

vraj1 · ‎04-19-2018

Thew values are numeric and as the dataset is in excel when i imported it became character, but somehow it is not working. attaching new data. ignore the values as it is test data but if visitnum is 1 with same studyid,usubjid,paramcd and aval is missing then the rest of the records for same studyid,usubjid,paramcd chg and pchg should be missing. data WORK.MYDATA; infile datalines dsd truncover; input usubjid:$16. studyid:$3. paramcd:$5. aval:3. ablf:$1. base:3. chg:3. pchg:2. visit:$9. visitnum:32.; datalines4; AA1-US1103-S3317,AA1,URIN,.,,,.,.,Visit 1,1,, AA1-US1103-S3317,AA1,URIN,3.6,,.,.,.,,,, AA1-US1103-S3317,AA1,URIN,3.6,,.,.,.,Visit 6,6,, AA1-US1103-S3317,AA1,URIN,3.6,Y,3.6,0,0,Visit 6,6,, AA1-US1103-S3317,AA1,URIN,4.2,,3.6,.,.,Visit 10,10,, AA1-US1103-S3317,AA1,URIN,4.2,,3.6,0.6,17,Visit 10,10,, AA1-US1103-S3317,AA1,URIN,5.6,,3.6,2,56,,,, AA1-US1103-S3317,AA1,URIN,5.6,,3.6,.,.,Visit 12,12,, AA1-US1103-S3317,AA1,URIN,5.6,,3.6,2,56,Visit 12,12,, AA1-US1103-S2317,AA1,PLASM,39,Y,42,-3,-7,Visit 1,1,, AA1-US1103-S2317,AA1,PLASM,42,,42,0,0,,,, AA1-US1103-S2317,AA1,PLASM,42,,39,3,8,Visit 5,5,, AA1-US1103-S2317,AA1,PLASM,42,,42,.,.,Visit 6,6,, AA1-US1103-S2317,AA1,PLASM,39,,42,-3,-7,Visit 10,10,, AA1-US1103-S2317,AA1,PLASM,39,,39,0,0,Visit 10,10,, AA1-US1103-S2317,AA1,PLASM,40,,42,-2,-5,,,, AA1-US1103-S2317,AA1,URIN,40,,40,0,3,Visit 1,1,, AA1-US1103-S2317,AA1,URIN,42,,40,0,0,Visit 12,12,, AA1-US1103-S2317,AA1,URIN,42,,40,-2,8,Visit 12,12,, ;;;; Sorry for the trouble but somehow it is mystery why it is not working.

Kurt_Bremser · ‎04-17-2018

@vraj1 wrote: Missing seq should be replaced from observation which has visit as visit1 and seq ne missing. That seq number should be retained to the seq number which has missing seq and visit as visit1 Then replace the second data step with data want; set have; by usubj; retain retseq; if first.usubj then retseq = .; if input(scan(visit,2),3.) = 1 /* Visit 1 */ then do; if seq ne . then retseq = seq; else seq = retseq; end; drop retseq; run;

vraj1 · ‎04-14-2018

It somehow does'nt work if i use the below code. ot sure where i am doing wrong. proc sort data=WORK.FILTER_FOR_ADLB_SAS7BDAT_0003 out=inh(keep=usubjid paramcd base chg aval studyid2 visitnum visit); by usubjid paramcd visit; run; data want (drop=lst_base lst_chg); set inh; retain lst_base lst_chg; by paramcd; if first.paramcd and visitnum=10 and aval ne . and studyid2="0A23" then do; lst_base=base; lst_chg=chg; end; else do; data: if base=. then base=lst_base; if chg=. then chg=lst_chg; end; run; usubjid paramcd aval base chg visit visitnum studyid2 101 Bio 45 42 3 . 0A23 101 Bio 43 42 1 . 0A24 101 Bio 45 . . . 0A23 101 Bio 43 . . . 0A24 101 Bio 43 45 -2 . 0A24 101 Bio 43 42 1 Unscheduled 5.1 0A24 101 Bio 43 . . Unscheduled 5.1 0A24 101 Bio 43 45 -2 Unscheduled 5.1 0A24 101 Bio 45 45 . Visit 1 (Baseline Extension A) 1 0A24 101 Bio 42 42 . Visit 1 (Screening) 1 0A23 101 Bio 48 42 6 Visit 10 (End of Week 😎 10 0A23 101 Bio 48 . . Visit 10 (End of Week 😎 10 0A23 101 Bio 45 42 3 Visit 12 (Completion/Withdrawal) 12 0A23 101 Bio 45 . . Visit 12 (Completion/Withdrawal) 12 0A23 101 Bio 45 42 3 Visit 6 (End of Week 4) 6 0A23 101 Bio 45 . . Visit 6 (End of Week 4) 6 0A23

kiranv_ · ‎04-08-2018

one way to do this data have; input var $20.; datalines; IE_INCL001G_9 IE_INCL001G_4 IE_INCL001G_19 IE_EXCL001G_3 IE_EXCL001G_1 ; data want; set have; newvar= cats(substr(scan(var,2,"_"),1,4),put(input(scan(var,3,"_"),2.),z2.)); run;

gamotte · ‎04-04-2018

Hello, A solution with a regexp : data have; string='If IsEqualTo Inclusion 1 then... set datapoint value for ILIST in Inclusion Criteria to LIST #1 - The subject is a boy or girl, aged ≥7 and <12years (patients who turn 12 years during the study will be allowed to continue in the game)., and execute the ""Return True"" custom function'; extract=prxchange("s/.*-(.*)\..*/$1/",1,string); run;

Astounding · ‎03-23-2018

Fourth, given that you need to collapse the observations, here's a way to do it that doesn't require too much programming: proc sort data=prim; by usubjid avisitn; run; data want; update prim (obs=0) prim; by usubjid avisitn; run;

Criptic · ‎03-23-2018

Use the first functionality in the data step e.g. data aaa; set your_table; by id; if first.id then output; run;

gamotte · ‎03-22-2018

Use compress with the hex code for linefeed. coll=compress(coll,'0A'x);

srinath3111 · ‎03-13-2018

Hi, Then try, data ds2; merge ds(where=(not val) in=null) ds; by id; if not null; run; Thanks

vraj1 · ‎03-09-2018

Its only 3 letters:-)

ballardw · ‎03-08-2018

One way, assuming that - first occurs in the way that you show. data want; set have; var = substr(var,index(var,'-')+2); run; The +2 assume that you do not actually want the value to start with the blank that would follow the -.

RW9 · ‎03-08-2018

As I have mentioned on many occasions, macro code does not do anything, it is a text find and replace system. So what do we do with the code you presented, we do a find and replace, so that code becomes: data EO; set EOex.EO_incl; EOTEST=upcase(cats(substr(EOi_std,1,4),substr(EOi_std,length(EOi_std)-1))); EOCAT=upcase(scan(EOi_std,1)); run; data EO; set EOex.EO_excl; EOTEST=upcase(cats(substr(EOe_std,1,4),substr(EOe_std,length(EOe_std)-1))); EOCAT=upcase(scan(EOe_std,1)); run; Now what part of this actual executable code does not work the way you had intended? Is it because you are overwriting EO in both the first and second calls to the macro? Also, you would again find your like is much simpler using industry standards - possibly CDISC SDTM due to this being inclusion/exclusion information, this way you would have all the data in one dataset, and the same code could run over just one dataset. Even if not using that, you can simplfy your code 50% by: data eo; set eoex.eo_incl (rename=(eoi_std=std)) eoex.eo_excl (rename=(eoe_std=std)); eotest=upcase(cats(substr(std,1,4),substr(std,length(std)-1))); eocat=upcase(scan(std,1)); run; See, never a need to use macro.

Online Status	Offline
Date Last Visited	‎01-24-2023 11:53 AM

Re: extract libnames from excel and create macro variable to call libn...

Re: extract libnames from excel and create macro variable to call libn...

extract libnames from excel and create macro variable to call libnames

Re: how to extract hour minutes and seconds from sas datetime19.

how to extract hour minutes and seconds from sas datetime19.

Re: need to count positive and negative PID's

Re: need to count positive and negative PID's

Re: need to count positive and negative PID's

Re: need to count positive and negative PID's

need to count positive and negative PID's

Re: proc sql - syntax error

Re: new record based on condition

Re: where condition if using multiple datasets in proc sql join

Re: How to handle with length truncation and replacing with valuable i...

Re: Need to extract data from string with conditions

split data based on conditions

Re: Need to retain seq number for same visit

Re: Need to extract data from string with conditions

Re: read all datasets in a library and conditionally split them

Re: how to replace missing values with values present by merging them

Re: want to make few variables blank if the condition satisfies

Re: Need to retain seq number for same visit

Re: unable to workout with lag

Re: how to extract particular string from the variable

Re: How to extract text data from a variable

Re: how to get all in one row

Re: filter needed if a same id has 2 or more observations

Re: text of variable wrapping to next line - any reason

Re: how to remove the entire records of each id if it has values as ei...

Re: How to extract first 3 letters and last letter by using proc sql

Re: How to get rid of particular text which comes in the start and has...

Re: how to update the dataset with the new macro call