*********************************************;
* f=sasmanual\clinq_view.sas                *;
*                                           *;
* Clinical data set questions:               *;
* I. Viewing the data                       *;
*********************************************;

options linesize=min;

%include 'c:\My Documents\My SAS Files\sasmanual\formats\clinical_fmt.sas';

libname mydir 'c:\My Documents\My SAS Files\sasmanual\data';

data clin;
  set mydir.clinical;
run;

proc contents data=clin;
title1 'The simulated clinical data from the SAS manual';
title2 'Question 1 - variables and their attributes';
run;

proc print data=clin;
title2 'Question 2a - all variables for all obs';
run;

proc print data=clin (obs=5) label;
  var gender dbp sbp;
  label gender = 'Gender of patient'
        dbp    = 'Diastolic blood pressure'
        sbp    = 'Systolic blood pressure';
  format gender $gender.;
title2 'Question 2b - 1st 5 obs, 3 variables, labels';
run;

proc sort data=clin;
  by gender;
run;

proc print data=clin label;
  var gender dbp sbp;
  label gender = 'Gender of patient'
        dbp    = 'Diastolic blood pressure'
        sbp    = 'Systolic blood pressure';
  format gender $gender.;
title2 'Question 2c - all obs, 3 variables, labels, sorted 1 var';
run;

proc sort data=clin;
  by gender dbp;
run;

proc print data=clin label;
  var dbp sbp;
  id gender;
  label gender = 'Gender of patient'
        dbp    = 'Diastolic blood pressure'
        sbp    = 'Systolic blood pressure';
  format gender $gender.;
title2 'Question 2d - all obs, 3 variables, labels, sorted 2 vars';
run;


proc format;
  value $genx 'M' = 'Male adult'
              'F' = 'Female adult';
  run;

proc print data=clin;
  var gender;
  format gender $genx.;
title2 'Question 3 - change values for gender';
run;