Monday, April 26, 2010

SAS training notes

Link to application:

https://coqanalytics.consind.ge.com/Portal/displaylogon.do


*Reports - this is where you save queries


*emerging issues - system decides what's coming up



*Why do all the lines seem to converge toward the origin? Is this data filtered to the production month that occured one year before the query date?


*"first scan date" is tunnel scan date

- periods in service are age in fault

- text mining determines comment category


*Data selection


*portal bottom left look at user guide


*"SWA Standards and Setup Links - Data Selection Setup"

*can drill down through heirarchy or go right to the model group if you know line and site or if you use search function.



*right now everything is in warranty. they will eventually load everything but the default query is for in warranty call classes




+create project and add data selections to it


+ can select multiple analyses per project



* Under "SWA Standards and Setup Links": "Tips on 12 SWA analyses": walks you through the 12 types of analysis.


Link:

file://For3fs01cige/pccommon/SWA/Pilot/SAS Warranty Analytics Analysis Tips.ppt


* Can right-click any analysis and "Save as Report"

- you can publish a report to any individual or group except yourself. There is no emailing of reports, you have to go in and pull it up. But at least it willl already be run.

- Auto update is always weekly

- red exclamation symbol means data is old


Emerging Issue:

SAS Web Report Viewer • Pending Calls fields delivered

Sc History Ind
Region Cd
Zone Cd
Call Num
Model Num
Serial Num
Swa Product Id
Problem Dsc
RemarksTxt
Sch Service Date
Sch Service Time
Dept Cd
Fq Dept Cd Desc
Product Line Cd
Fq Product Line Cd Desc
Mfg Site Cd
Fq Mfg Site Cd Desc
Model Grp Cd
Fq Model Grp Cd Desc
Cnsmr Id
Cnsmr Nam
Cnsmr Phn Num
Cnsmr Addr Dsc
Cnsmr Zip Cd
Tech Id
Tech Nam
Part1
Part2
Part3
Part4
Part5
Part6
Part7
Part8
Part9
Part10

SAS service call fields delivered

Swa Claim Id
Region Cd
Zone Cd
Invoice Num
Service Dt
Mfg Dt
Install Dt
Age At Fault Num
Swa Product Id
Fs Serial Num
Fs Model Num
Recode Model Num
Dept Cd
Mfg Site Cd
Model Grp Cd
Product Line Cd
Job1 Cd
Job1 Desc
Job2 Cd
Job2 Desc
Action Cd
Problem Desc
Other Problem Desc
Cnsmr Cpmln Dsc
Spcl Req Txt
Tech Cmnt Txt
Job Component Cd
Job Component Desc
Job Subsystem Cd
Job Subsystem Desc
Call Class Cd
Call Class Desc
Job Cd Minute Num
Region Desc
Zone Desc
Service St Cd
Service Part Num
Service Part Desc
Vendor Cd
Vendor Desc
Part Family Cd
Part Family Desc
Engg Part Num
Rplcm Part Cost Amt
Tech1 Desc
Tech1 Num
Tech2 Desc
Tech2 Num