I respectfully disagree. That method (constrained optimization) is not a good way to simulate data. ... View more

Hi there, Here is the code that I used to create the output that you desire. data have; length male $8; male="male"; arma=18; armb=16; run; ods rtf file='c:\sasuser\tryindent2.rtf'; proc report data=have NOWD style(lines)={leftmargin=.25in just=left protectspecialchars=off}; title1 "Table X Count of male subjects by arm"; column Male Arma armb; define Male/display " Male" style=[cellwidth=4 just=c]; define ArmA /display " Arm A /(N)" style=[cellwidth=2 just=c]; define armb/display "Arm B/(N)" style=[cellwidth=2 just=c]; compute after; line "1 Count of male subjects by arm."; line "2 Arm is assigned at week 2 after study initiated:"; line "\tab {2a Arm A: Control.}"; line "\tab {2b Arm B: Test.}"; endcomp; RUN; ods rtf close; Please keep in mind that \tab will not work in PDF or HTML, but in RTF only. I'm attaching the output that I got using the code above. ... View more

This shows how to colour the cells but the STYLE can also include the alignment/justification.  This is know as conditional formatting.   http://support.sas.com/kb/23/353.html   @Defense wrote: ods rtf file="&outdir\Table1.rtf";   title1 'Table XX'; title2 'Members by Country and City ';   proc report data=table NOWD; column Location All; define Location /"Location" style=[cellwidth=1 in font =("Arial",8) just=c]; define All /display "All" style=[cellwidth=1 in font =("Arial",8) just=c]; run;   ods rtf close;   ... View more

 I don't think so. The only way I could plot two variables was with "Multiple Measures Vertical Group", but it used a common left Y axis.   Tom ... View more

proc format; value gender 1='male' 2='femal'; run; DATA have; input group id sex ; format sex gender.; datalines; 1 133 1 3 134 1 ; run; proc report data=have nowd; define group/display; run; ... View more

@Defense And if you just want to execute and compile the format then use option 2 in below script. data have; infile datalines truncover; input col $char80.; datalines4; proc format ; value DFSTATv 0 = "lost" 1 = "clean" 2 = "dirty" 3 = "error" ; run; ;;;; run; /* option 1: Write code to .sas file on desktop of user */ data _null_; file "%sysget(userprofile)\Desktop\want.sas"; set have; put @1 col $char.; run; /* option 2: Write code SAS WORK location and the execute it */ filename code temp; data _null_; file code; set have; put @1 col $char.; run; %include code /source2; ... View more

Thanks. I did not add "input col $1-300;" complete code is   data want; infile "C:\Users\weig3\Desktop\CRF.sas" lrecl=300 truncover; input col $1-300; RUN;     Works. Thanks     ... View more

 Are you doing a hex to binary conversion like @PGStats suggested, or a char to binary conversion? If hex-binary, given the length is 20, you may need to read it in as hex one digit at a time, and spit it out as binary, then concatenate them together to the length of 80.  If char-binary, there is a format $binaryw. you may need to use.   Take a look at format/informat $binaryw and binaryw. ... View more

Open an official SAS support ticket. They will state if it's possible or not (not right now I think).  You should do this anyway to have an official response if your a contractor. Also why they pay the license fee, use tech support.    Or my solution, offer client the true options:   Quote 1 - develop add on to VA at cost of $xxxx and 1 month+ Quote 2 - use Adobe Pro for $x dollars and done in 1 day.   Most clients are actually quite reasonable BUT contractors rarely offer those options.  Projects are managed by PMs who don't understand the tech and besides option 1 is more billable hours.    As a contractor I give my clients the option, but I don't work with big companies and have direct communication with my clients. In my day job working with big firms they've never once made that suggestion. It's also why I prefer to do as much in house and never contract out if possible.    Sorry for the rant.  ... View more

This is the way I decide to do with my data. 1. Convert PDF to excel using Adobe Acrobat Professional version, which allows me to convert hundreds pdf to excel just by one “click” 2. Read excel to sas using a macro ... View more

By default, SAS will use column headers as SAS labels. But the maximum length is 64 chars due to a limitation in the Jet engine. Of course you could expand the label in a later step, but that would be considered a work around. http://support.sas.com/documentation/cdl/en/acpcref/67382/HTML/default/viewer.htm#n0msy4hy1so0ren1acm90iijxn8j.htm ... View more

Thanks for replying. I will try the both ways, “macro” and “by site", I will input site name as a variable ( the big dataset will be 13 variable, var1 will be the site) when I try to using "by site'. Thanks again . ... View more