Script_Excel.txt

SET ThousandSep=',';
SET DecimalSep='.';
SET MoneyThousandSep=',';
SET MoneyDecimalSep='.';
SET MoneyFormat='$#,##0.00;($#,##0.00)';
SET TimeFormat='h:mm:ss TT';
SET DateFormat='M/D/YYYY';
SET TimestampFormat='M/D/YYYY h:mm:ss[.fff] TT';
SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';
SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';
SET LongMonthNames='January;February;March;April;May;June;July;August;September;October;November;December';
SET LongDayNames='Monday;Tuesday;Wednesday;Thursday;Friday;Saturday;Sunday';
SET FirstWeekDay=0;
SET BrokenWeeks=1;
SET ReferenceDay=0;
SET FirstMonthOfYear=1;
SET CollationLocale='en-US';

//Facts
//1
'Death Records':
LOAD Id , 
     ResidentStatus, 
     Education1989Revision as Educ1989, 
     Education2003Revision as Educ2003, 
     EducationReportingFlag as EduFlag, 
     MonthOfDeath, 
     Sex, 
     AgeType, 
     Age, 
     AgeSubstitutionFlag, 
     AgeRecode52, 
     AgeRecode27, 
     AgeRecode12, 
     InfantAgeRecode22, 
     PlaceOfDeathAndDecedentsStatus, 
     MaritalStatus, 
     DayOfWeekOfDeath, 
     CurrentDataYear, 
     InjuryAtWork, //No Dimension
     MannerOfDeath, 
     MethodOfDisposition, 
     
     Autopsy, 
     ActivityCode, 
     PlaceOfInjury, 
     Icd10Code, 
     CauseRecode358, //No Dimension
     CauseRecode113, //No Dimension
     InfantCauseRecode130, 
     CauseRecode39, 
     NumberOfEntityAxisConditions, 
     NumberOfRecordAxisConditions, 
     Race, 
     BridgedRaceFlag, 
     RaceImputationFlag, 
     RaceRecode3, 
     RaceRecode5, 
     HispanicOrigin, 
     HispanicOriginRaceRecode
