It is imported from excel and it was done "Alt tab" to make it to next line and this is causing problem
data WORK.TEST;
infile datalines dsd truncover;
input _NAME_:$8. _LABEL_:$40. COL1:$1024. COL2:$1024.;
datalines4;
F1,F1,Trial,ID
F2,F2,,Trial name
F3,F3,,Sources
F4,F4,,Primary publication
F5,F5,,Trial number
F6,F6,Trial design,Objective
F7,F7,,Randomisation:
Parallel or cross-over?
F8,F8,,Setting
... View more
I have a variable and the text of it looks fine if i look
Randomisation:Parallel or cross-over?
But if i copy that variable and paste it wraps to next line and not sure the reason and it only happens to 1 value of the variable
Randomisation: Parallel or cross-over?
Tried reducing length but no use. any clue why it happens
... View more
data ds;
infile datalines;
input id val;
datalines;
1 1
1 0
2 0
2 1
2 2
2 0
3 5
4 0
5 2
;
run;
In this case id 2 should not come as it has one value val as 0. I dont want any id if has either 0 or missing and want the rest of the id and val
... View more
how to remove the entire records of each id if it has values as either missing or zero.
i.e if i have id and have 5 values to it and next id 4 values and one of them is missing or zero than i want to ommit the entire id.
Any help
... View more
I want to remove the first text in data which ends with "-" .
sample data is
Exclusion #13 - The patient has any other disorder for which the treatment .
Exclusion #19 - The patient has or has had one or more of the following.
Inclusion #5 - The patient and parent(s)/ legal representative (s) is willing and able to attend study appointments within the specified time windows.
So i want to remove whenever there is "Exclusion #13 -" or Exclusion #19 -"
ANy help
... View more
I am using the below macro code(using it as i want the same variable name from 2 different dataset).
%macro EOex(inp=,testvar=);
data EO;
set EOex.&inp.;
EOTEST=upcase(cats(substr(&testvar,1,4),substr(&testvar,length(&testvar)-1)));
EOCAT=upcase(scan(&testvar,1));
run;
%mend;
%EOex(inp=EO_incl,testvar=EOi_std);
%EOex(inp=EO_excl,testvar=EOe_std);
But if i use it then it will just give me the last call and not the set of 2 calls. How can i set them in the same program?
Any help
... View more
I have a variable which has values like "magnum 1", "magnum 2" "magnum 3". I need to extract first3 and last number like "MAG1"
"MAG2". How can i do this in proc sql?
Any help
... View more
I am creating the below macro parameter and i get the following error.
%local armn;
%let armn=;
arm has trt1 and trt2
data test;
set test1;
output;
&arm="total";
&armn=999;
output;
run;
output; &arm.="total"; &armn.=9999; output; - 180 ERROR 180-322: Statement is not valid or it is used out of proper order.
=9999;
The error is coming from armn and not sure why. Can anyone help me
... View more
I have a macro program which calls screened and screenfailure and it is optional. Below in the datastep i use these for calculating. If i change in the macro call instead of screened as screening and scrn fail instead of screenfailure can i make the datastep also change. I Know it is weird but can there any step where i can do.
if upcase(DSTERM) in ("SCREENING" "SCREENED") then do;
%if &TotIncl ne %then %do;
&armvar="&TotName";
%end;
descr='Patients screened';
sort1=1;
sort2=1;
n=count;
n_pct=.;
output;
end;
%* Screen failure*;
if upcase(DSTERM) in ("SCREENING FAILURE" "SCREEN FAILURE") then do;
%if &TotIncl ne %then %do;
&armvar="&TotName";
%end;
descr='Screening failures';
n=count;
n_pct=.;
sort1=2;
sort2=1;
output;
end;
macro call is
%macro inc(
Anl = sdtm.ds,
AnlSel = %quote(DSTERM in ("SCREENED" "SCREEN FAILURE"))
etc...
);
any help
... View more
I get the below error message when reading xml file.
Is it something i am missing
ERROR: Some code points did not transcode. occurred at or near line 69, column 311 ERROR: XML parsing error. Please verify that the XML content is well-formed.
Please help
filename SXLELIB 'C:\CTgovAE.xml'; filename SXLEMAP 'C:\CTGovMap.map'; libname SXLELIB xmlv2 xmlmap=SXLEMAP access=READONLY;
data add; set SXLELIB.primary_outcome; run;
... View more
How can i not create a dataset if a variable is completely blank.
I am looping my program to create multiple datasets and i want to create a condition like if a particular macro variable is blank than not to create that dataset.
Any help? i tried %goto exit but it didnt work
%if &suppvar_list. ne %then %goto exit;
%else %if;
%** Loop through each variable thats being pushed to SUPP **;
%if %sysevalf(%superq(suppvar_list) ne,boolean) %then
%do j = 1 %to %sysfunc(countw(&suppvar_list.));
%let curr_var = %scan(&suppvar_list., &j.);
if not missing(&curr_var.) then do;
QNAM = upcase(vname(&curr_var.));
%** Look-up to get a label **;
rc = _hhSUPP.find(key:QNAM);
if rc ^= 0 then do;
QLABEL = vlabel(&curr_var.);
end;
QVAL = &curr_var.;
output;
end;
%end;
%**if suppvar_list is missing then QNAM, QORIG, QEVAL should be blank;
%else %do;
%do j = 1 %to %sysfunc(countw(&suppvar_list,%str()));
%let curr_var = %scan(&suppvar_list., &j.);
call missing(QNAM, QORIG, QEVAL);
%end;
%end;
%end;
... View more
Hi Kurt,
In fact i did that but i need the order to be as it is in aval. for that i need to make a sort variable to sort but unfortunately i dont have any common observation to merge.
... View more
