About vraj1

vraj1 · ‎09-21-2017

I have a variable which has caharacter values and i want to extract values which ends with *. var 5.6 H * 4.3 2.6 9.6 L * How can i do that?

vraj1 · ‎09-12-2017

options missing = "" ls=200; proc report data = rep nowd split = "¤" headline missing contents = "" out=rep1; column param actarmn actarm timevar (' ' Ntot) anrind, (count pctc ) a1ind, (count2 pctc2 ) dummy ; define param / group style(header)={just=left cellwidth=4.5cm} style(column)=IdColIndent2{asis=on} "Parameter" ; define actarmn / group order=internal noprint; define actarm / group style(header)={just=left cellwidth=2cm} style(column)=IdColIndent2{asis=on} "Treatment Group"; define timevar /group order=data style={just=right cellwidth=2cm} "Week"; define anrind /across order=data style={just=left} "Normal Range"; define Ntot / analysis "N" style={just=right cellwidth=0.81346153846152cm} ; define dummy /noprint; define a1ind /across order=data style={just=left} "PCS"; define count /analysis order=internal group sum style={just=right cellwidth=0.81346153846152cm} "n"; define count2 /analysis order=internal group sum style={just=right cellwidth=0.81346153846152cm} "n"; define pctc /display order=internal group style={just=right cellwidth=1.08461538461536cm} "(%)"; define pctc2 /display order=internal group style={just=right cellwidth=1.08461538461536cm} "(%)"; compute before; line @1 ' '; endcomp; compute after actarmn; line ' '; endcomp; run;

vraj1 · ‎09-12-2017

how to group or order a variable if it is used analysis in define statement in proc report.

vraj1 · ‎09-11-2017

i have a sample dataset as below subj var2 var3 var4 1 time 12043 mark 1 jack 43535 steve 2 bob 52352 vsvgv 2 steve 24565 fbhdhn 3 kdire 2355 rtgeff 3 dfsde 63634 rwege 3 kjyytt 34235 fgsggsd and i need to set uplike below subj value desc 1 time var2 1 12043 var3 1 mark var4 1 jack var2 1 43535 var3 1 steve var4 2 bob var2 2 52352 var3 2 vsvgv var4 2 steve var2 2 24565 var3 2 fbhdhn var4 can anyone help me how to do this

vraj1 · ‎09-07-2017

I need to create a flag where in one dataset i have few terms like andy, parci, mubdi and if in the other dataset i have these terms it should be flagged as Y. How can i merge them?

vraj1 · ‎08-31-2017

Thanks a lot Tom. Can the new date format be converted to date9(characcter) in the same data step?

vraj1 · ‎08-30-2017

can usubjid be used in that code and take first and last observation? as i need time as well to calculate duration later

vraj1 · ‎08-30-2017

attaching test data

vraj1 · ‎08-30-2017

unfortunately i cannot use proc summary as the dates are character dates.

vraj1 · ‎08-30-2017

i used it but still doesnt work

vraj1 · ‎08-30-2017

I need to get for each usubjid i need the first ECSTDTC(start date) and last ECENDTC (end date) so basically one record per usubjid. proc sort data=ec out=ec7; by usubjid ECSTDTC; run; data ec1; set ec7; by usubjid ECSTDTC ECENDTC; if First.ECSTDTC and last.ECENDTC then output; run; can anyonew help me

vraj1 · ‎08-30-2017

I tried using the same code but it didnt work. i need to get for each usubjid i need the first ECSTDTC(start date) and last ECENDTC (end date) so basically one record per usubjid. proc sort data=ec out=ec7; by usubjid ECSTDTC; run; data ec1; set ec7; by usubjid ECSTDTC ECENDTC; if First.ECSTDTC and last.ECENDTC then output; run;

vraj1 · ‎08-25-2017

is there any option to send procedures used in program to output file may be in an excel?

vraj1 · ‎08-24-2017

i have an excel which i attached with multiple sheets in it and i am extracting them and all the sheets have same variable names. Can any one help me in extracting as i get errors and truncated values libname localct "M:\work/Boo.xlsx"; data test; set localct.'TEST$'n; localct.'CAT$'n; localct.'SCAT$'n; localct.'OTHER$'n; where fmtname ne ' '; run; data study_ct; set test cat scat other ; where fmtname ne ' '; run; libname localct clear;

vraj1 · ‎08-23-2017

I have a doubt and its not related to my work. Do we need to make define xml if the datasets submitted are not CDISC standard. If not what is usually submitted along with xpt files?

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

Need to extract data which has "*" as value

Re: how to group or order a variable if it is used analysis in define...

how to group or order a variable if it is used analysis in define sta...

data set up variables

merge without id variable

Re: first. and last.

Re: first. and last.

Re: first. and last.

Re: first. and last.

Re: first. and last.

first. and last.

Re: first.[variable], last.[variable] question

is there any option to send procedures used in program to output file

problems with length while extraction of multiple files

Do we need to make define xml if the datasets for submission are not C...