09-01-2015
Kpatel306
Calcite | Level 5
Member since
11-25-2013
- 14 Posts
- 0 Likes Given
- 0 Solutions
- 0 Likes Received
-
Latest posts by Kpatel306
Subject Views Posted 5930 07-03-2014 11:53 AM 6228 07-03-2014 09:06 AM 12812 11-27-2013 12:12 PM 13706 11-27-2013 11:58 AM 673 11-26-2013 09:31 AM 6002 11-26-2013 09:30 AM 736 11-25-2013 12:48 PM 6079 11-25-2013 12:35 PM -
Activity Feed for Kpatel306
- Posted Re: Message Box like Excel VBA in SAS on SAS Programming. 07-03-2014 11:53 AM
- Posted Message Box like Excel VBA in SAS on SAS Programming. 07-03-2014 09:06 AM
- Posted Re: Log and Antilog on SAS Programming. 11-27-2013 12:12 PM
- Posted Log and Antilog on SAS Programming. 11-27-2013 11:58 AM
- Posted Re: Calculating the average based on different columns for different rows on SAS Programming. 11-26-2013 09:31 AM
- Posted Re: Assign value to variable from table using on SAS Programming. 11-26-2013 09:30 AM
- Posted Calculating the average based on different columns for different rows on SAS Programming. 11-25-2013 12:48 PM
- Posted Assign value to variable from table using on SAS Programming. 11-25-2013 12:35 PM
07-03-2014
11:53 AM
Yes, you are right. I just want that process is run and job is done. i want this for Non SAS user, who just run my code and at the end they get such type of messagge.
... View more
07-03-2014
09:06 AM
Hi There, Anyone have any idea about how can we create a Message Box in SAS as we do in Excel VBA? I want to pop up a message like "Program is Completed" at the end of my program, so that person who dont know SAS and running my SAS projects, can get to know that prcess is finsihed now. Thanks, KP
... View more
11-27-2013
12:12 PM
Thanks Reeza, I have seen that before and use that function in my code, but I think I did some mistake in using EXP, so it was not working. But now its working. Thanks a lot.
... View more
11-27-2013
11:58 AM
Hi, anybody can guide me how can I do the reverse log in SAS. i.e.: LOG(98167.94) is 4.99196967766037 I want to convert 4.99196967766037 to 98167.94. Thanks, KP
... View more
11-26-2013
09:31 AM
Thanks Paige its working Thanks a lot
... View more
11-25-2013
12:48 PM
Hi, Anyone one can help me how can I calculated the average based on different columns for different rows: e.g: I want to calculate the field "Average" based on defined column name in "SAvg" to "EAvg": in first row I want to calculate the average for row M5 to M10 (i.e. 85,589), in second row M5 to M9 (i.e.154,669), and so forth. Source M1 M2 M3 M4 M5 M6 M7 M8 M9 M10 SAvg EAvg Average Coll1 £ 12,547 £ 86,417 £ 80,289 £ 102,858 £ 96,533 £ 91,042 £ 82,901 £ 100,368 £ 74,033 £ 68,658 M5 M10 Coll2 £ 109,891 £ 65,897 £ 67,685 £ 456,987 £ 456,987 £ 65,897 £ 102,985 £ 65,897 £ 81,577 £ 65,897 M5 M9 Coll3 £ 138,245 £ 93,213 £ 104,059 £ 456,987 £ 456,987 £ 456,987 £ 101,874 £ 93,213 £ 65,897 £ 65,897 M4 M8 Coll4 £ 102,852 £ 99,359 £ 101,605 £ 98,892 £ 93,213 £ 456,987 £ 456,987 £ 65,897 £ 99,617 £ 83,941 M5 M10 Coll5 £ 65,897 £ 81,481 £ 81,481 £ 108,522 £ 456,987 £ 95,261 £ 77,686 £ 100,531 £ 95,412 £ 103,649 M4 M7 Coll6 £ 65,897 £ 86,797 £ 82,744 £ 138,464 £ 456,987 £ 107,854 £ 97,684 £ 116,621 £ 456,987 £ 456,987 M2 M6 Thanks, KP
... View more
11-25-2013
12:35 PM
Hi, Anybody can help me on - how to create a macro variable using SYMPUT (or if is there any other way ) to crate the macro variable and to assign a value from table. e.g.; from below table I want to assign value 0.82% to AMR001, 0.58% to AMR002 and so forth. Variable Value AMR001 0.82% AMR002 0.58% AMR003 0.54% AMR004 0.57% AMR005 0.59% AMR006 0.75% AMR007 0.64% AMR008 0.93% AMR009 0.84% AMR010 0.66% AMR011 0.63% AMR012 0.62% AMR013 0.99% AMR014 0.62% AMR015 0.68% AMR016 0.70% AMR017 0.74% can anyone guide me how can I do that. Thanks, KP
... View more