Z:\to_server\website\mrdcl-learning.com\mrdcl_files\MKT-01\EPS Example 1 - Code Lists\reading_excel_2.stp
start data,
serial number in columns 1-5,
card characters 1000,
ds $gender=$6/1,2,
x='Male;
Female',
xt='Gender',
ds $age=$7/1-3,
x='16-34;
35-54;
55+',
xt='Age',
!!!!To use - call the workbook dbxls (the workbook can have any name)
!!!!Set *data cframes to 5 values as follows
!!!!1=variable name
!!!!2=worksheet name
!!!!3=Question text
!!!!4=Field
!!!!5=Repeats
!!!!Then call cf_sub_totals
dm $reasons=$8-9 * 3/
1+
3+
4+
7
,
1,
3,
4,
7,
5+
6
,
5,
6,
2+
8+
9
,
2,
8,
9,
10+
11
,
10,
11,
e,
x='
_Favourable comments (sub-total)_<g1b>;
It is a good brand<g2b><g1p>;
Favourite product<g1p>;
Best on the market<g1p>;
Green box<g2e><g1p>;
_Packaging comments (no mention of colour)_;
Packaging is atttractive<g2b><g1p>;
Useful<g2e><g1p>;
_Packaging comments (colour)_;
Comes in a red box<g2b><g1p>;
Red and green box<g1p>;
Red and blue box<g2e><g1p>;
_Price comments (sub-total)_<g1e>;
Cheap products<g2b><g1p>;
Good value products<g2e><g1p>;
NS<z>',
xt='Q1 Reasons for purchasing',
dm $other_reasons=$10-11 * 4/
1,
2,
8,
3,
5,
6,
7,
9,
10,
11,
12,
15,
1+
6+
15
,
8+
5+
7+
10+
11
,
3+
9
,
2+
12
,
e,
x='
AA;
BB;
FF;
CC;
DD;
EE;
ZZZZZZ;
GG;
YYYYY;
HH;
II;
JJ;
Subtotal 1;
Subtotal 2;
Subtotal 3;
Subtotal 4;
NS<z>',
xt='Q3 Other reasons for shopping',
finish data,
start tables,
t#1=$reasons * $gender,
t#2=$other_reasons * $gender,
finish tables,
