Hello,   I get an error message importing CSV file, I couldn't find a solution in this forum, please help, thank you!   code: %web_drop_table(WORK.IMPORT1); FILENAME REFFILE "&analydir/survey.csv" ; PROC IMPORT DATAFILE=REFFILE DBMS=csv OUT=WORK.IMPORT1; GETNAMES=YES; RUN; PROC CONTENTS DATA=WORK.IMPORT1; RUN; %web_open_table(WORK.IMPORT1);     log message:     exel file:     when opened with Notepad ++:   ... View more

Hello, Not sure if this will be a simple process, but is it fairly simple to import an excel file (eg ADSL specs) and convert them into dataset variable names, length, and label?     ... View more

Hello,   my legend does not have any colors to match with the bargraph. not sure how to fix it   output:     code: proc sgplot data=graph; vbar var/response=varn group=txt groupdisplay=cluster; label varn='% of Patients' var='' txt='Visit Time'; legenditem type=FILL name='Baseline' /label='Baseline (N=&two1n)' ; legenditem type=FILL name='Usage' /label='60-Month followup (N=&two2n)'; keylegend "Baseline" "Usage"; run;     ... View more

Hello,   How do i extract the value in the "( )" and convert into numeric? I only want numbers, not "NA". data: var1 (character) 3 ( na   )  81 (41.1%) 3 (1.5%)   want: var2 (numeric) . 41.1 1.5 ... View more

Hello,   I need to make a simple bar graph that looks like this:   sample data: order (num) var2 (char) var3 (char) var4 (num) 1 No Symptoms screening 23 1 Symptoms1 screening 244 1 Symptoms 2 screening 25 2 No Symptoms visit 20 50 2 Symptoms1 visit 20 70 2 Symptoms 2 visit 20 30 3 No Symptoms screening 23 3 Symptoms1 screening 244 3 Symptoms 2 screening 25 4 No Symptoms visit 20 50 4 Symptoms1 visit 20 70 4 Symptoms 2 visit 20 30                                                      1 ... View more

Hello I am trying to create a log file by using proc print but when I run my program it creates an rtf %let analydir=\\Biostatistics\Analysis\ ; ods tagsets.rtf(ID=l_chemo) file="&analydir.\Output\l_10_chemotherapy.rtf" style=myrtfn; *styles.rtfn; proc report nowd /*headline*/ headskip split='*' data=blank spacing=1 missing ; cols a; define a / display ''; run; ods tagsets.rtf(ID=l_chemo) close ODS RTF close; proc printto log="&analydir.\Log\l_10_chemo.rtf" NEW; run; RTF output:   ... View more

Hello,   I have values with spaces i want to strip.   data (character values): var1 (   5.4%, 15.3%) (     100.0%) (100.0%,99.9%)     want: var1 (5.4%, 15.3%) (100.0%) (100.0%,99.9%)   ... View more

Hello,   how do I add a ")" at the end of the variable if it's missing a ")"?   data: var (100.00% (99.0%) (10.00%) (5.55%) (99%   want: (100.00%) (99.0%) (10.00%) (5.55%) (99%) ... View more

Hi,   I need to plot this comparison graph between 2 variables (see screenshot).  Can someone identify the type of plot and a general procedure for this (looks like it's a comparison between 2 variables for 2 studies)?  Thank you.   ... View more