Learn SAS programming, SAS tutorials, SAS video tutorials, SAS ebooks, SAS tips, SAS codes, SAS sample programs, SAS certification..
| Home | My Account | Directories |
SDTM Compliance Checks
Published on 2011-11-12 23:37:00
Validation checks or tools to check the compliance of SDTM data JANUS is a standard database model which is based on the CDISC’s SDTM standard. JANUS is used by the FDA to store the submitted SDTM clinical data. As a part of data definition file submission pharmaceutical companies have to submit SAS datasets in transport file (.xpt) format along with annotated CRF and Define.xml file. The reason being this is… to properly load the clinical data into JANUS database which is maintained b
How to remove carriage return and linefeed characters within quoted strings.
Published on 2011-10-27 15:23:00
HANDLING SPECIAL EMBEDDED CHARACTERS To manage and report data in DBMS that contains very long text fields is not easy. This can be frustrating if the text field has special embedded symbols such as tabs, carriage returns (‘OD’x ), line feeds (‘OA’x) and page breaks. But here is simple SAS code which takes care of those issues. The normal line end for Windows text files is a carriage return character or a line feed character so The syntax for taking out all carriage re
Counting the number of missing and non-missing values for each variable in a data set.
Published on 2011-10-13 09:19:00
/* create sample data */ data one; input a $ b $ c $ d e; cards; a . a 1 3 . b . 2 4 a a a . 5 . . b 3 5 a a a . 6 a a a . 7 a a a 2 8 ; run; /* create a format to group missing and non-missing */ proc format; value $missfmt ' '='missing' other='non-missing'; value missfmt .='missing' other='non-missing'; run; %macro lst(dsn); /** open dataset **/ %let dsid=%sysfunc(open(&dsn)); /** cnt will contain the number of variables in the dataset passed in **/ %let