SAS/cereals data analysis1.sas at master · scratchnooob/SAS · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
proc import datafile = '/folders/myfolders/sasuser.v94/cereal.csv'
out = work.cereal
dbms = CSV
replace;
run;

proc print data=work.cereal;
run;

/*proc format library=work.formats;
VALUE $cereal_mfr 'A' = 'American Home Food Products'
'G' = 'General Mills'
'K' = 'Kelloggs'
'N' = 'Nabisco'
'P' = 'Post'
'Q' = 'Quaker Oats'
'R' = 'Ralston Purina';
VALUE $hotcold 'C'='cold'
'H'='hot';
run;

*/
PROC CONTENTS data=work.cereal; RUN;

PROC PRINT data=work.cereal(OBS=5);
var name mfr type;
run;

proc import datafile = '/folders/myfolders/sasuser.v94/cereal.csv'
out = work.cerealnew
dbms = CSV
replace;
run;

proc print data=work.cerealnew obs;
run;

data work.cerealnew;
set work.cerealnew;
calories_PC= calories/cups;
carbo_PC= carbo/cups;
fat_PC=fat/cups;
fiber_PC=fiber/cups;
potass_PC=potass/cups;
protein_PC=protein/cups;
sodium_PC= sodium/cups;
sugars_PC = sugars/cups;
vitamins_PC =vitamins/cups;
run;

proc print data=work.cerealnew (obs=1);
var name calories_PC sugars_PC;
run;

proc print data=work.cerealnew (obs=1);
var name calories_PC sugars_PC;
format calories_PC sugars_PC 8.;
run;

proc sort data=work.cerealnew ;
by descending calories_PC;
run;

proc print data=work.cerealnew(obs=5);
var name calories_PC sugars_PC;
format calories_PC sugars_PC 8.;
run;

proc sort data=work.cerealnew;
by sugars_PC;
run;

proc print data=work.cerealnew(obs=5);
var name sugars_PC;
format sugars_PC 8.;
run;
proc print data=work.cerealnew(obs=5);
where mfr='N';
var name mfr calories_PC;
format calories_PC 8.;
run;

proc sort data=work.cerealnew;
by sodium_PC;
run;
proc print data=work.cerealnew(obs=5);
where type='H';
var type name sodium_PC;
format sodium_PC 8.;
run;

PROC sort DATA = WORK.cerealnew;
BY descending sugars_PC;
RUN;
PROC PRINT data=work.cerealnew(obs=10);
var type name sodium_PC sugars_PC potass_PC;
format calories_PC sugars_PC protein_PC sodium_PC potass_PC  8.;
run;
PROC sort DATA = WORK.cerealnew;
BY  sugars_PC;
RUN;
PROC PRINT data=work.cerealnew(obs=10);
var type name sodium_PC sugars_PC potass_PC;
format calories_PC sugars_PC protein_PC sodium_PC potass_PC  8.;
run;