i have a date variable which is in numeric and in "2009-02-17" format. i am calculating flag variable with char date in "2009-02-15" and converting it to numeric like below
data ae053; set ae052; format SVSTD date9.; SVSTD = input ( SVSTD, MMDDYY10.); if ASTD < SVSTD then flag= "N"; else flag= "Y"; run;
I still get error in the log.
can anyone help me in this
... View more
I have a dataset and want to merge with another dataset but i have different lengths for variables in both the datasets.
In this case i am using length statement to match the lenghts but i get warnings.
data ae010; length AESPID $10 AESTDTC AEENDTC $20 AESEV $50 AECONTRT aeser $1; set ae010; run;
WARNING: Multiple lengths were specified for the variable AESPID by input data set(s). This can cause truncation of data. WARNING: Multiple lengths were specified for the variable AESEV by input data set(s). This can cause truncation of data. WARNING: Multiple lengths were specified for the variable AESER by input data set(s). This can cause truncation of data. WARNING: Multiple lengths were specified for the variable AECONTRT by input data set(s). This can cause truncation of data. WARNING: Multiple lengths were specified for the variable AESTDTC by input data set(s). This can cause truncation of data. WARNING: Multiple lengths were specified for the variable AEENDTC by input data set(s). This
... View more
i have 3 outputs and want to export them into single excel with different sheets.
Can any one help me easiest way to do then manually doing
... View more
in my dataset i have dates which are like
2005-09-16T13:30
2005-09-23
2005-09-30
in these i want to remove iso date and keep as yymmdd10. format.
i used the below code but
exstdtc1= input(exstdtc,yymmdd10.);
format exstdtc1 yymmdd10.;
I get the correct format but it is numeric. how to make it in character
... View more
I have a variable which has values like "haga-89ndff-pssj" i need to extract the values which is between - for ex in this case 89ndff.
Can anyone help me how to do it in scan.
... View more
sub visit flag
1 3 Y
1 4 Y
2 4 N
2 5 N
2 6 Y
3 4 Y
In the above if i want unique sub i do nodupkey on sub but for sub 2 the flag is N and Y and i only get N as it is first. FOr sub 2 i want Y if it has both N and Y
... View more
I created a flag variable like the below
data da1; set da; where visitnum gt 3; if dastresn gt 0 then do; FLAG="Y"; FLAGN=1; end; if dastresn le 0 then do; FLAG="N"; FLAGN=0; end; run;
Now for some subjs i get both Y and N and in those cases i only need Y.
I used nodupkey to get unique subjects but in some subjects i get flag as N
... View more
I have a dataset and in that a variable called var. In that i need extract observations which has a word "SOMETH". It may be first word or middle or last. Can you please explain me how to do it.
I tried var=:"SOMETH" but it only gives if the word comes first.
... View more
Sorry for asking it again.
after i do this step
proc datasets library=sdt; copy out=sdttest; quit;
I will import my excel sheet which has subject id's and then the below?
data _null_; set sashelp.vtable (where=(libname="sdt")); call execute('proc sql; delete from SDT.'||strip(memname)||' where SUBJID not in (select distinct SUBJID from SUBJ); quit;'); run;
Is it right?
where will my new data which has datasets with the subject id's needed be saved.
... View more
i am copying all datasets like below
proc datasets library=sdt;
copy out=sdttest;
quit;
In this i have a excel sheet with list of subjects and i only want those subjects copied in all the datasets from sdt.
Can anyone help me in this
... View more
I have a dataset like
Trial treat1 treat2
123 23.2 34.2
234 78 87
Now i want a last column naming all with sum of the rows
Trial treat1 treat2
123 23.2 34.2
234 78 87
all 101,2 121,2
Can any one help me in this
... View more
