Pls Provide a Small exapmle.... Thanks. ... View more

Hi user, data test; input date yymmdd8.; cards; 20050110 ; proc print; format date ddmmyy10.; run; Venkatesh. ... View more

As per my Knowledge there is no such type of option in WRS. the source data in IMS it self u have to modify the table as u want the display in WRS. u can sort the variable in IMS. venkatesh. ... View more

and u can do this while creating stored process u can change the meta data location at modify tab. Venkatesh... ... View more

Hi Lee., data grocery; input Sector $ Manager $ Department $ Sales @@; datalines; se 1 np1 50 se 1 p1 100 se 1 np2 120 se 1 p2 80 se 2 np1 40 se 2 p1 300 se 2 np2 220 se 2 p2 70 nw 3 np1 60 nw 3 p1 600 nw 3 np2 420 nw 3 p2 30 nw 4 np1 45 nw 4 p1 250 nw 4 np2 230 nw 4 p2 73 nw 9 np1 45 nw 9 p1 205 nw 9 np2 420 nw 9 p2 76 sw 5 np1 53 sw 5 p1 130 sw 5 np2 120 sw 5 p2 50 sw 6 np1 40 sw 6 p1 350 sw 6 np2 225 sw 6 p2 80 ne 7 np1 90 ne 7 p1 190 ne 7 np2 420 ne 7 p2 86 ne 8 np1 200 ne 8 p1 300 ne 8 np2 420 ne 8 p2 125 ; proc report data=grocery nowd; column manager department sales; define manager / order width=8 'Sales Manager'; define sales / analysis sum format=dollar7.2 'Sales'; /* break after manager / dol summarize suppress skip; */ rbreak after /dol summarize; run; Thanks..... ... View more

Hi Michel., If u want all the 20 data sets in a single dataset do as follows data test; set sashelp.column sashelp.company ------------------ ------------------ ------------------; run; proc print; run; and if u want to 20 datasets in a permanent library and assign a library. ... View more

Hi Brad... u can go like this way also.... data columbia(drop=ustreet1 ustreet2); input ustreet1 ustreet2; intersection=compress(cats(ustreet1,ustreet2)); cards; 123 235 564 562 235 562 ; proc print; run; ... View more

Hi sams., Actually i don't know Time serious analysis...but i tried...i got some values., please verify it hope its help u get exact values..... u r using SAS/Base.... first read the table and convert it as a data set. and go to solutions-->analysis-->Time serious Forecasting system. from here follow the instructions wizard..... i got the values for year 2008 and 2009 are from oct......... for 2008 oct, nov and dec... 4040 4350 4660 for 2009-----4970 5280 5590 5900 6210 6520 6830 7140 7450..... ... View more

I Resolved with Hot Fix. ... View more

Hi Flip., my exact problem is, i have a data in the form of application like (Invoice). In that quantity and rate per each quantity is available. i required these two fields from Quick Books. but unable to get the data from invoice. ... View more

Hi Liz., For me there is no option called Print to File. and thanks for u'r co operation. ... View more

Hi Patrick., Am not suppose to install any software in system. Is there any another way to write code either .NET or any...... Premier edition for Quick Book 2008 under 2003 OS server. ... View more