topic Re: How do I get variable values to show up in output? SAS 9.4 in New SAS User

How do I get variable values to show up in output? SAS 9.4

jranta — Fri, 17 Jul 2020 04:55:19 GMT

I know there has to be a simple solution here. It prints out everything I want except for the values.

proc format;
value id = 'ID';
value Diagnosis 0 = 'n/a' 
				1 = 'LTBI'
    			2 = 'ACTIVE' 
				3 = 'NOT TB';
value PPD 		0 = 'n/a' 
				1= 'Positive' 
				2= 'Negative';
value CXR 		0 = 'n/a' 
				1 = 'WNL' 
				2 = 'Abnormal';
value Treatment 0 = 'n/a' 
				1 = 'Yes' 
				2 = 'No' 
				3 = 'Pending';
				run;
Data Notes;
input ID Diagnosis PPD CXR Treatment;
datalines;
1 1 1 1 1
2 1 1 1 1
3 1 1 1 1
4 1 1 1 1
5 2 1 2 2
6 1 1 1 1
7 1 1 1 1
8 0 0 0 0
9 1 1 1 1
10 1 1 1 1
11 2 1 2 2
12 1 2 0 0
13 3 2 0 0
14 3 2 0 0
15 3 2 0 0
16 2 1 2 2
17 1 1 1 1
18 3 2 0 0
19 3 2 0 0
20 1 1 1 1
21 1 1 1 1
22 3 2 0 1
23 1 1 1 0
24 3 2 0 1
25 3 2 0 0
26 1 1 1 0
27 3 2 0 1
28 3 2 0 0
29 3 2 0 0
30 3 2 0 0
31 3 2 0 0
32 2 1 2 3
33 3 2 0 0
34 1 1 1 3
35 2 1 2 2
36 0 0 0 0
37 3 2 0 0
38 3 2 0 0
;
run;
format id id. diagnosis diagnosis. ppd ppd. cxr cxr. treatment treatment.;
proc print data = notes;
var diagnosis ppd cxr treatment;
title 'Chart';
run;

Re: How do I get variable values to show up in output? SAS 9.4

Shmuel — Fri, 17 Jul 2020 05:23:21 GMT

You can show the value as its meaning by using next formats:

proc format;
value id = 'ID';
value Diagnosis 0 = '(0) n/a' 
				1 = '(1) LTBI'
    			2 = '(2) ACTIVE' 
				3 = '(3) NOT TB';
value PPD 		0 = '(0) n/a' 
				1 = '(1) Positive' 
				2 = '(2) Negative';
value CXR 		0 = '(0) n/a' 
				1 = '(1) WNL' 
				2 = '(2) Abnormal';
value Treatment 0 = '(0) n/a' 
				1 = '(1) Yes' 
				2 = '(2) No' 
				3 = '(3) Pending';
run;

Re: How do I get variable values to show up in output? SAS 9.4

andreas_lds — Fri, 17 Jul 2020 05:29:22 GMT

The format-statement is misplaced, move it into proc print.

Re: How do I get variable values to show up in output? SAS 9.4

jranta — Mon, 20 Jul 2020 18:17:53 GMT

I thought I tried that before, but moving the format under under proc print was it! Thanks!