/****************************************************************/ /* S A S S A M P L E L I B R A R Y */ /* */ /* NAME: hpds2 */ /* TITLE: Getting Started Example for PROC HPDS2 */ /* Run DS2 Code on Grid - Simple Example */ /* PRODUCT: HPA */ /* SYSTEM: ALL */ /* KEYS: DS2 code */ /* PROCS: HPDS2 */ /* DATA: */ /* */ /* SUPPORT: */ /* REF: SAS/HPA User's Guide, PROC HPDS2 chapter */ /* MISC: */ /* */ /****************************************************************/ data daily_temps; input city $ mon tue wed thu fri; datalines; lax 88 92 94 97 86 sfo 65 60 75 72 74 nyc 99 95 94 95 90 phl 92 89 91 93 94 atl 95 99 92 98 94 den 85 87 89 72 73 pit 68 70 72 73 77 rdu 98 95 99 95 96 dtt 88 90 90 87 92 anc 51 56 60 64 62 sea 72 78 77 80 79 msy 98 97 99 98 99 mia 95 92 98 94 96 ord 87 85 84 80 79 dfw 95 96 97 95 97 hou 98 99 98 97 92 las 104 105 102 99 101 pdx 78 82 76 74 80 san 80 81 78 82 80 phx 95 98 95 97 100 cle 75 72 76 80 78 ont 78 80 78 81 72 tpa 94 94 92 90 92 bos 80 78 77 75 79 clt 83 80 79 80 81 ; run; libname applianc &ENGINE server = "&GRIDDATASERVER" user = &USER password = &PASSWORD database = &DATABASE; proc hpds2 data=daily_temps out=applianc.avg_temps; performance host="&GRIDHOST" install="&GRIDINSTALLLOC"; data DS2GTF.out; dcl double avgf avgc; dcl char(5) synopsis; method run(); set DS2GTF.in; avgf = mean(mon, tue, wed, thu, fri); avgc = round((avgf - 32.0) * 5.0/9.0, .1); if avgf >= 95.0 then synopsis = 'Hot'; else if avgf > 80.0 then synopsis = 'Warm'; else if avgf > 60.0 then synopsis = 'Mild'; else synopsis = 'Cold'; end; enddata; run; proc print data=applianc.avg_temps; title1 'Average Temperatures'; var city synopsis avgf avgc; run;