FROM
[C:\Users\VisualBI\Downloads\HPA\Assignment\Assgn2\HowPplDie\DeathRecords.csv]
(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

Concatenate
//EntityAxisConditions
LOAD //Id, 
     DeathRecordId, 
     Part, 
     Line, 
     Sequence
     //Icd10Code
FROM
[C:\Users\VisualBI\Downloads\HPA\Assignment\Assgn2\HowPplDie\EntityAxisConditions.csv]
(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

Concatenate

LOAD 
//Id, 
DeathRecordId ;
//Icd10Code
FROM
[C:\Users\VisualBI\Downloads\HPA\Assignment\Assgn2\HowPplDie\RecordAxisConditions.csv]
(txt, codepage is 1252, embedded labels, delimiter is ',', msq)

//Dimensions

//1
'Hispanic Origin Race Recode':
QUALIFY *;
UNQUALIFY HispanicOriginRaceRecode;
LOAD Code as HispanicOriginRaceRecode, 
     Description
FROM
[C:\Users\VisualBI\Downloads\HPA\Assignment\Assgn2\HowPplDie\HispanicOriginRaceRecode.csv]
(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

//2
'Resident Status':
QUALIFY *;
UNQUALIFY ResidentStatus;
LOAD Code as ResidentStatus, 
     Description
FROM
[C:\Users\VisualBI\Downloads\HPA\Assignment\Assgn2\HowPplDie\ResidentStatus.csv]
(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

//3
'Education 1989':
QUALIFY *;
UNQUALIFY Educ1989;
LOAD Code as Educ1989, 
     Description
FROM
[C:\Users\VisualBI\Downloads\HPA\Assignment\Assgn2\HowPplDie\Education1989Revision.csv]
(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

//4
'Education 2003':
QUALIFY *;
UNQUALIFY Educ2003;
LOAD Code as Educ2003, 
     Description
FROM
[C:\Users\VisualBI\Downloads\HPA\Assignment\Assgn2\HowPplDie\Education2003Revision.csv]
(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

//5
'Education Report':
QUALIFY *;
UNQUALIFY EduFlag;
LOAD Code as EduFlag, 
     Description
FROM
[C:\Users\VisualBI\Downloads\HPA\Assignment\Assgn2\HowPplDie\EducationReportingFlag.csv]
(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

//6
'Age Type':
QUALIFY *;
UNQUALIFY AgeType;
LOAD Code as AgeType, 
     Description
FROM
[C:\Users\VisualBI\Downloads\HPA\Assignment\Assgn2\HowPplDie\AgeType.csv]
(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

//7
'Age Recode 52':
QUALIFY *;
UNQUALIFY AgeRecode52;
LOAD Code as AgeRecode52, 
     Description
FROM
[C:\Users\VisualBI\Downloads\HPA\Assignment\Assgn2\HowPplDie\AgeRecode52.csv]
(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

//8
'Age Recode 27':
QUALIFY *;
UNQUALIFY AgeRecode27;
LOAD Code as AgeRecode27, 
     Description
FROM
[C:\Users\VisualBI\Downloads\HPA\Assignment\Assgn2\HowPplDie\AgeRecode27.csv]
(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

//9
'Age Recode 12':
QUALIFY *;
UNQUALIFY AgeRecode12;
LOAD Code as AgeRecode12, 
     Description
FROM
[C:\Users\VisualBI\Downloads\HPA\Assignment\Assgn2\HowPplDie\AgeRecode12.csv]
(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

//10
'Infant Age 22':
QUALIFY *;
UNQUALIFY InfantAgeRecode22;
LOAD Code as InfantAgeRecode22, 
     Description
FROM
[C:\Users\VisualBI\Downloads\HPA\Assignment\Assgn2\HowPplDie\InfantAgeRecode22.csv]
(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

//11
'Death Place':
QUALIFY *;
UNQUALIFY PlaceOfDeathAndDecedentsStatus;
LOAD Code as PlaceOfDeathAndDecedentsStatus, 
     Description
FROM
[C:\Users\VisualBI\Downloads\HPA\Assignment\Assgn2\HowPplDie\PlaceOfDeathAndDecedentsStatus.csv]
(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

//12
'Marital Status':
QUALIFY *;
UNQUALIFY MaritalStatus;
LOAD Code as MaritalStatus, 
     Description
FROM
[C:\Users\VisualBI\Downloads\HPA\Assignment\Assgn2\HowPplDie\MaritalStatus.csv]
(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

//13
'Death Day':
QUALIFY *;
UNQUALIFY DayOfWeekOfDeath;
LOAD Code as DayOfWeekOfDeath, 
     Description
FROM
[C:\Users\VisualBI\Downloads\HPA\Assignment\Assgn2\HowPplDie\DayOfWeekOfDeath.csv]
(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

//14
//'Injury At Work':
'Manner of Death':
QUALIFY *;
UNQUALIFY MannerOfDeath;
LOAD Code as MannerOfDeath, 
     Description
FROM
[C:\Users\VisualBI\Downloads\HPA\Assignment\Assgn2\HowPplDie\MannerOfDeath.csv]
(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

//15
'Method Of Disposition':
QUALIFY *;
UNQUALIFY MethodOfDisposition;
LOAD Code as MethodOfDisposition, 
     Description
FROM
[C:\Users\VisualBI\Downloads\HPA\Assignment\Assgn2\HowPplDie\MethodOfDisposition.csv]
(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

//16
'Activity Code':
QUALIFY *;
UNQUALIFY ActivityCode;
LOAD Code as ActivityCode, 
     Description
FROM
[C:\Users\VisualBI\Downloads\HPA\Assignment\Assgn2\HowPplDie\ActivityCode.csv]
(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

//17
'Place Of Injury':
QUALIFY *;
UNQUALIFY PlaceOfInjury;
LOAD Code as PlaceOfInjury, 
     Description
FROM
[C:\Users\VisualBI\Downloads\HPA\Assignment\Assgn2\HowPplDie\PlaceOfInjury.csv]
(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

//18
'Icd 10 Code':
QUALIFY *;
UNQUALIFY Icd10Code;
LOAD Code as Icd10Code, 
     Description
FROM
[C:\Users\VisualBI\Downloads\HPA\Assignment\Assgn2\HowPplDie\Icd10Code.csv]
(txt, utf8, embedded labels, delimiter is ',', msq);

//19
'Race':
QUALIFY *;
UNQUALIFY Race;
LOAD Code as Race, 
     Description
FROM
[C:\Users\VisualBI\Downloads\HPA\Assignment\Assgn2\HowPplDie\Race.csv]
(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

//20
'Bridged Race Flag':
QUALIFY *;
UNQUALIFY BridgedRaceFlag;
LOAD Code as BridgedRaceFlag, 
     Description
FROM
[C:\Users\VisualBI\Downloads\HPA\Assignment\Assgn2\HowPplDie\BridgedRaceFlag.csv]
(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

//21
'RaceImputationFlag':
QUALIFY *;
UNQUALIFY RaceImputationFlag;
LOAD Code as RaceImputationFlag, 
     Description
FROM
[C:\Users\VisualBI\Downloads\HPA\Assignment\Assgn2\HowPplDie\RaceImputationFlag.csv]
(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

//22
'Race Recode 3':
QUALIFY *;
UNQUALIFY RaceRecode3;
LOAD Code as RaceRecode3, 
     Description
FROM
[C:\Users\VisualBI\Downloads\HPA\Assignment\Assgn2\HowPplDie\RaceRecode3.csv]
(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

//23
'Race Recode 5':
QUALIFY *;
UNQUALIFY RaceRecode5;
LOAD Code as RaceRecode5, 
     Description
FROM
[C:\Users\VisualBI\Downloads\HPA\Assignment\Assgn2\HowPplDie\RaceRecode5.csv]
(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

//24
'Hispanic Origin':
QUALIFY *;
UNQUALIFY HispanicOrigin;
LOAD Code as HispanicOrigin, 
     Description
FROM
[C:\Users\VisualBI\Downloads\HPA\Assignment\Assgn2\HowPplDie\HispanicOrigin.csv]
(txt, codepage is 1252, embedded labels, delimiter is ',', msq);