Hi all, I have three variables Month, Type of Fruits and The number of sales (Count) each month. The data as arrange below. Month Fruits Count 2007/08 Apple 5 2007/08 Apple 6 2007/08 Strawberry 4 2007/08 Strawberry 1 2007/08 Orange 22 2007/08 Orange 90 2007/07 Apple 25 2007/07 Apple 4 2007/07 Strawberry 83 2007/07 Strawberry 80 2007/07 Orange 25 2007/07 Orange 25 2007/06 Apple 10 2007/06 Apple 6 2007/06 Strawberry 7 2007/06 Strawberry 96 2007/06 Orange 61 2007/06 Orange 22 Just wondering, say for example, if I just want a line graph just for the sales of apple in that three months (Jun-Aug 2007). How do I plot it? Hope you can help. Cheers! Yennie ... View more

Hi people, I am finding hard to understand the use of parameter in SAS Eguide. I know it allows a user to select certain values to be ran in stored process. However, I created parameter and ran the script, seriously, still couldn't figure out how it helps me stored process. is there any helpful articles that really helps me understand the use of parameters? Also how to create parameters in proper way? cheers, Yennie ... View more

Hi People, I am trying to assign this library permanently in SAS Eguide with the ref given below LIBNAME basedata sasspds "M_A_C30_PI_GIO" server=&spdshost..5090 user="&uid." passwd="&pw." group='production' ; I went through Tools > Assign Library > Library Wizard, came up with this error: ERROR: ERROR: LIBNAME path info not found in SPD Name Server.. ERROR: Error in the LIBNAME statement. Is there any notes around that help me out to assign this library correctly? Cheers, Yennie ... View more

Hi All, I am currently using SAS9.1 to build a tool to monitor motorbikes sales, new business, monthly GWP for my company. My manager would like that to be output as html pages in a way that there's drop down menus that allow him to select the different data that he would like to view at a particular month sold by a particular motorbike dealer. At this moment, I'm not very good with working with ODS HTML or MARKUP and having alot of difficulties stitching the html pages up and also really unsure if I can embed javascript on my html pages. I am hoping someone out there can direct me to some really helpful SAS notes and also a couple of powerful monitoring tool that was build out of SAS. Looking forward to everyone's suggestions! Cheers. Yennie ... View more

Hi People, I am trying to assign a oracle library in SAS 9.2 something similar to this libname mydblib oracle user=u317092 password=*** path='jdbc:oracle:thin:@JEEPROD1:1526:PRD0GIP'; however, my log came up with this error 7522 libname mydblib oracle user=u317092 password=XXXXX 7522! path='jdbc:oracle:thin:@JEEPROD1:1526:PRD0GIP'; ERROR: The ORACLE engine cannot be found. ERROR: Error in the LIBNAME statement. does anyone knows how to solve this? thanks in advance! Cheers. ... View more

Hi all, I am using SAS 9.2 at the moment and I understand that under Tools > Options > Preference > Results > Create HTML shows the directory of where my html page is going to be saved whenever i generate a html. Is there any script that I can write that will automatically direct my html page to be saved to my desired directory without having to manually go to Tools > Options to change it every time I run the script ? Hope someone can help. Cheers! ... View more

I found myself repeating the below datastep five times. I know %macro can help me to save the effort of writting the script over and over again. However, I am unsure on how to use it. =/ Hoping someone can help me out! Proc Summary Data = GIO_VOR Nway Missing; Class month GioBike_Grp; Var claimCount epy earnedPrem incurToDate; Output out = Gccgrp (Drop = _Type_ _Freq_) Sum=; Run; Data Gccgrp; Set Gccgrp; Length Claims_Frequency 8. Loss_Ratio 8.; Claims_Frequency = (claimCount/EPY) * 100; Loss_Ratio = (incurToDate/earnedPrem) * 100; Run; Proc Summary Data = GIO_VOR Nway Missing; Class month GioCover_Type; Var claimCount epy earnedPrem incurToDate; Output out = Gcover (Drop = _Type_ _Freq_) Sum=; Run; Data Gcover; Set Gcover; Length Claims_Frequency 8. Loss_Ratio 8.; Claims_Frequency = (claimCount/EPY) * 100; Loss_Ratio = (incurToDate/earnedPrem) * 100; Run; Proc Summary Data = GIO_VOR Nway Missing; Class month GIO_Ageband; Var claimCount epy earnedPrem incurToDate; Output out = GAgeband (Drop = _Type_ _Freq_) Sum=; Run; Data Gageband; Set GAgeband; Length Claims_Frequency 8. Loss_Ratio 8.; Claims_Frequency = (claimCount/EPY) * 100; Loss_Ratio = (incurToDate/earnedPrem) * 100; Run; Proc Summary Data = GIO_VOR Nway Missing; Class month GioChannel_Grp; Var claimCount epy earnedPrem incurToDate; Output out = Gchannel (Drop = _Type_ _Freq_) Sum=; Run; Data Gchannel; Set Gchannel; Length Claims_Frequency 8. Loss_Ratio 8.; Claims_Frequency = (claimCount/EPY) * 100; Loss_Ratio = (incurToDate/earnedPrem) * 100; Run; Proc Summary Data = GIO_VOR Nway Missing; Class month GioBike_Make; Var claimCount epy earnedPrem incurToDate; Output out = Gbikemake (Drop = _Type_ _Freq_) Sum=; Run; Data Gbikemake; Set Gbikemake; Length Claims_Frequency 8. Loss_Ratio 8.; Claims_Frequency = (claimCount/EPY) * 100; Loss_Ratio = (incurToDate/earnedPrem) * 100; Run; Much Appreciated. Yennie ... View more

Just wondering if there is any article that explains the steps to create Stored Process? And what exactly does it do? cheers. ... View more