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

Windows Checkpoint Restore

Thank GOD for inserting the paper bullet into the brain of the Microsoft engineer who came up with System Restore Points. After stupidly installing MS Office 2010 Beta out of curiosity, I found it totally messed up my ability to sync with my Palm TX, and was virtually impossible to uninstall. No problem, just roll back the clock to last week, and I'm good to go. Except for losing some email and having to erase dozens of duplicate entries in Outlook.

2010 looked like it had some nice features but untill somebody comes up with updates for HotSync and Documents to Go, I am stuck with Office 97 and Outlook 2003. Or until I get a smart phone, which will probably be sooner than I can afford.

Hello again Blogosphere

Attempt 2.0 at an online presence for me, this time as a late adopter and without grandiose pretensions of wide readability or significance. Mostly a place to post things of interest and convenience for my own access wherever I happen to be. Named for a beautifully written book I happen to like. Hopefully this one won't grow to the point where it becomes self-aware and demands a sandwich.