About jdk123

jdk123 · ‎07-18-2011

I am interested in the SAS BI to produce the financial reporting at the monthly basis. Can anyone provide some feedback on the comparisons among the major competitors: such as SAS BI, SAP Crystal reporting, and IBM BI platform? Thanks,

jdk123 · ‎05-18-2011

I would like to implement an interactive excel web client to interact with the stored process. can anybody shed some lights on this? thanks, Message was edited by: jdk123

jdk123 · ‎04-07-2011

I am new to the OLAP cube design. I have the OLAP studion 4.2. can you let me know a demo program which can be imported to the studion, so I can play with it. Thanks in advance,

jdk123 · ‎04-05-2011

Can anyboby explain the details of the OLAP TOOL? 1. How the olap cube build in the studio? does this require the coding effort? 2.how the dimenssional model can be done? does this need coding effort? 3. any sas tool or other tool to perform the dimenssional modeling, thanks, Message was edited by: jdk123

jdk123 · ‎04-01-2011

for instance: one of the observation from the datasets: total of 60 columns col1 col2 col3 col4....col60. i would like to perform the calculations for the last three columns, such as col58 col59 col60. the total of the columns is changing. how can i calculate the total of col58..col60

jdk123 · ‎03-31-2011

the variable name is _2001 _2002

jdk123 · ‎03-31-2011

dataset1: 2001 $500 $400 200 300 2002 $600 $300 100 200 After transpose: dataset2: _name_ 2001 2002 acct1 $500 $600 acct2 $400 $300 acct3 200 100 acct4 300 200 as you can see from dataset2 two different data types asscociated to the year variables. I would like to perform some calculations for instance: acct1 $600-$500=$100; acct3 100-200 =100. is this possible, if yes, how to handle this situation? Thanks,

jdk123 · ‎03-30-2011

Thanks so lot.you have been great help.

jdk123 · ‎03-30-2011

dataset contains the followwing values: tem1 year acct1 acct2 acct3 2001 $100.0 200 $300 2002 $400 500 $600 after transpose: proc transpose data=tem1 out=tem ; id year; run; 2001 2002 acct1 100 400 acct2 200 500 acct3 300 600 what I am expecting after the transpose: 2001 2002 acct1 $100 $400 acct2 200 500 acct3 $300 $600 question: how can i keep the original format of the data? such as the $100..

jdk123 · ‎03-28-2011

is there a shortcut to keep only the last column in the dataset? for instance, keep last_column Thanks,

jdk123 · ‎03-24-2011

Thanks Oliver, you have been great help.

jdk123 · ‎03-24-2011

the current_date='01feb2011'd; how to identify the last month of the last quarter of the current data '01feb2011'd? thanks,

jdk123 · ‎03-24-2011

input file from excel looks like the following: case1 Jan-06 Feb-06 Mar-06 Apr-06 item1 £23 £78 £78 £88 item2 £21 £76 £77 £888 item3 £67 £66 £88 £88 case2 Jan-06 Feb-06 Mar-06 Apr-06 item4 56 55 5 5 item5 34 55 5 5 item6 45 5 5 5 questions: 1. what is a best way to read in the file to a dataset? it is a good practice to read in the titles for both case 1 and case2? 2. how can i add in two additional columns for both case 1 and case2 and reproduce the output by using the same format as above; wih the final report how to have the user to view the formulas set in the original spreadsheet file? 3. is possible to add additional columns with group values to the output file. for instance: additional columns name: myValue 12345 34567 1% thanks for your time. Message was edited by: jdk123

jdk123 · ‎03-24-2011

creating the file now update Message was edited by: jdk123

jdk123 · ‎03-23-2011

Thanks Cynthia, and I apologized for my confusing you. if you could would you apply the proc report in your post. and repost your result here. That will be perfect. I am new to this area. Thanks so lot

Online Status	Offline
Date Last Visited	‎09-01-2015 07:11 AM

Financial Reporting

how to implement an interactive excel web client

demo to olap cube design

SAS OLAP studio

how to position the columns in the same observation

Re: mixted data types for the same variable

mixted data types for the same variable

Re: how to keep the original format in the dataset before traanspose

how to keep the original format in the dataset before traanspose

how to keep only the last column in the dataset

Financial Reporting

how to implement an interactive excel web client

demo to olap cube design

SAS OLAP studio

how to position the columns in the same observation

Re: mixted data types for the same variable

mixted data types for the same variable

Re: how to keep the original format in the dataset before traanspose

how to keep the original format in the dataset before traanspose

how to keep only the last column in the dataset

Re: sas function

sas function

Re: csv files handling in sas

Re: csv files handling in sas

Re: csv files handling in sas