Hi, I want to check the id value equal to 4 or not, if it is 4 then i require sum of id and age of previous observation...Example as follows Input Data: data dat1; input id age; cards; 1 10 2 10 3 10 4 10 5 10 6 10 4 10 ; run; Output: id age total 1 10 2 10 3 10 13 4 10 5 10 6 10 16 4 10 Provide me sas code for this query... Thankyou! ... View more

Hi, Base dataset month a/cno amount jan 1001 100 jan 1001 200 jan 1001 100 jan 1001 100 jan 1001 200 jan 1001 500 jan 1002 500 jan 1002 500 i require output dataset like this month a/cno amount count jan 1001 100 1 jan 1001 100 2 jan 1001 100 3 jan 1001 200 1 jan 1001 200 2 jan 1001 500 1 jan 1002 500 1 jan 1002 500 2 Require count for repetitive amount...by month and a/c no provide me the code... Message was edited by: NIKKI ... View more

Hi, I created cubes in SAS DI 3.4, now i am looking for publish cubes using Asp.Net, it must provide information about profit, revenue and expenditure for different dimensions like Time wise, Product wise, Geogrpahy wise and Channel wise. My Question is How to connect to sas cubes from Asp.net and how to publish them and is it possible or not, if possible how, What we require. Please provide information regarding this query. ... View more