Chrisspaceos

RegistrationBookletforTheSixthAnnualConferenceoftheSouthEastSASUsersGroupSheratonNorfolkWatersideHotelNorfolk,VirginiaSeptember13-15,1998WelcometoSESUG'98YouhavemostlikelyheardthenowpopularlinefromtheclassicmovieFieldofDreamsthatsays"Ifyoubuildit,theywillcome.
"Well,backin1992,severalpeoplehadadreamtostartaregionalusersgroupfortheSoutheastUnitedStates.
TwoofthosepeoplewereS.
DavidRibaandTamaraFischell.
TheyhelpedbuildtheSouthEastSASUsersGroup(SESUG)bychairingitsfirstconferencein1993attheTradeWindsinSt.
PetersburgBeach,FL.
Andthepeopledidcome.
In1994,FrankDiIorioandDebbieHoppecontinuedtheSESUGdreambyhostingasecondconferenceinCharleston,SC,attheOmniHotelatCharlestonPlace.
Andthepeoplecameagain.
ThedreamcontinuedthefollowingyearwhenMelissaGarreansandAndrewParkshostedSESUG'95attheNorthRaleighHiltoninRaleigh,NC.
ThiswasfollowedbyFrankDiIorioandGraceLossmanchairingSESUG'96attheswiss(telAtlantainAtlanta,GA.
Andlastyear,thedreamwasstillalivewhenDanBrunsandAndrewT.
KuligowskitookSESUG'97totheOmniJacksonvilleHotelinJacksonville,FL.
Throughouteachoftheseyears,thepeoplecontinuedtocome.
Thisyear,F.
JosephKelleyandRandyC.
Finch(that'sus!
)willcarryforththissixyeardreamwhenSESUG'98convenesattheSheratonNorfolkWatersideHotelinNorfolk,VA.
Oursincerehopeisthatevenmorepeoplewillcome.
Forthosewhodo,webelieveyouwillnotbedisappointed.
Manyexcellentpaperswillbepresentedbymanyexcellentpresenters.
TheabstractsinthisbookletshouldappealtoallSASusers,regardlessoftheirfieldofinterest.
Aswehavepointedout,SESUGhasarichhistory,albeitashortone.
Thisyear,SESUGwillbeheldinNorfolk,Virginia;acitywithalong,richhistorythatpredatestheestablishmentoftheRepublicbyalmost100years.
Hereissomeinformationaboutthecity.
NorfolkislocatedatthemouthoftheJames,Elizabeth,andNansemondrivers,neartheChesapeakeBay.
ThenearbycitiesofHampton,Portsmouth,andNewportNews,alongwithNorfolk,formtheportofHamptonRoads,oneofthegreatestnaturalharborsintheworld.
Norfolkisamajorseaportandanimportantmilitarycenter,havingoneoftheworld'slargestconcentrationsofnavalinstallationsaswellasimportantUnitedStatesNavy,Marine,andCoastGuardfacilities.
TheNorfolkNavalShipyardisacrosstheElizabethRiver,inPortsmouth.
NorfolkisalsothehomeofOldDominionUniversity(1930),NorfolkStateUniversity(1935),VirginiaWesleyanCollege(1961),andEasternVirginiaMedicalSchool(1964).
DuringtheAmericanRevolution,NorfolkwasinvadedandoccupiedbyBritishtroops.
Duringthewar,everybuildingexceptSaintPaul'sChurch(1739)wasdestroyed.
Rebuiltafterthewar,Norfolkbecameanimportantshipbuildingandmaritimecenter.
OnMarch9,1862,duringtheAmericanCivilWar,thefamousbattlebetweentheironcladwarshipsMonitorandMerrimack(C.
S.
S.
Virginia)tookplaceatHamptonRoads.
Twomonthslater,NorfolkwascapturedbyUnionforces.
Norfolk'senormousmilitarygrowthbeganduringWorldWarI(1914-1918).
Thisgrowthcontinueduntiltheearly1990swhenfederaldefensecutsandbaseclosurescostthecitymilitaryjobsanddefense-relatedcivilianjobs.
Buttoday,Norfolkisonthegrowthcurveagainwithmanyconstructionandrenovationprojectsunderway.
Foroverthreecenturies,Norfolkandthesurroundingarea(whichincludesJamestown,Yorktown,andWilliamsburg)havebeenverymuchapartoftheindustry,trade,andcommerceofthiscountry.
Ithasalsobeenthefocusofanumberofhistoricevents,includingarmedinvasions!
ThisSeptember,anotherinvasionofsortswilltakeplace,ashundredsofSASuserscomeforSESUG'98.
Thisisaninvasionthecitywillbelookingforwardto,andsoshouldyou!
Don'tmissout.
MakeyourplansnowtovisitthehistoriccityofNorfolkandbeapartofSESUG'98.
F.
JosephKelleyRandyC.
FinchSourceofinformationaboutNorfolk:Microsoft(Encarta(96Encyclopedia.
(1993-1995MicrosoftCorporation.
Allrightsreserved.
(Funk&WagnallsCorporation.
Allrightsreserved.
SASandallotherSASInstituteInc.
productorservicenamesareregisteredtrademarksortrademarksofSASInstituteInc.
intheUSAandothercountries.
Otherbrandandproductnamesareregisteredtrademarksortrademarksoftheirrespectivecompanies.
ConferenceRegistrationBooklet:"TheSixthAnnualConferenceoftheSouthEastSASUsersGroup"Copyright1998byTheSouthEastSASUsersGroupTheSESUG'98logowasdesignedbyRandyC.
FinchTableofContentsTableofContentsiConferencePlanningTeamiiConferenceCo-ChairsiiSectionChairsiiConferenceOverview1LocationandDates1Benefits1Registration1Accommodations2TransportationServices2AirTransportation3GroundTransportation3Parking3WeekendWorkshops3ConsultantsSASUsersGroup(CONSUG)3WarmupSession4OpeningSession4ReceptionandMixer4"MeetthePresenters"Luncheons4ShopTalk5SASFuturesForum5SASInstituteFormalOnlineDemos5SASInstituteDemoRoom5Birds-of-a-Feather(BOF)Sessions5AllInJest5ClosingSession5NearbySites6VendorParticipation6WhatHappensAfterIRegister6WhatYourPeersSaidAboutSESUG'977ConferenceChecklist8DatestoRemember8PreliminaryConferenceSchedule9SASInstitutePublications12HandsOnWorkshopsatSESUG13PaperandPresentationAbstracts15AdvancedTutorials15AllInJest19ApplicationsDevelopment20BeginningTutorials26CodersCorner31FormalOnlineDemonstrations37HostSystems40I-NetSolutions43InformationVisualization46PCHands-OnWorkshops49Posters50Serendipity54Statistics59Technology200064WeekendWorkshops66SheratonNorfolkWatersideHotel-ReservationRequestForm69SESUG'98ConferenceRegistrationForm71SESUGPoliciesandProcedures73ConferenceChecklist74DatestoRemember74ConferencePlanningTeamConferenceCo-ChairsRandyC.
FinchTennesseeValleyAuthorityCEB-4C-MPOB1010ReservationRoadMuscleShoals,AL35662-1010Phone:(256)386-2197;FAX:(256)386-3799rcfinch@tva.
govF.
JosephKelleyUniversityofGeorgiaUCNSClientServicesComputerServicesAnnexAthens,GA30602-1911Phone:(706)542-5359;FAX:(706)542-0349jkelley@arches.
uga.
eduSectionChairsAdvancedTutorialsGerardetteFurlowNorthCarolinaStateUniversityElizabethHamiltonUniversityofNorthCarolinaAllinJestOliviaRudFleetRobertPassmorePassmoreConsultingServicesApplicationsDevelopmentPhild'AlmadaEDSOliviaRudFleetBeginningTutorialsIanWhitlockWestat,Inc.
DavidMaddoxBellSouthCodersCornerMaribethJohnsonMedicalCollegeofGeorgiaAndrewT.
KuligowskiNielsenMediaResearchFoodServicesGeorgeMatthewsUniversityofGeorgiaHostSystemsGregoryBarnesNelsonASG,Inc.
I-NetSolutionsCarolineBahlerASG,Inc.
CarlHaskeSTATPROBE,Inc.
InformationVisualization&PostersEricBrinsfieldMeridianSoftware,Inc.
MattBeckerSTATPROBE,Inc.
RegistrationKathyFinch(pre-conference)IndependentGregAshley(onsite)UniversityofGeorgiaPCHands-onWorkshopsDanaRafieeDestinyCorp.
SerendipityMichaelRiddleQuintiles,Inc.
HowardSchreierU.
S.
Dept.
ofCommerceShopTalkRonColemanLinksAnalytical,Inc.
SiteCoordinatorNancyPattonASG,Inc.
JohnP.
MorganOldDominionUniversityStatisticsGraceLossmanSmith-HanleyMargaretConnollyShellSTAT,Inc.
SundayProgramFrankDiIorioAdvancedIntegratedManufacturingSolutionsCorp.
Technology2000RobertPassmorePassmoreConsultingServicesBenCochranTheBedfordGroupVendorProgramGeorgeMatthewsUniversityofGeorgiaGregoryBarnesNelsonASG,Inc.
ConferenceOverviewLocationandDatesSESUG'98willbeheldattheSheratonNorfolkWatersideHotelinNorfolk,Virginia(seetheAccommodationssectionforimportantinformationaboutthishotel).
TheconferencedatesareSundaytoTuesday,September13-15,1998.
YoumaywanttoarriveonSaturdaytotakeadvantageoflowerairfaresaswellasthenearbymuseums,shopping,anddining.
ThiswouldalsoallowyoutoparticipateintheoptionalWeekendWorkshopsorCONSUGmeeting.
BenefitsEveryyear,hundredsofSASusersfromaroundthecountrygatheratSESUG.
IfyouwouldliketojointogetherwithyourpeersinNorfolkthisSeptember,weencourageyoutoreserveyourplaceassoonaspossible.
YourregistrationfeeforSESUG'98entitlesyoutothefollowing:accesstoallpresentationsanddemonstrationsaccesstoareceptionandamixeradmissiontooneluncheononeitherMondayorTuesdayacopyoftheSESUG'98ProgramandtheSESUG'98ProceedingsassortedmementosofyourSESUG'98experience(thiscouldincludeaT-shirt,atotebag,andanumberofotherpromotionalitems)ThesebenefitscombinetomakeSESUG'98acost-effectiveinvestmentofyourtravelandtrainingbudget.
RegistrationTheRegularRegistrationFeeforSESUG'98is$210.
ThedeadlineforreceiptofyourregistrationandpaymentisFriday,August28,1998.
IfyourregistrationandpaymentarereceivedafterAugust28,theOn-SiteRegistrationFeeof$250willapply.
On-Siteregistrationisofferedonlyonaspace-availablebasis.
Inaddition,wecannotofferaluncheonticketwithOn-Siteregistration,norcanweguaranteethattherewillbesufficientPrograms,Proceedings,etc.
availableforOn-Siteregistrants.
Eventhough$210foraconferenceofthisnatureisatruebargain,wearemakingitevenbetterbyofferingaspecialEarlyRegistrationFeeof$180.
Togetthisrate,yourregistrationandpaymentmustbereceivedbyFriday,August7,1998.
SingleDayRegistrationsarenotavailableforSESUG'98.
ThereisanadditionalchargefortheWeekendWorkshopsandtheCONSUGmeeting.
TheRegistrationFormcanbefoundonpages71-72ofthisRegistrationbooklet.
Thisformcanbemailed,faxed,orphonedin.
Inaddition,youcanregisterforSESUG'98byfillingouttheRegistrationFormontheWorldWideWebathttp://www.
uga.
edu/~sesug.
Wearepleasedtoannouncethatstartingthisyear,registrationfeescanbepaidbycreditcard.
AcceptablecardsareMasterCard,Visa,AmericanExpress,Discover,andDinersClub.
Sincecreditcardpaymentsarenewthisyear,wedonotyethaveawaytoacceptthistypeofpaymentviaasecureWebtransaction.
However,creditcardpaymentscanbemailed,faxed,orphonedin.
Checkormoneyorderpaymentsmustbemailedin.
AccommodationsAtpresstime,theconferencehotelisnamedtheOmniWatersideHotel.
However,asofAugust1,itwillberenamedtheSheratonNorfolkWatersideHotel.
Throughoutthisregistrationbooklet,itwillbereferredtobythelattername.
SESUG'98hasreservedablockofroomsforconferenceattendeesattheSheratonNorfolkWatersideHotelforaspecialSESUG'98rateof$99pernightforeithersingleordoubleoccupancy.
TheSheratonhasindoorandoutdoordining,abarwithentertainment,abusinesscenter,andanoutdoorpool.
TheYMCA,locatedneartothehotel,isavailabletohotelguestswitharoomkeyfor$6.
00pervisit.
Itfeaturesawhirlpool,aerobicclasses,KeiserStations,lifecycles,lifesteps,exercisebikes,andmore.
TomakehotelreservationsattheSheratonNorfolkWaterside,youcandooneofthefollowing:ifreservingbeforeAugust1,calltheOmni'sNationalReservationNumberat(800)THE-OMNIifreservingonorafterAugust1,calltheSheratonNationalReservationNumberat(800)325-3535calltheSheratonNorfolkWatersideHoteldirectlyat(757)622-6664fillouttheformonpages69-70ofthisbookletandmailorfaxitdirectlytotheSheratonNorfolkWatersideHotelRemember,youmustidentifyyourselfasaSESUG'98attendeetobeeligibleforthespecialconferencerates.
TheSheratonNorfolkWatersideHotelisalsoofferingalimitednumberofGovernment-RateroomsattheprevailinggovernmentperdiemrateforSESUG'98attendees.
Inordertoreceivethegovernmentrate,youmustbecurrentlyemployedbyarecognizedstateorfederalgovernmentagencyandprovideproofofthatemploymentuponregistration.
ThegovernmentrateisonlyavailablewhencontactingtheSheratonNorfolkWatersideHoteldirectlyat(757)622-6664.
Donotwait.
OurspecialSESUGratesattheSheratonareonlyavailableuntilAugust24,oruntilourroomblockhasbeenfilled.
Afterthat,theroomratewillincreaseifthehotelstillhasadditionalroomsavailable.
Forthosewhodonotwishtostayattheconferencehotel,SESUG'98hasarrangedaspecialrateof$79pernightattheClarionHotel(formerlyknownastheHotelNorfolk).
Thishotelislessthantwomilesfromtheconferencehotelandiscurrentlybeingcompletelyrenovated.
Bythetimeoftheconference,thehotelshouldlooklikeabrandnewhotelwithnewcarpet,windows,andfurniture.
Eachguestroomwillhaveamicrowave/refrigerator,coffeemaker,dataport,iron,ironingboard,andhairdryer.
Reservationscanbemadebycalling(757)627-5555.
ThespecialconferencerateisavailableuntilAugust24oruntiltheroomblockhasbeenfilled.
Anoverflowhotelisnotbeingofferedthisyear.
Therearetworeasonsforthis:1)anexcellentrateisbeingofferedattheconferencehoteland2)overflowhotelshavebeenunderutilizedduringpastconferences.
However,shouldyouwishtostayatahotelotherthantheconferencehotel,thereareseveralnicehotelsnearby.
Belowisalistofafewofthemalongwiththeirtelephonenumbers.
PleasecontactthemforratesandproximitytotheOmniWatersideHotel.
MarriottRamadaMadisonHotelNorfolkRemember:Youareresponsibleforyourownlodgingarrangements.
WhenregisteringattheSheratonNorfolkWatersideHotelortheClarionHotel,identifyyourselfasaSESUG'98attendeetoobtainthespecialconferencerate.
MakeyourreservationsassoonaspossibletoensurethattheSESUG'98rateisstillavailable.
Ratesdonotincludeapplicabletaxes,whicharecurrently11.
5%.
TransportationServicesHarboursideTravelServices,Inc.
,whichhasproudlyandsuccessfullyservedSESUGattendeessince1993,isreturningastheofficialtravelagencyforSESUG'98.
ContactRozMoorebyphoneat(800)330-8646or(813)724-9094,byfaxat(813)724-9247,orbye-mailathts@intnet.
net.
ShecanmaketravelarrangementstoandfromNorfolkandoffersspecialdiscountedairfaresonDeltaAirline,theOfficialAirlineofSESUG'98.
CheckoutHarbourside'sWebsiteat:http://www1.
tagonline.
com/Ads/Harbourside/.
HarboursideTravelServices,Inc.
cannotreserveroomsforyou.
Youmustdothisyourself.
AirTransportationDeltaAirlineshasbeennamedtheOfficialAirlineofSESUG'98.
ContactHarboursideTravelServices,Inc.
at(800)330-8646ortheDeltaAirlinesConventionDeskat(800)241-6760totakeadvantageofthisdiscountedairfare.
GroundTransportationAsofthiswriting,theSheratonNorfolkWatersideHotelprovidesafreeshuttletoandfromtheNorfolkInternationalAirportonanavailabilitybasis.
Anairportshuttleisavailableforaroundtripfeeof$22.
00.
Up-to-datedetailsaboutthis,aswellasdrivingdirectionsandinformationaboutpublictransportation,willbesenttoSESUG'98attendeesaspartoftheirRegistrationConfirmation.
IfyoustayattheClarionHotel,a12-15passengervanwillbeavailablefortransportationtoandfromtheconferencehotel.
Thenumberoftripseachdaywillbelimited.
Formoredetails,calltheClarionHotelat(757)627-5555.
IfyoustayanywhereotherthantheSheratonNorfolkWatersideHotelortheClarionHotel,youwillberesponsibleforyourowntransportationtoandfromtheconference.
ParkingParkingfortheSheratonNorfolkWatersideHotelisavailableattheDominionTowerParkingGarageadjacenttothehotel.
Thecosttoregisteredguestsiscurrently$3.
00perday,whichincludesunlimited"inandout"privileges.
Valetparkingisavailablefor$9.
50perday.
Theseratesareaccurateasofthewritingofthisbooklet.
Whilenochangesareanticipated,wecannotberesponsibleforchangesintheseparkingrates.
ParkingattheClarionHotelisfree.
WeekendWorkshopsDuetothesuccessoftheSundayWorkshopsinpastconferences,SESUG'98isproudtoannouncethattheseworkshopshavebeenexpandedtoSaturdayafternoon,also.
Forafeeyoucanattendmorningorafternoonworkshopsconductedbywell-knownSASusersandexperts.
Theworkshopfeesincludetrainingmaterialsthatwillbedistributedattheworkshop.
Acompletedescriptionoftheworkshopsandbiographiesoftheinstructorscanbefoundbeginningonpage66.
SignupforyourpreferenceusingtheConferenceRegistrationFormonpages71-72.
ConsultantsSASUsersGroup(CONSUG)ConsultantswhousetheSASSystem,orindividualswhoareconsideringamovetoconsulting,willbeinterestedinattendingtheCONSUGMeetingonSundaymorning,September13.
Theagendaforthisyear'smeetinghasnotbeenfinalizedasthisbookletisgoingtopress,however,inpreviousyearstheagendahasincludedsuchtopicsasNegotiatingTechniques,LegalIssues,andtheQualityPartnersProgram.
InformationcanbefoundattheCONSUGWebSite:http://www.
meridian-software.
com/consug/consug.
htmForadditionalinformation,pleasecontactFrankDiIorioatfcd@aimsco.
comor(919)942-2028.
AnominalfeeischargedforattendanceattheCONSUGmeeting,whichtraditionallyincludesacontinentalbreakfast.
ThisfeeisnotincludedinyourSESUG'98Registration.
WarmupSessionWhatcanIexpectoutoftheSESUG'98conferenceWhydosomeattendeeshavecoloredribbonsontheirbadgesWhat'sallthisstuffinmybagIreceivedattheregistrationtableWhat'sa"BOF"TheanswerstotheseandotherquestionswillbeaddressedattheSESUG'98Warmupsession.
SESUG'99Co-ChairsGeorgeMatthewsandGregoryBarnesNelsonwillexplaintheconferenceformatandanswerquestions.
ThissessionshouldproveespeciallyusefultofirsttimeattendeesofaSESUGconference,butanyonemayattend.
OpeningSessionTheofficialstartoftheconferencewillbeonSundayeveningwhentheSheratonNorfolkWatersideHotelhoststheSESUG'98OpeningSession.
ConferenceCo-ChairsRandyC.
FinchandF.
JosephKelleywillintroducesomeofthekeyconferenceplanners,discusstheactivitiesoftheSouthEastSASUsersGroupoverthepastyear,andprovideapeekatsomeoftheplansforthenext12months.
Wearepleasedtoannouncethatthisyear'sKeynoteAddresswillbegivenbyMs.
CarolRigsbeeoftheSASInstitute.
CarolisaPrincipalDeveloperintheWindowsUserInterfaceThinClientgroupatSASInstitute.
Shehasbeeninvolvedinthedesignanddevelopmentofthisprojectsinceitsbeginning.
ShehasbeenattheInstituteforthepasttwelveyears,developingtheSASSystemforPC'ssinceSASRelease6.
03.
Shehasbeenworkinginthecomputerindustrysince1980.
Carol'stalkisentitled"TheFutureInterfacetotheSASSystemforPC's.
"ItdiscussesanewuserinterfacetotheSASSystem.
Thisinterfaceisastate-of-the-artMicrosoftWindow'suserinterface,providingahighlyintegratedinterfacewiththeWindowssystem,otherWindowsapplicationsandtheWeb.
Thisinterfaceprovidesthin-clientaccesstoallV7SASSystemplatforms,includingPC,UNIXandmainframes.
ThisinterfacedramaticallyimprovestheSASSystem'seaseofuse.
TransparentaccesstodataandfullaccesstotheOutputDeliverySystem,ODS,isalsoprovided.
ReceptionandMixerTherewillbeareception(snacksandbeverages)immediatelyaftertheOpeningSessiononSundayevening.
Thiswillprovideafriendly"welcome"toNorfolkforSESUG'98attendees.
Allyouneedtoprovideistheconversation.
Amixer(beveragesonly)willtakeplacelateMondayafternoonimmediatelyafterthelastpresentations.
Wehopethisearlystartwillprovideacomfortable"wind-up"totheday'sactivities,andgiveeveryoneachancetomingleinarelaxingsetting.
TheRegistrationPacketyoureceiveatcheck-inwillincludedrinkvouchersthatcanberedeemedattheSESUG'98receptionandmixer.
"MeetthePresenters"LuncheonsAticketforeithertheMondayorTuesdayluncheonwillbeincludedinyourRegistrationPacket.
YoucanchoosewhichdayyoupreferontheRegistrationForm.
Ifyoudonotwantafreelunchoneitherday,pleaseindicatethisontheRegistrationformsowecanmakeyourticketavailabletosomeoneelse.
Duringlunch,youwillbeabletochatwithotherattendees.
Therewillbenopre-assignedseatsortopics.
Instead,attendeeswillhavetheopportunityto"MeetthePresenters"duringlunch.
SESUG'98speakershavevolunteeredtohosttablesattheluncheons.
Youwillbefreetositdownatanytableanddiscusstopicswithapresenter.
Seatingfortheluncheonswillbelimitedbothdays.
Ticketswillbeassignedonafirstpaid-and-registered,firstservedbasis.
So,ifyouwantatickettooneoftheluncheons,makesureyouregistersoon.
ShopTalkAreyouhavingaproblemwithaSASroutineIstheresomeaspectofaparticularSASProcedurewhichhasalwayseludedyouWell,helpisonthewayinNorfolk.
StopbytheShopTalktableintheSASInstituteDemoRoomanddiscussyoursituationwithanexperiencedSASprofessional.
YourConferenceProgramwilllistthescheduleforthepeopleondutyandtheirareasofexpertise.
Lookitover,determinethetimeswhentherewillbeapersonavailablewhocanassistyou,andstopbytheShopTalktableatthattime.
Feelfreetobringyourprintoutsorotherdocumentationtoassistinthediscussion.
SASFuturesForumTheSASFuturesForumprovidesaforumforSASUsersandSASDeveloperstosharefuturedirectionsoftheSASSystem.
ThisforumisscheduledforMondayafternoon.
SASInstituteFormalOnlineDemosSASInstituteispleasedtoofferitspopularandinformativeseriesofFormalOnlineDemonstrations(FODs)presentedbyInstituteexperts.
FODsthisyearwillshowcasedemonstrationsonnewfeaturesandenhancementstothenewreleaseoftheSASSystem,Version7-especiallyrelatedtothenewOutputDeliverySystem,accessingdatawiththenewlongtableandvariablenameoptions,andthenewthinclientofferings.
OtherdemonstrationswillbedoneontheDataWarehouse,CustomerRelationshipManagement,DataMining,WebEnablement,andOLAPsolutionsavailablewithRelease6.
12oftheSASSystem.
Eachdemonstrationwilllast50minutes.
AdetaileddescriptionofthedemonstrationswillbeprintedintheConferenceProgram.
SASInstituteDemoRoomSASInstitutestaffwillbeonhandtodiscussanddemonstratethelatestsoftwareandservicesavailablefromtheInstitute.
InstitutedivisionsthatwillsponsorboothsincludeConsulting,JMPSoftware,ProfessionalServices,QualityAssurance,QualityPartners,TechnicalSupport,andUserPublishingandUserGroupSupport.
YoucanalsomeetSASInstitutestafffromselectedregionalofficesattheRegionalOfficeBooth.
Inaddition,thePublicationsBoothintheDemoAreawilloffera15%discountonSASdocumentationorderedatSESUG'98.
StopbytheboothtobrowsethelatestinInstitutedocumentation.
YoumayalsohaveanopportunitytochatwithBooksbyUsersauthorsabouttheirbooks.
Birds-of-a-Feather(BOF)SessionsTheseMondayeveningget-togethersallowattendeestodiscusstopicsofmutualinterestinaninformalsetting.
TheonlyBOFplannedatthistimeistheSESUG'99PlanningMeeting.
Ifyouareinterestedinhelpingshapenextyear'sconference,pleaseattendthismeeting.
Asign-upboarddescribingtheBOFswillbelocatedneartheRegistrationArea.
Ifyoudon'tseeatopicofinterest,youcancreateanewtopic.
AllInJestNewthisyearistheAllInJestsession.
Here,paperswithnoseriouscontentwillbepresentedtoprovideabitofcomicreliefaftertwodaysofseriouspresentations.
ThissessionwilltakeplaceonTuesdayafternoonbeforetheClosingSession.
ClosingSessionWe'llwishafondfarewelltoSESUG'98andNorfolkonTuesdayafternoonattheClosingSession.
SESUG'99Co-ChairsGregoryBarnesNelsonandGeorgeMatthewswillpreviewwhattoexpectwhenwereconvenein1999.
Plus,therewillbedoorprizes.
Wecan'tguaranteewhatwillbeoffered,butin1997,SESUGattendeeswalkedoutoftheClosingSessionwithT-Shirts,booksgalore,aLynyrdSkynyrdCD,aship-in-a-bottle,andafreeseattoanSITrainingCourse.
MostawardsrequiretheattendeetobepresentattheClosingSessiontowin,sobesureyouarethere!
NearbySitesIfyouarefortunateenoughtohavesomefreetimewhileinNorfolk,youmaywanttotakeinsomeofthesitesinthearea.
YoumaywanttowalknextdoortotheWatersideFestivalMarketplaceforshoppinganddining.
Ifyouhavetransportation,youmaywanttodriveeasttoVirginiaBeachfordinner,ordriveacrosstheChesapeakeBayBridge-Tunnel,orgoforabarefootwalkalongtheAtlanticOcean.
Manyotherareasofinterestarealsonearby.
Withinwalkingdistancearethe:ChryslerMuseum,MacArthurMemorial,D'ArtCenter,St.
Paul'sChurch,HistoricHomes,TownPointPark,andNauticus.
ToursareavailablefromTheWatersidetothe:NorfolkBotanicalGardens,HamptonRoadsNavalMuseum,andNorfolkNavalBase.
Withindrivingdistanceare:ColonialWilliamsburg,Yorktown,Jamestown,BuschGardens,ChesapeakeBayBridge-Tunnel,andVirginiaBeach.
Also,rivercruisesareavailableon:TheAmericanRover,a135-foottopsailschooner;TheCarrie"B",areproductionofa19thCenturyMississippiRiverboat;orTheSpiritofNorfolk,adininganddancingcruise.
VendorParticipationTherewillbeopportunitiesforrepresentativesfromcompaniesthatofferproductsandservicesthatcomplementtheSASSystemtobeapartofSESUG'98.
Thisyear,wewillonceagainmakeavailablespaceinavendorroomwhereattendeescancomeandseewhatyouhavetooffer.
Thisyear,thevendorroomisonthesamelevelasmanyofthebreak-outroomsandwillthereforebemoreaccessibletotheattendeesthatwishtovisitit.
Atablewillbeprovidedtoeachvendor,butvendor-supplieddisplayscanalsobesetupaslongastheyfitwithintheirallottedspace.
WearealsoofferingspaceintheConferenceProgramforadvertisementsfromcompaniesandindividualsthatofferSASconsulting,SAS-basedsoftware,orarelookingforSASprogrammers.
Inaddition,eachattendeeattheconferencewillbeofferedapacketofvendorarticleswiththeirregistrationmaterialsduringcheck-in.
Vendorsmaydistributebrochures,keychains,pins,orotherpromotionalmaterialviathisprocess.
Allofthesemethodsareexcellentwaystoreachamotivated,receptive,andtargetedaudience.
Formoreinformation,includingratesandschedules,pleasecontactGeorgeMatthewsatgmatthew@arches.
uga.
eduor(706)542-5359orGregBarnesNelsonatgbn@asg-inc.
comor(919)467-0505.
AllvendorsattendingSESUG'98willbeexpectedtoabidebytheSESUGPolicyonVendorParticipation,whichcanbefoundonpage73.
WhatHappensAfterIRegisterAfterSESUGreceivesyourRegistrationandPayment,wewillmailyouaConfirmationPacketwithadditionalinformation.
Thiswillincludeaconfirmationofyourregistrationandpayment,directionstoNorfolkandtheSheratonNorfolkWatersideHotel,Norfolktourisminformation,andotherappropriateinformation.
We'llbelookingforyouinNorfolk!
WhatYourPeersSaidAboutSESUG'97Eachyearweincludeaquestionnaireintheconferenceprogram,askingattendeeswhattheylikedanddidn'tlikeabouttheconference.
Herearesomeverbatimcomments:"IhaveanewappreciationforSASasalanguageandasaproduct.
Thanks.
""Goodbuffet[on]Sunday.
""Allspeakerswerewellprepared.
""Veryusefulinformationwaspresented.
""Greatjob!
""Exceptionallyexcellent-SAS's[formal]onlinedemos.
""Thegeneralformatwasexcellent.
""Conferencewasinformativeanddiverse.
Allsessionparticipants…werepleasantandhelpful.
""Vendor'sAreawasagreatidea.
""…thesizeandenergyoftheconferencearegreat.
""Attendeesandvolunteersandeveryoneinvolvedwerefantastic.
""Excellentselectionoftopicsandspeakers.
""Verygoodorganization.
""Veryinformative.
""Thankyouallplannersandcoordinators-itwasgreat.
""SESUG97wasaclassact…""Keepupthegreatwork.
""Good,hardworkingconferenceleaders.
""[Iwill]definitelyattend[SESUG']98"Ofcourse,notallcommentsweresopositive.
TheSESUGExecutiveCouncilcarefullyreviewseverycommentoneveryevaluationformandusesthemtoimprovefutureconferences.
Attendeeshavesuggestedawiderangeofenhancementsandimprovements.
Manyhavebeenimplemented,somewilltaketimetoimplement,andsomearesimplynotfeasible.
Ifyouhaveanysuggestions,pleaseforwardthemtotheConferenceCo-Chairs.
ConferenceChecklistRegisterandpayfortheconference.
SeetheRegistrationFormonpages71-72fordetails.
Thisstepisrequired!
Arrangetransportation(seepage2forcontactinformationforHarboursideTravelServices,Inc.
).
MakereservationsattheSheratonNorfolkWatersideHotel(seepages69-70forreservationform),theClarionHotel,oranotherhotelofyourchoice.
SignupfortheCONSUGmeeting(page3).
Thisstepisoptional.
Signupforyourchoice(s)ofWeekendWorkshops(page66).
Thisstepisoptional.
Bringacreditcard,personalcheck,cash,orpurchaseordertotakeadvantageoftheConference's15%discountonSASInstitutebooks.
DatestoRememberJune15,1998RegistrationopensAugust7,1998LastdayfordiscountedEarlyRegistrationrateAugust21,1998LastdaytocancelyourconferenceregistrationandreceivearefundAugust24,1998LastdaySESUGroomratesarehonoredattheSheratonNorfolkWatersideHotelAugust24,1998LastdaySESUGroomratesarehonoredattheClarionHotelAugust28,1998LastdayregularRegistrationrateisineffectSeptember13-15,1998SESUG'98!
PreliminaryConferenceSchedulePermanyofyourrequestsfrompreviousconferencefeedbackforms,wehaveincludedapreliminarygridofwhattheconferencewilllooklike.
Pleasebeawarethisgridcouldchangeduetoeventsbeyondourcontrol.
RoomSaturdayMorningSaturdayAfternoonSaturdayEveningEppingtonWorkshop1:Religion101-UNIXforNon-believers(1:30-5:30pm)MontpelierWorkshop2:SASDebuggingTechniques(1:30-5:30pm)RoomSundayMorningSundayAfternoonSundayEveningCoatRoomRegistration/Information(2:00-5:00pm)ProvidenceCONSUGMeeting(8:30am-12:00pm)OpeningSession(7:30-9:00pm)StratfordSectionChairsMeeting(2:30-3:30pm)PresentersMeeting(3:30-4:30pm)WarmupSession(4:30-5:30pm)ClaremontVendorArea(1:30-5:30pm)EppingtonWorkshop3:IntegratingSASintoanIntelligentInternet/IntranetApplication(8:00am-12:00pm)Workshop5:ConnectingSAStotheInternetataPriceYouCanAfford(1:30-5:30pm)MontpelierWorkshop4:ASASProgrammer'sViewoftheSASSupervisor(8:00am-12:00pm)Workshop6:Merging,Combining,andSubsettingFiles(Tricks,Traps,andTechniques)(1:30-5:30pm)WiltonRehearsal(9:00am-12:00pm)Rehearsal(1:30-5:30pm)MonticelloReception(9:00-11:00pm)RoomMondayMorningMondayAfternoonMondayEveningCoatRoomRegistration/Information(8:00am-12:00pm)Registration/Information(1:30-5:00pm)PromenadePosters(8:00am-12:00pm)Posters(1:30-4:30pm)PoplarI-NetSolutions(8:00am-12:00pm)I-NetSolutions(1:30-4:30pm)SASFuturesForum(4:30-5:30pm)ProvidenceBeginningTutorials(8:00am-12:00pm)BeginningTutorials(1:30-4:30pm)StratfordAdvancedTutorials(8:00am-12:00pm)Technology2000(1:30-4:30pm)YorkSASInstituteDemoRoom(8:00am-12:00pm)ShopTalk(9:00am-12:00pm)SASInstituteDemoRoom(1:00-4:30pm)ShopTalk(1:30-4:30pm)ClaremontVendorArea(8:00am-5:30pm)EppingtonSerendipity(8:00am-12:00pm)Serendipity(1:30-4:30pm)BOF(7:00-9:00pm)GreenwayApplicationsDevelopment(8:00am-12:00pm)ApplicationsDevelopment(1:30-4:30pm)BOF(7:00-9:00pm)MontpelierStatistics(8:00am-12:00pm)Statistics(1:30-4:30pm)BOF(7:00-9:00pm)RiverviewHostSystems(8:00am-12:00pm)HostSystems(1:30-4:30pm)BOF:SESUG'99PlanningMeeting(7:00-9:00pm)BrandonAFormalOnlineDemos(8:00am-12:00pm)FormalOnlineDemos(1:30-4:30pm)BrandonBPCHands-OnWorkshops(9:00am-12:00pm)PCHands-OnWorkshops(1:30-4:30pm)WiltonRehearsal(7:00am-12:00pm)Rehearsal(2:00-5:30pm)MonticelloLuncheon(12:00-1:30pm)Mixer(5:30-7:00pm)RoomTuesdayMorningTuesdayAfternoonCoatRoomRegistration/Information(8:00am-12:00pm)Registration/Information(2:00-5:00pm)PromenadePosters(8:00am-12:00pm)PoplarTechnology2000(8:00-11:00am)I-NetSolutions(11:00am-12:00pm)I-NetSolutions(1:30-3:30pm)ProvidenceBeginningTutorials(8:00am-12:00pm)BeginningTutorials(1:30-3:30pm)StratfordAdvancedTutorials(8:00am-12:00pm)AdvancedTutorials(1:30-3:00pm)AllInJest(3:30-4:30pm)ClosingSession(4:30-5:30pm)YorkSASInstituteDemoRoom(8:00am-12:00pm)ShopTalk(9:00am-12:00pm)SASInstituteDemoRoom(1:00-2:30pm)ShopTalk(1:30-2:30pm)ClaremontVendorArea(8:00am-3:30pm)EppingtonCodersCorner(8:00am-12:00pm)CodersCorner(1:30-2:30pm)GreenwayApplicationsDevelopment(8:00am-12:00pm)ApplicationsDevelopment(1:30-2:00pm)Statistics(2:30-3:30pm)MontpelierStatistics(8:00am-12:00pm)Serendipity(1:30-3:30pm)RiverviewInformationVisualization(8:00am-12:00pm)InformationVisualization(1:30-3:30pm)BrandonAFormalOnlineDemos(8:00am-12:00pm)FormalOnlineDemos(1:30-2:30pm)BrandonBPCHands-OnWorkshops(9:00am-12:00pm)WiltonRehearsal(7:00am-12:00pm)MonticelloLuncheon(12:00-1:30pm)SASInstitutePublicationsHandsOnWorkshopsatSESUGPresentedbyProvidersofSASSoftwareTrainingandConsultingforoverelevenyearsSeptember13-15,1998SheratonNorfolkWatersideHotel,Norfolk,VATopicsInclude:Monday,September14thWorkshopsMergeProcessinginSASSoftware9:00-10:20a.
m.
Thisworkshopisdesignedtodemonstratesimpletoadvancedmatchmergeprocessing.
Theuseofcontributionvariables(IN=),selectionofdataandmanipulationintheprogramdatavectorwillbediscussed.
PROCTabulateBasics10:40-12:00p.
m.
AttendeeswillgainexperiencewiththeTabulateprocedurebybuildingitfromscratch.
Class,Var,andTablestatements,alongwithoperatorswillbedemonstratedindetail.
InteractivePROCReport1:30-2:50p.
m.
Thissessionwillteachattendeeshowtodevelopreportsinaninteractiveenvironmentwithoutwritingcode.
Thereportcanbeviewedasitisdevelopedandsavedforfutureuse.
MovingSASInformationtoWord/ExcelusingDDE3:10-4:30p.
m.
ThisworkshopwilldemonstratehowtotakedataoutofSAStoexternalapplicationssuchasWordorExcel.
HandsonDDEapplicationswillbebuilt.
Tuesday,September15thWorkshopsBeginningMacros9:00-10:20a.
m.
Thisworkshopwillintroducemacrovariables,callsymput,andsymget,alongwith%macro,%mendbundlesofcode.
Attendeeswillunderstandhowtomacro-izeprogramsforsimpler,moreefficientprocessing.
SQLBasics10:40-12:00p.
m.
AttendeeswillgethandsonexperiencewritingProcSQLcode,typicallyusedtosimplifyextractionandsummarizationofdata.
SQLcodewillbebuiltfromsimpleselectstocomplexjoins.
Weaskedformerstudentswhattheylikedabouttheworkshop.
"Terrificclass.
Veryveryhelpful!
NowIcanseethepowerofthelanguage!
"WellsFargoBank"ExcellentIntrotoSAS.
Theinstructorgearedittoourlevelandansweredallquestionsthoroughlyandwillingly!
"USAAInsurance"ThingsI'velearnedinthiscoursewillbeimmediatelyusefulinmyjob!
"U.
S.
Airways"Usefulworkshopexercises!
"BlueCross/BlueShield"Greatcourse!
"BureauoftheCensusComputerSeatingisavailablebyticketonlyonSunday,September13thonafirstcome,firstservedbasis.
Seeyourconferencepacketfordetails.
DestinyCorporation1321SilasDeaneHighwayWethersfield,CT06109-4302USAPhone:800-7TRAININGFax:860-721-9784Email:destinycorp@compuserve.
comWebSite:www.
destinycorp.
comPaperandPresentationAbstractsThissectionliststheabstractsreceivedthroughmid-April1998andisthereforeapreliminarylist.
PleasevisitourWebsiteperiodicallyathttp://www.
uga.
edu/~sesugforchanges.
ThefinallistofpresentationswillappearintheConferenceProgram.
Theabstractsarelistedalphabeticallybythefirst-listedauthor'slastnameineachsection.
Thenumbertothefarleftofanauthor'snameisthenumberofminutesscheduledforthepresentation.
Notethatbecauseofturnaroundtimebetweenspeakers,a50minutepapertakesa60minutetimeslot,anda20minutepresentationtakesa30minutetimeslot.
CodersCornerandAllinJestpresentationsare10minutes,takingupa15minutetimeslot.
Theletter(IorC)totheimmediateleftofanauthor'snamedesignateswhetherthepaperisInvitedorContributed.
AdvancedTutorialsSectionChairs:GerardetteFurlowNorthCarolinaStateUniversityRaleigh,NCElizabethHamiltonUniversityofNorthCarolinaChapelHill,NCHot-DeckImputation:ASimpleDataStepApproach50ILawrenceAltmayer;U.
S.
BureauoftheCensus;Washington,DCHot-deckimputationisameansofimputingdata,usingthedatafromotherobservationsinthesampleathand.
ThispaperdealswithamethodofimputationweusedfortheSurveyofAdultsonProbation.
Inthismethod,wefirstattempttoimputeracebasedonothervariablesinanobservation.
Weimputetheremainingmissingracedata,andageandgender,usingthesamevariableinpriororlatterobservationsinthedataset.
Thismethodusesmacrovariablestosubsetthedataintogroupswithinwhichimputationisdone.
Italsousesarraystokeeptrackofvaluestouseforimputation.
LawrenceAltmayerhasbeenwiththeU.
S.
CensusBureaufornineteenyearsandisacomputerspecialist.
HehasmorethaneightyearsSASprogrammingexperience,mostrecentlywithmacros.
HeiscurrentlyusingSAStoprocessNationalCrimeVictimizationSurveydata.
HisprogrammingexperiencehasbeenmainlyintheVMS,andmorerecentlyUNIX,operatingsystems.
HehasaBAinStatisticsfromtheUniv.
ofBuffalo,andMasterofAppliedStatisticsfromOhioStateUniversity.
BuildingBridgesBetweenOracleandSAS50IWilliam(Bill)CalvertandFengZhou;FoodandDrugAdministration;Rockville,MDInthecontextofadata-richclient-serverenvironment,techniquesarepresentedshowinghowtouseSASwithSQLandODBCtoconnecttoOracledatabases,developviews,andextractworkingSASdatasets.
Inaddition,waystosurveydatatables,prepareoutputandformatfieldsareshown.
Emphasisisplacedonautomatedapproaches(usingSAS/MACROSforexample)tominimizeotherwiselaboriousandtimeconsumingtasks.
BillCalvert,asChiefoftheSurveillanceandDataProcessingBranchintheDivisionofPharmacovigilanceandEpidemiology,CDER/FDAisworkingtoimprovedrugsafetymonitoringinformationsystems.
Formerlyheprovidedcontractresearchservicestopharmaceutical,healthcare,andinsuranceindustries.
Bill'sbroadbackgroundencompassesseveralyearsprovidingscientificcomputingsupportattheNationalInstitutesofHealthandarangeofpublicationsandpresentations,includingabook'ConceptsandCaseStudiesinDataManagement'.
Withover20yearsofexperienceinthehealthfieldBillhasdemonstratedasimultaneousgraspofclinical,statisticalandinformationtechnologyconcepts.
FengZhou,asastafffellowattheFDA,providesanalyticalandprogrammingsupportinpost-marketdrugsafetysurveillanceactivities.
Withover7yearsofSASexperienceinhighdemandenvironmentsonseveralcomputingplatforms,Fenghasdemonstratedskillsinpharmacovigilanceandepidemiologicstudies,surveysamplingandanalysis,statisticalcomputingandmodeling,databasedevelopmentanddatamanagement.
SheholdsanMAinStatisticsandanMAinMathematicsfromMichiganStateUniversityandisanexpertintheuseofSASproductssuchasBASE,STAT,SQL,andMACRO.
ASimpleFrameworkforSequentiallyProcessingHierarchicalDataSetsforLargeSurveys50IRichardL.
DownsandPuraA.
Perez;U.
S.
BureauoftheCensus;Washington,DCThispaperexplainsasimpleframeworkforapplyingtraditionalsequentialprocesses(reformat,edits,imputation,etc.
)toahierarchicalgroupofdatasets.
Theframeworkmergesthedatasetsusingaseriesoflayereddatastepviews.
Itthenshowshowuserscanwritedatastepcodethatprocessesthemergeddatasetsandoutputsupdatedversionsofoneormoreofthosedatasets.
Thedatastepcodeusesamacrotohelpdynamicallycreateakeepoptionforeachoutputdataset.
Thedatastepthenusesacombinationofcheckingforlast.
variablesandmissingvaluestodeterminethepropertimetooutputtoeachdataset.
Thisframeworklargelyisolatesthecomplexityofrelatingthedatasetsfromthecomplexityoftheactualprocess,itmaintainsthedatasethierarchy,andeliminatestheneedforanypost-processprocessing(alloutputdatasetsarecompleteattheendoftheprocessdatastep).
RichardL.
Downs,Jr.
hasaBSinInformationSystemsManagementfromtheUniversityofMaryland,BaltimoreCountyandaMSinComputerSystemsManagementfromtheUniversityofMaryland.
HehasworkedattheU.
S.
BureauoftheCensusfor10yearsasanapplicationsandsystemsprogrammerwith5yearsprogrammingexperienceinSAS.
PuraA.
PerezhasaBSinMathematicsandComputerSciencefromtheCatholicUniversityofPuertoRicoandaMSinComputerSystemsManagementwithaconcentrationinDatabaseSystemsandSecurityfromtheUniversityofMaryland.
Shehasworkedforthepast7yearsattheU.
S.
BureauoftheCensusasanapplicationsprogrammerwith3yearsexperienceprogramminginSAS.
MATCH-MERGING:27PlusTrapsandHowtoAvoidThem50IMalachyJ.
Foley;UniversityofNorthCarolina;ChapelHill,NCMatch-mergingisacommonformofcombiningfiles.
Yet,ithasitspitfalls.
Thistutorialreviewsmorethan27trapsthatcansnarlevenaseasonedprogrammer.
Itgivesexamplesofmanyofthesetraps,andprovidesacomprehensivedefensivestrategyforavoidingmostofthem.
MalFoleystartedprogrammingcomputersinhighschoolandhasneverstopped.
Hiscareerincludesbeinganinternationalcomputingconsultant,auniversityprofessor,amanagerofseveralcomputingdepartments,andtheCEOofhisowncomputingcompany.
Mal'sspecialtiesareclinicaltrials,surveyresearch,businessapplicationsdevelopment,anddatabasemanagement.
HehasprogrammedinSAS,FORTRAN,COBOL,PL/1,RPG,ALGOL,BASIC,REXX,andAssembler.
HehasconsultedtoIBM,DowChemical,Ford-RockefellerFoundation,UnitedNations,U.
S.
DepartmentofAgriculture,U.
S.
AgencyforInternationalDevelopment,andmanyUSandLatinAmericanuniversities,governmentagenciesandbusinesses.
HehasgivenpresentationsatSUGIandmanyotherSASusergroups.
CreatingIndexedDataSetsandUsingDirectedAccessQueries50IJohnCharlesGober;DepartmentofCommerce,BureauoftheCensus;Washington,DCWhenretrievingormininginformationfromadatawarehouseconsistingofahalfterabyteofdata,itisessentialthatonereduceprocessingtimeandtemporarystoragespacetothesmallestunitsavailable.
Byselectivelyretrievingrecordsfromonefilebasedonkeyscreatedfromanotherfile,youcanoftenincreasetheefficiencyofdataextractionbyover90percentascomparedwiththeusual"match/merge"process.
Thispaperwillwalktheuserthroughanapplicationusingdatasetscontaininguniqueandnon-uniqueindices,andcoverhowsuchindicescanbeusedtoextractdatainanefficientandtimelymanner.
JohnGoberisemployedasaprogrammer/analystbytheCommerceDepartment,BureauoftheCensus,DemographicSurveysDivision.
HehasalmosttwodecadesofSASexperienceonMainframe,PC,VAX,andUNIXenvironmentsandspecializesinthecleaning,extraction,manipulation,andtransferofdataonmultipleplatformenvironments.
Mr.
Goberisproficientinthemacrolanguage,applicationdevelopment,creatinguserfriendlyinterfaces,andisafrequentpresenteratNESUG,SESUG,andSUGI.
AStatistician'sGuidetoUsingSASwithMSAccessandExcelData50IRobertE.
Johnson;VirginiaCommonwealthUniversity;Richmond,VAStatisticiansandstatisticalprogrammersoftenmustanalyzedatafromexternalsourceswhichmayarriveintheformofanMSAccesstableoranExcelworkbook.
WhilethesedatacouldbeexportedtoatextfileandthenimportedintoSAS,thisisaquickfixforisolatedapplications.
AmoreusefulsolutionistouseSASsoftwaretoreadfromandwritetothesemediaandamannerwhichmayeasilyberepeatedwithnewdatabecomeavailable.
Inthistutorial,wewillexplorethevariousoptionsforpassinginformationbetweenAccesstablesandspreadsheets.
RobertE.
Johnson(Bob)hasbeenaSASuserfor22years.
HeauthoredwithRickLangston(SASInstitute)andDanaQuade(UNC-CH)theVersion5supplementalSASprocedureMATPAR.
HehasalsomadeseveralpresentationsatSUGIandSESUG.
Dr.
JohnsonisanassociateprofessorofstatisticsatVirginiaCommonwealthUniversity.
Hisresearchisinbiostatisticsandgeometriclinearmodels.
AnOverviewofTechniquestoIntroduceExternalDataIntotheSASSystem80IAndrewT.
Kuligowski;NielsenMediaResearch;Dunedin,FLTheSASSystemhasnumerouscapabilitiestostore,analyze,report,andpresentdata.
However,thosefeaturesareuselessunlessthatdataarestoredinorcanbeaccessedbytheSASSystem.
ThispresentationwillprovideabriefintroductiontomanyofthedifferentmethodsthatcanbeusedtopassdataintotheSASSystem.
Topicswillincludethemenu-drivenSASImportWizard,theINPUTandINFILEstatements,DDE,ODBC,andmanyothersasmanyastimeandspacewillallow!
ThegoalofthispresentationistoprovideinformationthatwillbeusefultoallusersoftheSASSystem.
Sometopicsaretailoredtothenovice,whileotherswillbemoreapplicabletotheexperienceduser.
AndrewT.
Kuligowskihasbeenacomputerprofessionalforwellover10years(althoughhedeclinestoadmitjusthowmanyyearsover10).
HehasbeenprogrammingwiththeSASSystemthroughouthiscareer.
AndyjoinedNielsenMediaResearchin1986,afterspending5yearsinthepetrochemicalindustry.
Hehasbeeninvolvedinamyriadofprojectssincethen,mostofthemdealingwiththecabletelevisionindustry.
Inhissparetime,AndyalsoservesontheExecutiveCommitteefortheSoutheastSASUsersGroup.
HewastheConferenceCo-ChairforSESUG'97,whichwasheldinJacksonville,Florida.
YourBaseSASDollarsatWork-What'sNewandUsefulinVersion750IChrisOlingerandBrianSchellenberger;SASInstituteTheBASEproceduresgroup(IPD)atSASInstitutehasbeenhardatworkaddingnewandusefulfeaturestotheheartoftheSASSystem.
Thistalkdescribesthisworkandusesgeneric"businessoriented"examplestoplacethesefeaturesinacontextthatdemonstratestheiruseineverydayprogramming.
Coveredare:NewSUMMARY/TABULATEoptionslikepercentiles,independentorderingofclassvariables,andthepre-loadingoftheclass-variablespaceusingformatsand/ordatasetsTheODSstatementforproducingoutputdatasetsandHTMLoutputfromallSASprocedures,High-FidelityPrintingandmoreODSspecificadditionstoPROCREPORT,PROCTABULATE,andtheSAS/GRAPHProceduresthatenhancetheWebpotentialofthesework-horsetools.
BuildtreesofWebpageswithgraphics,embeddedlinksandcell-specificformatting(likefontandcolor)easily,repeatablyfromyourcurrentbatchjobs.
ChrisOlinger,aveteranSASemployee,worksintheApplicationsDivisionofResearchandDevelopment.
HeisoneofthekeyODSdevelopers(hewaspartlyresponsiblefortheVersion6ODSprototype)andnowprogramsthebulkoftheinternalODSinfrastructureintheSASSystem.
BrianSchellenberger,aveteranSASemployee,worksintheApplicationsDivisionofResearchandDevelopment.
HeisresponsibleforthenewHighFidelityprintingtechnology(PostscriptandPDF)inODS.
HerecentlyreturnedtoworkonBaseSASSoftwareafterastintwhereheworkedoninternaltoolslikecompilersanddebuggers.
ProgrammaticGenerationofTableSpecificationsUsingtheSASMacroFacility50IDr.
WilliamSun;PharmaceuticalResearchAssociates,Inc.
Whenpreparingadataanalysisplanforaclinicaltrial,weneedtocreatetablespecificationspriortotheavailabilityofthedatabase.
Manytimes,thesetablespecificationsareproducedthroughawordprocessing,whichmaynotbeefficient.
Toincreaseefficiency,thefollowingtwostepshavebeentriedtoprogrammaticallyproducetablespecifications:generatedummySASdatasetsbasedupontheefficacyandsafetyvariablesdefinedinaprotocoluseagenericSASmacroandtheREPORTproceduretoproducedesiredtablesbaseduponthedummydatasetscreatedBytheendofthisprocess,notonlythedesiredtablespecificationsareproduced,butalsothetable-productionprogramsandaformatlibrary,whichcontainstitles,footnotes,andvariableformatsassideproducts.
Whenproducingrealtables,weneedonlytogeneratethoseanalysisdatasetswhichareinthesamestructureasthedummydatasets,andrunthetable-productionprogramsontherealdatasets.
Thismethodhasbeenprovedveryefficient.
TherearetwogenericSASmacros,MDATSETandSUMCLIN,whichmayhelpuserstoproducedummydatasetsandsummarytables,respectively.
Thispaperillustratesthedesignofthemacrosanddemonstratesapplicationsofthesetwomacrostoarealstudy.
WilliamSunisemployedasabiostatisticianbyPharmaceuticalResearchAssociates,Inc.
HegothisPh.
D.
inStatisticsfromtheUniversityofVirginiainMay,1995.
Dr.
SunhasplentyofexperienceinscientificprogrammingusingSAS,C++,andFORTRAN.
Hehad6yearsexperienceindevelopingastatisticalsoftwarepackagewhenhewasinChina.
Duringthepastfewyears,hemadespecialeffortsonstandardizationofcommonpracticesofavarietyofclinicaltrialsandputgreatattentiononthepossibilityofdesigninganddevelopinggenericmacrostodealwithavarietyofstatisticalanalysesandsummariesofclinicaldata.
AllInJestSectionChairs:OliviaRudFleetWilmington,DEBobPassmorePassmoreConsultingServicesDurham,NCAdvancedSuspendedAnimationProgram(ASAP)UsingSASv32.
09forSpaceOSv7.
5893210CWrittenby:RandyFinchII;SusAnTechnologies;Spaceport28,ALPresentedby:RandyFinch;TennesseeValleyAuthority;MuscleShoals,ALThroughtemporalreversaltechniques,wehaveobtainedanexcerptfromtheProceedingsofSUGI75whichwillbeheldinNewNew-York,NewYorkintheyear2050.
Thisexcerptdiscusseswhatwillthenbearevolutionarynewsuspendedanimationtechnique.
RandyFinchIIwillbeagraduateofInternet3University,anonlinevirtualrealityschool.
HewillbetheProjectLeaderfortheASAPprojectatSusAnTechnologies.
Atthattime,hewillhaveworkedwithSASfor10years.
RandyFinchIIisthegrandsonofRandyFinch,aConferenceCo-ChairforSESUG'98.
RandyFinchisagraduateoftheUniversityofLouisville.
HeiscurrentlyemployedbytheTennesseeValleyAuthorityandhasbeenusingSASfor18years.
HowtoImpressanInterviewerThatYouareaSASSoftwareExpert10CMichaelRaithel;RaithelConsultingServices;GarrettPark,MDIfyouareaSASprogrammerwhoislookingtoaddmorepzaztoyourjobinterviewingtechniques,thenthispresentationisforyou!
Inthissession,youwilllearnanumberofinsightfulphrasesaboutSASSystemsoftwarethataresuretomakeyourinterviewersitupstraightandthinkthatyouare"intheknow.
"Bycarefullyweavingtheseshrewdobservationsthroughoutyourinterview,youshouldbeabletostunyourinterviewer,acetheinterview,anddrasticallyincreaseyourstartingsalary.
Note:Duetothenatureofthematerialinthispresentation,notechnicalrecruitersorPersonnelDepartmentemployeeswillbeadmittedtothissession.
MichaelA.
RaithelisacomputerperformanceanalystthatspecializesinMVSperformance,tuning,andcapacityplanning.
Hewasco-chairoftheNESUG'95conferenceinWashington,DC,andhasbeenafrequentinvitedspeakeratSUGIandNESUGconferences.
Michaelistheauthorof"TuningSASApplicationsintheMVSEnvironment"publishedbytheSASInstitute.
TheSASTravelCompanion10CC.
OliviaRud;'CondeSAS'TravelMagazineAsSASusers,weareallawareofthevarietyoftoolsavailabletousthroughtheSASsystemfromversatiledatamanipulationtopowerfulanalytictoolsandprocesses.
However,fewofusareawareofthestrongfunctionalityoftheSASsystemasatravelguide.
ThepurposeofthispaperistotakeyouonajourneyusingtheSASTravelCompanion.
Youareguaranteedtoreturnrefreshedandreadytogo.
It'sjustwhatDr.
Goodnightorderedforyourbadcode.
C.
OliviaRudisaheadwriterandtravelconsultantfor'CondeSAS'TravelMagazine.
ShespecializesintripsforthementallyunsoundandhasbeenakeyresourcefortheplanningofSESUGandSUGIconferences.
ShewasinstrumentalinsecuringthemostrecentlocationforSUGI23inNashville,TN.
TheNashvillelocationachievedhergoalofequalizingand/orreducingthementalcapabilitiesoftheattendeesthroughexcessiveexposuretocountrymusic.
ShehasbeenaSASprogrammerfor15hours.
ApplicationsDevelopmentSectionChairs:Phild'AlmadaEDSAtlanta,GAOliviaRudFleetWilmington,DECalibratingInstrumentsAutomaticallywithSASSoftware20CEricBrinsfield;MeridianSoftware,Inc.
;Raleigh,NCMostautomatedmanufacturingprocessesusedelicateinstrumentstomonitorspecificcharacteristicsofrawmaterialsorend-products.
Theinformationderivedfromthesemetersmustbeaccurateinordertoprovideanybenefittoqualityandconsistency.
Asaresult,theinstrumentsshouldbecheckedandcalibratedregularly.
Unfortunately,manualcalibrationcanleadtosignificantdowntimeandthereforelossofproductivity.
Toalleviatethisdilemma,wedevelopedaSAS/AFapplicationthatevaluateshistoricaldataandprovidesrecommendationsforsoftware-basedcalibrationofinstruments.
Theclient-serverapplicationreadssampledatafromInformix,performsanalysiswithinSAS,andpermitsuser-initiatedupdateofcalibrationparametersinInformix.
Thesystemoffersauditedexclusionofoutliersinthedataaswellasadhochistoricalanalysis.
EricBrinsfieldispresidentofMeridianSoftware,Inc.
,acustomsoftwaredevelopmentfirm.
HehasbeenusingSASsoftwaresince1977andspecializesinprojectmanagement,softwaresystemdesign,databasedesign,andGUIdesign.
EricearnedhisBSfromDukeUniversityandhisMSfromNorthCarolinaStateUniversity.
BuildingMacro-basedDataStepFunctionsUsingRandomMacroAliasestoSimulateLocalScopeofInternalFunctionVariables20CPaulDorfman;CitibankUniversalCardServices;Jacksonville,FLInlieuofuser-definedDATAstepfunctions,SASMacrofacilityisapowerfulmeansofdevelopingfunctionsandlanguagestatementstobeusedinaDATAstep.
However,careshouldbetakentoproperlylocalizevariablesusedinsidesuchconstructs,sotheywouldnotinterferewithothervariablesusedintheDATAstepwheretheymaybeinvoked.
Inthispaper,issuesrelatedtodevelopingmacro-basedDATAstepfunctionsarediscussed,andarandomtechniqueofcreatingrandommacroaliasesthatpracticallyeliminatesinterferencebetweenthevariablesispresented.
Themethodisillustratedbyreal-worldexamplesofbuildingmacro-basedDATAstepfunctionsandlanguagestatementswherelocalscopeofinternalvariablesisrandomlysimulatedbyastand-alonemacro.
PaulDorfmanbeganusingSASmorethan13yearsagoasascientificprogrammerforcomputationalmodelingofinstabilitiesinionbeamplasma.
Afterwards,heusedSASforapplicationdevelopment,adhocdataprocessing,datawarehousing,anddataanalysisinelectronicengineering,telecommunications,pharmaceutical,andcreditcardindustries.
Hisprincipalworkingenvironment,mainframe,isslightlycontaminatedwithsomePCimpurities.
HelovesSASandfindsSASprogrammingaestheticallyandprofessionallysatisfying,butalsoadmitstohavingbeenchronologicallyexposedtoAlgol,Fortran,Basic,Cobol,andC.
%FREQ1VAR:FrequencyofOneVariablewithFormat:aMacrotoStandardizePROCFREQOutputDataSets20CRonaldFehd;CDC;Atlanta,GASASsoftwareprovidestheabilitytoassociateformats,orlookuptables,withvariablesinadataset.
Encapsulatingtheformatlabelsinasummarydatasetprovidesacompleteandindependentsetofinformationaboutavariabletootherprocedures.
ThismacrowaswrittentostandardizesummarydatasetsandbringthemintoconformancewithdatasetsproducedbyFehd's(1997)CHECKALLandSHOWCOMBmacros,whichprovideinformationaboutmultipleresponsedata.
Thestandardizeddatasets,orobjects,havethesamestructureandareusedforquickandconcisereportingofsummaryinformationoflargesurveyquestionnairedatasets.
Theiridenticalstructureenableseasyaccessbyothermethodsandsoftware.
RonaldFehd(pronunciationtip:FEHDrhymeswithFEDERAL:Ronworksforthe_federal_government)receivedhisBSinComputerSciencefromtheUniversityofHawaii-Manoain1986.
HehasbeenaSASuserformorethantwelveyearsandhasworkedfortheCentersfortheDivisionofLaboratorySystems,PublicHealthPracticeProgramOffice,CentersforDiseaseControlandPrevention,AtlantaGA,formorethantenyears.
HehaspostedtoSAS-LunderthenametheMacroMaven.
Heisaprogrammer/analyst,datamanager,anddatadetective.
Hisexpertiseisthemacrolanguageandadvanceddatastepprogramming,withanemphasisoncharactervariablemanipulation.
Theseroutinesareapartofhisdatamanager'stoolbox.
HowtoUseSASSoftwarefromBeginningto(Almost)EndingforYourDataWarehouse50IAkbarGolmirzaie;IndependentConsultant;Fayetteville,ARTheUniversityofArkansasatFayettevillebeganexplorationofthedevelopmentandimplementationofdatawarehousinginNovember,1995.
Inundertwoyears,theComputingServicesDepartmenthasmovedfromconceptualmodelingtoaworking,evolvingproductionsystemfordatastorageandretrieval-allatasubstantialsavingsintime,money,andresourceswhencomparedtoothersystemsbuiltbyanddemonstratedtousatotherfacilities.
FundamentalinthisendeavorhasbeentheuseofSASsoftware.
Fromthesystemadministrationtoolstothosemaintainingthesecureserver,theUniversityofArkansasdevelopmentteamfoundinasinglesoftwaresuitewhatpreviouslyhadbeenavailableonlyasseparate,muchmoreexpensivepackages.
Inaddition,themultiplatformcapabilitiesofthesoftwareandthenewSASODBCdriversensurethatend-userscandirectlyretrieve,massage,andreportfromthenow-centralizeddatawithanyODBC-compliantsoftwarepackage,inadditiontoSASitself.
Thispaperisprimarilyintendedforfacilitymanagement,MISprogrammersandtechnicalstaffmembers.
InitweshallpresentareviewoftheFayettevilledatawarehouse,addressingitsdesign,construction,andimplementation.
AkbarGolmirzaiewasaprojectdeveloperattheUniversityofArkansasandhasover17yearsexperienceusingSAS.
HehasbeenaSASprogrammer,trainer,analyst,andrepresentativefor13yearsattheUniversityofArkansas.
Hewastechnicalleader,developer,andtrainerforthedatawarehouseattheUniversityofArkansas.
Hewastherecipientofthe1997EnterpriseComputingAwardforAcademicApplicationsthatwaspresentedatSUGI23.
DevelopingRatioEditParameterswithSASfortheEconomicCensus50IRichardW.
Graham;U.
S.
BureauoftheCensus;Washington,DCInMay1995,ateamofsubject-matterspecialists,processors,programmers,andmathematicalstatisticianswascommissionedtodevelopageneralizededitandimputationsystemforthe1996AnnualSurveyofManufacturesandthe1997EconomicCensuses.
Outofthateffort,theteamdevelopedamodularly-designedsystemconsistingofthreemaineditingcomponents:aratiomodule,abalancingmodule,andaverificationorreferencelookupmodule.
Whileeachmodulemaybeusedindependently,whenusedincombination,thesystemprovidesforacompleteandconsistentdataset.
Thispaperbrieflycoverstheunderlyingtheoryandframeworkoftheratiocomponent,discussesthemethodologyforcreatingeditingrules,andfocusesonthedevelopmentoftheeditrulesandimputationparameterswithintheSASsystem.
Specifically,thepaperdetailsanexploratorydataanalysis(EDA)approachdevelopedinthemacrolanguageandtheSAS/AFframeentryfront-enddevelopedasaninterfacetolaunchthemacroapplication.
ThepaperalsodiscussestheSASimplementationfordevelopingimputationparametersusingPROCREG.
RichardGrahamisasurveystatisticianattheBureauoftheCensus.
HehasbeenaSASuserforapproximately7yearsandhasdevelopedanumberofSAS/AFapplications.
HisprimarydutiesattheBureauarethedevelopment,implementation,andcoordinationofthepost-collectioneditingactivitiesandoutlieranalysismethodologiesfortheEconomicCensus.
DevelopingaParameterEvaluationMethodologyUsingSAS20CRichardW.
Graham;U.
S.
BureauoftheCensus;Washington,DCThispaperisafollow-uptotheDevelopingRatioEditParameterswithSASfortheEconomicCensus.
Inthispaper,thediscussioncoversthedevelopmentofSAS/AFapplicationsusedforevaluatingthepreviously-developededitingboundariesandtheimputationparameters.
ThepaperfocusesontwoSAS/AFapplications.
Thefirstapplicationlaunchesabatchprocedurewhichconductsadataanalysisoftheparameters,thengraphsthefailuresusingPROCGPLOT.
ThefailureplotsarestoredforlaterreviewusingPROCGREPLAY.
Thesecondapplicationisabasiccopyofthefirstexceptthatinthisapplication,theanalysthasinteractivecontroloverwhichindustriestoreviewandthisapplicationalsoallowsforthereviewofacceptedparameters.
RichardGrahamisasurveystatisticianattheBureauoftheCensus.
HehasbeenaSASuserforapproximately7yearsandhasdevelopedanumberofSAS/AFapplications.
HisprimarydutiesattheBureauarethedevelopment,implementation,andcoordinationofthepost-collectioneditingactivitiesandoutlieranalysismethodologiesfortheEconomicCensus.
DATAStepinVersion7:What'sNew50IWilliamF.
Heffner;SASInstituteThispaperwilldiscussenhancementsforVersion7totheDATAstepanditsassociatedenvironment.
Theseenhancementsincludenamespaceandvariable-handlingimprovements,newexternalI/Ofeatures,newbuilt-infunctions,anoptionfortheSETstatementwhichdelaysSASdatasetopensuntilneeded,theDATASTMTCHK=option,performanceimprovements,andnewquasi-multiprogrammingcapabilities.
WilliamF.
HeffnerisaPrincipleSystemsDeveloperinCoreSupervisorDevelopmentatSASInstitute.
HehasbeenwiththeInstituteforoverthirteenyears.
Forthepastfiveyears,hehasbeentheleaddeveloperfortheDATAStep,supportingthecompile,resolve,andexecutephases,aswellastheDATAStepviewengineandtheDATAStepdebugger.
PreviousdevelopmentworkinvolvedtheSASSystemforMVSandcodegenerationsubsystems.
HarnessingthePowerofSCLLists50ILisaHorwitz;SASInstituteSCLlistsareorderedcollectionsofdatastoredinmemoryandareapowerfultoolforapplicationsdevelopers.
Thesourcesofthisdatacanincludehardcodedvalues,SASdatasets,informationretrievedfrominteractionwiththeapplicationuserorthecurrentSASsession,ortheFRAMEentry'sobjectsthemselves.
ThispaperexploreshowtocreateandpopulateSCLlists,howtoretrieveandutilizeinformationfromlists,howtomanipulatelists,andhowtoaccesssomeofthelistsassociatedwithFRAMEentryobjects.
AnassortmentofideasforusingSCLlistswillbesuggestedaswell.
LisaHorwitz,RegionalTrainingCenterManager,overseestrainingatSASInstitute'sNewYork,Bedminster,NJ,Philadelphia,PA,Boston,MA,andHartford,CToffices.
Lisaalsoteachesclassesandconsultsinherspecialtyareas,whichincludeapplicationsdevelopmentandtheMacrolanguage.
SheisafrequentpresenteratlocalandregionalUsersGroupmeetingsandatSUGI.
GUITestingofSASSoftware50IAllenMalone;SASInstituteTestingthegraphicaluserinterface(GUI)ofSASSoftwarehasmanychallenges.
TestingtheGUIonseveraldifferenthardwareconfigurationsaddstothechallenges.
ThispaperwilldiscussthemethodsusedintestingtheGUIofSASSoftwareusingtoolsdevelopedwithSASSoftwareaswellasvendorsuppliedtestingtools.
ThechallengeofautomatingGUItestingwillbediscussedaswellascreatingandmaintaininggoodGUItests.
TheQADivisionhasmanydecadesoftestingexperiencewithintheranks.
Thetopicoftestingthegraphicaluserinterfaceisachallengethathasfacedalltesters,astheSASSystemhasbecomemoreGUIoriented.
TheQAStaffwouldliketosharethatknowledgewiththeSASUserCommunityastheyhaveincreasingtestingdemandswhiledevelopingSASApplications.
AllenMaloneisaQualityAssuranceAnalystatSASInstitutewherehehasleadtestingeffortsforSAS/CONNECTandSAS/SHAREinthepast.
HeiscurrentlyworkingonSAS/AF,SCLandSAS/FSPfortheupcomingVersion7release.
AllenalsositsontheboardoftheTriangleInformationSystemsQualityAssociationcoordinatinglecturersonSoftwareQualitytopicsintheResearchTrianglePark,NCarea.
AMaintenance-Free,Menu-DrivenClosureSystem50CStephenM.
Noga;Rho,Inc.
;ChapelHill,NCAsaclinicaltrialnearsclosure,aseriesofdatavalidationprogramsarerun,sometimesindividually,andsometimesincombinationwithoneanother.
Ofcourse,onlythoseprogramsthatareinexistenceatclosuretimecanberun.
ThispaperdescribesamenudrivenclosuresystemthatwasdevelopedusingSASFrame,andtakesadvantageofwhatwereonceexclusivelySCLcommands,butwhicharenowavailableinthedatastep.
Thissystemismaintenance-freebecauseyoucanaddnewclosureprogramstoitwithouteverhavingtoupdatethemenu.
SteveNogaiscurrentlyaSeniorSASProgrammer/AnalystatRho.
Beforethat,hewasthestatisticalcomputingteamleaderontheAtherosclerosisRiskInCommunitiesstudyattheUniversityOfNorthCarolina-ChapelHill,DepartmentofBiostatistics,andwastheDirectorOfTechnicalProgramsandServicesfortheNationalCenterForCharitableStatistics.
HehasbeenaSASuserinaprofessionalenvironmentforthepasttwelveyears,workingonvariouscomputerplatformsandoperatingsystems.
PastSUGIand/orSESUGpapershavebeenonfactoranalysis,maps,PROCLOGISTICandPROCTABULATE.
GUIKISSes:TipsandStrategiesforInterfaceDesign20CJohnA.
Quarantillo;Westat,Inc.
;Rockville,MDThispaperdiscussesGraphicalUserInterface(GUI)design.
Itistemptingfordeveloperstobuildaninterfaceusingtoomany'bellsandwhistles'.
Suchaninterface,althoughtechnicallyappealingandchallenging,canbedifficulttodevelopandmaintain,butmostimportant,difficulttouse.
TheacronymKISS(KeepItSimple,Stupid)applieswelltointerfacedesign.
Asimple,effectiveinterfaceshouldbedesignedwiththeusers'needstakingfirstpriority.
Specifictopicsaddressedinclude:whichtypesofscreencontrolstouseandwhen,keyboardandmousesupport,designingwithportabilityinmind,andtesting.
Theaudiencelevelisbeginner,andwillfocusmoreonthestrategiesusedthantheactualcodetoimplementsuchinterfaces.
JohnQuarantilloisaSystemsAnalystwithWestat,IncorporatedinRockville,Maryland.
HehasworkedwithSASforelevenyears,usingSASfordatamanipulation,management,anddatacollection.
Inhissparetime,Johnenjoysmusic,Webpagedesign,'netsurfingand'real'surfing.
STDINFO:ApplicationsDevelopmentandSexuallyTransmittedDiseases50IRayL.
RansomandSharonHixon;CDC;Atlanta,GATheDivisionofSexuallyTransmittedDiseasePrevention(DSTDP)oftheCentersforDiseaseControlandPreventioniscurrentlydevelopinganapplicationfront-endtotheirdatawarehouse.
Thedatawarehouseincludesmorbidity,costanalysis,behavioral,demographic,programmatic,andadministrativedatarelatedtoSTDcontrolandpreventionaswellaswarehouseandapplicationmetadata.
Theapplication,STDINFO,providesresearchers,datamanagers,andoperationalandprogramstaffdesktopaccesstodataandtoolsforquerying,analysis,andreporting.
STDINFOiscurrentlyinit'sfirstproductionreleasephase.
Inthispresentation,theauthorswilldemonstratedevelopmentstrategiesandspecificfunctionalitiesofSTDINFO.
StrategiesdemonstratedwillincludemaintainingacommonWindows"lookandfeel",buildingmetadata,usingSCLliststounlockthepowerofyourmetadata,andusingSCLsublistsforimprovedapplicationperformanceandefficiency.
Demonstratedapplicationfunctionalitywillincludeuserfeedback,Helptools,documentation,anddatasetcreationandconversionacrossoperatingsystems.
ApplicableSASSystemcomponentsincludeSAS/AF,SAS/SCL,SAS/SHARE,andSAS/CONNECT.
OperatingsystemsandplatformsincludeWindows3.
1,95andNT,UNIX,Novell4.
11,andSQL.
RayRansomisaSystemsAnalystfortheDivisionofSTDPreventionattheCentersforDiseaseControlandPrevention.
HehasbeenusingSASSoftwarefor12yearsandhaspresentedat5SUGIconferencesand1SESUGConference.
Hehaswon3"BestPaper"awardsatSUGIandwasanInvitedspeakerintheSystemsArchitecturesectionatthisyear'sSUGIinNashville.
BesidesprovidingtechnicalsupportforseveralnationalandinternationalSTDpreventionprojects,heiscurrentlytheprojectleaderonacombineddatawarehousingandapplicationsdevelopmentprojectattheCentersforDiseaseControlandPrevention.
SharonHixonisaProgrammerfortheDivisionofSTDPreventionattheCentersforDiseaseControlandPrevention.
HerbackgroundisintrainingandsupportandsheisaCertifiedMicrosoftProductSpecialist.
ShehasbeenusingSASSoftwarefor3yearsandhaspresentedatSUGI22inSanDiego,whereshewon"BestPaper"award,andatSESUG97inJacksonville.
SheiscurrentlyadeveloperonacombineddatawarehousingandapplicationsdevelopmentprojectattheCentersforDiseaseControlandPrevention.
CATALOGER:AnApplicationDevelopmentTooltoSearch,Compare,andDocumentSASCatalogsandDataFiles20CChristopherA.
RoperandMichaelGilman;QualexConsultingServices,Inc.
;Fairfax,VAThispaperwillpresentanapplicationwrittenentirelyinSASthatgreatlyenhancesthedeveloper'sabilitytodevelop,compare,andmanageSAScatalogentriesanddatasets.
Thisapplicationhaspointandclickcapabilitiesforprintingcatalogentries,includingimagesofframeentriesandcompletedescriptionsofassociatedwidgetsdirectlyintoMicrosoftWorddocuments,creatingpublicationqualitydocumentationatthepushofabutton.
Thebatchprintingfacilityallowsforprintingofallcatalogentriesofvirtuallyanytype,includingProgram,Source,SCL,andSlist(includingexpandedsublists)entries.
Thetextsearchingfacilitywillsearchthroughalltext-basedentriesforcharacterstringsandallowpointandclickaccesstothelocationsinanycatalogentrycontainingthetextstring.
Additionally,interactive,side-by-sidecomparisonsofcatalogentriesinseparate,independentwindowsonthesameSAS/AFscreengreatlyenhancestheapplicationdeveloper'sabilitytomanageandcomparedifferentversionsofSAScatalogs.
ChristopherA.
RoperisaSeniorSystemsConsultantwithQualexConsultingServices,Inc.
HisareasofexpertiseincludeBaseSAS,SAS/AF,SAS/FSP,Macros,Frame,andSCL,hasbeendevelopingSASapplicationsforovertenyears.
ChriswonBestContributedPaperinApplicationsDevelopmentatlastyear'sWUSSconference,andisanfrequentpresenteratSASusergroupsacrosstheUnitedStatesandEurope.
ChrishasaBSinBusinessAdministrationwithaConcentrationinEconomicsfromChristopherNewportUniversity.
MichaelGilmanhasworkedwiththeSASsystemforalmost20years.
Hisexpertiseencompassesabroadrangeofindustriesincludingautomotive,educational,financial,government,health,andindustrial.
NowasSeniorApplicationsConsultantwithQualexConsultingServices,Inc.
,MichaelcontinuestodevelophighqualitySASsoftwaresolutionsusingBaseSAS,SAS/FSP,Frame,SCL,andSAS/GRAPH.
MichaelhasaM.
Sc.
(ComputerScience)andB.
Sc.
(Major:Psychology;Minor:ComputerScience)fromMcGillUniversityinMontreal,PQ.
AMethodologyforDevelopingSASApplicationsforUseInMultipleLanguages20CChristopherA.
Roper,GinaM.
Thomas,andMichaelGilman;QualexConsultingServices,Inc.
;Fairfax,VADevelopingSASapplicationsthatwillbeusedinseveralcountries,eachwithitsownnativelanguage,presentsuniquechallengesfortheSASapplicationsdeveloper.
ThispaperwillpresentamethodologyfordevelopingaSASapplicationthatmaybeusedinanynumberoflanguages,withoutrequiringarewriteoftheapplicationcodeforeachlanguagetranslation.
Theapplicationisdevelopedonce,thetranslationmethodologyisappliedonce,andthentheapplicationcanbetranslatedasoftenandtoasmanylanguagesasisnecessary,withouthavingtorewriteanyoftheoriginalapplicationcode.
ChristopherA.
RoperisaSeniorSystemsConsultantwithQualexConsultingServices,Inc.
HisareasofexpertiseincludeBaseSAS,SAS/AF,SAS/FSP,Macros,Frame,andSCL,hasbeendevelopingSASapplicationsforovertenyears.
ChriswonBestContributedPaperinApplicationsDevelopmentatlastyear'sWUSSconference,andisanfrequentpresenteratSASusergroupsacrosstheUnitedStatesandEurope.
ChrishasaBSinBusinessAdministrationwithaConcentrationinEconomicsfromChristopherNewportUniversity.
GinaThomasisaSoftwareApplicationsDeveloperwithQualexConsultingServices,Inc-basedoutofCleveland,Ohio.
ShehasbeenworkingwithSASforabout3yearsandhasworkedinavarietyofareassuchasBASE,AF,SCL,EIS,andMACRO'swiththeSASsystem.
ShehasaMasterofSciencefromOhioUniversityinIndustrialandSystemsEngineeringandhasaspecializationinGeneticAlgorithms,NeuralNetworks,andArtificialIntelligence.
MichaelGilmanhasworkedwiththeSASsystemforalmost20years.
Hisexpertiseencompassesabroadrangeofindustriesincludingautomotive,educational,financial,government,health,andindustrial.
NowasSeniorApplicationsConsultantwithQualexConsultingServices,Inc.
,MichaelcontinuestodevelophighqualitySASsoftwaresolutionsusingBaseSAS,SAS/FSP,Frame,SCL,andSAS/GRAPH.
MichaelhasaM.
Sc.
(ComputerScience)andB.
Sc.
(Major:Psychology;Minor:ComputerScience)fromMcGillUniversityinMontreal,PQ.
DataValidationUsingaSASFormat20CNaokoStearns;ResearchTriangleInstitute;RTP,NCJohnR.
Gerlach;MaximGroup;PlymouthMeeting,PAProperdataanalysisrequireswell-defineddatathathavebeenvalidated.
Typically,thetransitionfromrawdatatoaviableSASdatasetrequiresmoreeffortthanjustwritinganINPUTstatement.
Infact,thequestforvalidateddataoftenbecomesaprojectinitselfconsumingtremendousresources.
ConsideringthatmanyvalidationcheckscanbewrittenasBooleanexpressions,it'spossiblethatthecheckscanbestoredinauser-definedformat.
TheSASsolutiondescribedhereinvolvesamacroandauser-definedformatthatperformsvalidationchecksonadataset,thenproducesareport.
Consequently,thevalidationchecksaremaintainedbysimplymodifyingtheformatandthevalidationprocessisperformed,asneeded,byinvokingthemacro.
Thispaperexplainsaneasyandself-documentingapproachtothisvalidationprocess.
NaokoStearnsisaresearchprogrammer/analystatResearchTriangleInstitute,RTP,NC.
NaokohasbeenusingSASfor10years.
Herrecentworkfocusesonimplementingdatadictionaries,codegenerators,andcodebooks.
JohnGerlachhasbeenusingtheSASSystemforover10years,specializingintheMacroLanguageandrelationaldatabases,wherehehasworkedmostlyinthehealthindustry,specificallyepidemiology,clinicaltrials,andlongitudinalpatientdataanalysis.
JohnhaswrittenandtaughtSASseminars;and,recently,hehasworkedonafinancialdatamartprojectinvolvingperformancemeasuresofcreditcardcustomers.
Also,JohnholdsaBAdegreeinItalianLiterature.
AutomaticReferencingSASMacroVariablesUsingArrayProcessing,CALLSYMPUTRoutine,andDOLoops20CPei-ChunT.
Wan;TRW,Inc.
;Atlanta,GAThispaperillustrateshowonecanusethecombinationofarrayprocessing,SASmacrofacility,CALLSYMPUTroutine,anditerativeDOloopstoautomaticallyassigntitlesandlabelstoaddresscorrespondingvariablesinthefrequencytables.
IntheAdult/AdolescentSpectrumofDisease(ASD)projectoftheCentersforDiseaseControlandPrevention(CDC),thereisaneedtoproducefrequencytablesforeachofthe231987-definitionAIDSOpportunisticIllnesses(OI).
Byusingthetechniquesdescribedherein,onecansetupanarraywithall23AIDSOInames,useSASmacrotosetupmacrovariableforfuturereference,useCALLSYMPUTroutinetoassignvaluetomacrovariablewhichcanbeusedlaterinthetitlestatementandlabelstatementforeachAIDSOInameinthefrequencytable,anduseDOLoopstoperformthistaskrepetitivelyforeachofthe23AIDSOInames.
Thistechniquecanbeappliedwidelytoanyprogramwhichrequiresuserstoreferencemultiplevariablesrepetitivelyinthetitleandlabelstatementofthefrequencyprocedureortabulateprocedure.
Pei-ChunWanhasaMaster'sdegreeinInformationandComputerSciencefromGeorgiaInstituteofTechnologyandhasbeenworkingwithSASforthelastfiveyears.
SheisthenationaldatamanagerfortheAdult/AdolescentSpectrumofDiseases(ASD)projectatCentersforDiseaseControlandPrevention(CDC).
Shehasco-authoredmanyarticlesandabstractsinmedicaljournalsandatnationalandinternationalconferences,andshehasalsopresentedthispaperatSUGI23.
BeginningTutorialsSectionChairs:IanWhitlockWestat,Inc.
Rockville,MDDavidMaddoxBellSouthBirmingham,ALSAS/ASSISTEasyAccesstotheSASSystem50IArturoBarriosandSallyMuller;UniversityofNorthCarolina;ChapelHill,NCSAS/ASSISTprovidesasimpleandnon-threatening,yetverycapable,toolforusingSASandlearningtheSASlanguage.
A"point-and-click"interfaceASSISThastwodistinctadvantagesoverconventionalmethodsofusingtheSASSystem.
First,althoughASSISTdoesn'trequirethatyouwriteasinglelineofSAScode,itisaveryeffectivewayoflearninghowtowriteSAScode.
EachtaskthatyouaccomplishgeneratesafullydocumentedSASprogram.
Thestepsyoutaketothensavetheprogramarequitesimpleandyoucanthenstudyand/orreruntheprogramanytime.
Second,thelearningcurvewithASSISTissignificantlyshorterthanthelearningcurvetousetheSASSystemwithanyothermethod--yougostraighttotheworkathandandgetyourresultsimmediately.
BesidesshowingyoucommontasksthatcanbeaccomplishedwithASSIST,thistutorialwillshowyouhowSAS/ASSISTdiffersfromother"point-and-click"interfaces,suchasDESKTOP,andwhenyouwouldwanttochooseoneoftheseproductsovertheother.
ArturoBarriosisaComputerConsultantfortheCustomerServicesDivisionofAcademicTechnologyandNetworks(ATN)attheUniversityofNorthCarolina.
ArturobeganusingSASasagraduatestudentintheDept.
ofCityandRegionalPlanning,in1991.
HeprogressedtosupportingSASasaComputerConsultantandteachingSASShortCourses,includingSAS/ASSIST,SAS/CONNECT,and"PuttingYourSASApplicationsontheWeb".
ArturohaspresentedpapersatthelastfourSESUGsandmostenjoysthe"BeginningTutorials"section.
SallyMulleristheManageroftheStatisticalSupportgroup,adivisionofAcademicTechnologyandNetworks(ATN),attheUniversityofNorthCarolina.
SallybeganusingSASsoftwarein1978andin1987becameasiterepresentative.
Sincethenshehasansweredover20millionSASuserquestionsandtaughtseveralthousandSAS/ASSISTclasses.
SallyfindsthatSASnovicesandevenpeoplewithlimitedcomputingknowledgeofanykindcanlearntouse(andlove)SAS/ASSIST.
AdesiretoshowtheadvantagesofASSISToverotherSASinterfacesandconventionalmethodsoflearningtousetheSASSystemisthemotivationofthispaper.
TheBuildingBlocksofPROCTABULATE50IRonColeman;LinksAnalytical,Inc.
;JacksonvilleFLThereare6waystodoanythinginSAS!
Especiallyreporting.
WhichtoolshouldyouusePROCTABULATEistheworkhorseofreportinginSASbutisoftencomplicatedtouse.
TheBuildingBlockapproachbreaksdownthecomplexityofTABULATEandshowsyouhowtobuildpowerfulreportsoneblockatatime!
RonColemanhas14yearsexperienceusingSASonmainframes,UNIXsystems,andWindows.
HeisanindependentconsultantspecializinginSAStraining,productivityenhancement,anddatawarehousing/datamining.
RonfoundedLinksAnalytical,Inc.
in1996andhasworkedforautomobile,banking,credit,energy,andinsuranceindustries.
RonhaspresentedpapersatSUGI,theWisconsin/IllinoisSASUsersGroup,andtheSouthCarolinaSASUsersGroup.
HehasalsofoundedseveralcompanyinternalgroupsandispresentlythePresidentoftheNorthFloridaUsersoftheSASSystem.
TheSASDebuggingPrimer50IFrankDiIorio;AdvancedIntegratedManufacturingSolutionsCorp.
;ChapelHill,NCMeetanaccomplishedSASprogrammerandyoumeetsomeonewhosprobablylearnedbymaking(andfixing)lotsofmistakesalongtheway.
ThebreadthoftheSASSystemstargetapplications,thevarietyofits"dialects"(BaseSAS,macro,SCL,IML,SQL),andthequirkyprocedural/non-proceduralenvironmentalmixconspiretomaketheSASSystemaslipperyslopetoascend.
Debuggingistheartofgracefullyrecoveringandlearningfromfallsduringtheascent.
ThispaperdiscussestechniquesfordebuggingSASprograms.
Itspurposeistwo-fold.
First,itprovidesbehavioralandtechnicaltipsforfixingcode(howtoreaderrormessagesintheSASLog,knowingwhenthereisaproblemwiththeprogramevenifSASsaysthereisn't,usingtheDATAstepdebugger,identifyingsystemoptions,usingPROCsfordatavalidation,usingmacrovariablestocontroldebuggingoutput,etc.
)Thesecondfocusofthepaperisitspresentationofdesignandcodingmethodsthatmaketheprogrammingprocessmorereliable,thusreducingtheneedfordebugginginthefirstplace.
Thepaper'stargetaudienceisrelativenewcomerstotheSASSystem.
Moreseasonedusersmayfindorrediscoversomeofthetechniquesandfeaturesbeingdiscussed.
EmphasisisplacedonBaseSASandthemacrolanguage,althoughthetechniquesthemselvesareapplicabletoSCLandotherproducts.
FrankDiIorioisDirector,SASSystemDevelopmentatAIMSCo(AdvancedIntegratedManufacturingSolutionsCorporation),amanufacturingsystemsintegrator.
Hehasover22years'experiencewithBaseSASandproductssuchasSAS/GRAPH,SAS/AF,SAS/GRAPH,SAS/QC,andSAS/FSP.
Hehasworkedineducational,financial,pharmaceutical,andmanufacturingenvironments,focusingonprogramefficiency,report-writing,themacrolanguage,anduserinterfacedesignissues.
Muchoftheknowledgegainedfromthesevariedworkenvironmentshasbeencommittedtopaper—hehaswrittenmanypaperspresentedatlocal,regional,andinternationalSASusergroups.
FrankisalsotheauthoroftwopopularSASprogrammingtexts,"SASApplicationsProgramming:AGentleIntroduction"and(co-authoredwithKennethHardy)"QuickStarttoDataAnalysiswithSAS.
"Athirdbook,"TheElementsofSASProgrammingStyle,"isbeingdeveloped.
FrankisactiveintheSouthEastSASUsersGroup(SESUG).
Hewasconferenceco-chairin1994and1996,andiscurrentlyservingasPresidentofthegroup.
FormatsasaProgrammingTool50IJohnR.
Gerlach;MaximGroup;PlymouthMeeting,PAAlanRinkus;FleetFinancialGroup;Horsham,PATheFormatProcedureinSASprovidesthemeanstocreateuser-definedinformatsandformatsforcharacterandnumericdata.
Besidesitstypicaluse,however,thisprocedureoffersmuchmoreasaprogrammingtool.
Forexample,theFormatprocedurecanbeusedforfacilitatingtablelook-ups,datavalidation,andsubsetting.
Also,theFormatprocedurehasthecapabilityofcreatingformats,evendynamicformats,directlyfromSASdatasets.
Thispaperoffersabriefoverviewanddiscussesprogrammingaspectsofthispowerful,under-utilizedprocedure.
JohnGerlachhasbeenusingtheSASSystemforover10years,specializingintheMacroLanguageandrelationaldatabases,wherehehasworkedmostlyinthehealthindustry,specificallyepidemiology,clinicaltrials,andlongitudinalpatientdataanalysis.
JohnhaswrittenandtaughtSASseminars;and,recently,hehasworkedonafinancialdatamartprojectinvolvingperformancemeasuresofcreditcardcustomers.
Also,JohnholdsaBAdegreeinItalianLiterature.
AlanRinkusiscurrentlyDirectorofInformationManagement,DecisionSystems,inFleetCreditCard'sDecisionSupportGroup.
Alan'sexperienceincludesprospecttargetingandsegmentation,andpredictivemodeldevelopmentrelatedtocreditcardacquisitioncampaignswhileworkingatAdvantaCorportationand,previously,atMBNAAmerica.
AlanearnedaBAdegreeinPsychologyandanMAdegreeinSociology;and,hehasheldseveraladjunctfacultypositionsteachingstatistics.
AlanhasbeenusingSASforfiveyears.
AStatisticalRoadmapfortheSASSystemforBeginners50IKennethHardy;UniversityofNorthCarolina;ChapelHill,NCItdoesn'ttakeatrainedstatisticiantofigureoutthatPROCMEANSproducesmeansandPROCREGisprobablyusefulforregressionanalysis.
ButwhatPROCdoyouusetoproduceaboxplotoraTobitregressionorCronbach'sAlphaorBhapkar'stestofmarginalhomogeneityFindingoutwhichPROCtousetocreatethatstatisticalanalysisyourbosswantsby4:00P.
M.
todaycanoftenbeadauntingtaskevenforatrainedstatisticianjuststartingoutwithSAS.
ThisbeginningtutorialwillhelpyououtbygivinganoverviewofmanycommonandesotericstatisticsproducedbytheSASsystemandthedocumentationyouneedtoreadtoprogramSAStoobtainthem.
ItwillalsointroduceyoutoaveryusefulSASTechnicalSupportWebpagethatcanhelpyoufindouthowtoperformBhapkar'stestandmanyotheradvancedstatisticalanalyseswithSAS.
KennethHardyisAssociateDirectorforInformationSystemsattheInstituteforResearchinSocialScienceoftheUniversityofNorthCarolinaatChapelHill.
HehasbeenusingandconsultingonSASforstatisticalanalysesforovertwenty-fiveyears.
Inadditiontoacademicresearchpublications,hehaspresentedmanypapersatSUGIandSESUGmeetings.
Hehasalsoco-authoredbooksontopicsrangingfromtheinequityofthedeathpenaltytoquantitativeresearchmethodsforhistorians.
Hismostrecentbook,writtenwithFrankC.
DiIorio,is"QuickStarttoDataAnalysiswithSAS".
FundamentalsofFRAME:ATutorialforBuildingApplications50IGregoryBarnesNelson;ASG,Inc.
;Cary,NCSAS/AFFRAMEtechnologyallowsustodevelopuserinterfacesthatarefriendlytouse.
TheyarethebasisformanySASapplicationsinwhichend-usersdeterminewhathappenswiththeclick-of-a-button.
Thispaperpresentsaframeworkforbuildingintuitiveuser-basedapplications.
Herewewilldevelopasimpleapplication,whichbuildsonitselfiteratively.
ByexploringsomeofthemostcommonFRAMEobjectsandunderstandinghoweventsarehandledinAF,wewillbuildasimpleinterfaceforsomecommonapplications.
Throughthisstep-by-stepprocess,wewillshowyouhowtobuildaninterfacethatcollectsuserinput,whichcanbeusedtofront-endtraditionalSASMacros.
Despiteitssimplicity,thispapershouldgivethereaderamethodologyfordevelopinguser-basedapplicationsthatcanservetofront-endmostrun-time,interactivemacros.
ThispaperisintendedforbothnewusersofSASSoftwareaswellasexperiencedSASprogrammerswithlittleornoexperienceinSAS/AF.
ExamplesinthispaperwillincludebothVersion6.
12andVersion7oftheSASSystem.
GregBarnesNelsoniscurrentlytheDirectorofTechnologySolutionsatASG,Inc.
,aSASInstituteBusinessPartner.
Apsychologistbytraining,Gregisatechnologistatheart.
Hiscurrentareaofexpertiseincludedesigningcomplexdatamanagementsystems,userinterfacemodules,anddatawarehousingdesign(bothbusinessprocessanddatamodeling)andimplementation(e.
g.
,distributedarchitectureandfront-enddevelopment).
PriortojoiningASG,GregwastheDirectorofSASEducationandDevelopmentatTheGallupOrganizationandManagerofClientSupportattheUniversityofGeorgia.
Hehasover13yearsofexperienceusingtheSASSysteminawidevarietyofapplicationsandplatforms.
PROCUPLOADandDOWNLOAD:AnEasyWaytoExportSAS50IMartinJ.
O'ConnellFiletransferusingPROCUPLOADandDOWNLOAD(availablethroughtheuseofSAS/CONNECT)representsaconvenientwayoftransferringSASdataandprogramlibrariesfromplatformtoplatform.
Bydoingthis,subsequentdevelopmentcanbetransferredfromarestrictiveenvironmenttoamoreuser-friendlyone,suchasaWindowsPC.
Inaddition,jobprocessingcanbeperformedfromaremoteSASsessionusingCONNECT.
TheuseofSAS/AFtoautomatetheseprocessescanprovideanalmosttransparentwayofdevelopingonaclientPC,whileprocessingonamorepowerfulremoteserver.
Thispapershouldbeparticularlyusefultothoseusingahigh-endPCasaterminalformainframeSASprogramdevelopment.
Itdiscusses:OverviewofSAS/CONNECTIssuestoconsiderbeforeexportingdevelopmentFiletransferdetailsJobcontrolfromthePCusingSAS/CONNECTDevelopmentofaGUIinterfaceusingSAS/AFMartinJ.
O'ConnellearnedanMSinMathematicsfromNorthCarolinaStateUniversityin1991.
HisareaofstudywasNumericalAnalysisandOptimization.
Hehas7YearsofSASexperience;5yearsonmainframes,2yearswithclientserver.
HeiscurrentlyworkingwithSASdevelopmentontheGEICOActuarialDataWarehouse.
HisareasofexpertiseincludeBaseSASandclientservercomputingwiththeSASsystem.
TheDATAStatement:EfficiencyTechniques50IS.
DavidRiba;JADETech,Inc.
;Clearwater,FLOneofthoseSASstatementsthateveryonelearnsinthefirstdayofclass,theDATAstatementrarelygetsasecondlook.
However,thisBaseSASstatementhasevolvedinrecentreleasesoftheSASSystem.
IfyouhavenotlookedattheoptionsontheDATAstatementrecently,youwillprobablybesurprised.
ThisbeginningtutorialexaminesthesyntaxoftheDATAstatementandthedifferentoptionsthatarevalidforusewithit.
Eachoptionwillbediscussedandillustratedwithexamplesofhow(andwhen)tousethem.
Amongthetopicsthatwillbediscussedaredatasetindexing,compression,andviews.
S.
DavidRibaisCEOofJADETech,Inc.
,aSASInstituteQualityPartnerwhospecializesentirelyinapplicationsdevelopment,consultingandtrainingintheSASSystem.
DaveisthefounderandPresidentoftheFloridaGulfCoastSASUsersGroup.
HecharteredandservedasCo-ChairofthefirstSouthEastSASUsersGroupconference,SESUG'93,andservesontheExecutiveCouncilsoftheSouthEastSASUsersGroupandCONSUG,theConsultant'sSASUsersGroup.
HisfirstSUGIwasin1983,andhehasbeenactivelyinvolvedinbothSUGIandtheRegionalSASUserGroupcommunitysincethen.
HehaspresentedpapersandassistedinvariouscapacitiesatSUGI,SESUG,NESUG,MWSUG,SCSUG,andPharmaSUG.
DaveisanunrepentantSASbigot.
HismajorareasofinterestareefficientprogrammingtechniquesandapplicationsdevelopmentusingtheSASSystem.
HisSASsoftwareproductspecialtiesareSAS/AFandFRAMEtechnology,SAS/EIS,SAS/IntrNet,andCFO/Vision.
DataMining:AnOverviewofMethodsandTechniquesforIncreasingProfitsinDirectMarketing50IC.
OliviaRud;Fleet;Wilmington,DEDataMiningisanewtermforthecommonpracticeofsearchingthroughdataforpatternswhichwillpredictfutureoutcomesordefinemeasurablerelationships.
Statisticalandmachine-learningmethodsarethefavoredtoolsofmanybusinesseswhoutilizedirectmarketing.
ThispaperwillexploresomeofthetypicalusesofDataMininginbusinesswithdiscussionsandexamplesofmeasuringresponse,riskandlifetimecustomervalue.
ThepaperwillconcludewithhighlightsoftheSASEnterpriseMinoranditsabilitytotransformtheDataMiningprocess.
C.
OliviaRud,VPisaleadanalyticconsultantforFleetCreditCardBank.
Herprimaryresponsibilitiesincludedatamining,modeling,andsegmentationforacquisition,retention,risk,andportfoliomanagement.
Shehasworkedinthefinancialservicesindustryfor7years.
OliviahasaBAinMathematicsfromGettysburgCollegeandanMSinDecisionandInformationSystemswithanemphasisinStatisticsfromArizonaStateUniversity.
ShehasbeenaSASuserfor9years.
GettingStartedwithDynamicDataExchange50IHowardSchreier;U.
S.
Dept.
ofCommerce;Washington,DCTherearenumerouswaystomoveinformationbetweenSASandthird-partyapplications,suchasspreadsheetsanddatabasepackages,especiallyintheMicrosoftWindowsenvironment.
DynamicDataExchange(DDE)isaversatileapproach,becauseitprovidesaDATAstepinterfaceratherthandatasetconversion.
ThispresentationwillexplainthebasictechniquesofusingDDEtomovedatatoandfromSAS.
HowardSchreierisaneconomistbytraining.
HeservestheU.
S.
DepartmentofCommerceinaninformationmanagementrole.
HehasusedSASsince1981andhasbeenafrequentSAS-Lcontributor.
ChangingtheShapeofYourData:PROCTRANSPOSEvs.
Arrays50IBobVirgileTotransposeyourdata(turningvariablesintoobservationsorturningobservationsintovariables),youcanuseeitherPROCTRANSPOSEorarrayprocessingwithinaDATAstep.
Thistutorialcomparesvariationsonbothmethods,findingtheadvantagesofeach.
BobVirgileisaSASveteran,havingparticipatedineveryNESUGandmanySUGI,MWSUG,PharmaSUG,andSESUGconferences.
Besidespresentingpapers,Bobcreatestheproblem-solvingcontestsforSUGIandNESUG,andhaspublishedtwobooksthroughSASInstitute.
BobalsodevelopsandteachesanoutstandingseriesofcustomizedSASclasses.
ASASProgrammer'sViewofSQL50IIanWhitlock;WESTAT,Inc.
;Rockville,MDThistutorialintroducesthetraditionalSASprogrammertoPROCSQL.
FirstsomehistoricalperspectiveisgiventoshowthecontextinwhichSQLwasdeveloped.
ThenasetofexamplesisgivenshowingareaswhereSQLisliabletobebetter(easiertocodeand/ormorecomputerefficient).
IntheendtheyoushouldhaveabetterunderstandingabouthowtouseSQLandwhyyoushouldwantto.
SomeofthelaterexamplesdoinvolvetheinteractionofPROCSQLwiththemacrofacility.
Buteventheseexamplesshouldbecleartothemacronaive.
IanWhitlockisaseniorsystemsanalystatWestat,workingonsurveyresearchproblems.
HehasbeenprogramminglargelyinSASsince1981usinganinteractiveenvironmenttodevelopprogramsforexecutioninabatchenvironment.
HeisskilledinproblemsolvinginvolvingSASmacro,PROCSQL,reportingproceduresandtheDATAstep.
Inadditiontoprogramming,heteachesSAScoursestoWestatemployees.
HeisactiveonSAS-L,andhaspresentedmanydifferentpapersatnational,regional,andlocalSASUserGroupmeetings.
TheProgramDataVectorasanAidtoDATAStepReasoning50IMarianneWhitlock;WESTAT,Inc.
;Rockville,MDTheSASDATAstepiseasyenoughforbeginnerstoproduceresultsquickly.
Theycanuseamodelfromamanualoracolleague'sprogram,andadaptittotheirproblems.
Typically,theycodea"SET"or"INPUT"statementandproceedwithassignmentstatements,etc.
,toproduceanewfilefromapreviousone.
Theycaneasilyprinttheirresults,orputthedataintoastatisticalprocedure,withoutevertroublingthemselveswiththeprogramdatavector(PDV).
Whentheywanttoaccomplishsomethingmorecomplex,theyfindthatfamiliaritywiththetypicalDATAsteppatternisnotenough,andbecausetheyhavenotinternalizedtheconceptofthePDV,theyarenotwellequippedtotellSASwhattheywant.
Usingincreasinglycomplexproblems,thistalkwillstepthroughcodefromthePDVpointofview.
Thegoalwillbetogivepeopleconfidencetotrymoremanipulativeprogramming.
AsetofrulesgovernsthePDV,andateachpointinthecompilingandexecutionoftheDATAstep,itispossibletoknowexactlywhatinformationthePDVholdsandwhatitwilldowiththatinformation.
Understandingthisenablestheprogrammertotakecontrol,andtellSASpreciselywhathewants.
MarianneWhitlockisasystemsanalystandhasbeenaSASuserfor16years,thelast12atWestatinRockville,MD.
Sheisexperiencedinstatisticalprogrammingincludingsampling,surveyresearch,healthstudies,datamanagement,andreportwriting.
ShehaspresentedpapersatseveralSUGI's.
CodersCornerSectionChairs:MaribethJohnsonMedicalCollegeofGeorgiaAugusta,GAAndrewT.
KuligowskiNielsenMediaResearchDunedin,FLPROCDATACHKRevisited:TheDATACHKMacro10CJeffreyM.
AbolafiaandCarryW.
Croghan;UniversityofNorthCarolina;ChapelHill,NCPROCDATACHK,aSUGISupplementalLibraryprocedureinVersion5oftheSASSystem,providedausefulmethodforquicklycheckingnumericdatainaselectedSASdataset.
TheoriginalDATACHKmacro,presentedatSUGI22,attemptedtosimulatePROCDATACHK.
Foreachnumericvariable,theDATACHKmacroliststhenumberofnonmissingobservations,thenumberofmissingobservations,thefivelowestvalues,andthefivehighestvalues.
TheDATACHKmacrohasbeenupdatedincorporating:1)newSASfeaturestoincreaseefficiency,2)bygroupprocessing,and3)additionalformattingoptions.
JeffAbolafiaisamemberofthefacultyintheDepartmentofBiostatisticsattheUniversityofNorthCarolinaatChapelHillaswellastheDirectoroftheStatisticalComputingDivisionattheCollaborativeStudiesCoordinatingCenter.
JeffhasusedSASforoverfifteenyearsandistheauthorofseveralSUGI/SESUGpapers.
Hisareasofinterestincludeclinicaltrials,statisticalcomputing,andresearchdatamanagement.
CarryCroghanhasbeenworkingattheUniversityofNorthCarolina-ChapelHill,DepartmentofBiostatisticsattheCollaborativeStudiesCoordinatingCenterforsixyearsasanapplicationsprogrammer.
Shehasworkedonseveraldifferentstudiesduringthattime.
Priortothat,sheworkedwiththeEPAasaresearchassistantandprogrammer.
ShehasbeenusingSASfortenyears.
NewDataStepFunctionsinSAS6.
12-DataSetandVariableFunctions10CCarolineBahler;ASG,Inc.
;Cary,NCTheDataStepinSAS6.
12istherecipientof50+newfunctions.
Thesenewfunctionsarebrokenintothefollowinggroupings:datasetfunctions,externalfilefunctions,libraryandcatalogfunctions,specialfunctions,variablefunctions,andstatisticalfunctions.
Theobjectiveofthispaperistodiscussthedatasetandtheirfunctionsandtoillustratepotentialusesofthedatasetfunctions.
CarolineBahleriscurrentlyaseniortechnicalconsultantintheAdvancedSolutionsGroupatASG,Inc.
,SASInstituteBusinessPartner.
HerSASbackgroundstretchesbackover18yearsandmanyversionsofSAS,includingusingSASoverawidevarietyofplatforms.
AMacro-DrivenSQLCodeGenerator10CJohnE.
Bentley;FirstUnionNationalBank;Charlotte,NCSAS'sSQLPass-ThroughFacilityisanefficientwayforSAStoaccessdatainaRDBMSdatabase.
It'sapowerfultoolformergingandsubsettingdatabecauseittakesadvantageoftheinherentpoweroftheRDBMSandminimizesI/Obyreturningonlythedatathat'sneeded.
BecauseofthesyntaxandstyledifferencesbetweenSASandSQL,formostSASusersit'salmostpainfultolearn.
ForusersofourInformixdatawarehouse,we'vebuiltaSASFRAMEapplicationthatusestheSASMacrolanguagetogenerateSQLcodebasedonuserinput.
Thispresentationwillbeaquickoverviewofthatcode.
SomefamiliaritywithSASMacrowouldbeuseful.
JohnE.
BentleyisconsideredbysometobeaSASgurubyvirtueof12yearsexperiencewithSAS.
Thiscanbeinterpretedassayingthathe'sproventhevalidityofmostofMurphy'sLawsofTechnology.
He'sworkedasahealthcaredataanalyst,managedateamwritingcleaningandtransformationroutinesforpensiondatapriortoloadingitintoaSybasedatabase,andrecentlycompletedmanagingdevelopmentandimplementationofaSASFRAMEapplicationtoaccessfinancialdatainanInformixdatawarehouse.
Rightnowhe'sworkingtoportthatapplicationtoanOracledatamart,developinganotherSASapplicationfordecisionsupport,andprovingmoreofMurphy'sLaws.
AutomatingDatesinSASCodeforBatchProcessing10CRonColeman;LinksAnalytical,Inc.
;Jacksonville,FLYouneedareportruneverymonthtoincludeallofthedaysfromthepreviousmonth.
HowdoyoudoitIncountlessshopsaroundtheworldsomeonegoesintosomepieceofcodetofillindaterangesfortheprogramtouse.
WhyHereisaquickmacrotechniquetoautomatestandarddaterangeswhileallowingforoverrides.
RonColemanhas14yearsexperienceusingSASonmainframes,UNIXsystems,andWindows.
HeisanindependentconsultantspecializinginSAStraining,productivityenhancement,anddatawarehousing/datamining.
RonfoundedLinksAnalytical,Inc.
in1996andhasworkedforautomobile,banking,credit,energy,andinsuranceindustries.
RonhaspresentedpapersatSUGI,theWisconsin/IllinoisSASUsersGroup,andtheSouthCarolinaSASUsersGroup.
HehasalsofoundedseveralcompanyinternalgroupsandispresentlythePresidentoftheNorthFloridaUsersoftheSASSystem.
DevelopinganHourlyProfilefromaMonthlyForecast10CThomasA.
Fuchs;LouisvilleGasandElectricCompany;Louisville,KYTheLG&EForecastingandLoadResearchDepartmentdevelopsamonthlyforecastofsalesvolumesandrevenues.
Aftertheseforecastsaredeveloped,theSASprogram,LOADSHAPES.
SAS,isruntocreateanhourlyprofilefromtheforecastinformationandhistorichourlyprofiles.
Theresultingforecastprofilesareusedforoperationsplanning.
Theprogramperformsdatacollectionandcreatesaverageperunitdurationcurvesforeachmonthbyaveragingovertheyearsinthehistory.
Next,sincesaleshaveaweeklypattern,anaverageofconsecutive52-weekperiodsinthehistoryiscreated.
Thisaverageprofileisusedtocreatethetemplatefortheforecastperiod.
Themonthlyperunitdurationprofilesaremanipulatedaccordingtotheforecastandmergedwiththetemplatetoproducetheforecastprofile.
Thismethodologyisfairlysimple,buttheresultingprofilesarereasonableforuseinplanning.
TomFuchsisaSeniorAnalystintheForecastingandLoadResearchDepartmentoftheLouisvilleGasandElectricCompany(LG&E).
Inthe14yearsTomhasbeenwithLG&EhehasworkedinEngineering,ProductionPlanningandLoadResearch.
TomreceivedaBachelorsofScienceinElectricalEngineeringandaMastersofBusinessAdministrationfromtheUniversityofLouisville.
WhenTomisnotcreatingormodifyingSAScodeyoucanfindhimandhiswifecheeringforhisthreechildrenataSwimMeetorT-ballgame.
ThisisTom'sthirdSESUG.
ArraysandScoringTestsInvolvingMultidimensionalCriteria10CImeldaC.
Go,Ph.
D.
;RichlandCountySchoolDistrictOne;Columbia,SCIneducationalapplications,astepthatissometimesrequiredafterscoringresponsestoatestislookingupvaluesofothermeasuresthatcorrespondtoatestscore.
Forexample,scalescorescancorrespondtorawtestscores.
Scalescorescanalsodependonthetestformthatwasused.
Theremightevenbetheneedtoobtainseveraltypesofscalescoresbasedontestsections.
Unlessyouknowhowthesescalescoresareobtainedcomputationally,thesesituationsconjureimagesofmultidimensionallookuptables.
Ineitherone-dimensionalormultidimensionalsettings,temporarySASarraysprovideanelegantlysimpleandefficientmeansforstoringtestanswerkeysandlargelookuptablesrequiredforsuchscoringprocesses.
UsingSASarrayshavedefiniteadvantagesoverusingotherSASstatements(e.
g.
,SET,RETAIN,IF-THEN/ELSE,SELECT,etc.
)toaccomplishthesametask.
ImeldaC.
Go,Ph.
D.
,hasworkedwithSASprogramssince1989.
Workingindifferentcomputingenvironmentsthatwerenotalwaysequalintermsofcomputingpowerandresourcesledtoaninterestinefficiency.
SheresidesinColumbia,SC,andworksforalargeschooldistrictasaresearcherandSASprogrammer.
SYMPUTRoutine:PainlesslyPuttingPartsandPiecesTogether10CImeldaC.
Go,Ph.
D.
;RichlandCountySchoolDistrictOne;Columbia,SCThemacroSYMPUTroutinewasusefulinconsolidatingthesametypeofinformationfromdifferentsources.
ThisparticularuseoftheSYMPUTroutineevolvedfromtheneedtocombinethedata(intheformof50differentfiles)from50differentschoolsinalargeschooldistrict.
Eachschoolhasarecordinanexternaltextfilethatcontainsasfieldsallvaluesofparametersthatarepredictablyneededforprocessingthedatafilefromeachschool.
TheSYMPUTroutinewasusedtoaccessspecificmacroparametervalues(fromtheexternaltextfile)foreachschool,whicheliminatedtheneedtoexplicitlytype/retypethesespecificvaluesinSASprogramcodeforeachsetoffilesthatneededtobeconsolidated.
Other"freebies"resultedfromusingthissystem.
ImeldaC.
Go,Ph.
D.
,hasworkedwithSASprogramssince1989.
Workingindifferentcomputingenvironmentsthatwerenotalwaysequalintermsofcomputingpowerandresourcesledtoaninterestinefficiency.
SheresidesinColumbia,SC,andworksforalargeschooldistrictasaresearcherandSASprogrammer.
TheSubtleTyrannyofFloatingPointNumbers:WhenChastheValueX,ButXNEC10CF.
JosephKelley;UniversityofGeorgia;Athens,GAMostprogrammersaretaughtnevertotestforequalitybetweenafloating-point(Real)numberandaconstant(orinteger).
Theusualadviceistotestfor"greater-than-or-equal-to"(or"less-than.
.
.
").
Overtime,thiswarningisoftenforgottenoravoidedinonewayoranother.
ManypersonswhowriteSASprogramshavelittleornobackgroundincompilerlanguages(wherethisistaught),andSASitself,withonlytwo"datatypes"("numeric"andcharacter)doesnotmaketheproblemanyclearer.
Buttheproblemdidnotgoaway;itcanstrikeandhavethemostunexpectedresults.
Thispaperwillexaminetheproblem,compareresultsonseveralplatforms,offersomedebuggingtechniquesandpossiblesolutions.
FrancisJ.
KelleyisaseniorconsultantintheHostSystemsandStatisticalSoftwareSupportgroupatUniversityComputing,TheUniversityofGeorgia.
HeprovidesassistancefortheIBMandCDCmainframesatUGA(operatingsystems,compilers,editorsandsoftwarepackages)andprovidesSASsoftwaresupportforallthesystemsitisavailableonattheUniversity:MVS/TSO,VM/CMS,UNIX,OS/2,Windows,Macintosh,andDOS.
HehasusedSASextensivelyforabout15years,andhasbothmadepresentationsandchairedsectionsatpreviousSESUGs.
HeisSESUG'98ConferenceCo-chair.
AutomaticallyCreatingSASMacroVariablestoManageUnknownValuesinYear/MonthVariablesforYear2000Issues10CJianminLi,ShelleyRen,andPei-ChunT.
Wan;TRWInc.
ThispaperillustrateshowonecanusePUTstatements,IF-THENstatements,andaCALLSYMPUTroutinetoautomaticallycreateSASMacrovariablesandMacrostatements.
AndonecanuseARRAYprocessingandDOloopstosummarizeandconvertunknownvaluesinyear/monthvariablestoprepareforYear2000issues.
IntheNationalHIV/AIDSSurveillancedatabaseatCentersforDiseaseControlandPrevention(CDC),"99"isusedtocodeunknownvaluesforyear/monthvariables.
Toprepareforyear1999,character"99"forunknownyearsneedstobeconvertedtocharacter".
.
".
Byusingthistechnique,onecanusetheCONTENTSproceduretooutputmonth/yearvariablenamestoaSASdataset,usePUTstatementstoautomaticallycreatemacrovariables,anduseFILEand%INCLUDEstatementstoplaceandlocatefileswithalistofmacrovariablesandmacrostatements.
Inaddition,aCALLSYMPUTroutineisusedtocountthenumberofyear/monthvariablestoautomaticallydefineARRAYdimensions,andsummarizeandconverttheunknownvaluesinyear/monthvariablesusingDOLoops.
Thistechniquecanbeappliedtoprogramswhichrequiretheusertoselectasubsetofvariableswithsimilarelementsintheirnames,andmanagethevariableswithSASMacros,Arrays,andDoloops.
JianminLihasaMaster'sdegreeinEducationalResearchMethods/AppliedStatistics/Measurement/EvaluationandaDoctoralDegreeinMovementScience.
ShelleyRenhasaMaster'sdegreeinComputerScience.
Pei-ChunT.
WanhasaMaster'sdegreeinInformationandComputerScience.
AllthreeauthorshavebeencomputerprogrammersforNationalHIV/AIDSSurveillanceatCentersforDiseasesControlandPrevention(CDC)forthelast5years.
BothJianminandPei-Chunhaveeachcoauthoredanumberofarticlesandabstractsinmedicaljournalsandatnationalandinternationalconferences.
UsingPROCFREQandRemainingDataDriven10CGraceLossman;StatconInc.
/Smith-HanleyConsultingGroup;SouthOrange,NJOutputdatasetsfromtheprocedureFREQareusedinmanywaysbytheprogrammerandstatisticianalike.
Sometimes,however,itcanbefrustratingfussingaroundwithadjustmentswhencellsizesaretoosmallforparticularstatisticaloptions.
Theensuinghardcodinginaprogramisnotverypleasingwheneverythingelserunsinadatadrivenmanner.
Thismacromakeschoicesdependentuponthedataandusestheappropriatestatistic.
GraceLossmanhasaMaster'sdegreeinPhysicsandiscompletingherMaster'sinStatistics.
SheisaconsultantworkingforSmith-HanleyConsultingGroupandisCEOofStatcon,Inc.
Shehasover12yearsexperiencewiththeSASSystemandiscurrentlyworkingonacontractingassignmentatPfizerPharmaceuticalsinManhattan.
GracehastwobooksstillinprogressthroughtheInstitute'sBooksbyUsersProgram:onedealingwithstatisticsandgraphicsforscientistsandengineers;theotherdealingwithproblemsinherenttothepharmaceuticalindustry.
Sheactuallymayfinishonewhenshe'snotgardening,playingwiththedogsorgoingtotheopera.
Graceco-chairedthe1996SESUGconferenceinAtlantawithFrankDiIorio.
UsingARRAYs:TheBasics10CGeorgeMatthews;UniversityofGeorgia;Athens,GAGeorgeMatthewsisastatisticalsoftwareconsultantinanacademicenvironment.
Heoftenencountersnoviceuserswhoneedtoprocessseveralvariablesinthesameway.
IntheDATAstep,youcanputvariablesintoatemporarygroupcalledanarray.
Arraysprovideaverypowerfultoolforgroupprocessing.
ThispaperwillprovideparticipantswiththebasicsofArrayProcessing.
ThispaperisintendedforSASuserswhohavesomeexperiencewiththeDATAstepandnoorverylittleexperiencewitharrays.
GeorgeMatthewsisaStatisticalSoftwareConsultantfortheUniversityofGeorgia.
HehasbeenprogramminginSASforover10years.
HespecializesinBASESAS,SAS/ASSIST,andSAS/ACCESS.
IN&OUTofCNTLwithPROCFORMAT10CNancyPatton;ASG,Inc.
;Washington,DCCNTLIN=Ifyouaregivenaccountnumbersinadatasetandyouareaskedtoidentifyalltheseaccountsinnumerousflatfiles,howmightyouapproachthisUsingtheSASsystemandtheCNTLIN=optioninPROCFORMAT,aformercanbedefinedwherealltheaccountnumbersyouwantidentifiedaresettoavalueof'KEEP'.
ByusingthePUTfunctiontoapplythatformattotheaccountnumbersasyoureadtheflatfiles,youcouldidentifytherecordswiththeaccountsyouarelookingforandcontroltheirdestiny!
Thisexamplewillmakethelook-upprocesssimpletounderstandandeasytobringbacktowork!
CNTLOUT=Haveyoueverhard-codeda'dummy'datasettocombinewithyourdatainordertoforceallcategoriesofaformattedCLASSvariableinPROCSUMMARYbeincludedinyouroutputYoucouldhaveusedCNTLOUT=optionandcreatedthatdatasetquiteeasily!
You'llusethistechniquewheneveryouneedtocreatea'dummy'datasettoforceuniformoutputfromPROCSUMMARY.
NancyPattonhasbeenusingSASforabout15years.
SheiscurrentlyaconsultantwithASGonassignmentwithGECapitalinStamford,CT.
HerareasofexpertiseincludeMACROandPROCREPORT.
MostofherprogrammingisdoneinanMVS/TSObatchenvironment.
NancyhasbeenattendingSUGIsince1989,andhasbeenactiveinbothSUGIandNESUG(theNorthEastSASUsersGroup)since1992.
YetAnotherMoreUser-FriendlyText-WrappingAlgorithm10CDorothyE.
PughandSusanM.
Lach;ClinTrialsResearch,Inc.
;RTP,NCIntheclinicaltrialsfieldwhichofteninvolvesreportingcommentfieldsintheformoflargetextfields,itisimportanttohaveatext-wrappingalgorithmwhichrequires:1)simpleinput,2)minimalpre-andpostprocessingonthepartoftheprogrammer,and3)canhandleanobservationwithmultiplelargetextfields.
Thisalgorithmrequiresthreeinputparameters,nopre-processing,anditsoutputisaSASdatasetcontainingthewrappedtextandtwonewvariablesindicating1)whichlineswereaddedtothedatasetasaresultofthetext-wrapping,and2)whichnewobservationsweregeneratedfromthesameoldobservation.
Theonlypostprocessingtheuserneedstodoistomakeoutputofeachvariableconditionalonthevalueofthesenewvariables.
DorothyE.
PughisaSeniorSASProgrammer/AnalystatClinTrialsResearchInc.
Inadditiontoprogramming,shedevelopsdetailedprogrammingspecificationsbasedondataanalysisplansandsupervisestheirimplementationwiththeaidofaprogrammingchecklistandQCprogrammingtoolsshehasdeveloped.
Sheco-authoredtheZybanFinalStudyReportleadingtothedrug'sFDAapprovalShehasspecialexpertiseinclinicaltrials,andinusingtheSASMacroLanguage,SAS/GRAPH,andPROCREPORT.
SusanM.
LachisaSASprogrammeratClinTrialsResearchInc.
PriortojoiningClinTrials,SusanworkedasapharmacistforaretailchainandasasystemsdeveloperforSASInstituteInc.
HerareasofexpertiseincludeBaseSAS,SAS/AF,SAS/FSP,ScreenControlLanguage,PROCSQL,andPROCReport.
SusanhasaBSinPharmacyfromtheUniversityofNorthCarolinaatChapelHillandaBSinComputerSciencefromNorthCarolinaStateUniversity.
ShehasbeenaSASsoftwareuserfornineyears.
ApplyingARobustGeneralizedAxis-ScalingAlgorithmtotheUseofSAS/GRAPH10CDorothyE.
Pugh;ClinTrialsResearch,Inc.
;RTP,NCGeneratinghigh-qualityplotsquicklyisanimportanttaskfortheclinicaltrialsprogrammer.
Creatingreasonable-lookingaxesfortheseplotspresentsaspecialchallengebecauseofthemutuallyconflictingneedsto:1)makethenumberoftickmarksmoderateandconsistent,2)reducethenumberofsignificantfiguresinthetickmarklabels,and3)minimizewastedspaceintheresultingplot.
Asolutionisthissimpleaxis-scalingalgorithm,anenhancementtothedefaultalgorithmofSAS/GRAPH,achievesanoptimaltradeoffamongthesecriteriatoproduceafairlyconsistentnumber(4to8)ofevenly-spacedtickmarkswithlabelsthatarealwaysintegersmultipliedbypowersoffiveorten.
DorothyE.
PughisaSeniorSASProgrammer/AnalystatClinTrialsResearchInc.
Inadditiontoprogramming,shedevelopsdetailedprogrammingspecificationsbasedondataanalysisplansandsupervisestheirimplementationwiththeaidofaprogrammingchecklistandQCprogrammingtoolsshehasdeveloped.
Sheco-authoredtheZybanFinalStudyReportleadingtothedrug'sFDAapproval.
Shehasspecialexpertiseinclinicaltrials,andinusingtheSASMacroLanguage,SAS/GRAPH,andPROCREPORT.
WhatSortofInputShouldYouInputtoaSort10CMichaelA.
Raithel;RaithelConsultingServices;GarrettPark,MDBecausetheSASSystemmakessortingsosimple,someprogrammerssortanentireSASdatasetwithoutgivingitasecondthought.
But,efficiency-mindedprogrammersoftenpausetoconsiderwhatportionofaSASdatasetactuallyneedstobeinputtoPROCSORT.
WhatifonlyaspecificsubsetofaSASdataset'sfieldsarerequiredinthefinalsorteddatasetIsitreallynecessaryfortheentiredatasettobesorted,oristhereamoreefficientalternativeThispaperdiscussesdifferentmethodsofinputtingaSASdatasettoPROCSORT.
ItcomparestheefficiencyofsortinganentireSASdatasetwiththreemethodsofsubsettingthedataset'sfieldsandinputtingthemtoPROCSORT.
ThispracticalinformationcanbeusedbySASprogrammerstoimprovetheefficiencyoftheirsorts.
MichaelA.
RaithelisacomputerperformanceanalystthatspecializesinMVSperformance,tuning,andcapacityplanning.
Hewasco-chairoftheNESUG'95conferenceinWashington,DC,andhasbeenafrequentinvitedspeakeratSUGIandatregionalSASconferences.
Michaelistheauthorof"TuningSASApplicationsintheMVSEnvironment"publishedbytheSASInstitute.
HiscompanyisRaithelConsultingServices,aSASQualityPartner.
QUIZZER:AFun,FastPacedGame40CChristopherA.
Roper;QualexConsultingServices,Inc.
;Fairfax,VAQuizzerisafun,fastpacedgameintheformatofthepopularTVgameshowJeopardy!
WrittenentirelyusingSAS/AFandFrame,thisapplicationofferstheopportunitytohavealittlefunwhiledemonstratingtherangeofcapabilitiesintheSASsystem.
ThequestionsandanswersareallrelatedtotheSASsystemandaregearedtobechallengingenoughforeventhemostexperiencedSASexpert,andyetsimpleenoughfornoviceSASuserstobeabletoparticipate.
Therearetworoundsoftwenty-fivequestions,andafinalquizzerroundofonequestionwhereateamcanbetitall.
ContestantstesttheirknowledgeofSASinacompetitive,yetfriendlyenvironmentoffairplay,andunwittinglymaylearnalittlemoreabouttheSASsystemintheprocess.
ChristopherA.
RoperisaSeniorSystemsConsultantwithQualexConsultingServices,Inc.
HisareasofexpertiseincludeBaseSAS,SAS/AF,SAS/FSP,Macros,Frame,andSCL,hasbeendevelopingSASapplicationsforovertenyears.
ChriswonBestContributedPaperinApplicationsDevelopmentatlastyear'sWUSSconference,andisanfrequentpresenteratSASusergroupsacrosstheUnitedStatesandEurope.
ChrishasaBSinBusinessAdministrationwithaConcentrationinEconomicsfromChristopherNewportUniversity.
ReadingandJoiningKey-SequencedVSAMDataintheMVSEnvironment10CTinaTilman;CapitalOne;GlenAllen,VAThesequenceofdatainakey-sequencedVSAMdataset(KSDS)isdeterminedbyauniquevalue,theKEY.
Theprimarykeycanbeoneormorefieldswithinthefile(usuallythefirstfield(s)inthefile).
Itidentifiestherecordandestablishestheorderoftherecordswithinthefile.
ThispaperaddressesreadingdatausingSASfromaKSDS,basedontheprimarykey,andthenjoiningthoserecordstootherKSDSfileswherethereareone-to-oneandone-to-manymatchesonthekeyfieldorfields.
TinaTilmaniscurrentlywithCapitalOneinGlenAllen,VA.
SheisanMISAnalystworkingwithAccountSolicitationsandApplicationsProcessingandhas2yearsSASexperience.
ShewasformerlywithVirginiaHealthQualityCenterinRichmond,VAandspent4yearsasaPowerhouseQuizreportwriter.
TinalivesinHollyGrove,VA.
TheRESOLVEFunction-WhatIsItGoodFor10CIanWhitlock;Westat,Inc.
;Rockville,MDTherearefourDATAstepfunctionsthatcommunicatewiththemacrofacility.
CALLSYMPUTSYMGETCALLEXECUTERESOLVECALLSYMPUTandCALLEXECUTEsenddatastepinformationtothemacrofacility.
Theyarebothverypowerfultools.
NumerousSUGIpapershavebeenwrittenonthewondersofCALLSYMPUT.
ThemorepowerfulCALLEXECUTEislesswellknown,butagainonecanfindSUGIpapersdocumentingitsuse.
Ontheotherhand,haveyoueverseenapaperonSYMGETorRESOLVEThesecorrespondingcounterpartsgetinformationfromthemacrofacilityintotheDATAstep.
OneoftenseesSYMGETemployedinmacrocode,butalmostneverinaplacewherethecodewouldnotbebetterwrittenwithoutit.
NowRESOLVEisastrongerSYMGET,butIdonotevenrememberoneprogramthatevenusesRESOLVE,otherthanthoseprovidedbytheSASInstituteforexplanatorypurposes.
ThispaperpresentsandsolvesaproblemwhereRESOLVEiscrucialtoaneasysolution.
IanWhitlockisaseniorsystemsanalystatWestatworkingonsurveyresearchproblems.
HehasbeenprogramminglargelyinSASsince1981usinganinteractiveenvironmenttodevelopprogramsforexecutioninabatchenvironment.
HeisskilledinproblemsolvinginvolvingSASmacro,PROCSQL,reportingproceduresandtheDATAstep.
Inadditiontoprogramming,heteachesSAScoursestoWestatemployees.
HeisactiveonSAS-L,andhaspresentedmanydifferentpapersatnational,regional,andlocalSASUserGroupmeetings.
FormalOnlineDemonstrationsSectionChair:SASInstituteInc.
EstablishingaRepeatableWarehousingProcess50ITonyBrown;SASInstituteAspartofitsthree-prongedapproachtodatawarehousing,SASInstituterecognizespeopleasyourcompany'snumberonecorporateasset,providestechnologythatintegrateseasilyandgrowswithyourneeds,andoffersatestedandprovenmethodologytoensuresuccessinestablishingarepeatablewarehousingprocess.
Allthewhile,youarebuildinganewcorporateassetinmetadatawhichdocumentsalltheprocessesinvolvedindeployingyourwarehousingstrategy.
Thisapproachmaximizestheeffectiveuseofexistinghardware,software,data,andpeopleresources.
Nobiographyavailableatpresstime.
RapidApplicationsDevelopmentusingSASComponentObjectModel(SCOM)inSAS/AFSoftware50ILisaHorwitz;SASInstituteInthisdemoyouwilllearnhowtoexploittheplug-and-playnatureofSCOMcomponentstodevelopbusinessapplicationsquicklywithminimalcoding.
Thenewarchitectureallowsforthedevelopmentanddeploymentofre-useablecomponents.
YouwilllearnhowtousethenewGUIinterfacetoconnectvisualcomponentswithmodelsusingdraganddrop.
Youwillalsoseethenewpropertysheetinaction.
ThisnewVersion7enhancementisamustifyouare,orareconsideringbecoming,aSAS/AFprogrammer.
LisaHorwitz,RegionalTrainingCenterManager,overseestrainingatSASInstitute'sNewYork,Bedminster,NJ,Philadelphia,PA,Boston,MA,andHartford,CToffices.
Lisaalsoteachesclassesandconsultsinherspecialtyareas,whichincludeapplicationsdevelopmentandtheMacrolanguage.
SheisafrequentpresenteratlocalandregionalUsersGroupmeetingsandatSUGI.
UsingODSwiththeBaseReportingProceduresinVersion750IChrisOlinger;SASInstituteAllSASproceduresinteractwiththeOutputDeliverySystem(ODS)togiveyoumorecontroloveroutput.
Some,likePROCREPORTandPROCTABULATE,havenewsyntaxtospecifythis,butmostrelyonthefeaturesofPROCTEMPLATE.
ThispresentationexplorestheODSHTMLreportingfeaturesavailableforSASprocedureoutputingeneral,andthenhighlightstheextra"specialeffects"possibleintheREPORTandTABULATEprocedures.
ChrisOlinger,aveteranSASemployee,worksintheApplicationsDivisionofResearchandDevelopment.
HeisoneofthekeyODSdevelopers(hewaspartlyresponsiblefortheVersion6ODSprototype)andnowprogramsthebulkoftheinternalODSinfrastructureintheSASSystem.
SASEnterpriseMiner50IKristinRahn;SASInstituteThispresentationwillprovideanoverviewofEnterpriseMiner,anintegratedsoftwareproductthatisanend-to-endbusinesssolutionfordatamining.
Agraphicaluserinterface(GUI)providesauser-friendlyprocessflowthatempowersyoutodefineyourdataminingprocess(sample,explore,modify,model,andassess).
EnterpriseMinercontainsacollectionofsophisticatedanalysistoolshavingaCommonuser-friendlyinterfacethatenablesyoutocreateandcomparemultiplemodels.
Statisticalandminingtoolsincludeclustering,variableselection,decisiontrees,linearandlogisticregression,andneuralnetworks.
Datapreparationtoolsincludeoutlierdetection,variabletransformations,missingvalueimputation,randomsampling,andthepartitioningofdatasets(intotrain,test,andvalidatedatasets).
Advancedvisualizationtoolsenableyoutoquicklyandeasilyexaminelargeamountsofdatainmultidimensionalhistograms,andtographicallycomparemodelingresults.
EnterpriseMineralsoallowsyoutomanage,edit,export,andexecutescoringcodethatisgeneratedfromatrainedmodel.
Inaddition,youcanbringotherSASmodelsoroutsidemodelsintotheEnterpriseMinerenvironmentviaamodelingAPI.
Finally,youcanincorporateneworexistingSAScodedirectlyintotheprocessflow.
Nobiographyavailableatpresstime.
TheFutureInterfacetotheSASSystemforPCs-AFirstGlance50ICarolRigsbee;SASInstituteThispresentationdescribesanewuserinterfacetotheSASSystem.
Thisinterfaceisastate-of-the-artMicrosoftWindowsuserinterface,providingahighlyintegratedinterfacewiththeWindowssystem,otherWindowsapplications,andtheWeb.
Itprovidesthin-clientaccesstoallVersion7SASSystemplatformsincludingPC,UNIX,andmainframesanddramaticallyimprovestheSASSystem'seaseofuse.
TransparentaccesstodataandfullaccesstotheOutputDeliverySystem(ODS)arealsoprovided.
CarolRigsbee,InstituteKeynote,isaPrincipalDeveloperintheWindowsUserInterfaceThinClientgroupatSASInstitute.
Shehasbeeninvolvedinthedesignanddevelopmentofthisprojectsinceitsbeginning.
ShehasbeenattheInstituteforthepasttwelveyears,developingtheSASSystemforPC'ssinceSASRelease6.
03.
Shehasbeenworkinginthecomputerindustrysince1980.
EnterpriseReporter:CreativeReporting50IMelodieRush;SASInstituteTitles,footnotes,reportheaders,pagenumbers,companylogos,summaries,groupings,calculations,graphics,presentation-qualityoutputaswellaspublishingoutputontheWebarejustafewexamplesofwhatbusinessusersarelookingforinaPCreportpackage.
ThenewEnterpriseReportersoftwareprovidesreportingflexibilitybyallowingyoutoconcentrateondesigningbusinessstylereports--withoutworryingabouthowtoaccessyourcompany'sdata.
ThispresentationwilldemonstratethemanydifferenttypesofreportingfeaturesfoundinEnterpriseReportersoftware.
Nobiographyavailableatpresstime.
TheAnalystApplication50IMauraStokes;SASInstituteTheAnalystApplicationprovidesapoint-and-clickinterfacetothebasicstatisticalanalysesintheSASSystem.
Thistask-orientedapproachissuitablefornovices,experiencedprogrammers,andstatisticiansalike--andaresultstreemakesmanagingtheresultsveryconvenient.
OngoinginterfaceworkfortheSASSystemisbasedontheAnalystparadigm.
MauraStokesisManageroftheStatisticalApplicationsRandDDepartmentandhasworkedatSASInstituteforfourteenyears.
Sheisco-authorofthebookCategoricalDataAnalysisUsingtheSASSystem.
SheholdsaDrPHdegreeinBiostatisticsfromUNC/ChapelHillandisnowanadjunctmemberofthefaculty.
TheNewADXInterfaceforDesignandAnalysisofExperimentalDesignSoftware50IMauraStokes;SASInstituteThenewADXinterfaceprovidesapoint-and-clickapproachtothedesignandanalysisofstandardexperiments--anapproachofparticularbenefittoqualityengineers,researchers,andothernon-statisticians.
Theinterfaceoffersadesktopfororganizingdesigns,step-by-stepguidance,interactivegraphics,reportgeneration,andHTMLoutput.
AvailableasanexperimentalproductwithRelease6.
12oftheSASSystemonUNIXandPCplatforms,itwillgoproductionwithVersion7.
MauraStokesisManageroftheStatisticalApplicationsRandDDepartmentandhasworkedatSASInstituteforfourteenyears.
Sheisco-authorofthebookCategoricalDataAnalysisUsingtheSASSystem.
SheholdsaDrPHdegreeinBiostatisticsfromUNC/ChapelHillandisnowanadjunctmemberofthefaculty.
FineTuningOLAP50IJenniferTorrisi;SASInstituteYouhaveusedtheSAS/MDDBServerandhaveexploredtheSASSystem'sOLAPTechnology.
Youhavetakenitasfarasyouknowhowtotakeit.
JoinusforthispresentationwherewewillshowyouhowtotakethisOLAPtechnologytothelimitsandbeyond.
WewillshowyouhowtocreatemoreefficientmultidimensionaldesignsfordeliveringfasterperformanceinOLAPreporting.
Nobiographyavailableatpresstime.
SecondGenerationOLAP:BeyondtheCube50IJenniferTorrisi;SASInstituteSASInstitutehasannouncedanewextensiontoitsOLAPserver.
ThisextensioncanenhancescalabilityandperformanceinOLAPapplications.
Withthisextension,itisnowpossibletoeasilyintegrateRDBMS,MDDB,andSASdatasetsallintoasinglevirtualOLAPview.
Withlittleornochange,applicationscanbeextendedtouseanytypeofdataonanymachine.
Theextensionalsoincorporatesremotecomputingfunctionalitysotheapplicationcanusethepoweroftheserver,andincludesrichercachingandloggingfeatures.
ThisdemowilldiscussthearchitectureforthisnewHOLAPenvironment,andwilldemonstratethefeaturesandfunctionsofthenewextension.
Nobiographyavailableatpresstime.
SolvingBusinessProblemswithSAS/IntrNetSoftware50IBarbaraWalters;SASInstituteThisdemonstrationwillfocusoncommonbusinessproblemsfacedbymanyorganizations,andshowhowSASInstitute'sWebtechnologycanbedeployedtosolvetheseproblemsandbringthepoweroftheSASSystemtodesktopsworldwide.
SeehowSAS/IntrNetsoftwarecanhelpwithreportdistribution,applicationdistributionanddeploymentofthinclients.
BarbaraWaltersisprojectmanageroftheJavaWebtoolsgroupinCary.
ShecreatedJavaclassesthatprovideaccesstoSASdataaswellastocomputeservices.
ShehasbeenwithSASInstitutesince1995.
PriortocomingtotheInstitute,shedevelopedaWebbrowserforOS/2calledWebExplorer.
HostSystemsSectionChair:GregoryBarnesNelsonASG,Inc.
Cary,NCSASClient-ServerDevelopment:TricksoftheTrade50IEricBrinsfield;MeridianSoftware,Inc.
;Raleigh,NCClient-servercomputingisnotjustamatteroftradingdatabetweenhostandclient.
Whetheryouaredevelopinginaclient-serverenvironmentorusingaclient-serverapplication,thewell-designedclient-serversystemshouldoptimizethelocationofprocessingandminimizethetransferofdata.
ThispaperofferstipstotheSASclient-serverdeveloperbydiscussingtraditionalclient-servertechniquesusingSAS/CONNECTaswellasclarifyingtheimpactofthin-clientWebdevelopment.
Whereappropriateduringthisdiscussion,Iwillevaluatetheprosandconsofperformancestrategies.
Wherepossibleduringthepresentation,Iwilldemonstratetheresultsofinterestingdesignchoices.
EricBrinsfieldispresidentofMeridianSoftware,Inc.
,ascustomsoftwaredevelopmentfirm.
HehasbeenusingSASsoftwaresince1977andspecializesinprojectmanagement,softwaresystemdesign,databasedesign,andGUIdesign.
EricearnedhisBSfromDukeUniversityandhisMSfromNorthCarolinaStateUniversity.
tAWKingAboutMigration:UsingUNIXUtilitiestoConvertanMVSSystem20CFrankDiIorio;AdvancedIntegratedManufacturingSolutionsCorp.
;ChapelHill,NCTrue,"SASisSAS"inanysystemenvironment.
Codecanbedesignedsothatitcanbeportedtovirtuallyanyenvironmentwithaminimumofsystem-dependentcode.
Buthowcanexisting("legacy")systemsbeeffectivelymigratedbetweenenvironmentsTheprospectofmovinglargeamountsofcodeanddatathatwereneverintendedforlifeoutsideaparticularsystemisnotappealing.
ThispaperdescribesalargemigrationeffortfromanMVSsystemtoaUNIX-based(SUNSolaris)platform.
Wefocusontheroleofoperatingsystemutilitiesandfeaturessuchasawk,grep,andenvironmentvariablesinfacilitatingtheconversionand,infact,producingamorereliableandrobustenvironmentonthetargetmachine.
Mostimportantly,virtuallyallofthemigrationefforttookplaceoutsidetheSASSystem.
ThepaperstressestheimportanceofbothknowingthetargetoperatingsystemandhavingawillingnesstostepoutsidetheSASSystem"blackbox.
"FrankDiIorioisDirector,SASSystemDevelopmentatAIMSCo(AdvancedIntegratedManufacturingSolutionsCorporation),amanufacturingsystemsintegrator.
Hehasover22years'experiencewithBaseSASandproductssuchasSAS/GRAPH,SAS/AF,SAS/GRAPH,SAS/QC,andSAS/FSP.
Hehasworkedineducational,financial,pharmaceutical,andmanufacturingenvironments,focusingonprogramefficiency,report-writing,themacrolanguage,anduserinterfacedesignissues.
Muchoftheknowledgegainedfromthesevariedworkenvironmentshasbeencommittedtopaper–hehaswrittenmanypaperspresentedatlocal,regional,andinternationalSASusergroups.
FrankisalsotheauthoroftwopopularSASprogrammingtexts,"SASApplicationsProgramming:AGentleIntroduction"and(co-authoredwithKennethHardy)"QuickStarttoDataAnalysiswithSAS.
"Athirdbook,"TheElementsofSASProgrammingStyle,"isbeingdeveloped.
FrankisactiveintheSouthEastSASUsersGroup(SESUG).
Hewasconferenceco-chairin1994and1996,andiscurrentlyservingasPresidentofthegroup.
ApplicationDevelopmentfortheNewHostontheBlock:JavaVirtualMachine50IBradKlenz;SASInstituteSASInstituteisquicklymovingforwardontoolsforSASapplicationdevelopmentintheJavaenvironment.
WhatarethesetoolsHowaretheyusedThispaperwilldiscusstheuseofJconnectandSASJDBCclasseswithinthe'Jazz/IDE'developmenttoolnowavailablefromSASInstitute.
ThepaperwillalsodiscusstheadvantagesandlimitationsofusingaJavafrontendtoSASapplications.
BradKlenzspecializesinSASapplicationdesignanddevelopment.
Hehasbeendoingconsultingworkforthepast6years.
Previoustothat,BradwasanemployeeatSASInstituteintheTechnicalSupportDivisionwhereheprovidedprimarysupportforSAS/ACCESStoDB2andSAS/Share.
Brad'sexpertiseiswithapplicationuserinterfacesincludingSAS/AFFrame,OOP,interfacingtheSASSystemwithhostplatformssuchasWindowsNTandUNIX,andWebinterfacesusingSAS/IntrNet.
TheindustryareasBradhasworkedinincludeSPCanalysisinterfacesformanufacturingandclinicaldatamanagementforpharmaceuticals.
BradhasbeenafulltimeSASuserforthepast10years.
AMethodologyforLinkingHeterogeneousDatabasesforClinicalResearch20CSharonKromhout-Schiro;NorthCarolinaTraumaRegistry,UniversityofNorthCarolinaatChapelHill;ChapelHill,NCHealthcareinformationiscrucialtomakingdecisionsthatwillhelptocontainthecostsofhealthcare,andforimprovingtheoutcomesofmedicalcare.
Theelectronicmedicalrecordoftenisfragmentedovermultiplephysicalsites,andincludesdatabasesofdifferingstructures.
Accesstothemedicalinformationrequiresthelinkingofthesemultipledatabases.
Duetotheheterogeneityofthedatabases,thelinkingofthedatabasesnecessitatesthetranslationofthedataanddatastructuressothatthedatainthecompositedatabasehavethesamemeaning.
Thispaperdescribestheprinciplesbehindthelinkingofmultipledatabasesthroughthedevelopmentofaplatformofcommondatadefinitions.
ThisplatformofcommondatadefinitionsishenceforthcalledtheFoundationLibrary.
TheuseoftheFoundationLibraryreducestheeffortrequiredtodevelopcodeforthetranslationofdata,asonlyonetranslationprogramneedstobedevelopedforeachdatabase:thetranslationtotheFoundationLibrary.
ThispaperdescribestheFoundationLibraryconceptanditsuseinaclinicalresearchproject.
Nobiographyavailableatpresstime.
PowerTechniquesforProcessingLargeTapeDataSetsUsingtheSASSystemintheMVSEnvironment50IMichaelRaithel;RaithelConsultingServices;GarrettPark,MDTapeisoneoftheoldestandmostdependablemediumsforstoringdatasetsintheMVSenvironment.
SASdatalibraries,OSdatasets,anddatabasebackupfilesareafewofthemanytypesofdatasetscommonlystoredontape.
Becausetapeisarelativelyinexpensivemedia,itisparticularlywellsuitedforstoringlargedatasets.
But,thesubsequentprocessingoflargedatasetsstoredontapecanbecostlyintermsofcomputerresourcesandelapsedtime.
IfyouworkinanorganizationthatrunsMVS,itisverylikelythatyouwillhavetoprocesslargetapedatasetssoonerorlater.
Perhapsyoualreadydo.
ThispaperfocusesonstrategiesforoptimizingyourprocessingoflargetapedatasetsusingtheSASSystem.
Itprovidestechniquesthatyoucanusetoreducecomputeroverheadandelapsedtime.
OptimummethodsforprocessinglargeSASdatalibrariesaswellasOSdatasetsarecoveredinthispaper.
MichaelA.
RaithelisacomputerperformanceanalystthatspecializesinMVSperformance,tuning,andcapacityplanning.
Hewasco-chairoftheNESUG'95conferenceinWashington,DC,andhasbeenafrequentinvitedspeakeratSUGIandNESUGconferences.
Michaelistheauthorof"TuningSASApplicationsintheMVSEnvironment"publishedbytheSASInstitute.
Using64-bitSAStoYourAdvantage-SASConfigurationGuidelinesonDigitalUNIX20CCarlRalston;DigitalEquipmentCorp.
;Cary,NCThispresentationwilldescribesetup,installation,configuration,andtuningguidelinesofSASsoftwareonDigitalUNIX.
TheSASSystemonDigitalUNIXisa64-bitapplication.
TheSASSystemwilltakeadvantageoftheHUGEaddressspaceforthingslikedatacaches,in-memorysorts,code,I/Obuffers,MDDB'sandgeneratedAlphacode.
ConfigurationoftheI/Osubsystem,RAIDtradeoffs,UNIXattributesandparameters,andvariousSASoptionswillbediscussed.
ComparisonofSAS6.
12and7.
0willbedone.
CarlRalstonhasover25yearsexperienceinSoftwareEngineering,hasdeveloped10softwareproductsonfourdifferentoperatingsystems,andwasformerlyanAdjunctFacultymemberofSoftwareEngineeringandManagement,consultingatcompanieslikeGE,Kodak,CorningGlass,andSUNY.
Heisatechnicalevangelistfor64-bits,kernelthreads,filesystems,andWindowsNTAffinity.
CarlisDigital'sSeniorSoftwareSystemsConsultantonsiteatSASInstitute'sCustomerTechnologyCenterinCary,NC.
HehasaPh.
D.
inresearchinPhysics.
GettingtheMostfromYourSASEnvironmentonOpenVMSAlpha20CCarlRalston;DigitalEquipmentCorp.
;Cary,NCThispresentationwilldescribesetup,installation,configuration,andtuningguidelinesofSASsoftwareonOpenVMSAlpha.
ConfigurationoftheI/Osubsystem,RAIDtradeoffs,OpenVMSprocessquotasandlimits,OpenVMSsysgenparameters,andvariousSASoptionswillbediscussedthateffectperformanceandthroughput.
ComparisonofSAS6.
12and7.
0willbedone.
CarlRalstonhasover25yearsexperienceinSoftwareEngineering,hasdeveloped10softwareproductsonfourdifferentoperatingsystems,andwasformerlyanAdjunctFacultymemberofSoftwareEngineeringandManagement,consultingatcompanieslikeGE,Kodak,CorningGlass,andSUNY.
Heisatechnicalevangelistfor64-bits,kernelthreads,filesystems,andWindowsNTAffinity.
CarlisDigital'sSeniorSoftwareSystemsConsultantonsiteatSASInstitute'sCustomerTechnologyCenterinCary,NC.
HehasaPh.
D.
inresearchinPhysics.
ThinClientsfortheWindows-"JazzFront"and"JazzReporter"50ICarolRigsbee;SASInstitute;Cary,NC"JazzFront"and"JazzReporter"arethecodenamesfortwonewWindowsThinClientsthatareavailablewiththeNashvillerelease.
"JazzFront"providesapointandclick,codebaseduserinterfacetoalltheVersion7SASSystemservers.
"JazzFront"providestransparentdataaccesstobothSASandnon-SASdata,acustomizableUserInterface,theabilitytoexportresultstootherWindowsapplicationsandtheabilitytoscheduleyourprojecttorunatalatertime.
"JazzReporter"providesareportbaseduserinterfacetoyourSASandnon-SASdata.
CarolRigsbee,InstituteKeynote,isaPrincipalDeveloperintheWindowsUserInterfaceThinClientgroupatSASInstitute.
Shehasbeeninvolvedinthedesignanddevelopmentofthisprojectsinceitsbeginning.
ShehasbeenattheInstituteforthepasttwelveyears,developingtheSASSystemforPC'ssinceSASRelease6.
03.
Shehasbeenworkinginthecomputerindustrysince1980.
FormsandMore:GettingWhatYouWantfromYourPrinter50CFrankRoediger;MeridianSoftware,Inc.
;Raleigh,NCAnannoyingholduptoproducingafinalreportissometimestheprinteritself:allyourcodeworksfinebutyoucan'tgettheprintertoproduceahardcopythatmatchesyourfinickyuser'sdetailedreportspecsformargins,font,andpitch.
Whenthishappens,Release6.
12forPCplatformslikeWindows/NTgivesyouagreatdealofcontrolincustomizinghowadocumentgetsprinted.
However,ifyou'reworkingonaUNIXsystem,manyofthePC-basedprintercontrolfeaturesaren'tavailabletoyou.
There,theFORMSsubsystemallowsyoutostorecustomizedsettingsandusethemtocontrolprintedoutputrepeatedly.
Regardlessofwhichplatformyouuse,therearealsosituationssuchaswhentheprinterjamsinthemiddleofalongreportandyouwanttoprintoutonlythepartthatit"ate",orwhenyouneedtousespecialcharacters(like"plus-over-minus").
ThispaperwillwalkyouthroughtheseandotherprintingchallengesandpresentsolutionsthatcanworkforbothUNIXandWindows/NTplatforms.
FrankRoedigerisaSeniorProgrammerAnalystwithMeridianSoftware,Inc.
Hehasover18yearsexperienceusingSASinthefieldsofacademicresearch,finance,healthcare,andpharmaceuticalclinicaltrials.
I-NetSolutionsSectionChairs:CarolineBahlerASG,Inc.
Cary,NCCarlHaskeSTATPROBE,Inc.
AnnArbor,MISAS/IntrNetandSESUGRegistration:TheApplicationDispatcherAddsaNewDimension50IGregAshley;UniversityofGeorgia;Athens,GAAtSESUG'97theauthor,whowasalsotheConferenceRegistrar,presentedanapplicationhehaddevelopedtohandleSESUGConferenceregistrationusingtheWebandSASashisprimetools.
Theywerenothisonlytools,however;severalPerlscriptswereusedtoconnectvariouspartsoftheoverallapplicationtogether.
Thisyear,asOnsiteConferenceRegistrar,theauthorhaspursuedthisprojectand,withtheSASApplicationDispatcher,hasreplacedthePerlscriptswithatotalSASsolution.
ThispaperwillreviewthepreviousregistrationandthescriptsitemployedandthenmoveintothenewopportunitiesaffordedbytheApplicationsDispatcher.
GregAshleyistheManagerofHostSystems&StatisticalSoftwareSupport,UniversityComputing,attheUniversityofGeorgia.
DynamicWebPages-IntegratingJavaScriptintoaSASWebApplication50ICarolineBahler;ASG,Inc.
;Cary,NCTheuseofdynamicWebpagesineitherInternetorIntranetapplicationsisrapidlybecomingthehottestSASapplicationdevelopmenttopic.
OnecomponentofadynamicWebpageistheuseoftheJavaScriptlanguage.
JavaScriptisalanguagethathastremendouspotentialforenhancingWebapplications,especiallyclient-sidedatavalidation.
TheobjectiveofthispaperistointroducetheJavaScriptlanguage,illustratehowWebpagedevelopersareusingit,anddiscusshowtheJavaScriptlanguagecouldbeincorporatedintoaWebapplicationpoweredbySAS.
CarolineBahleriscurrentlyaseniortechnicalconsultantintheAdvancedSolutionsGroupatASG,Inc.
,aSASInstituteBusinessPartner.
HerSASbackgroundstretchesbackover18yearsandmanyversionsofSAS,includingusingSASoverawidevarietyofplatforms.
MassProducingWebPageswithSAS50IKeithBrown;UNC;ChapelHill,NCWithSAS'Webpublishingmacros,turningSASoutputintoaWebpageisrelativelysimple.
Problemsarise,however,wheninsteadofoneWebpage,youneedtoproducemultiplepages,andbeabletolinkthembacktoanindexpage.
Thispresentationwillexaminethecodeneededtobuildanindexpage,ormultipleindexpages,withlinkspointingtotheproperdatapages;tooutputthedatapages,eitherlocallyoronaremoteserver;andoptionally,toproducehardcopyoutputratherthanWebpages.
KeithBrownbeganusingSASasagraduatestudentatUNC-ChapelHillin1982,andprogressedtoteachingitasaninstructoranduserserviceconsultant.
In1994,hemoved"downthehill"toUNCGeneralAdministration,whichoverseesallsixteencampusesoftheUNCsystem.
Currently,KeithisaprogrammeranddataanalystintheDivisionofProgramAssessmentandPublicService,whereheprimarilyusesBaseSAS,SAS/GRAPH,andSAS/STATonseveralsystems,includingUNIXandMacintosh.
CastingPERLBefore(andAfter)SAS--NotJustaBadAllusion20CKennethHardy;UNC;ChapelHill,NCOnewaytocreatedynamicWebpagesthatuseSAStoproducereportsoranalysesondemandistowritethenecessaryCGI(CommonGatewayInterface)programsthatcallSASandcommunicateswiththeWebclientinPERL.
ThispaperwillreviewthebasicsofWebclient-serverdialogues,provideaquickoverviewofPerlandexplainwhyit'ssopopularforwritingCGIprograms.
ItwillalsogivesomepointersforusingPerltowriteCGIprogramsthatcallSAStoproducecustomreportsoranalysesanddisplaytheiroutputasWebpages.
KennethHardyisAssociateDirectorforInformationSystemsattheInstituteforResearchinSocialScienceoftheUniversityofNorthCarolinaatChapelHill.
HehasbeenaSASuserandconsultantforovertwenty-fiveyears.
Inadditiontoacademicresearchpublications,hehaspresentedmanypapersatSUGIandSESUGmeetings.
Hehasalsoco-authoredbooksontopicsrangingfromtheinequityofthedeathpenaltytoquantitativeresearchmethodsforhistorians.
Hismostrecentbook,writtenwithFrankC.
DiIorio,is"QuickStarttoDataAnalysiswithSAS".
Forthepastthreeyears,hehasbeenwritingWeb-basedapplicationsusingCGIscriptsthatuseSASandtextsearchingsoftware.
UsingSASandtheInternetforExploringClinicalData50ICarlR.
Haske,Ph.
D.
;STATPROBE,Inc.
;AnnArbor,MIInthepharmaceuticalsetting,SASistheprimarytoolforanalyzingdata.
Traditionally,reportsandanalysesaredeliveredtotheuserinstaticpaperformat.
WiththeadventoftheInternet,thepossibilitiesforinformationdeliveryandonlineanalysisofdataareboundless.
Clinicalinformationdelivereddynamicallytoabrowserrunningontheclientmachineprovidestheinformationconsumerwithreal-timedataaccess:datacanbeinspected,probed,andassimilatedwithanimmediacynotconceivableforconventionalmethods.
Theresultisfasterproducttomarketinahighlycompetitiveindustry.
However,deliveringarobustandusablebrowserinterfacethatallowstheusertointeractintuitivelywithdataisanexceptionalchallenge.
ThispaperdescribestechniquesandapplicationsforexploringandanalyzingclinicaldatastoredinSASdatasetsonanapplicationserverwithdistributiontothinclientsviaanInternetbrowser.
CarlHaskereceivedhisPh.
D.
inMathematicsfromRiceUniversityandservesasDirectoroftheResearchInformationSystemsDepartmentofSTATPROBE,Inc.
,acontractresearchorganizationinAnnArbor,Michigan.
Carlisinvolvedintheprocessclassificationofclinicaldatamanagementandreportgenerationinordertostandardizeandintegratesystemsthatcondensethereportdevelopmentprocess.
HehasbeenaSASapplicationsdeveloperfortenyearsandhasgivenpresentationsatseveralSUGIconferencesandregionalSASusergroupconferences.
TalesfromtheFront:PanelDiscussion50IModerator:CarlHaske,Ph.
D.
;STATPROBE,Inc.
;AnnArbor,MIPanelists:notavailableatpresstimeNoabstractavailableatpresstime.
CarlHaskereceivedhisPh.
D.
inMathematicsfromRiceUniversityandservesasDirectoroftheResearchInformationSystemsDepartmentofSTATPROBE,Inc.
,acontractresearchorganizationinAnnArbor,Michigan.
Carlisinvolvedintheprocessclassificationofclinicaldatamanagementandreportgenerationinordertostandardizeandintegratesystemsthatcondensethereportdevelopmentprocess.
HehasbeenaSASapplicationsdeveloperfortenyearsandhasgivenpresentationsatseveralSUGIconferencesandregionalSASusergroupconferences.
Nootherbiographiesavailableatpresstime.
HowtoWebEnableSASApplications:AnOnlineDemonstrationofSAS/IntrNetApplications50IBradKlenz;SASInstituteSASInstitutenowofferstoolsforWebenablementofSASsoftwareapplications.
ThispaperguidesyouinselectingthecorrectSAS/IntrNettoolforthetaskyouwanttoachievebycomparingthecapabilitiesoftheApplicationDispatcher,HTMLFormattingtools,Jazz/IDEJavadevelopmenttool,andDynamicHTML.
Demonstrationapplicationsarepresentedtoshowthedifferenttoolsinaction.
Therearemultiplewaysto'Webenable'anapplication.
Theexamplespresentedinthispaperinclude:anapplicationthatgenerates,andregularlyrefreshes,asetofHTMLpagestoprovideanalternativetostandardreportdistribution;aremotedataentryinterfacetoaSASdatabase;andaGUIthatprovidestheflexibilityofJava,butalsoenablesaccesstoSASdataandrunsSASproceduresforanalysis.
BradKlenzspecializesinSASapplicationdesignanddevelopment.
Hehasbeendoingconsultingworkforthepast6years.
Previoustothat,BradwasanemployeeatSASInstituteintheTechnicalSupportDivisionwhereheprovidedprimarysupportforSAS/ACCESStoDB2andSAS/Share.
Brad'sexpertiseiswithapplicationuserinterfacesincludingSAS/AFFrame,OOP,interfacingtheSASSystemwithhostplatformssuchasWindowsNTandUNIX,andWebinterfacesusingSAS/IntrNet.
TheindustryareasBradhasworkedinincludeSPCanalysisinterfacesformanufacturingandclinicaldatamanagementforpharmaceuticals.
BradhasbeenafulltimeSASuserforthepast10years.
RealWorldUtilizationofSAS/IntrNetApplicationDispatcher50IRuthL.
Marinshaw,SallyS.
Muller,andJoyceW.
Tabor;UNC;ChapelHill,NCTheUniversityofNorthCarolinaatChapelHill'sCarolinaPopulationCenter(CPC)isoneofthemostactiveresearchcentersatUNC-CH.
Withover40projectsand48facultyfellows,theCenterhasmanyresponsibilitiesincludinganalysisoflargepopulationdatabasesandproducinganddistributinglargevolumesofreportsworldwide.
OneofthegoalsoftheCPC'sprogrammingstaffistoimproveonthedelivery,dissemination,andanalysisofpopulationdatacollectedbytheCenter.
CPChasfoundthattheSASSystemprovidesoptimaltoolsforaccomplishingthisgoal,andin1998theybeganprovidingaccesstotheirlargepopulationdatabasesusingSASviatheWeb.
ThispaperhighlightstheirtransitionfromusingthestaticSASHTMLWebpublishingmacrostousingacombinationofthesetoolsandtheSAS/IntrNetdynamictoolsastheircurrentinformationdeliveryparadigm.
RuthMarinshawisaSystemsProgrammer/AdministratorattheCarolinaPopulationCenter,wheresheusesandsupportsSASonseveralplatforms.
ShehasbeenaSASuserforaboutelevenyearsandlearnedmuchofwhatsheknowsaboutSASfromco-authorJoyceTabor.
SallyMulleristheManageroftheStatisticalSupportgroup,adivisionofAcademicTechnologyandNetworks(ATN),attheUniversityofNorthCarolina.
SallybeganusingSASsoftwarein1978andin1987becameasiterepresentative.
Sincethenshehasansweredover20millionSASuserquestionsandtaughtseveralthousandSAS/ASSISTclasses.
SallyfindsthatSASnovicesandevenpeoplewithlimitedcomputingknowledgeofanykindcanlearntouse(andlove)SAS/ASSIST.
AdesiretoshowtheadvantagesofASSISToverotherSASinterfacesandconventionalmethodsoflearningtousetheSASSystemisthemotivationofthispaper.
JoyceTaborworksfortheCarolinaPopulationCenteratUNC-ChapelHill.
Nootherinformationavailableatpresstime.
ExtendingtheLifeofYourAFApplication:ExploitingtheModel-ViewerParadigm50IGregoryS.
BarnesNelson;ASG,Inc.
;Cary,NCSAS/AFFRAMEtechnologyhaslongbeenthemainstayofourvisualentréeintotraditionalSASapplications.
TheWorldWideWebhastakenafront-seattomostapplicationdevelopmenteffortsinanattempttosurfacemoreandmoreinformationtoentireenterprises.
Thisinterest,inpart,hasforceddeveloperstolookmorecriticallyatnotonlywhattechnologyweusetodevelop,butalsohowwecancapitalizeonourrecentinvestmentsinapplicationsdevelopment.
ThispaperattemptstodispelthenotionsthatSAS/AFFRAMEmaybeanoutmodedtechnology.
Rather,hereweshowhowwecanexploitthelessonslearnedfromtheseapplicationsbysurfacingtheinterfaceontheWeb,whileretainingthekeybusinesslogicinSAS/AF.
WewilldiscusstherolethatSAS/AFcanstillplayinthisnewthin-centricworldandhowtosurfacethisinformationacrosstheenterprise.
GregNelsoniscurrentlytheDirectorofTechnologySolutionsatASG,Inc.
,aSASInstituteBusinessPartner.
There,hisprimaryroleistopartnerwithclientsindevelopingsystemsandtobringtechnologytotask.
PriortojoiningASG,GregwastheDirectorofSASEducationandDevelopmentatTheGallupOrganizationaswellasManagerofClientSupportattheUniversityofGeorgia'scomputercenter.
Hehasover13yearsofexperienceusingtheSASSysteminawidevarietyofapplicationsandplatforms.
OverviewofJavaComponentsandAppletsinSAS/IntrNetSoftware50IBarbaraWalters;SASInstituteThispaperdescribestheJavacomponentsandthesampleappletsthatarepartofSAS/IntrNetsoftware.
ThispaperdescribeshowtousetheSAS/SHARE*NETdriverforJDBC,JConnect,andJTunneltoaccessinformationandservicesavailablefromSASservers,andalsoprovidescodeexamplestodemonstratethesecapabilities.
Notethatthecodeexamplesreferencedinthetextarepresentedinaseparatesectionattheendofthepaper.
BarbaraWaltersisprojectmanageroftheJavaWebtoolsgroupinCary.
ShecreatedJavaclassesthatprovideaccesstoSASdataaswellastocomputeservices.
ShehasbeenwithSASInstitutesince1995.
PriortocomingtotheInstitute,shedevelopedaWebbrowserforOS/2calledWebExplorer.
InformationVisualizationSectionChairs:EricBrinsfieldMeridianSoftware,Inc.
Raleigh,NCMattBeckerSTATPROBE,Inc.
AnnArbor,MIProducingUsefulSurveyAnalysisGraphicswithEfficientSASCode50CDr.
DonaldT.
GantzandYanYaun;GeorgeMasonUniversity;Fairfax,VAAnalyzingandreportingsurveydatatypicallyrequiresthegenerationofmanygraphicalpresentationswhereeachgraphicrevealsrelationshipsbetweenseveralvariables.
Frequently,ananalystassociatesagoodgraphicvehiclewithsetsofvariablesandthensettlesdowntogruntingoutmanyindividualgraphs.
BycleverlydesigningtheproductionprocesswithflexiblecodinganduseoftheSASMacrolanguage,theSASprogrammercancreateanefficientpathfromrawdatatoanalysisandpresentationgraphics.
WritingreusablemodulesofcodeandutilizingtheSASMacrolanguagearemeanstothatend.
ThispaperillustratesaparticularapplicationtheauthorshavedesignedandimplementedintheirworksupportingresearchonthedatabasefromaNationalSurveyofRegisteredNurses.
TheapplicationisrootedinaveryversatilecoreofgraphicscodethatiseasilymodifiedtoproduceavariedmenuofgraphicstructuresviaafrontendprogramfeedingitvaluesforMacrovariables.
InadditiontodemonstratingtheutilityofSASMacroLanguageandSAS/GRAPH,thispapermakesavailabletoreadersagraphicformthattheauthorshavefoundquiteuseful.
Dr.
DonaldGantzisaprofessorintheDepartmentofAppliedandEngineeringStatistics,GeorgeMasonUniversity,Fairfax,Virginia.
Hespecializesintheuseofvisualizationindatamodelingandanalysis.
HeteachesaSASbasedgraduatecasestudiescourseindataanalysis;hispresentationsinvolvehissolutionstoreal-worldquantitativeproblemsandtheSASapplicationshehasdevelopedtoimplementthesolutions.
HeisanexpertinSASwhichhasbeenhisprimarytoolboxasaconsultantinappliedstatisticsfortwentyyears.
HehaspresentedinvitedpapersconcerninghisSASapplicationsatSUGI15andNESUG'92.
YanYaunworksintheApplied&EngineeringStatisticsDept.
atGeorgeMasonUniversityinFairfax,VA.
Nootherinformationavailableatpresstime.
UsingJMPforDesignofExperimentsandVariabilityAnalysisforSemiconductors50IBillGjertsen;SASInstituteSemiconductordevicesareabsolutelyessentialcomponentsofallelectronicproducts.
Withoutsemiconductorsandintegratedcircuitchips,electronicproductsandsystemscannotbemadeoroperated.
Thisisadatarichindustrywithscienceandskillpressedtothelimittoachievequality.
Excellentdesignandmanufacturingareessentialtomeettightspecifications.
WiththisinmindweshowwithexamplessuchasamultipleresponsedesignofexperimentsandGageR&RhowJMPcanbeusedtoaddresssomeofthesequalityissues.
BillGjertsenisaSeniorMarketingAnalystfortheJMPproduct.
HehasbeeninvolvedwithsalesandmarketingatSASInstitutefor21years.
AchievingGraphicalExcellenceWithSAS/GRAPH50IDr.
ArcherGravely;UNCAsheville;Asheville,NCThispaperwillintegratetheprinciplesofgraphicalexcellence(Tufte,1983;andothers)withtheuseofSAS/GRAPHtoproduceplotsandbarcharts.
Theuseoftheseprincipleswillenableuserstocreatepresentationsthatcommunicatecomplexideaswithclarity,precision,andefficiencywhileavoidingthepitfallsof"chartjunk",graphicaldecoration,unintentional"opticalart",andotherformsofbadgrahicaldesign.
Guidelinesforchoosingamongtables,graphs,andtextaspresentationdevicesarealsodiscussed.
GraphicalexcellencewithSAS/GRAPHrequirestheuseofcustomizationfeaturessuchasNOTEandAXISstatements.
Examplesofcustomizedplotsandbarchartsthatillustratetheprinciplesofgraphicalexcellenceareprovided.
Thispaperisbasedonthebook"YourGuidetoSurveyResearchUsingtheSASSystem"publishedbySASInstituteBBUin1998.
Dr.
ArcherGravelyisDirectorofInstitutionalResearchandUniversityPlanningOfficeratUNCAsheville.
HehasusedSASforover17yearsandhasconductedapproximately100surveyresearchprojects.
Forthelasttenyears,hehastaughtworkshopsonSASandsurveyresearchatstate,regional,andnationalinstitutionalresearchconferences.
Hisbook,"YourGuidetoSurveyResearchUsingtheSASSystem"waspublishedbytheSASInstituteBooksbyUsersprogramin1998.
AnInternet-basedVisualRetrievalModelforBiologicalSequenceInformationDatabases50ISimonMengLin,M.
D.
;UniversityofNorthCarolina;ChapelHill,NCAstheHumanGenomeProject(HGP)advances,sequencesimilaritysearchesarebecomingroutineworkinbiomedicalresearch.
Therearetwomajordifficultiesthatarehinderingthisprocess:ValuablebiologicalsequenceinformationisspreadovertheInternetinaheterogeneousanddistributedcomputingenvironment.
Theresultofthequeryisalistthatmaycontainhundredsofstatisticallyranked,potentiallyhomologoussequences;viewingthisresultinatext-editorisexceedinglytimeconsumingandtedious.
AnInternet-basedintuitiveVisualSequenceRetrievalInterface(VSRI)isplannedtotackletheseproblems.
Eachresultantquerysequenceistreatedasanobject,andisvisualizedintoa3-Dspace;theend-userwillbeabletoclickontheobjectsinthe3-Dvisualspacetoaccessthegenequerydetailsdirectly.
Javaisusedastheprogramminglanguagetoprovideaneasygraphicalinterfaceandastrongcross-platformability,whileCORBAisusedtointegratethecriticalsteps:QuerytheFASTAserverorotherretrievalsystemtogetthesimilarobjectsandtherelationshipmatrixdescribingtheinter-objectdistances.
Projectingtheobjectsintoa3-DvisualspaceviaSASMDSprocedure.
Visualizingtheobjectsinthe3-DspaceandprovidinghyperlinkstothesequencedatabasesbyaJavaviewer.
Themodeldescribedhereisobject-orientedandawaitingmoreCORBA-compliantobjects.
SimonMengLinreceivedtheM.
D.
degreefromBeijingMedicalUniversityin1996andcompletedtheclinicalinternshipinBeijingHospital,specializedinmedicalinformatics.
HeiscurrentlyworkingtowardsthedoublemajorM.
Sc,degree(BiophysicsandPharmacology)attheUniversityofNorthCarolina,ChapelHill,andwillgraduatein1998.
Hehasabroadknowledgebaseandbackgroundinhealthscienceandcomputerprogramming.
Hisprimarycareerinterestistheutilizationofinformationtechnologyandbiostatisticsinpharmaceuticalandclinicalresearch.
Dr.
LinisamemberofSunJAVADeveloperConnection.
SeeSallyWork:TechniquesforDesigningandEvaluatingUserInterfaces50IJudyLoren;UNUMLifeInsuranceCompanyofAmericaSystemsareonlyasgoodastheiruserinterfaces.
Inputscreendesigncanaffectaccuracyandspeedofdataentry.
Navigationflowscanbeaidstoefficiency,ortheycangetinthewayofdoingrealwork.
Userswillfindwaystoworkaroundsystemsthatdon'tservetheirneeds.
ButhowcanyouknowinadvancethebestwaytomakeyoursystemserveitsusersThispaperdescribestwotechniquesusedatUNUMtodesignandevaluatetheinteractioncomponentofneworexistingsystems.
Paperprototypingandusabilitymethodologieshavebeenaroundforawhile,butUNUMisapplyingtheminnewwaystocreatebetter,moreeffectivesystems.
AsKevinFrye,thepioneerofthisapproachatUNUM,says,"Youpayforusabilityeitherway:byinvestinginpreventionofdefects,orbysupportingdefectsduringthelifeofthesystem.
"Nobiographyavailableatpresstime.
SAS/GRAPH-DressingUpanOldWorkhorse20CRobW.
Phelps;WakeForestUniversity,BaptistMedicalCenter;Winston-Salem,NCSAS/GRAPHhasalonghistoryofbeingabletogeneratealargequantityofoutputbyusingautomatedtechniqueslikeby-groupprocessingandprogrammaticannotation.
AlthoughdatacouldbeclearlypresentedusingGCHART,GPLOT,GMAP,etc.
,theresultingoutputhaslongbeencriticizedasbeingunimpressivebydesktoppublishingstandards.
TheadventofHTMLandWebtechnologyhashelpedtochangethewaypeoplerelatetoinformation.
Webpublishingandtheneedtogenerategraphsfordatawarehouseapplicationshasgivennewlifetoanoldreliableworkhorse.
ThispaperwilldemonstratesomeofthedesignprinciplesandtechniquesthathelptomakeWeb-enabledSAS/GRAPHnotonlyaworkhorsebutalsoacontenderintheraceforbettervisualizationofqualitativeinformation.
WorkfromthedevelopmentofabrowserbasedIntranetdatawarehouseapplication(DSSI-DecisionSupportSystemIntranet)willbeusedasexamples.
EmphasiswillbegiventothedesignprinciplesusedtodisplayinformationandthetechniquesusingamixtureofWebtechnologiesandSAS/GRAPHthatproducetheresults.
RobertPhelpsisamanagerofsystemsdevelopmentatWakeForestUniversityBaptistMedicalCenter.
HehasbeenaSASprogrammerforover15years.
Rob'smajorareaofinterestisindatawarehouseapplicationsandinusingavarietyoftechnologiestoproduceintegratedsystems.
HismajorworkincludesaDecisionSupportSystemandanEISsystemthathehelpeddeployattheMedicalCenter.
RobhaspresentedforseveralIDSConferenceApplicationShowcaseatSASInstituteandhasservedonadvisoryteamsforSASaspartoftheApplicationDevelopmentCouncilandaspartoftheSAS/GRAPHsoftwareforum.
CombatingChartOverloadwithGroupControlCharts20CDarrenStewartandEricBrinsfield;MeridianSoftware,Inc.
;Raleigh,NCTraditionalcontrolchartingtechniques,suchasShewhartcharts,areusedtotrackchangesinonevariableovertime.
Often,whenmonitoringamanufacturingprocess,morethanonevariableisneededtorepresentthestateofaprocessatanygivenpointintime.
Forexample,tomonitoruniformityofthickness,youmusttakeseparatemeasurementsatvariouslocationsacrossamanufacturedunit.
Traditionalchartingmethodscallforaseparatechartforeachlocation.
"Groupcharts",however,areusedforplottingmultiplecharacteristicsonthesamechart.
Groupchartsmakecomparisonsamongthemultiplecharacteristicsmucheasier,whilereducingtoonethenumberofchartsneededtomonitoraparticularprocess.
Groupchartscanbeusedasexploratorytoolsorasformalcontrolchartswithstatisticalcontrollimits.
WewilldemonstratehowSAS/QCandSAS/GRAPHcanbeusedtocreatetheseinformativecharts.
DarrenStewartisastatisticalprogrammerwithMeridianSoftware,Inc.
inRaleigh,NC.
HehasaMaster'sdegreeinStatisticsfromNorthCarolinaStateUniversityinRaleighandaBachelor'sdegreeinMathematicalSciencesfromtheUniversityofDelawareinNewark,DE.
EricBrinsfieldisPresidentofMeridianSoftware,Inc.
,acustomsoftwaredevelopmentfirm.
HehasbeenusingSASsoftwaresince1977andspecializesinprojectmanagement,softwaresystemdesign,databasedesign,andGUIdesign.
EricearnedhisBSfromDukeUniversityandhisMSfromNorthCarolinaStateUniversity.
PCHands-OnWorkshopsSectionChairs:DanaRafieeDestinyCorp.
Wethersfield,CTAllPCHands-OnWorkshopswillbepresentedbyDanaRafiee;DestinyCorp.
;Wethersfield,CT.
Admittancewillbebyticket.
Theticketswillbedistributedattheregistrationboothonafirstcome,firstservedbasis.
Allworkshopsare80minuteslong.
DanaRafieeisarecognizedauthorityontheMainframeandMicroSASSoftwareandIBMenvironmentswithmanyyearsofexperienceintheareasofapplicationsdevelopmentanddesignin4thGenerationLanguages,OperatingSystems,Communications,Consulting,andTraining.
HisspecificareasofexpertiseincludeSAS,MVS,JCL,IBMUtilities,CMS,TSO,ISPF,UNIX,VMSandNovell.
HehasworkedaccessingdatawithSASSoftwarefromrelationaldatabasessuchasDB2,Datacom,Oracle,andSybase.
Mr.
RafieehasbeenaconsultantandtraineronmanyapplicationsdevelopmentprojectsandimplementationsforseveralconcernsincludingAetna,Inc.
,StateofConnecticut,HartfordSteamBoilerInspectionandInsurance,U.
S.
Government,AmericanExpress,BankofNewEngland,U.
S.
DepartmentofTransportation,NASA,Bradlees,Prudential,U.
S.
Army,USAirWays,OceanSpray,BostonGas,EUAServiceCorp.
,AMA,GTEShareholderServices,RonsonManagementCorporation,UnisysInc.
,BankofBoston,FirstNationalBankofMaryland,McClellanAirForceBase,Bristol-MeyersSquibb,NECA,DEC,andmanyothers.
HeisalsoanactivememberoftheNorthEastSASUsersGroupandisaninvitedspeakeratallregionalconferencesandSUGI.
MergeProcessinginSASSoftwareThisworkshopisdesignedtodemonstratesimpletoadvancedmatchmergeprocessing.
Theuseofcontributionvariables(IN=),selectionofdataandmanipulationintheprogramdatavectorwillbediscussed.
PROCTabulateBasicsAttendeeswillgainexperiencewiththeTabulateprocedurebybuildingitfromscratch.
Class,Var,andTablestatements,alongwithoperatorswillbedemonstratedindetail.
InteractivePROCReportThissessionwillteachattendeeshowtodevelopreportsinaninteractiveenvironmentwithoutwritingcode.
Thereportcanbeviewedasitisdevelopedandsavedforfutureuse.
MovingSASInformationtoWord/ExcelusingDDEThisworkshopwilldemonstratehowtotakedataoutofSAStoexternalapplicationssuchasWordorExcel.
HandsonDDEapplicationswillbebuilt.
BeginningMacrosThisworkshopwillintroducemacrovariables,callsymput,andsymget,alongwith%macro,%mendbundlesofcode.
Attendeeswillunderstandhowtomacro-izeprogramsforsimpler,moreefficientprocessing.
SQLBasicsAttendeeswillgethandsonexperiencewritingProcSQLcode,typicallyusedtosimplifyextractionandsummarizationofdata.
SQLcodewillbebuiltfromsimpleselectstocomplexjoins.
PostersSectionChairs:EricBrinsfieldMeridianSoftware,Inc.
Raleigh,NCMattBeckerSTATPROBE,Inc.
AnnArbor,MIDesigningAccessibleHelpSystemsCCathyBrinsfield;MeridianSoftware,Inc.
;Raleigh,NCSASGUIapplicationscanbenefitgreatlyfromwell-designed,integratedhelpsystems.
ThisposterusesWinHelptoshowyouhowtodesignyourhelpsystemusinggranularinformationandprogressivedisclosure.
HowmanytimeshaveyouopenedthehelpforanapplicationonlytobeoverwhelmedbytheamountofinformationyoumustsiftthroughtogettothepieceyouneedOryouhavespentsomuchtimeclickingonlinksthatyouareoffsomewhereincyberspaceThisapproachseparatestaskinformationforawindowfromtheoverviewinformationausermayneedtounderstandthetasks.
Thehelpforeachwindowpresentstheuserwithaselectablelistoftasksandassistancewithanynavigationaltools.
Theusercanlinktohelpforthetask,oraccessoverviewinformationthatprovidesabroaderperspectiveonhowthetaskinthewindowfitsintotheoverallpurposeoftheapplication.
CathyBrinsfieldistheInformationDeveloperforMeridianSoftware,Inc.
,wheresheisresponsiblefordesigning,developing,andstandardizingdocumentsforclientprojectsinbothhardcopyandonlineformats.
ShealsodevelopsandmaintainsmarketingandinternaldocumentsforMeridianSoftware,includingtheWebsite,informationpackets,andthecompanyIntranet.
PriortojoiningMeridianSoftware,CathywasatSASInstitutefor10years.
ShewastheCourseDevelopmentSupportmanagerintheProfessionalServicesdivision,developingcoursematerialsfortheInstitute'strainingcourses.
CathyhasaBAfromUCLAinPoliticalScience.
SelectivelyDownloadingFilesfromRemotePlatformsCJohnCharlesGober;CommerceDept.
/BureauoftheCensus;Alexandria,VALawrenceAltmayer;U.
S.
BureauoftheCensus;Washington,DCTheBureauoftheCensusisthepreeminentcollectorandprovideroftimely,relevant,andqualitydataaboutthepeopleandeconomyoftheUnitedStates.
Thisdatacanbestoredinavarietyofformatsandacrossmultipleplatforms.
Fromtimetotimesimpleapplicationsneedtobedeveloptoaidinternalstaffmembersintheretrievalandpresentationofthisdata.
Theapplicationdescribedhere,eventhoughsimple,usesmanySAStechniqueswhichcouldbeusedeitherseparatelyortogetherandappliedacrossmanyareasofstudy.
JohnGoberisemployedbytheBureauoftheCensus,DemographicSurveysDivisionwhereheisinpartresponsiblefortheCurrentPopulationSurvey.
HehasalmosttwodecadesofSASexperienceonMainframe,PC,andworkstationenvironmentsandspecializesindatacleaning,extraction,manipulation,andtransfer.
Johnisproficientinthemacrolanguage,applicationdevelopment,andhaspresentedpapersandpostersatSUGI,NESUG,andSESUG.
LawrenceAltmayerhasbeenwiththeU.
S.
CensusBureaufornineteenyearsandisacomputerspecialist.
HehasmorethaneightyearsSASprogrammingexperience,mostrecentlywithmacros.
HeiscurrentlyusingSAStoprocessNationalCrimeVictimizationSurveydata.
HisprogrammingexperiencehasbeenmainlyintheVMS,andmorerecentlyUNIX,operatingsystems.
HehasaBAinStatisticsfromtheUniv.
ofBuffalo,andMasterofAppliedStatisticsfromOhioStateUniversity.
AnAnalysisofSASCodingTechniquesCCarlR.
Haske,Ph.
D.
;STATPROBE,Inc.
;AnnArbor,MIAllSASprogrammersdevelopapersonalbagoftricksforsolvingcomplexprogrammingproblems.
Agoodsetofreusableprogrammingtoolswillincludeusefulutilitiesthatcanbeappliedrepeatedlyinvirtuallyanyapplication.
IntheSASlanguage,asinanyotherlanguageordevelopmentplatform,thereisusuallymorethanonewaytocodeasolutiontoaparticularproblem-forexample,thereareseveralapproachestodeterminingtheexistenceofadatafile,suchasuseofPROCCONTENTS,PROCSQLwiththeDICTIONARYtables,orSCLfunctions-andeachmethodwillhaveitsownadvantagesinreadability,maintainability,conciseness,andperformance.
Thispaperexaminesanumberofdifferentmethods,whichuseanassortmentoftechniques,forcodingasetofSASutilities.
Importantattributesofthemethodsaremeasured:performance,bybenchmarktestresults;concisenessandmaintainability,bycontrastofthemethodswitheachother;andreadabilityandappeal,byresultsofapollofSASprogrammers.
CarlHaskereceivedhisPh.
D.
inMathematicsfromRiceUniversityandservesasDirectoroftheResearchInformationSystemsDepartmentofSTATPROBE,Inc.
,acontractresearchorganizationinAnnArbor,Michigan.
Carlisinvolvedintheprocessclassificationofclinicaldatamanagementandreportgenerationinordertostandardizeandintegratesystemsthatcondensethereportdevelopmentprocess.
HehasbeenaSASapplicationsdeveloperfortenyearsandhasgivenpresentationsatseveralSUGIconferencesandregionalSASusergroupconferences.
UsingSAStoCalculateTestsofCliff'sDeltaCKristineY.
Hogarty,JeffreyD.
Kromrey;UniversityofSouthFlorida;Tampa,FLThispresentationwilldemonstratecodewritteninSAS/IMLthatcalculatesthreeestimatesformakingstatisticalinferencesregardingtheDeltastatistic.
TheDeltastatistic(Cliff,1993)maybeusedwhentestingnullhypothesesaboutgroupdifferencesonordinallevelmeasurements.
Thisstatisticandtheinferentialmethodsassociatedwithitareaddressedbyconsideringdataarrangedinadominancematrix.
Theprogramcalculatesthemarginalvaluesofthedominancematrixthatareusedintheinferentialstatisticsassociatedwithd(sampleestimateofthepopulationparameter).
Thethreemethodsofinferencefordincludetwoestimatesofthevarianceofd,andtheconfidencebandaroundthesamplevalueofd.
Thedeltastatistichasbeenrecommendedfortheanalysisofordinalleveldatabecauseofincreasedpower(relativetothechi-squaretest)orincreasedrobustness(relativetotestsofmeandifferences).
ThepresentationwillprovideademonstrationoftheSAS/IMLcodeandexamplesofapplicationofthecodetosimulationstudiesinstatistics.
KristineY.
HogartyisadoctoralstudentintheDepartmentofEducationMeasurementandResearch.
JeffreyD.
KromreyisanAssociateProfessorintheDepartmentofEducationalMeasurementandResearch.
X-12-Graph:VisualDiagnosticsforTimeSeriesModelingandSeasonalAdjustmentCCatherineC.
Hood;BureauoftheCensus;Washington,DCX-12-GraphisaSASprogramdevelopedattheCensusBureautoprovidegraphicaldiagnosticsfortheBureau'sX-12-ARIMAprogram,apublicly-availableprogramusedworldwidefortimeseriesmodelingandseasonaladjustment.
X-12-Graphcomesintwoversions,interactiveandbatch.
BothversionsareeasytouseandrequirenopreviousSASexperiencefromourusers.
TheinteractiveprogramusesSAS/AFandScreenControlLanguage,withSAS/GRAPH'sGPLOTandGREPLAYprocedures,templates,andannotatedatasets.
WehaveversionsforbothPCandUNIX.
X-12-Graphallowstheuserto:selectfrommorethan12typesofgraphscomparedifferentX-12ARIMAadjustmentschooseoptionsforthegraphs,suchasstartingandendingdates,scale,andcolorsassembleacombinationgraphfrompreviouslyproducedgraphsThebatchprogramusesSASMacrosandsendsselectedgraphsforanynumberofseriesdirectlytoaprinter.
Itrunsonanyplatform,includingplatformswithoutaGraphicalUserInterface.
CatherineHoodcurrentlyworksontheTimeSeriesStaffintheStatisticalResearchDivisionoftheCensusBureau.
ShehasbeenprogramminginSASforover10years.
GeneratingItemResponsesBasedonMultidimensionalItemResponseTheoryCJeffreyD.
Kromrey,CynthiaG.
Parshall,WalterM.
Chason,QingYi;UniversityofSouthFlorida;Tampa,FLThepurposeofthispresentationistodemonstratecodewritteninSAS/IMLthatgeneratesexaminees'itemresponses(0/1s)basedonmultidimensionalitemresponsetheory(MIRT)model.
ThisprogramreadsinafileofcalibrateditemparametersfromtheNOHARMcomputerprogram.
NOHARMcalibratesitemsparametersonmultidimensionalabilityspaces.
TheSAS/IMLprogramcalculatestheprobabilityofanexamineeobtainacorrectresponsebasedontheMIRTmodel,thencomparesthisprobabilitywithauniformrandomnumbertodecidethisexaminee'sitemresponse.
Iftheprobabilityislargerthanorequaltotherandomnumber,thisexamineeiscreditedacorrectresponse(i.
e.
,1)otherwise,azero.
Thisprogramallowsusertospecifythenumberofexamineesandthenumberofitemstowhichitemresponsesgenerated.
TheSAS/IMLcodewillbepresentedinthepresentation.
JeffreyD.
KromreyisanAssociateProfessorintheDepartmentofEducationalMeasurementandResearch.
CynthiaG.
ParshallistheSeniorPsychometricianattheInstituteforInstructionalResearchandPractice.
WalterM.
ChasonisadoctoralcandidateintheDepartmentofEducationalMeasurementandResearch.
QingYiisadoctoralcandidateintheDepartmentofEducationMeasurementandResearch.
ModernPsychometricTheory:UsingSAStoCalculateIRTAbilityEstimatesCJeffreyD.
Kromrey,CynthiaG.
Parshall,WalterM.
Chason,QingYi;UniversityofSouthFlorida;Tampa,FLThispresentationwilldemonstratecodewritteninSAS/IMLthatprovidesmaximumlikelihoodestimatesofexamineeabilityunderthe1,2,or3parameterlogisticmodelsusedinmodernpsychometrictheory.
Theprogramreadsafileofexamineescoredresponses(1/0)toasetoftestitemsandestimatesofparametersfortheitemsthatareobtainedusingtheBILOGprogram.
TheprogramimplementstheNewton-Raphsonalgorithmtoobtainmaximumlikelihoodestimatesofexamineeability,thenoutputsafileofabilityestimatesandwarningflagsforexamineeswithresponsepatternsthatdidnotprovideconvergenceofthealgorithm.
Theprogramiswrittensothattheusermayspecifytheconvergencecriterionormaximumnumberofiterationsfortheestimation.
Modernpsychometrictheoryevaluatesexamineeresponsestotestitemsasprobabilisticmodelsbasedonlogisticfunctionsofitemparameters(difficulty,discrimination,andguessing)andexamineeparameters(abilities).
Thebenefitsofsuchmodelsincludecomputeradaptivetesting,advancesintestequating,andnewdevelopmentsinitembiasanalysis.
ThepresentationwillprovideadescriptionoftheSAS/IMLcodeandexamplesofapplicationsofthecodetosimulationstudiesinpsychometrics.
JeffreyD.
KromreyisanAssociateProfessorintheDepartmentofEducationalMeasurementandResearch.
CynthiaG.
ParshallistheSeniorPsychometricianattheInstituteforInstructionalResearchandPractice.
WalterM.
ChasonisadoctoralcandidateintheDepartmentofEducationalMeasurementandResearch.
QingYiisadoctoralcandidateintheDepartmentofEducationMeasurementandResearch.
EffectivePosterPresentationsforSASUserGroupConferences:RecommendationsandTechniquesCHelen-JeanTalbott;CommercialCreditCorporation;Baltimore,MDPostersessionsatSAS*UserGroupConferencesprovideanexcellentopportunitytopresentinformationsuchasdetailedcodeandoutputinadisplayformat,yettheycanchallengethosewhomaybeuncertainaboutposterpreparation.
Thepurposeofthispaperistoprovideguidanceonhowtocarryoutposterideasclearlyandeffectivelywithaminimumamountoftimeandeffort.
Practicalsuggestionsaregivenonposterdesign,materials,color,lettering,graphics,andconstructionmethods.
AlthoughtherecommendationsandtechniquespresentedfocusonpreparationofpostersforSASUserGroupconferences,theyareapplicabletomanyotherendeavorssuchasbusinesspresentations,showcasedisplays,scientificexhibits,and(forthosewithchildren)sciencefairbackboards.
Helen-JeanTalbottisManagerofCreditPolicyMISatCommercialCreditCorporation.
HerareasofSASexpertiseareBASESASsoftwareandSAS/FSP,withspecializationindevelopingandmanagingtrackingsystems.
Helen-JeanhasBSandMSdegreesinagronomyfromtheUniversityofMaryland.
ShehasbeenaSASuserformorethantwentyyears.
In1997,shewasConferenceCo-chairoftheNorthEastSASUsersGroup,Inc.
conferenceheldinBaltimore,Marylandwhichhadover1000attendees.
HowToConvertASASDataSetToAQuickenQIFFormatFileCHelen-JeanTalbott;CommercialCreditCorporation;Baltimore,MDRegistrationactivitiesfortheNorthEastSASUsersGroup(NESUG)annualconferencemakeuseofQuickenandSASsoftwareonpersonalcomputers.
Quickensoftwareisveryusefulformanagingfinancialdataforhomeandsmallbusinessapplications.
SAS/FSPandBaseSASsoftwareareveryeffectiveforvalidateddataentry,datamanagement,andreportproduction.
ThedifficultyliesintransferringdatafromSASdatasetstoQuickenfiles.
InordertoimporttransactiondatafromsoftwareotherthanQuicken,thedatamustbeavailableasanASCIIfileinQuickenInterchangeFormat(QIF).
TheQIFfileformatisnotoneofthestandarddataconversionformatsforSASsoftwareatthistime.
ThisposterdemonstrateshowtowriteSASprogramcodetocreateanASCIIfileinQIFfileformatfromaSASdataset.
Helen-JeanTalbottisManagerofCreditPolicyMISatCommercialCreditCorporation.
HerareasofSASexpertiseareBASESASsoftwareandSAS/FSP,withspecializationindevelopingandmanagingtrackingsystems.
Helen-JeanhasBSandMSdegreesinagronomyfromtheUniversityofMaryland.
ShehasbeenaSASuserformorethantwentyyears.
In1997,shewasConferenceCo-chairoftheNorthEastSASUsersGroup,Inc.
conferenceheldinBaltimore,Marylandwhichhadover1000attendees.
HowtoSortProductionReportsPriortoPrintingCHelen-JeanTalbott;CommercialCreditCorporation;Baltimore,MDEarlR.
Westerlund;EastmanKodakCorporation;Rochester,NYEachmonththeCreditPolicyDepartmentofCommercialCreditproducesabout25differentreportstosendtothe202district,48region,and8divisionmanagers.
ThesereportsareproducedusingbaseSASsoftwareinprogramsruninaproductionenvironmentunderMVS.
Eachdistrictmanagerreceivesportionsofthereportsspecificforthatdistrict.
Similarly,regionanddivisionmanagersreceiveportionsspecificforthedistrictswithinregionsandforregionswithindivision.
Duetothesizeofthesereportsandnumberofrecipients,itwouldtake2daysforapersontosortandlabelthemfordistribution.
Therewasaneedforanautomaticmethodtoprintreportsinorderbydistrictsothattheywouldnothavetobesortedmanually.
ThepurposeofthisposteristoshowhowtocreateSASdatasetsandreportmodulesandtousetheminconjunctionwiththeSASmacrolanguagetoproducereportssortedindistrictorderpriortoprinting.
Helen-JeanTalbottisManagerofCreditPolicyMISatCommercialCreditCorporation.
HerareasofSASexpertiseareBASESASsoftwareandSAS/FSP,withspecializationindevelopingandmanagingtrackingsystems.
Helen-JeanhasBSandMSdegreesinagronomyfromtheUniversityofMaryland.
ShehasbeenaSASuserformorethantwentyyears.
In1997,shewasConferenceCo-chairoftheNorthEastSASUsersGroup,Inc.
conferenceheldinBaltimore,Marylandwhichhadover1000attendees.
AreYouLosingRecords&Don'tKnowItTEXTMERG:ASASMacrothatHandlesHiddenProblemsinMany-to-OneMergesCDebraH.
Weiner;FamilyHealthInternational;ResearchTrianglePark,NCWhendoingamany-to-onemerge,onecanloserecordswithoutknowingit.
Forexample,toassignclassificationcodestotextfields,wemergeaSASdatasetcontainingatextfield("devicemoved&Ihadtroublegettingitout")withaSASdatasetcontainingclassificationcodesforthatfield,mergingonthetextvariable.
Wefoundthatif(a)asinglefieldhadmorethanonecode("devicedislodged","problemremovingdevice")or(b)thesametextexistedinmultiplerecords(e.
g.
thesameproblemwasreportedmorethanonce)SASwillnotalwaysreturnthecorrectnumberofrecords.
Noerrororwarningmessagesaregiven.
ThispresentationdescribesaSASmacrothatperformsaccuratemergeswhetherornotamany-to-oneproblemexists.
Themacrocanbeeasilymodifiedtohandlemergesonnumericvariables.
DebraWeiner,MPH,isastatisticianatFamilyHealthInternational,ResearchTrianglePark,NC,whohasbeenprogramminginSASsince1989.
SerendipitySectionChairs:MichaelRiddleQuintiles,Inc.
RTP,NCHowardSchreierU.
S.
Dept.
ofCommerceWashington,DCCreatingNumericFormatsBasedonPrecision,NotMagnitude20CJohnR.
Gerlach;MaximGroup;PlymouthMeeting,PASupposeyouneedtoknowthenaturalformat,indicatingfullprecision,ofoneormorecontinuousnumericvariables.
Perhapsyouneedtoproduceacodebookthatindicateslengthandformat,notlikethoseattributesfoundintheCONTENTSprocedure.
Or,perhaps,youneedtowritearawdatafilehavingarecordlayoutthatrequiresoptimalprecision.
ThispaperdiscussesnumericdatainSASandexplainsarobusttoolthatcreatesapictureformatforeachnumericvariableinaSASdataset.
JohnGerlachhasbeenusingtheSASSystemforover10years,specializingintheMacroLanguageandrelationaldatabaseissues.
Johnhasworkedmostlyinthehealthindustry,involvingepidemiology,pharmacology,andclinicaltrials.
HehaswrittenandtaughtSASseminarsaswell.
SurveyResearchUsingSAS:TricksoftheTrade50IDr.
ArcherGravely;UNCAsheville;Asheville,NCThispaperwillillustratetheuseofSAStoconductmailandtelephonesurveyresearchprojectsbasedonprinciplesofefficientsurveypractice.
SAStechniquesforaccomplishingthefollowingsurveyadministrationtaskswillbereviewed:calculatingsamplesizerequirementsanderrorratesselectingrandomsamplestechniquesforgeneratingpersonalizedsurveycommunicationstoincludeadvancedcharacterdatamanipulationtechniquesproceduresfortrackingrespondentsandreportingresponseratesThissessionwillalsoreviewtheuseofPROCTABULATEtoreportpercentagesandtricksforcomputingpercentageswithmeans.
Thispaperisbasedonthebook"YourGuidetoSurveyResearchUsingtheSASSystem"publishedbySASInstituteBBUin1998.
Dr.
ArcherGravelyisDirectorofInstitutionalResearchandUniversityPlanningOfficeratUNCAsheville.
HehasusedSASforover17yearsandhasconductedapproximately100surveyresearchprojects.
Forthelasttenyears,hehastaughtworkshopsonSASandsurveyresearchatstate,regional,andnationalinstitutionalresearchconferences.
Hisbook,"YourGuidetoSurveyResearchUsingtheSASSystem"waspublishedbytheSASInstituteBooksbyUsersprogramin1998.
SASConferences:AViewFromtheInside50IModerator:NeilHowardPanelists:notavailableatpresstimeConferenceslikeSESUGandSUGIdon'tjusthappen.
TheyaretheculminationofagreatdealofthoughtandeffortonthepartofleaderswithintheSASusercommunity.
WehavegatheredapanelofveteranSASconferenceorganizerswhowilldemystifytheprocess,describetheupsanddownstheyhaveexperienced,andcontemplatefuturedirections.
NeilHowardwasconferencechairforSUGI20inOrlando(1995).
ShehasbeenaSASusersince1978,primarilyinhealth/medical/epidemiologic/clinicalapplications.
NeiltaughtnumerouscoursesasacontractinstructorforSASInstituteforsevenyears.
ShehashelpedtoorganizelocalSASusersgroupsintheWashington,DCarea,NorthTexas,andColorado,andhasbeenactiveatdifferenttimesintheNortheastandSouthCentralregionalgroups.
Otherbiographiesnotavailableatpresstime.
DetectionofFraudulentMedicareProvidersintheMedicareProgramUsingSASSoftware20CChuanchiehHsu,Ph.
D.
,J.
MichaelHardin,Ph.
D.
,RobertOrr,andDebbieSartain,R.
N.
;BlueCrossandBlueShieldofAlabamaHundredofmilliondollarshavebeenillegallycollectedorstolenbydishonestphysicians,hospitaladministrators,nursinghome,andotherprovidersofmedicalservicesandsupplieseveryyear.
Medicare/Medicaidfraudandabuseoccurinallstates.
ThemostimportanttopicinMedicare/Medicaidprogramtodayishowtoidentifythefraudandtorecoupthemoneybackfromthem.
ThepurposeofthispaperistodemonstratehowtouseSAS/Macro,SAS/STATandSAS/GRAPHsoftwaretodetectfraudinMedicarePartAprogram.
ChuanchiehHsu,Ph.
D.
iscurrentlyanindependent,statistical,andSASconsultant.
HereceivedhisPh.
D.
inBiostatisticsfromtheUniversityofAlabamaatBirmingham(UAB)in1995.
HealsoreceivedhisMSinBiostatisticsfromUABin1991.
DuringhisstudiesatUAB,Dr.
HsuworkedasaresearchassociateandstatisticianwherehewasresponsiblefordatamanagementandstatisticalprogrammingforseveralverylargeNIHfundedresearchprojects.
HisareasofexpertiseincludecomputationaltechniquesforstatisticalapplicationsandSASapplicationprogramming.
Heistheauthororco-authorofanumberofpapers.
J.
MichaelHardin,Ph.
D.
isProfessorofHealthInformaticsandBiostatisticsattheUniversityofAlabamaatBirmingham.
Dr.
Hardin'sinterestisintheapplicationofstatisticaltechniquestohealthserviceresearch.
Inparticular,hehasbeeninterestedinusingstatisticalprocedurestoassistadministratorstodetectpotentiallyaberrantbillingproceduresandfraudulentbehaviors.
Dr.
HardinisalsoactivelyinvolvedintheapplicationofDataMiningtechniquestotheHealthcareindustry.
Heoftenprovidesconsultationtohealthcareandotherorganizationsintheareasofstatisticsandinformationtechnologies.
HeisaSASQualityPartner.
RobertOrrisManager,PartAfortheChahabaGovernmentBenefitAdministrators:ADivisionofBlueCrossandBlueShieldofAlabama.
Mr.
Orrhasover15yearsexperiencewithBlueCrossandwiththeMedicareprogram.
HeisactivelyinvolvedindataanalysisissuesandishimselfaSASprogrammer.
DebraK.
Sartain,R.
N.
isManager,MedicareMedicalReviewfortheChahabaGovernmentBenefitAdministrators.
Shehas20yearsexperienceinthehealthcarefield.
Forthelastthreeyears,shehasconcentratedontheuseofdataanalysistoassistmedicalreviewersinselectingaberrantbillingandutilizationbyproviders.
Shehasattendednumeroustrainingcoursesondatadrilldownsoftwareandonstatisticalmethodsforfrauddetection.
IndexedTableLookupAgainstMultipleDataSets20CLt.
Col.
DougMcAllaster;USArmy;Washington,DCThispaperdemonstratesindexedtablelookupagainstmultipledatasets.
Thispaperisgivenasanextensionofanexample3.
11intheSASmanual"CombiningandModifyingSASDataSets:Examples".
ThepaperpresentsatypicalexampleoffindingthemostrecentgoodobservationfromaseriesofhistoricalSASdatasets.
Thepaperdemonstratesthebenefitsofusingindicesonlegacydatasets.
ItalsoshowstheimportanceoftheautomaticSASvariable,_IORC_,anditspotentialpitfalls.
Itprovidesanexcellentapplicationofanexplicitreturnstatementaswellastheimportanceofproperinitialization.
Lt.
Col.
DougMcAllasterisanoperationsresearcher(statistician,programmer,andanalyst)atHQUSArmyPentagon,OfficeoftheDeputyChiefofStaffforPersonnel.
DoughasbeenusingSASforeightyearsinhisworkmanagingofficerpersonnelandbillets.
DoughasaBachelor'sdegreeincivilengineeringfromUSMilitaryAcademyatWestPointandaMaster'sdegreeinoperationsresearchfromtheUniversityofTexasatAustin.
HehasalsotakengraduatestatisticscoursesatUniversityofKansasandGeorgeMasonUniversity.
CreatinganADPCenterofExcellence:AMiltonianApproachofLookingThroughTwoDecadesof"VisibleDarkness"50IPeterParker;U.
S.
Dept.
ofCommerce;Washington,DCAfteralmosttwodecadesofworkingwithlargethensmallcomputers,primarilywithSASsoftware,IstepbackfrommymonitorandponderwhatmakesmyADPshopaCenterforExcellence.
Inthispaper,I'llinquireonwhatmostbecomesacomputerguru,anunusualtypeofprofessional.
Aswell,Ioffermytruthsonhowtohandleusers,management,andtheconstantlyreinventedtechnology.
IwillusenotesthatIhaveamassedthroughoutmycareer,nowatitsmidpoint.
Ratherthantakingadrytotallytechnicalapproach,Ipreferamoreliterarystylisticone,drawingonJohnMilton's"ParadiseLost"andotherclassicliteratureasdescriptiveaidstomyargument.
Myobservationsmayhelpyoukeepuserssatisfiedandplanaprosperouscareerininformationprocessingandofficeautomation.
PeterParkerhasbeenprogrammingsince1979,mostlyinSASsoftware,andisproficientinmosthardwareandsoftware.
HerunsanADPshopintheU.
S.
DepartmentofCommerce.
Aswell,herunsaconsultingfirm,PerfectProgrammingEnterprises,providingprogramming(againprimarilySASsoftware),OfficeAutomation,andInternetsupport.
PeterhasBAandMAdegreesinEconomics.
HehaspresentedotherpapersforSASconferences,andtheycanbeaccessedthroughhispersonalhomepage,http://members.
aol.
com/pparker923.
A"BigPicture"DataDiagnosticProgramforClinicalTrialsData20CDorothyE.
PughandIndraniNandy;ClinTrialsResearch,Inc.
;RTP,NCOneofthefirstthingsthoseperformingclinicaltrialsdatacleaningneedtodoistogetanoverviewoftherelationshipsofthevisitsequencenumbersandthedatesatwhichthevariousassessmentsassociatedwiththosevisitstookplace.
TheSASprogrampresentedherehelpsshowhowtocapturetherelativelysparseanomaliesintheserelationshipsbycomparingthedateofeachassessmenttooneormoreuserspecifiedreferencedates.
Thistechniquecanbeusedto:1)determinewhichassessment(s)shouldbeusedtodeterminethepatient'sfirstandlastdateinaprotocoloronstudydrug,2)determinewhichassessmentsweretypicallyperformedatunusualtimes,3)catchobviousdataerrors,and4)spotpossiblyseriousprotocolviolations.
DorothyE.
PughisaSeniorSASProgrammer/AnalystatClinTrialsResearchInc.
Inadditiontoprogramming,shedevelopsdetailedprogrammingspecificationsbasedondataanalysisplansandsupervisestheirimplementationwiththeaidofaprogrammingchecklistandQCprogrammingtoolsshehasdeveloped.
Sheco-authoredtheZybanFinalStudyReportleadingtothedrug'sFDAapproval.
Shehasspecialexpertiseinclinicaltrials,andinusingtheSASMacroLanguage,SAS/GRAPH,andPROCREPORT.
IndraniNandywasborninCalcutta,India.
ShecompletedherBachelor'sandMaster'sinStatisticsatIndianStatisticalInstitute,Calcutta.
ShereceivedherPh.
D.
fromtheStateUniversityofNewYorkatStonyBrookin1992.
ShejoinedtheLouisianaStateUniversityMedicalCenterasstatistician,andworkedasInstructorandAssistantProfessorinBiometryforeightyears.
ThereshetaughtstatisticsandSAScourses,collaboratedwithfacultyonpublications,anddevelopedcustomizedprogramsinSAStogradescantrontests.
ShejoinedClinTrialsResearchInc.
in1997asseniorbiostatistician.
Herresponsibilitiesincludedesigningclinicaltrialsandanalyzingdata.
ADayintheLife:TheSASSoftwareConsultant50IModerator:S.
DavidRiba;JADETech,Inc.
;Clearwater,FLPanelists:notavailableatpresstimeWhatdoesittaketobesuccessfulasanindependentSASconsultantWhatarethepracticalconcernsinconductingaSASconsultingpracticeWhatshouldclientsunderstandWehavegatheredapanelofdistinguishedSASconsultantstotalkabouttheissuestheyfaceasindependents.
S.
DavidRibahasprovidedindependentSASconsultingandtrainingservicesforovertenyears.
Nootherbiographiesavailableatpresstime.
SQLQueryWindowClasses:HowToIncorporateTheSQLWhereExpressionBuilderClassInCustomSAS/AFApplications20CChristopherA.
Roper;QualexConsultingServices;Fairfax,VASQL(StructuredQueryLanguage)isthestandardlanguageusedforqueryingallmajordatabases,includingSYBASE,ORACLE,REDBRICK,DB2,andothers.
TheSASQuerywindowcreatesSQLexpressionsusingSAS/AFClassesthatareavailabletotheSAS/AFdeveloper.
OneoftheseclassentriesistheWhereClauseBuilderClass,namedQWWHERE.
CLASSintheSASHELP.
SQLcatalog.
ThisistheclassusedbyboththeQuerywindowandSAS/ASSISTtobuildSQLwhereclauses.
ThisclassmaybecalledbyanySAS/AFentrytopresentthesameinterfacetheSASQuerywindowusestobuildwhereclausesforSQLqueries.
ThispaperwillcoverwhattheWhereClauseBuilderClassis,howtoincorporateitintoaSAS/AFapplication,andthenuancesofusingthisclasseffectively.
ChristopherA.
RoperisaSeniorSystemsConsultantwithQualexConsultingServices,Inc.
HisareasofexpertiseincludeBaseSAS,SAS/AF,SAS/FSP,Macros,Frame,andSCL,andhehasbeendevelopingSASapplicationsforovertenyears.
ChriswonBestContributedPaperinApplicationsDevelopmentatlastyear'sWUSSconference,andisafrequentpresenteratSASusergroupsacrosstheUnitedStatesandEurope.
ChrishasaBSinBusinessAdministrationwithaConcentrationinEconomicsfromChristopherNewportUniversity.
SQLQueryWindowClasses:HowToAddTheSQLCalculatedColumnExpressionBuilderClassInCustomSAS/AFApplications20CChristopherA.
Roper;QualexConsultingServices;Fairfax,VASQL(StructuredQueryLanguage)isthestandardlanguageusedforqueryingallmajordatabases,includingSYBASE,ORACLE,REDBRICK,DB2,andothers.
TheSASQuerywindowcreatesSQLexpressionsusingSAS/AFClassesthatareavailabletotheSAS/AFdeveloper.
OneoftheseclassentriesistheExpressionBuilderClass,namedQWCLEXPR.
CLASSintheSASHELP.
SQLcatalog.
ThisistheclassusedbyboththeQuerywindowandSAS/ASSISTtocreatecalculatedcolumnsusingSQL.
ThisclassmaybecalledbyanySAS/AFentrytopresentthesameinterfacetheSASQuerywindowusestobuildcalculatedcolumnsforSQLqueries.
ThispaperwillcoverwhattheExpressionBuilderClassis,howtoincorporateitintoaSAS/AFapplication,andthenuancesofusingthisclasseffectively.
ChristopherA.
RoperisaSeniorSystemsConsultantwithQualexConsultingServices,Inc.
HisareasofexpertiseincludeBaseSAS,SAS/AF,SAS/FSP,Macros,Frame,andSCL,andhehasbeendevelopingSASapplicationsforovertenyears.
ChriswonBestContributedPaperinApplicationsDevelopmentatlastyear'sWUSSconference,andisafrequentpresenteratSASusergroupsacrosstheUnitedStatesandEurope.
ChrishasaBSinBusinessAdministrationwithaConcentrationinEconomicsfromChristopherNewportUniversity.
ASimplifiedReportingStrategy:"Summary"DataSetsforReportingonDatafromMultipleSourceDataSets20CSteveRoss;ClinTrialsResearch,Inc.
;ResearchTrianglePark,NCInconductinganalysisofclinicaltrialsdata,itisrarethatallofyourdatawillcomefromonesourcedataset.
Intheinterestofsimplicityanddiskspace,asingle"SUMMARY"filecreatedearlyintheprogrammingprocessandcontainingvariablesapplicabletomanytablesisstrategicallybeneficialtotheprogrammingandQCprocesses.
Forexample,inatrialmeasuringabloodpressureloweringdrug,demographicinformationwillbedrawnfroma'DEMO'dataset,treatmentassignmentandstart/stopdatesfroma'DOSING'dataset,andbaselineandpost-treatmentvitalsignsfroma'VlTALS'dataset.
Placingthesevaluesinacentrallocationgivesthreeadvantages:1)thesummaryfilecaneasilybemergedontodatasetsforreportingandanalysis,2)asingledatasetissimplertodatacheckandQC,and3)theresultantdatasetissmallerthanthecumulativeeffectofaddingeachofthesevariablestoalldatasetspermanently.
Forthisdiscussion,stepsdetailingthecreationofthisdatasetwillbeoutlined,aswellasexamplesandsuggestionsforitsuseintheQCprocessandinfinishedoutputreporting.
SteveRosshasbeenemployedasaSASProgrammeratClinTrialsResearch,acontractresearchorganizationlocatedinResearchTrianglePark,NorthCarolina,forovertwoyears.
Hiscurrentresponsibilitiesincludetechnicalteamleadershipincreating,maintaining,andreportingondatabasesofclinicaltrialsdata.
WhilelearningSASasagraduatestudent,SteveworkedfortheNorthCarolinaCenterforUrbanAffairs,analyzingresultsofstatewidestandardizedtestscoresofgradeschoolstudentsandmaintainingateachingWebsiteforNorthCarolinaeducators.
StevereceivedhisBAfromElonCollegein1992andhisMAfromNorthCarolinaStateUniversityin1997.
InstituteQualityPartners--WhoareThey20CLorettaJoSchlatzer;SASInstituteInstituteQualityPartnersareindependentconsultingorganizationswhoseprimarybusinessisinprovidingconsultingservicesusingSASsoftware.
QualityPartnersmustmeetspecificcriteriainordertoparticipateintheprogram.
Inaddition,theymustadheretoadditionalprogramrequirementstoensurecontinuedparticipationintheprogram.
Thiscriteriaincludesminimumeducation,participationatusergroup&businessmeetings,sponsorshipbyanInstituteemployeeandcustomerreferences.
OneofthegoalsoftheprogramistoidentifythoseconsultantswhohaveprovenSASskillsaswellasbusinessandsubjectmatterexpertise.
ThishelpstoensuretheSASusercommunitythatwhenanalternativeresourceisrequired,SASexpertiseisavailable,andthatbyselectingaQualityPartnertheyaremoreassuredofthequalityofservicethatwillbeprovided.
QualityPartnersreceivemanybenefits.
Thesebenefitsinclude:accesstotechnology,trainingdiscounts,publicationdiscounts,referrals,advanceinformationviatheQPListservandQPNewsletter.
AdditionaldiscussionontheroleoftheQualityPartner,availabilityofQP'ers(viatheQPon-lineregistry),determininghowtofindtherightSASexpertiseforthejob,etc.
LorettaJoSchlatzeristheQualityPartnerBusinessManagerintheProfessionalServicesDivisionatSASInstitute.
ShehasbeenwiththeInstituteformorethantenyears.
CurrentlyLorettamanagestheUSQualityPartnerProgram,whichisaprogramthatsupportsindependentconsultingorganizationsthatprovideSASexpertise.
DataDictionaryApproachestoEditandValidateSurveyData20CNaokoStearns;ResearchTriangleInstitute;RTP,NCTheprocessofvalidatingandeditingsurveydatabecomescrucialtoanorganization'sreputationwhentheintendeduseristhegeneralpublic.
Also,thesetasksrequiresubstantialresources,includingexperiencedprogrammersanddataanalysts.
Fortunately,usingadatadictionarycanfacilitatethateffortintwoways:usingthedictionaryforproducingdocumentationaboutthedata;and,forgeneratingSAScodethatpreciselyrepresentsthedata.
Theimplementationofadatadictionaryandcodegeneratorsautomatesmanyofthemundaneanderrorpronedatacleaningtasks,suchasassigningspecialmissingcodesandproducingdeliverableASCIIfiles.
ThispaperdiscussesamethodofusingaMicrosoftExceldatadictionarythatisdynamicallyaccessedviaDynamicDataExchange(DDE)forthepurposeofefficientlyeditingandvalidatingsurveydata.
NaokoStearnsisaresearchprogrammer/analystatResearchTriangleInstitute,RTP,NC.
NaokohasbeenusingSASfor10years.
Herrecentworkfocusesonimplementingdatadictionaries,codegenerators,andcodebooks.
UsingSASImport/ExportWizardsandSASMacrostoAutomateDataManipulationofExternalData20CChrisD.
Thompson;WachoviaThispaperpresentsasituationinwhichdatathatwasavailableinaseriesof14MicrosoftWorddocumentsneededtobeconvertedtoadifferentseriesof24MicrosoftExceldocuments.
APCSASforWindowsversion6.
12programwaswrittenonaWindows/NTplatformtoimporttheWorddata,combineitintoasingledataset,sliceanddiceitintothe24groupingsneededforExcel,andfinallyexportitinto24ExcelWorkbookswithouttheuserevertouchingWordorExcel.
SASprogrammingtechniquesincludeuseoftheImport/Exportwizard(PROCACCESS,PROCDBLOAD)anduseofuserwrittenSASMacros(creatingloopsforiterativeprocessing).
ChrisThompsonfirststartedusingSASin1990asanundergraduateStatisticsmajoratNorthCarolinaStateUniversity.
Uponcompletionofhisdegreein1994,heworkedthreeyearsasabiostatisticianatBowmanGraySchoolofMedicinebeforemovingtoWachoviaasatechnicalanalystinJune,1997.
ChrishasspecializedintheautomationofreportsusingSASMacrosandiscurrentlyworkingonadatawarehousingprojectatWachovia.
StatisticsSectionChairs:GraceLossmanSmith-HanleySouthOrange,NJMargaretConnollyShellSTAT,Inc.
MarionStation,MDBeatingtheSystem:AdaptingExploratoryMethodstotheSASEnvironment110IFacilitator:MargaretConnolly;ShellSTAT,Inc.
;MarionStation,MDPanelists:DouglassChapman,DavidDickey,MaribethJohnson,RobertMiceli,KenPollockMostSASStatisticsproceduresaredirectedtowardconfirmatorydataanalysis-modelbasedestimates,hypothesistests,andconfidenceintervals.
Outputdatasetsofmanyproceduresmayincludesophisticateddiagnosticcalculations.
However,intelligentdatadisplaysprovidethekeytoexploratoryanddiagnosticmethodsandSASmaynotprovidethebestenvironmentfordevelopingdatadisplays.
Thispaneldiscussionwillcoveravarietyofapproachesformakingexploratoryanddiagnosticprinciplesapartofthestandarddataanalysisprocedure.
Panelistswilldescribemethodswhichtheyhavefoundrelativelyeasytoimplementintheroutineanalysisormethodswhichwillgenerallyrepaytheeffortofdesigningthestandardgraphicdisplay.
Forthisdiscussion,exploratorymethodsincluderepresentationsofrawdata--typicalranges,atypicalobservations,dataclustering,andpatternsimposedbytheexperimentalorsamplingdesign-anddisplaysofdiagnosticoutput.
Thepanelistsandaudiencewillsharetheirexperiencesofusingexploratorymethodsinroutinedataanalysisandincludingdescriptiveoverviewsaspartofastudysummary.
MargaretConnollyisaconsultingbiostatisticianwithpharmaceuticalclientsandtheoccasionalacademicresearchprojectorgovernmentagencysub-contract.
OverthepastseveralyearsshehasusedSASforpharmacokineticcalculations,assayvalidation,drugstabilitystudies,andclinicaltrials.
ShehasaMaster'sDegreeinDairyScience(animalbreeding)fromMichiganStateandaPh.
D.
inBiostatisticsfromtheJohnsHopkinsSchoolofPublicHealth.
DougChapmanisanAssistantDirectorinBiometricsatPfizer,workingonPhaseIIIbandPhaseIVclinicalstudieswithAllergy,Arthritis,andDepressionandAnxietydiseasemanagementteams.
HehascollaboratedonmanymedicalresearchprojectssponsoredbyPfizerandbyhisearlieremployer,MemorialSloan-KetteringCancerCenter.
HisfirstclientforstatisticalserviceswasCovenantHouseyouthcrisiscenter.
Mr.
Chapman'sMSinStatisticsisfromBaruchCollegeofCityUniversityinNewYorkCity.
DavidA.
DickeyisaprofessorofstatisticsatNorthCarolinaStateUniversityandacontractinstructorforSASInstitute.
Hehasco-authoredseveralbooksincluding"SASSystemforForecasting"(SASInst.
,1986),"PrinciplesandProceduresofStatistics"(McGraw-Hill,1997)and"AppliedRegressionAnalysis"(Springer,1998inpress).
Hisresearchonstationaritytestingresultedinthe"Dickey-Fuller"testasdiscussedinseveraltextsandimplementedinseveralcomputerpackagesincludingSAS/ETS,PROCARIMA.
MaribethJohnsonhasbeenaresearchstatisticianintheOfficeofBiostatisticattheMedicalCollegeofGeorgiafor5years.
SheworkedpreviouslyintheUniversityofGeorgiaDepartmentofAnimalofDairySciencefor11yearsasastatisticalprogrammer.
ShehasMSdegreesinAnimalBreedingfromVATechandinStatisticsfromUGA.
ShehasbeenusingSASfor17years.
RobertMiceli:Nobiographyavailableatpresstime.
KennethH.
PollockisprofessorofStatistics,Biomathematics,andZoologyatNorthCarolinaStateUniversity.
Hisresearchinterestissamplingfishandwildlifepopulationsandhehaspublishedover100articlesinscientificjournals.
HeisafellowoftheAmericanStatisticalAssociation.
HisBSisfromSidneyUniversityinAustralia,andhisMastersandPh.
D.
arefromCornellUniversity.
RegressionwithTimeSeriesErrors50IDavidA.
Dickey;N.
C.
StateUniversity;Raleigh,NCOrdinaryLeastSquares(OLS),theestimationmethodusedinPROCREGandPROCGLM,isonlyvalidundercertainassumptions.
Oneoftheseassumptions,independenceoferrors,isoftenviolatedwhendataaretakenovertime.
Methodstotestforviolationsarediscussed.
Whentheindependenceassumptionisviolated,alternativemethods(GeneralizedLeastSquaresandEstimatedGeneralizedLeastSquares)areavailable.
PROCAUTOREGisthesimplesttoolforthistypeofproblem.
PROCAUTOREGisillustratedwithanexample.
Amoresophisticatedtool,PROCARIMAwithitsINPUToption,willalsobeillustratedanditsadvantagesdiscussed.
DavidA.
DickeyisaProfessorofStatisticsatNorthCarolinaStateUniversityandacontractinstructorforSASInstitute.
Hehasco-authoredseveralbooksincluding"SASSystemforForecasting"(SASInst.
,1986),"PrinciplesandProceduresofStatistics"(McGraw-Hill,1997)and"AppliedRegressionAnalysis"(Springer,1998inpress).
Hisresearchonstationaritytestingresultedinthe"Dickey-Fuller"testasdiscussedinseveraltextsandimplementedinseveralcomputerpackagesincludingSAS/ETS,PROCARIMA.
BeyondFactorAnalysis:CantheResultsBeValidated20CRachelJ.
Goldberg;Mercedes-BenzCreditCorporation;Atlanta,GAThispresentationexploresusingdifferenttechniquestovalidateaninitialsetoffactoranalysisresults.
AllofthefactoranalysesdiscussedareproducedusingtheSASSystem'sPROCFACTORprocedure.
AnunderstandingofhowtousetheSASSystemtorunabasicfactoranalysisisneeded,sincethispresentationwillfocusonhowtointerpretandcomparePROCFACTORresults.
First,theoutputfromtheoriginalfactoranalysissolutionispresented;thissolutionusesPrincipalFactorAnalysisastheinitialextractionmethodwithaVARIMAXrotation.
Inanattempttovalidatetheseoriginalfindings,theresultsarecomparedtofourdifferentfactorsolutionsobtainedby:1)changingtheinitialfactorextractionmethod,2)changingtherotationmethod,3)changingthenumberoffactorsanalyzed,and4)splittingthedatasetinhalfandrunningthesameinitialfactorextractionmethodandrotationonbothhalves.
TheresultsofeachfactoranalysisfirstwillbedisplayedastheoriginalPROCFACTORoutputandthensummarizedintables.
AlloftheresultsdiscussedutilizeBaseSASandSAS/STATsoftware.
RachelGoldbergworksforMercedes-BenzCreditCorporation(MBCC)inAtlanta,Georgia,wheresheisresponsibleforCreditRiskManagementofleaseandretailcustomers.
SheusestheSASSystemtoassistintheanalysisandmanagementofconsumers'creditbehaviorthroughouttheirlifecyclewithMBCC.
PriortojoiningMBCC,RachelworkedasaprojectdirectorintheMarketResearchindustryforovertwoyearsandasastatisticalconsultantintheFinancialindustryforaboutfiveyears.
RachelhasaBSinStatisticsfromtheUniversityofFloridaandhasusedSASforthepasteightyears.
LongversesWide-ADifferentWayofLookingatDataSetsandSASCoding20CRichardGoldsmith;ASG,Inc.
SASdatasetstendtobecreatedwide,i.
e.
asingleobservationhasmanyvariables.
ThisintuitiveapproachmakesthemosteffectiveuseofdatastoragespaceandallowsthesimplestapproachtowritingSAScode.
However,whathappensifalongdatasetisusedinsteadofawidedatasetLongdatasetscanincreasetheflexibilityoftheunderlyingdatastructureandcanaidintheconstructionofreusablecodewhenusedwiththeSASmacrofacility.
AsimpleexampleshowinghowalongdatasetandtheSASmacrofacilitycanbeusedtoconstructageneralizedSASprogramforusewithPROCGLMwillbepresented.
ThisapproachwilldemonstratetheuseoftheSASmacroindirectreferencingfacility(everwonderwhatrealuse&&has)andshowhowindirectreferencingcanbeusedtogeneratemetavariablesforuseinwritingreusablecode.
Themajordisadvantagesofthisapproach-increaseddatastoragesize,increasedprogramcomplexity,andincreasedprogramexecutiontime--willbeaddressedandmethodsthatcanbeusedtoreduceprogramcomplexitywillbediscussed.
RichGoldsmith,Dorothy,andTotoareallfromKansas.
RichandTotoaresomewhatsimilar–neitherofthemhastheslightestideawhattheirtitleis.
TheWizardofASGgrantshiswishforapaycheck.
RichhadaPhilosophyBAand,findingnotmuchdemandforphilosophersin1967,hethenobtainedaBSdegreeinMeteorologycourtesyoftheUSAirForce.
HehasanMSinComputerScience.
Rich'sSASexperiencedatesbackto1980andincludesworkforaminingcompany,amanufacturingcompany,amajorbank,ahealthcarecompany,andseveralpharmaceuticalcompanies.
TheEffectofMissingDataonRepeatedMeasuresModels50IMaribethJohnson;MedicalCollegeofGeorgia;Augusta,GATheMIXEDprocedureoftheSASSystemenablesexaminationofcorrelationalstructuresandvariabilitychangesbetweenrepeatedmeasurementsonexperimentalunitsacrosstime.
WhilePROCMIXEDhastheabilitytohandleunbalanceddatawhenthedataaremissingatrandom,aquestionarisesastowhenthedegreeofsparsenessjeopardizesinference.
Simulationisatoolthatcanbeusedtoaddressthesetypesofquestions.
Thispapershowstheapplicationofsimulationtodetermineinferenceproblemsinadatasetwithaspecificpatternofmissingdata.
Thistechniqueisalsoappliedtothetopicofinitialstudysamplesizedetermination.
MaribethJohnsonhasbeenaresearchstatisticianintheOfficeofBiostatisticattheMedicalCollegeofGeorgiafor5years.
SheworkedpreviouslyintheUniversityofGeorgiaDepartmentofAnimalofDairySciencefor11yearsasastatisticalprogrammer.
ShehasMSdegreesinAnimalBreedingfromVATechandinStatisticsfromUGA.
ShehasbeenusingSASfor17years.
ASASMacroProgramtoPerformPermutationTestingforGroup*TimeInteractioninanUnbalancedRepeated-MeasuresAnalysisofVariance20CMarkS.
Litaker;OfficeofBiostatistics,MedicalCollegeofGeorgia;Augusta,GABernardGutin;DepartmentofPediatrics,MedicalCollegeofGeorgia;Augusta,GAInastudytoevaluatetheeffectsofphysicaltrainingonheart-periodvariability(HPV)measurements,79obese7-11yearoldchildrenwererandomlyassignedtoparticipateinanexerciseprogramduringthefirstorsecond4monthsofthestudyperiod.
Measurementsweremadeatmonths0,4,and8withthegoalofidentifyingdifferencesinpatternsofchangeinHPVbetweenthetwogroupsacrossthestudyperiod.
SAS'PROCGLMwasusedtocalculateanalysesofvariance(ANOVA)withsubjectasarandomeffectandgroupandmonthasfixedeffects.
ThestatisticaltestwhichisofinterestistheF-testforgroup*timeinteraction.
Distributionsofresidualsindicatednon-normality,oftenduetoafewrelativelylargeresiduals.
PermutationtestingprovidesamethodforevaluatingthestatisticalsignificanceoftheobservedF-tests,whileavoidingproblematicdistributionalassumptions.
ASASmacroprogramispresentedwhichsamplesthepermutationdistributionoftheFstatisticunderthenullhypothesis,andprintspercentilevaluesfortheempiricaldistribution.
MarkLitaker,forthepastnineyears,hasbeenabiostatisticianfortheMedicalCollegeofGeorgia,OfficeofBiostatistics.
HisbiostatisticstrainingwasdoneattheMedicalUniversityofSC(MSdegree)andtheUniversityofSC(Ph.
D.
).
HehasusedSASforabout12years.
BernardGutin:Nobiographyavailableatpresstime.
TheReplicationMethodforEstimatingSamplingErrors,PrinciplesandSoftware50IDavidMorganstein;Westat,Inc.
;Rockville,MDResearchersusingclustered,stratifiedorunequallyweighteddatacannotrelyuponSASorotherstandardstatisticalpackagestoprovideaccurateinferences.
Standardstatisticalpackagesrelyontheassumptionofsimplerandomsampling.
Therearetwocommonlyusedmethodsforobtainingproperinferencesfromcomplexsampling:replicationandlinearization.
Inthispaper,wedescribehowreplicationtheoryachievesobjectivesthatareinherentlydifficultwithlinearization.
Thestrengthsofthereplicationmethod,asimplementedintheWesVarPCprograminclude:itiseasytoexplainreplicationtodatauserswithoutspecialtraininginvarianceestimationforsamplesurveys;itcanbeappliedtomanydesignsandmanystatisticsusingthesameprocedurewithoutmodifyingthesoftware;itcanhandleavarietyofestimationstrategies;itisaconsistentprocedureforhandlingsubsetsofthedataandmissingdataitems;and,itisasimpleandelegantmethodforhandlinglongitudinalsampledesigns.
Mr.
MorgansteinisaSeniorStatisticianandVicePresidentofWestat,Inc.
Hisspecialareasofexpertisearethedesign,implementation,andanalysisofdatabases;designandapplicationofsamplesurveysandsystemsofevaluation;statisticalanalysis;andestimationandquantification.
HehasdesignedandanalyzedmanynationalandlocalareaRDDhouseholdsurveysandwasco-developerofPROCWESVARandWesVarPC.
InadditiontohisworkwithorganizationsinNorthAmericaandoverseas,teachingstatisticalprocesscontrolforqualityassurance,heisalsoaninstructorattheJointProgramforSurveyMethodologyattheUniversityofMaryland.
AnApplicationofClusterAnalysisintheFinancialServicesIndustry50CSatishNargundkarandTimothyJ.
Olzer;May&Speh,StrategicDecisionServices;Atlanta,GAAnalyticalmodelsarecriticalintheFinancialServicesIndustryineveryphaseofthecreditcycle-Marketing,Acquisitions,CustomerManagement,Collections,andRecovery.
Whilesuchmodelsarenowcommonplace,thesearchforcompetitiveadvantagerequirescontinuousimprovementinthemodels.
Customizationofthemodelsforeachsegmentofthepopulationisacrucialsteptowardsachievingthatend.
Segmentsinthepopulationmaybedefinedjudgmentallyusingoneortwovariables,butClusterAnalysisisanexcellentstatisticaltoolformultivariatesegmentation.
Theclustersmaybeusedtodrivethemodeldevelopmentprocess,toassignappropriatestrategies,orboth.
ThispaperdiscussestheFASTCLUSprocedureasatoolforsegmentationofapopulation.
Thefirstphaseinvolvespreparingthedataforclustering,whichincludeshandlingmissingvaluesandoutliers,standardizing,andreducingthenumberofvariablesusingtoolssuchastheFACTORprocedure.
TheFASTCLUSdiscussionemphasizestheassumptions,theoptionsavailable,andtheinterpretationofSASoutput.
Finally,thebusinessinterpretationoftheclusteranalysisisprovidedwithinthecontextofthisspecificindustry.
Thisenablestheanalysttoidentifytheappropriatenumberofclusterstouseinmodeldevelopmentorstrategicplanning.
SatishNargundkarjoinedCSMinApril1996,laterbecomingamemberoftheTrainingSteeringCommitteeatMay&SpehStrategicDecisionServices.
Hewasaprogrammer/consultantinAT&T'sinteractiveproductsandservicesdivisionandhasheldacademicandteachingpositionsincludingappointmentsatOglethorpeUniversity,MountOliveCollegeandGeneralFortuneCorporation.
NargundkarhaspublishedarticlesinTheJournalofBusinessResearch,theJournalofGlobalStrategiesandtheJournalofManagerialStudies.
HereceivedaBachelor'sofEngineeringinMechanicalEngineeringfromIndia'sOsmaniaUniversityandaPh.
D.
inindustrialmanagementfromClemsonUniversity.
TimothyJ.
Olzer:Nobiographyavailableatpresstime.
ItChops,ItDices,ItMakesJulienneSlices!
ODSforDataAnalysisOutputAs-You-Like-ItinVersion750IChrisOlingerandMauraStokes;SASInstituteThispaperdiscussesadvancesmadeintheoutputgeneratedbyallVersion7SASsoftwareprocedures.
NewfeaturesprovidedbytheOutputDeliverySystem(ODS)includeautomaticrenderingofprocedureoutputinHTMLfortheWeb,rich-text,PostscriptorPCLformat,outputdatasetsfromanyprintedoutput,andtheabilitytoeditthelookandfeelofmostoutput.
ODSalsosupportsalllegacyline-modeprintingandsupportsadocumentfeaturetoallowpost-procedurereplayingofoutput.
ThistalkintroducesODSfeaturestobedeliveredinVersion7andprovidessomeconcreteexamplesofhowdataanalystsandstatisticianscantakeadvantageofthefeaturesetprovidedbyODS.
ChrisOlinger,aveteranSASemployee,worksintheApplicationsDivisionofResearchandDevelopment.
HeisoneofthekeyODSdevelopers(hewaspartlyresponsiblefortheVersion6ODSprototype)andnowprogramsthebulkoftheinternalODSinfrastructureintheSASSystem.
.
MauraStokesisManageroftheStatisticalApplicationsRandDDepartmentandhasworkedatSASInstituteforfourteenyears.
Sheisco-authorofthebookCategoricalDataAnalysisUsingtheSASSystem.
SheholdsaDrPHdegreeinBiostatisticsfromUNC/ChapelHillandisnowanadjunctmemberofthefaculty.
ComputingaTestStatisticforScaleParametersBasedonaJacknifeProcedure20CJeanG.
Orelien;ResearchTriangleInstitute;RTP,NCItiswellknownthattheFtestisnotrobustwhentheassumptionofnormalitynolongerholds.
Onewaytotestforscaleparameterswhennormalityoftheunderlyingdistributionscannotbeassumedistousenonparametricmethods.
However,therearetwoproblemswithnonparametrictestsforscaleparameters.
ThecomputationscanbelaboriousandthereislessefficiencycomparedtotheFtestwhenthedistributionsarenormal.
Inthispaper,usingtheIMLmoduleintheSASSystem,weimplementatestforscaleparametersfortwoindependentsamplesbasedonajacknifeprocedurethatwasproposedbyR.
G.
Millerin1969.
Theadvantagesofthistestbasedonthejacknifeisthatitdoesnotrequireanyassumptionsforthelocationparametersorequalsamplesizes.
Whenthedistributionsarenormal,thistesthasanasymptoticrelativeefficiencyequalto1withrespecttotheFtest.
JeanOrelienrecentlygraduatedwithanMSinStatisticsfromNorthCarolinaStateUniversity.
ShehasworkedasateachingassistantandisnowemployedasastatisticianattheResearchTriangleInstitute.
ShehasaBAinMathematicsfromRutgersCollegeofRutgersUniversity.
MultipleComparisonProcedureswithSAS50IDrorRomandChung-KueiChang;ProsoftSoftware,Inc.
ThispresentationdiscussessomecommonlyusedmultiplecomparisonproceduresavailableinSAS.
Wefocusonthefollowingmethods:ModifiedBonferroniProcedures,Dunnett'sprocedureforcomparisonswithacontroltreatment,withandwithoutacovariateadjustment,step-downandclosedtestingprocedures,adjustedp-valuesusingMonte-Carlosimulation,andcalculationofexactadjustedp-valuesfordiscretedata.
WewillcoverPROBMC,PROCGLM,PROCMULTTEST,andsomemacrosforvariousmethods.
Varioussettingswillbeusedtodemonstratetheprocedures,including,multipletreatmentcomparisons,pairwisecomparisons,doseresponse,andmultipleendpointsinclinicaltrials.
DrorRomisaco-authorwithPeterWestfall,YosefHochberg,RandyTobiasandRussWolfingeron:"MultipleComparisonsandMultipleTestingUsingtheSASSystem",a'BookbyUsers'toappearnextyear.
Hehasbeentwoyearsathisowncompany,developingsoftwareandconsultingonclinicaltrials.
Previously,heworkedatRhone-PoulencRorerinclinicalPhaseI-IIIandpre-clinicalareasandatMerckResearchLabsinanimaltoxicologystudies.
HehasaPh.
D.
fromTempleUniversityforworkinDiscreteMultivariateAnalysis.
Chung-KueiChang:Nobiographyavailableatpresstime.
SoftwareforGEE:PROCGENMODandSUDAAN50IDr.
BabubhaiV.
Shah;ResearchTriangleInstitute;RTP,NCUntilrecently,mostofthestatisticalsoftwarewaslimitedtoanalyzingdatafromsimplerandomsamples.
Recently,someprogramshavebecomeavailabletoanalyzecorrelatedorclustereddata.
Weshallreviewtwosuchprogramsanddiscusstheirstrongpoints.
Weshallalsopresentpointerstotakethemostadvantageofboththeseprograms.
Themajoradvantageofthesemethodsistheuseofrobustsandwichestimatorsforthevariancesofparameterestimates.
Thebasicalgorithmintheseprogramsisiterativeandsomecareisneededinapplyingthesetofitagivenmodeltoaparticulardatasample.
Occasionally,theiterativealgorithmsmayconverge(orfailtoconverge)incorrectly.
Theuserneedstoverifythatthealgorithmhasconvergedcorrectly!
Dr.
BabubhaiV.
ShahisaChiefScientist,StatisticsResearchDivision,attheResearchTriangleInstitute.
HecompletedhisPh.
D.
inStatisticsattheuniversityofBombay,India.
Dr.
Shah'scontributiontotheoreticalandappliedstatisticsaredemonstratedbyhisextensivepublishedresearch.
HehasbeenhonoredasFellowoftheAmericanStatisticalInstituteandisalsoaFellowoftheRoyalStatisticalSocietyandoftheInternationalStatisticalInstitute.
Heisanadjunctprofessoratthedepartmentofbiostatistics,intheschoolofpublichealthatUniversityofNorthCarolinaatChapelHill.
RecentEnhancementsandNewDirectionsinSAS/STATSoftware50IMauraStokes;SASInstituteVersion7oftheSASSystembringsmajorenhancementstothestatisticalsoftware.
AlloutputisnowhandledbytheOutputDeliverySystem,whichgivestheusercontrolovertheprintingoftheresults,allowsalltablesandstatisticstobeoutputtoSASdatasets,andproducesWeb-browsableHTMLoutput.
Newproceduresprovidetoolsforpartialleastsquaresanalysisandspatialprediction.
TheGENMODprocedurenowprovidesLSMEANSandESTIMATEstatements,anditsGEEfacilityprovidesthealternatinglogisticregressionalgorithmandnowhandlestheordinalresponsecase.
AdditionalexacttestshavebeenaddedtotheFREQandNPAR1WAYprocedures,andnumerousotherupdatestoproceduresarealsoincluded.
Inadditiontonewproceduresforsurveydesignandanalysis,Version7alsointroducesexperimentalproceduresfornonparametricmodeling.
MauraStokesisManageroftheStatisticalApplicationsRandDDepartmentandhasworkedatSASInstituteforfourteenyears.
Sheisco-authorofthebookCategoricalDataAnalysisUsingtheSASSystem.
SheholdsaDrPHdegreeinBiostatisticsfromUNC/ChapelHillandisnowanadjunctmemberofthefaculty.
Technology2000SectionChairs:BobPassmorePassmoreConsultingServicesDurham,NCBenCochranTheBedfordGroupRaleigh,NCDataWarehousingEfficiencyTechniqueswiththeSASSystem50ITonyBrown;SASInstituteThispaperwillbeaimedtowardmid-rangetoadvancedusersandwarehouseadministrators.
Itwillcoverthetopicsoftechnicallyimplementingasubject-basedstarschemausingtheSASSystem.
Supportingtopicswillbe:SubjectselectionStar-schemamodelingwithSASdatasetsUtilizingindexingforefficientqueryretrievalUsingformatsandothertechniquestopreventtablejoinsinstarschemasUsingadvancedSASfuntionstooptimizeSQLreporting,integration,andmanagementEfficiencywiththewarehouseadministratorThepaperwillincludeasectiononcost/performanceofefficiencytechniques.
Nobiographyavailableatpresstime.
GettingStartedwiththeSASMultidimensionalDatabase(MDDB)Server50IBenCochran;TheBedfordGroup;Raleigh,NCThisisapaperonhowtostartfromscratchandpreparetheMDDBsothatitcanbeusedwiththedrill-downobjectsinSAS/EIS.
Weuseastep-by-stepapproachtogettingthedatareadyfortheseEISobjects.
Thenwelookatwaysinwhichtheusercancustomizetheseobjectsatrun-timeaswellasslicinganddicingyourwaytoanalyzingyourdata.
BenCochranhasovertwelveyearsofexperiencewiththeSASSystem.
HewasaformerinstructorwithSASInstitute,thenwastheMarketingManagerforSAS/EISbeforeleavingtheInstitutetobecomeaSASQualityPartner.
BenhasgivennumerouspapersatpreviousSUGIandSESUGconferencesontopicsrangingfromSAS/ASSISTandSAS/CALC,aswellasSAS/EIS.
NewDirectionsinSASSoftwareVersion7Documentation50IJimSheedy;SASInstituteThissessionwillwalkusersthroughnewfeaturesintheonlineinformationdeliveredwithVersion7oftheSASSystem.
ItwilldiscussSASOnlineDoc--theCD-ROMapplicationforviewingandsearchingreferencebooksonline.
Also,itwilldiscussanddemochangesintheSASHelpsystem.
JimSheedyisaTechnicalWriterIIIinthePublicationsDivisionatSASInstitute.
HeistheprojectcoordinatorforallSAS/GRAPHDocumentationandmaintainsthedocumentationforthegraphicscomponentsinSAS/AFsoftware.
SASEnterpriseReportervs.
MicrosoftApplications50IVinceRaimondi;GECapital;Atlanta,GAJoeWhitehurstandMarkTabladillo;WhitehurstAssociatesInc.
;Atlanta,GATheEnterpriseReporterisarelativelynewSASapplication.
ThispresentationwillevaluatethefeaturesandefficiencyoftheEnterpriseReporter(abovethefunctionalityinbaseSAS)ascontrastedwithAutomationwithMicrosoftApplications(usingSASastheclientandMicrosoftOffice'97astheserver).
Featuresofkeyinterestinclude:1)abilitytoaccessSASdatasetsonmultipleplatforms;2)abilitytorunbatchreportsstartingfromtransaction-leveldata;and3)abilitytoproduceelectronicreportswhichuserscanmodify.
VinceRaimondiisManagerofCommercialInformation,GECapital-RFS,andfocusesonthedesignandimplementationofDataMartsolutionsandreportautomation.
VincehasbeencodinginSASforfiveyears,threeyearsofwhichhasbeendedicatedtotheCreditCardindustry.
VinceearnedanMSinStatisticsandOperationsResearchfromNewYorkUniversityin1992.
JoeWhitehurstisPresidentofWhitehurstAssociates,Inc.
,aSASInstituteQualityPartner.
Since1980,JoehasdevelopedSASApplicationsintheBanking,HealthCare,HigherEducation,Insurance,Manufacturing,andTelecommunicationsindustries.
In1988,hefoundedtheVirginiaSASUsers'GroupandservedaselectedPresidentuntil1991.
MarkTabladillohasbeenaSASusersince1992andhasprogrammedSASintheHealthPromotion,University,andFinancialServicesarenas.
HehasspecificSASexperiencewithdataminingtechniques,aPh.
D.
inIndustrialEngineeringfromGeorgiaTech,andteachingexperienceinStatisticsandQualityManagement.
It'sAlmosttheYear2000--ShouldIPanic50IMichelleRobinson;SASInstituteThispaperwilladdressthemostfrequentlyaskedquestionsaboutYear2000compliancefortheSASSystem.
Topicsinclude:IstheSASSystemYear2000compliantHowcanItestmySASapplicationsforYear2000complianceDoIneedspeciallicensinginordertodoYear2000testingWherecanIgetmoredetailedinformationaboutSASapplicationsandtheYear2000MichelleRobinsonisaTechnicalSupportAnalystatSASInstitute.
ShehasworkedatSASInstitutefor5years.
ReplacingOraclewiththeSASScalablePerformanceDataServer:ImprovedPerformance,EnhancedFunctionality,andIncreasedEfficiency50IJayL.
Stevens;ThePrudentialBank;Atlanta,GAAlthoughtheSASInstitutehasbeenverysuccessfulinbuildinghighfunctioninggatewaystoexternaldatabaserepositories,itisalmostimpossibletotakefulladvantageoftheSASsystemthroughtheseinterfaces.
ManyexperiencedSASusershavelongrecognizedthatSASisvastlymoreefficientandfunctionalwhenusedagainstSASdatasets.
Partiallyduetotheiroriginastransactionprocessingsystems,mostoftheexistingrelationaldatabasesareoverlycomplexandinefficientwhenusedastherepositoryforadatawarehouseordatamart.
WiththeadventoftheSASScalablePerformanceDataServer,aviablehigh-performancealternativetoOracleandtheotherRelationalDatabaseManagementSystems(RDBMS)isavailabletotheenterprise.
ThispaperwillreviewtheprocessandadvantagesofmigratingfromOracletoSAS/SPDSincluding:OvercomingObstaclestoMigrationPerformance&ProductivityGainsDataLoadingandTransformationEfficienciesSecurityandAuditingConsiderationsJayStevensdirectsthePortfolioAnalysisdecisionsupportgroupofPrudentialBank.
Hisgroupisresponsibleforanalysisandmodelingforallofthebank'screditproducts.
HehasbeenusingSPDSsinceit'sintroductioninbetaandwasanInstituteinvitedpresenteratSUGI23.
Hehasbeenworkingindecisionanalysisforcreditfor8yearsandhasadegreeinDecisionSciencesfromGeorgiaStateUniversity.
WeekendWorkshopsThecostoftheseworkshopsisnotincludedinthecostoftheconference.
PleaseseetheRegistrationFormonpage71forsigningup.
Spaceineachworkshopislimited,sodon'tdelay.
SectionChair:FrankDiIorioAdvancedIntegratedManufacturingSolutionsCorp.
ChapelHill,NCReligion101-UNIXforNon-believersGraceLossman;Smith-HanleyConsultingGroup;SouthOrange,NJSaturdayAfternoon,1:30-5:30pm$70UNIXisfun!
Really.
Itcanmakeyourprogrammingmoremeaningfulandadventurefilledthanyoucanpossiblyimagine.
Whateveryou'vedreamedofdoingonasystemandcouldn'twillnowbesimple.
WanttorunajobinthemiddleofthenightwithoutgoingintotheofficeWanttosetupyourowndesignerenvironmentWanttodotruemultitaskingWriterealmultithreadedapplicationsUNIXcandoallthisandfarmore.
Evenwhenyouaresomehowabletodothesethingsonanothersystemtheyarecumbersome.
Theclassmaterialisintroductory.
ThestudentwillbegiventhetoolstobeginyournewlifeasaUNIXuser.
Whoshouldattend:Anyonewhohasbeen-orthinkstheymightbe-workinginaUNIXenvironmentbutdoesnotfeelcomfortablewithUNIXcommands.
GraceLossmanhasaM.
S.
inPhysicsandhasbeenusingSASsincetheearly80's.
HerloveaffairwithUNIXstartedinthelate80'swhenshefirstsawthelightandbecameaUnixconvert.
LatersheactedinthecapacityofSystemAdministratoratNIEHSinResearchTrianglePark,NCandthenlaterattheMedicalUniversityofSouthCarolinainCharleston.
ShecanoffertheuniqueperspectiveofbothUNIXSysadminandSASprogrammer.
SASDebuggingTechniquesS.
DavidRiba;JADETech,Inc.
;Clearwater,FLSaturdayAfternoon,1:30-5:30pm$70FromthenoviceSASusertotheseasonedSASexpert,allSASprogrammersexperiencetheultimatethrillofdebuggingtheirsoftwarecode.
Whiledebuggingtechniquesmayvary,everyoneneedstounderstandhowtodebugtheirprograms.
MostprogrammersuseafewsimpletechniqueslearnedintheirearlyexposuretoSAS.
However,theexperiencedprogrammerknowsthatdifferentsituationscallforavarietyofdifferentdebuggingtechniques.
HowdoyoudetermineifheproblemisyourcodeoryourdataWhataresomesimpletechniquestotestyourprogramwithoutprocessingreamsofdataHowcanyoudefineyourprogramssotheyerror-checkandmodifythemselvesiferrorsoccurHowcanyoutraperrorsandtestyourprogramlogic"on-the-fly"Thisworkshopwillfocusonseveraldebuggingtechniques,fromtheverysimpletothesophisticated,thatwillhelpyoulocateandresolveproblemsinyourSASprograms.
ItisintendedforallSASusers,frombeginnerstoexperiencedusersoftheSASSystem.
ThisworkshopwillconcentrateontechniquesfordebuggingBaseSASprograms.
SpecificemphasiswillbeplacedontheDataStepDebuggerandhowtouseit.
Iftimepermits,partoftheWorkshopwillbedevotedtodebuggingSCL(ScreenControlLanguage)andMacrolanguageprograms.
WhoShouldAttend:AnyonewhowritesSASprograms.
SomeSASexperiencerequired.
S.
DavidRibaisCEOofJADETech,Inc.
,aSASInstituteQualityPartnerwhospecializesentirelyinapplicationsdevelopment,consultingandtrainingintheSASSystem.
DaveisthefounderandPresidentoftheFloridaGulfCoastSASUsersGroup.
HecharteredandservedasCo-ChairofthefirstSouthEastSASUsersGroupconference,SESUG'93,andservesontheExecutiveCouncilsoftheSouthEastSASUsersGroupandCONSUG,theConsultant'sSASUsersGroup.
HisfirstSUGIwasin1983,andhehasbeenactivelyinvolvedinbothSUGIandtheRegionalSASUserGroupcommunitysincethen.
HehaspresentedpapersandassistedinvariouscapacitiesatSUGI,SESUG,NESUG,MWSUG,SCSUG,andPharmaSUG.
DaveisanunrepententSASbigot.
HismajorareasofinterestareefficientprogrammingtechniquesandapplicationsdevelopmentusingtheSASSystem.
HisSASsoftwareproductspecialtiesareSAS/AFandFRAMEtechnology,SAS/EIS,SAS/IntrNet,andCFO/Vision.
IntegratingSASintoanIntelligentInternet/IntranetApplicationCarolineBahler;ASG,Inc.
;Cary,NCSallyMuller;UNC;ChapelHill,NCSundayMorning,8:00am-12:00pm$70Intelligentinternet/intranetapplicationscanbeconstructedutilizingDynamicHTMLandJavaScripts.
ThiscoursewillcoverHTML,DynamicHTMLandJavaScriptbytakingthestudentsthroughthestepsrequiredtocreateaninteractiveWebapplication.
SectiononeofthecoursewillcoverallaspectsofHTMLandallowyoutoconfidentlycreatestaticWebpages.
SectiontwoofthecoursewillcoverallaspectsofDynamicHTMLandthebasicsofusingJavaScripttocreateinteractiveWebpagesthatsubmitSASjobsandcreatestaticWebpagesonthefly.
ThefinalsectionofthecoursewilllookathowtointegrateHTML,DynamicHTMLandJavaScripttocreateaninteractiveandintelligentapplication.
CarolineBahlerisaSeniorConsultantintheAdvancedSolutionsGroupofASG,Inc.
HereducationalbackgroundisinecologyandshehasaPh.
D.
inAgronomy.
Ms.
BahlerhasbeenusingSASforthepast18yearsinboththeresearchandbusinessenvironments.
SallyMulleristheManageroftheStatisticalSupportgroup,adivisionofAcademicTechnologyandNetworks(ATN),attheUniversityofNorthCarolina.
SallybeganusingSASsoftwarein1978andin1987becameaSASsiterepresentative.
Sincethenshehastaughtover20millionSASintroductorycoursesincluding"PuttingYourSASApplicationontheWeb.
"SallyfindsthatevenpeoplewithlimitedknowledgeofHTMLcanlearntoputtheirSASapplicationsontheWeb.
AdesiretoshowtheeasewithwhichHTML,DynamicHTML,andJavaScriptcanbeusedtocreatestaticanddynamicWebpagesisthemotivationofthispaper.
ASASProgrammer'sViewoftheSASSupervisorIanWhitlock;Westat,Inc.
;Rockville,MDSundayMorning,8:00am-12:00pm$70DoyouwriteSAScodewithoutreallyknowingexactlyhowSASwillprocessyourcodeThenthismini-courseisforyou.
Itisintendedtoanswerquestionslike:AsaDATAstepprogrammer,whatdoIneedtoknowabouttheSASsupervisorandwhyHowdoestheSASsupervisorprocessDATAstepcodeHowdoesaSASMERGEworkWhatroleshouldengines,indexing,andviewsplayinmyprogramsWhathappenswhenmyDATAstepcodecontainsmacrovariablesWhatifmyDATAstepinvokesamacrooriscontainedinamacroInshortitisnotintendedtoteachyouSASsyntax,itisintendedtotohelpyouthinkSAS.
For10years(1983-1992)DonaldHendersonoroneofhiscolleaguesgaveafantasticallysucsessfultutorialabouttheSASSupervisorattheSUGIconferences.
TwoyearsagoIpresentedatutorialatSESUGbuildingonthoseearlierarticlesandaddingmyownexperience.
Inthewordsofoneattendee,"ThebestsessionIwenttowasWhitlock'sontheSupervisor.
Myonlygripewasthatitwaswaytoshort.
IthinkthiswouldmakeagoodSundayafternoon2hoursession.
Forheaven'ssakechangethenameofit-Supervisorsoundssodry.
Callitsomethinglike"WhySASDoesn'tDoWhatITellit".
AreyoureadyforthiscourseHereisatest.
Considerthecodedatalook;inputx@@;cards;1122;data_null_;dowhile(notlast.
x);setlook;byx;put_n_=;end;run;WhatmessageiswrittentothelogwhenthiscoderunsIfyoucannotanswerthequestionwithoutrunningthecode,orwanttoknowwhyafterrunningthecode,thenthiscourseisforyou.
IanWhitlockisaseniorsystemsanalystatWestatworkingonsurveyresearchproblems.
HehasbeenprogramminglargelyinSASsince1981usinganinteractiveenvironmenttodevelopprogramsforexecutioninabatchenvironment.
HeisskilledinproblemsolvinginvolvingSASmacro,PROCSQL,reportingproceduresandtheDATAstep.
Inadditiontoprogramming,heteachesSAScoursestoWestatemployees.
HeisactiveonSAS-L,andhaspresentedmanydifferentpapersatnational,regional,andlocalSASUserGroupmeetings.
ConnectingSAStotheInternetataPriceYouCanAffordKennethA.
Hardy,Ph.
D.
;UniversityofNorthCarolinaatChapelHill;ChapelHill,NCSundayAfternoon,1:30-5:30pm$70Corporations,governmentagencies,educationalinstitutions,andnot-for-profitswanttoincreasetheiruseoftheInternettoacquireandpublishinformation.
OrganizationswhouseSAStomanage,analyze,andreportinformationneedtoknowhowtointerfaceSASwithInternetWebandFTPservers.
ThisworkshopwillshowyouhowtouseSAStoreaddatafromFTPsitesandWebpagesandwritedatadirectlytoFTPsites.
ItwillprovideabriefoverviewofWebpublishingusingbasicHTMLandteachyouhowtoturnSASoutputintoWebpagesusingthePUTstatementandthreepageformattingmacrosfreelyavailablefromSASInstitute.
ItwilltellyouwhichdevicedriverstousewithSAS/GRAPHtoproducegraphsandmapsfordisplayontheWeb.
Mostimportantly,itwillgiveyoutheknowledgenecessaryforcreatingdynamicWebpageswithHTMLformsandCGIscriptsthatrunSAStaskstocreatecustomreportsoranalyses.
Itwillalsoexplainwhenusingthis"free"techniquemaybeanalternativetopayingforandusingSAS/IntrNet.
KennethHardyisAssociateDirectorforInformationSystemsattheInstituteforResearchinSocialScienceoftheUniversityofNorthCarolinaatChapelHill.
HehasbeenaSASuserforovertwenty-fiveyears.
Inadditiontoacademicresearchpublications,hehaspresentedmanypapersatSUGIandSESUGmeetings.
Hehasalsoco-authoredbooksontopicsrangingfromtheinequityofthedeathpenaltytoquantitativeresearchmethodsforhistorians.
Hismostrecentbook,writtenwithFrankC.
DiIorio,isQuickStarttoDataAnalysiswithSAS.
Forthepastthreeyears,hehasbeenwritingWeb-basedapplicationsusingCGIscriptsthatuseSASandtextsearchingsoftware.
Merging,Combining,andSubsettingFiles(Tricks,Traps,andTechniques)MalFoley;UniversityofNorthCarolinaatChapelHill;ChapelHill,NCSundayAfternoon,1:30-5:30pm$70ThisworkshopisforanyonewhomanipulatesSASdatasets.
Itcoversawiderangeoftopicssuchassubsetting,concatenations,theIN=datasetoption,FIRST.
variable,one-to-onemerges,matchmerges,andfuzzymerges.
Theworkshopstartswiththebasicsandcontinuestobuilduptocomplexandtrickyexamplesofdatasetmanipulation.
TheonlyprerequisiteforthecourseisaworkingknowledgeoftheSASDATAStep.
Yet,thisworkshopwillgiveintermediateandadvancedprogrammersagreatreviewandsomesurprises.
ComeseewhatmysterieslurkinmanipulatingSASfiles!
MalFoleyisaSASProgrammer/AnalystwiththeUniversityofNorthCarolinaatChapelHill.
Malhasworkedwithclinicaltrialdataforthepast10years,andsurveyresearchdataformorethan20years.
Hiscareerincludesbeinganinternationalcomputingconsultant,amanagerofseveralcomputingdepartments,andtheCEOofhisowncomputingcompany.
Hehastaughtdozensofcomputerprogrammingcoursesattheundergraduate,graduate,andprofessionallevels.
HehaspublishedpapersandgivenpresentationsatmanyregionalSASuser'sgroupsandSUGI.
SheratonNorfolkWatersideHotel-ReservationRequestFormSESUG'98September13-15,1998GuestName:(Last)(First)M.
I.
)Company/AffiliationMailingAddressCity:StateZipCode:Addressis(CheckOne)HomeBusinessDaytimePhone:Fax:ArrivalDate1998DepartureDate1998ArrivalTime:CreditCard:(Type)Number)(Expiration)(Signature)RoomType:(Single)($99/night)(ClubSingle)($114/night)(Double)($99/night)(ClubDouble)($114/night)(ParlorSuite)350/night)(WetbarSuite)450/night)(Government)Prevailingrates-callhotelfordetailsandreservationsForDoubleOccupancy:(checkone)(King-1bed)(DoubleBeds)NameofAdditionalPersonSmokingPreference:(checkone)(smoking)(nonsmoking)SheratonNorfolkWatersideHotel-ReservationRequestFormSESUG'98September13-15,1998Notes:RatesareineffectfromSeptember4-October8,1998.
ReservationsmustbemadepriortoAugust24,1998inordertotakeadvantageofthespecialSESUG'98rates.
TherearealimitednumberofroomsavailableatthespecialSESUG'98rate.
Therateforremainingroomsatthehotelwillbehigher-ifanyareavailable.
Allroomsaresubjecttoapplicabletaxes,whicharecurrently11.
5%.
Check-intimeis3:00pm.
Check-outtimeis12:00Noon.
FailuretonotifytheSheratonNorfolkWatersideHotelofachangeinarrivaldateortimemayresultinfullcancellation.
Reservationsmustbeguaranteedonamajorcreditcardorwithfirstnight'sdeposit.
Reservationsnotguaranteedaresubjecttocancellationafter4:00pm.
Cancellationsmustbemadewithin72hoursofarrivalinordertoreceivearefundofdeposit.
Foradditionalinformationortomakereservationsbyphone,pleasecalltheSheratonNorfolkWatersideHoteldirectlyat(757)622-6664.
Alternatively,beforeAugust1,calltheOmniNationalReservationNumberat(800)THE-OMNI.
AfterAugust1,calltheSheratonNationalReservationNumberat(800)325-3535.
Mailthisformto:SheratonNorfolkWatersideHotelAttn:ReservationsDepartment777WatersideDr.
Norfolk,VA23510orfaxto:(757)625-8271IMPORTANT:Onlyhotelreservationsshouldbemailed/faxedtothisaddress!
SESUG'98ConferenceRegistrationFormSheratonNorfolkWatersideHotel,Norfolk,VirginiaSeptember13-15,1998Pleasecompleteallsections(bothsides)ofthisform.
Filloutoneformperattendee.
Useadditionalformstoregistermorethanoneperson(aphotocopyisacceptable).
TheConferenceRegistrationFeeentitlesyoutoaccesstoallSESUG'98presentationsanddemonstrations,complimentarybeveragesatmorningandafternoonbreaks,accesstoareceptionandamixer,andadmissiontotheOpeningandClosingSessions.
ItalsoincludesacopyoftheConferenceProgramandConferenceProceedings,otherassortedgiveaways,andbeveragecouponsforuseatthereceptionandthemixer.
TheConferenceRegistrationFeedoesnotincludeWeekendWorkshops,theCONSUGmeeting,lodging,ortransportation.
Section1:FeesConferenceRegistration(Required)EarlyRegistration$180(paymentmustbereceivedbyAugust7,1998)RegularRegistration$210(paymentmustbereceivedbyAugust28,1998)On-SiteRegistration$250(ifpaymentreceivedafterAugust28,1998)OptionalEventsSaturdayAfternoonWorkshops(concurrent-selectone):$70Religion101:UNIXforNon-believersSASDebuggingTechniquesSundayMorningWorkshops(concurrent-selectone):$70IntegratingSASintoanIntelligentInternet/IntranetApplicationASASProgrammer'sViewoftheSASSupervisorSundayAfternoonWorkshops(concurrent-selectone):$70ConnectingSAStotheInternetataPriceYouCanAffordMerging,Combining,andSubsettingFilesTotalAmountEnclosedLuncheon(noadditionalcharge-selectpreference):MondayTuesdayDon'twantafreelunchSection2:PaymentPaymentmustbemadeinU.
S.
currency.
Pleasemakecheckspayableto"SouthEastSASUsersGroup".
TheSESUGFederalTaxIdentificationNumberis59-3122815.
FullrefundsofallfeesidentifiedinSection1willbemadeifwrittennotificationisreceivedbyAugust21,1998.
PleasecontacttheRegistrarattheaddressbelow.
NorefundswillbeissuedafterAugust21,1998.
CheckOne:PurchaseOrderisenclosedMoneyOrderisenclosedCheckisenclosedCreditcardpayment,circleone:MCVisaAmExDiscoverDiner'sCardNumber:Exp.
Date:Signature:Section3:DemographicsNote:FirstName,LastName,Company/Affiliation,City,andStatewillappearonyourconferencebadgeasyoulistthem.
FirstNameLastName:Company/AffiliationMailingAddressCityState:ZipCode:DaytimePhoneFaxE-mailNumberofSESUGconferencesattended:Pleaseletusknowofanyspecialneedsyoumighthave,suchashearing,mobility,orsightimpairment.
AttachaseparatesheettothisRegistrationFormwithdetails.
Returnthisformwithpaymentto:ORfaxthisformto:ORfillouttheWebregistrationformat:SESUG'98SESUG'98http://www.
uga.
edu/~sesugAttn:KathyFinchAttn:RandyFinch122WestOakHillDr.
(256)386-3799IfusingfaxorWebregistration,Florence,AL35633-1013mailpaymenttoaddressatleft.
Ifpayingbycreditcard,youcanregisterbyphoneat(256)764-1726.
Usethissamenumberforquestionsaboutregistration.
Thisregistrationandinformationtelephonelinecanbeusedfrom9:00AMto5:00PMCSTMondaythroughFriday.
NOTE:OnlyConferenceRegistrationFormsandFeesshouldbesenttothisaddress.
CONSUGandhotelreservationrequestsaretobesenttotheirrespectiveaddresses.
SESUGPoliciesandProceduresCONFERENCEPARTICIPATIONGUIDELINESTheannualSouthEastSASUsersGroup(SESUG)Conferenceisprimarilyaneducationalgatheringforthebenefitofitsattendees.
SESUGrecognizesthatthemajorityofattendeesarepresentasrepresentativesoftheiremployersforthispurpose.
Accordingly,SESUGdoesnotcondone,endorse,orencourageactivitiesthatmayconflictwiththeeducationalnatureoftheconference.
AllattendeesandvendorsareexpectedtoabidebythePoliciesandProceduressetforthinthisdocument.
PaperContentUsersareurgedtopresentpapersdescribingrealworldapplicationsusingSASInstitutesoftware.
SESUGalsoacceptsalimitednumberoftheoreticalandgeneraloverviewpapers.
AcceptanceofallpresentationsisatthediscretionoftheConferenceCo-chairs.
Oralpresentationsandwrittenpapersdescribingproductsorservicesofacommercialnaturemayonlybepresentedattheconferenceif:TheydescribehowthatproductrelatestotheuseofSASInstitutesoftwareTheydoNOTincludepricelists,supportcommitments,orothermaterialofapromotionalorsalesnature.
RightofWithdrawalTheSESUGExecutiveCouncilandtheConferenceCo-chairsreservetherighttodetermineifanyactivityisinviolationoftheseGuidelines.
Theymay,attheiroption,directthewithdrawalofapresentationordemonstrationorthedismissalofaSESUGattendeefromtheconference.
MarketingandRecruitingAnypersonorentitywishingtomarkettheirproducts/servicesorwhosepresenceisprimarilytorecruitattendeesattheannualSESUGconferencemustregisterasavendor.
Registeredvendorsareexpectedtoconductthemselveswithprofessionalism.
TheSESUGExecutiveCouncil(EC)reservestherighttorefuseanyorallvendorregistrations.
Inadditionto,orinlieuof,aphysicalpresenceattheannualSESUGconference,vendorsmaychoosetohaveavirtualpresencethroughmeansofadvertising.
Advertisingopportunitiesaredelineatedbelowanddonotrequireseparateregistrationofthevendor.
TheConferenceProgrammayincludeprintedvendoradvertisements.
AlladvertisingisacceptedatthediscretionoftheSESUGConferenceCo-chairs.
Afeemaybeassessed.
Salesliteratureandpromotionalitemsmayonlybedistributedtoconferenceattendeesinanapprovedmanner.
ItemsfordistributionmustbesubmittedtoadesigneeoftheConferenceCo-chairsandaresubjecttoapprovalofformandcontent.
Afeemaybeassessed.
VendorswhowishtosponsorthegoalsandaimsofSESUGmayberecognizedpubliclyatthediscretionoftheConferenceCo-chairs.
Distributionofsalesliteratureandotherpromotionalitemswillbelimitedtotheaboveprocedures.
TheConferenceCo-chairswillissuespecificrequirements(e.
g.
-content,deadlines,andcosts)forthesevendorpromotionalopportunities.
SESUGdoesnotcondone,endorse,orencourageunauthorizedhospitalitysuitesorothersimilarunauthorizedactivities.
Intheeventofanyquestionsofinterpretation,thedecisionoftheConferenceCo-chairswillapply.
Non-registeredvendorsmaynotengageinanydirectmarketingorsaleseffortattheconference.
ConferenceChecklistRegisterandpayfortheconference.
SeetheRegistrationFormonpages71-72fordetails.
Thisstepisrequired!
Arrangetransportation(seepage2forcontactinformationforHarboursideTravelServices,Inc.
).
MakereservationsattheSheratonNorfolkWatersideHotel(seepages69-70forreservationform),theClarionHotel,oranotherhotelofyourchoice.
SignupfortheCONSUGmeeting(page3).
Thisstepisoptional.
Signupforyourchoice(s)ofWeekendWorkshops(page66).
Thisstepisoptional.
Bringacreditcard,personalcheck,cash,orpurchaseordertotakeadvantageoftheConference's15%discountonSASInstitutebooks.
DatestoRememberJune15,1998RegistrationopensAugust7,1998LastdayfordiscountedEarlyRegistrationrateAugust21,1998LastdaytocancelyourconferenceregistrationandreceivearefundAugust24,1998LastdaySESUGroomratesarehonoredattheSheratonNorfolkWatersideHotelAugust24,1998LastdaySESUGroomratesarehonoredattheClarionHotelAugust28,1998LastdayregularRegistrationrateisineffectSeptember13-15,1998SESUG'98!
SESUG'97attendeessaid:"Overall,Ilearnedagreatdealattheconference.
""IreallyenjoyedandlearnedalotfromShopTalks.
""AsabeginningSASuserIwasreallyimpressedwithallIlearned.
""Thankyou!
Welldone!
Organized,wellexecuted.
Hadagreattime.
Goodbalancebetweensessionsandfreetime.
""SASInstitutesentexceptionallyknowledgeablepeople.
Insmallergroup[theywere]easiertoaccess.
""Lovedit.
"