Is it possible to use SAS for annotating the CRF(case report form in Clinical Trials) ? If so, please assist on how to do it? Looking forward to your response. Thanks In advance ... View more

As I recently posted here, I'm trying to create Table 1 for a research journal article. @Reeza pointed me to the Table 1 macro "TableN" and it looks like exactly what I need.   I downloaded the macro and ran it, and then I tried to call it based on the example provided.   /*Example macro call*/ /*%tablen(data=example, by=arm, var=age date_on sex race1 smoke_st num_met, type=1 3 2, outdoc=~/ibm/example1.rtf);*/ /*My version*/ %tablen(data=have, by=TM_group, var=DEM_AGE DEM_SEX, type=2 2, outdoc="C:\data_output\test.rtf); But I got an error after "by TM_group": ERROR: All positional parameters must precede keyword parameters. I looked up the error and it has something to do with the commas between the parameters. After some trial and error of deleting commas, I got it to run without error, but it doesn't produce any output.     Sample data is provided below: data have; infile datalines dsd dlm=',' truncover; input DEM_AGE DEM_SEX cohort_flag TM_group; datalines; 3,1,1,0 2,1,1,1 3,2,1,1 3,2,1,1 3,2,1,0 2,2,1,1 2,1,1,1 3,1,1,1 2,1,1,1 3,2,1,0 2,1,1,0 2,2,1,1 3,2,1,0 2,2,0, 3,2,1,1 3,2,1,1 3,1,1,0 3,2,1,0 2,1,1,0 3,1,1,1 3,2,1,1 3,2,1,0 3,2,1,1 3,2,1,1 3,2,1,1 ; RUN; proc format library=temp; value age2grp 1='1:Age Group <65' 2='2:Age Group [65,75)' 3='3:Age Group >=75' .='Inapplicable/Missing'; value sex .='Inapplicable/Missing' 1='1:Male' 2='2:Female' value yesfmt 1='1:Yes' 2='2:No' .='Inapplicable/Missing' ; RUN;   ... View more

Hi everyone, I can see all the markers in the plot, but the corresponding admission dates on the x-axis are not fully visible. How can I adjust to see every admission date?   proc shewhart data=VV; xchart   LOS*admission_date  /Markers   outtable=outtable    nohlabel   TOTPANELS=1; run;proc print;run;   Thanks,   ... View more

Hi, I am new to SAS and I am trying to input data from the a .txt file. Could someone please help me figure out why the IF-THEN statement only applies to the first row of the data? Thanks! Data:   DATA work.condo_ranch; INFILE '/home/u63748921/SAS 123 Problems/sas123_p13.txt' DSD; INPUT style $ @; IF style = 'RANCH' OR style = 'CONDO' THEN INPUT sqfeet bedrooms baths street $ price : dollar10.; RUN; Output: ... View more