Yes, that's a very nice book(little SAS Book). Also try these  books, they are wonderful for all level- beginner to advanced sas users: 1. sharpening your SAS skills- by sunil gupta 2. SAS Statistics by example-  By Ron Cody 3. Learning SAS by Example: A Programmer's Guide - by ron cody..one of the finest ever SAS books, many people's favorite 4. For Proc SQL- Your best bet is "Proc SQL beyond the basics"- by Kirk Paul Lafler if you master the above 4, you are certain to become a great SAS programmer ... View more

data have; input field; datalines; 5 5 8 10 10 ; data want; set have; by field; if first.field then New_column=0; New_column+1; run; ... View more

I fully agree with Xia, it's just a matter of understanding the concept fully and thoroughly well. Of course, if you have great mentors like Ian, Art or Xia its a lot less tedius to comprehend concepts at a faster pace and likewise I am in need of that too. Like you are a big fan of Ian, I am a big fan of Dr. Arthur Tabachneck. All the best! Art, I'll reach out to you offline for the link of Ian's posts, and besides that if you saved your own great stuff, I'd appreciate if you can share that too. Regards, Naveen Srinivasan L&T Infotech ... View more

Hi, I'm afraid I am very busy in the middle of my work right now, and so don't have the time to look through your data in detail to understand it. Also, I'd like to ask a few questions: 1. Are you trying to build a predictive model? if so, what's your dependent variable for regression? 2. Or is your objective to build a time series model based on the qunatitative data in the dataset? 3. Your statement- "i need to run two types of regressions one is yearly and one is overall". On what variable do you want to do this? More info can only help us to help you. If your initial objective is to do a descriptive, I'd suggest create a 3 different macro variables that will have the value of the 3 types you mentioned frontier, developed and emerging. Then filter them to three datasets with a IN operator and an output statement, so you get 3 datasets containing 3 different groups respectively. Then do a proc univariate taking each dataset as input with the plot option, to arrive at a box plot. These tasks should get you started with descriptives. Either way,  your best bet is you need responses from folks who have the time to get the business understanding to transform them to SAS logic. If you are lucky, you should get great responses  from Art, Xia,PG, Reeza, or Steven. Honestly, i am not even close to any of these guys nor I have that much time as I consumed at work. However, I like to try! ... View more

data have; input x y z a b c; datalines; 1 2 3 4 . . 5 8 9 1 2 3 1 4 7 8 5 6 4 5 6 7 8 9 . . . . 5 6 run; data want; set have end=last; array arrayname _numeric_; array arrayname2(*) x1 y2 z2 a2 b2 c2; retain arrayname2; if _n_=1 then do; do i=1 to dim(arrayname); arrayname2(i)=arrayname(i); end;               end; if last then do; if b2=. then b2=b; if c2=. then c2=c; output;            end;            keep  x1 y2 z2 a2 b2 c2; run; data want2; set have; if _n_=1 then set want; array arrayname(*) x y z a b c; array arrayname2(*) x1 y2 z2 a2 b2 c2; do i=1 to dim(arrayname); if arrayname(i)=. then arrayname(i)=arrayname2(i); end; keep  x y z a b c; run; Is this what you want? ... View more

Hello Sir, We at L&T Infotech,India exactly encountered the same problem in our on going project last week and after despairing attempts, we could not still not get SAS to access sharepoint. We raised a ticket with SAS technical support in india and after their failed attempts the ticket was transferred to SAS USA, nonetheless the issue has still not been resolved and the ticket is still open. Yes, SSPI option was the recommendation they gave and bore no fruit. However, we did a work around downloading the file with a VB script and also tried calling the VB script from batch script and that worked fine. For now, we have chosen to go with this approach. If you need more help, i will try to get more details from my admin and see what best I can share with you that made us progress in our project. Wishing you a merry Christmas!!!! An excerpt from my SAS Admin that I can share: "We tried downloading sample file from sharepoint sites using sas code by making changes in the configuration files. The success rate is 1 out of 10 means the same sas code which had successfully downloaded the file was ran without making any changes to it; it fails giving multiple errors as below. We are getting 2 type of errors for same set of code, technical support  track was raised with SAS India and this was shown to them via web-ex session and they are following up with US technical support for the fix since they are not able to solve it" And another one from SAS tech support:- "Hi Naveen, You need to start the SAS session that you are running Proc Http from with the "-sspi" option Example: sas -sspi Let us know if that fixed that error if you using windows You should be able to right click on the SAS 9.4 icon and select properties. There should be Short cut tabl with a target defined. You should be able to add the option there." ... View more

Hi,Can you do the favor of simply printing the list as open text here or as xls files as opposed to the attachment coz I am an unable to open the attached sas datasets?Sorry for the inconvenience ... View more

Sorry not tested for the reason I am not sitting in front of my SAS software so my apologies that I can't test or give you a code that you can use as a verbatim. However on a first glance of your data from my cell phone, this is the code that comes to my mind: Data want(drop= i /*and your year variable list*/); set have; array arrayname  _numeric_ ; /*assuming year variables are numeric- so easily grouped*/ do i=1 to dim(arraynme); year=vname(arrayname(i)); GDP=arrayname(i); output; end; run; Please do the necessary changes accordingly and you should be able to make it to work for you. If the logic is wrong, my sincere apologies in advance Thanks, Naveen Srinivasan L&T infotech. ... View more

And if you want to just keep the names, not having to deal with renaming after in my previous: proc sort data=have out=have2; by tran_id tran_dt; run; data want2; set have2; by Tran_id Tran_dt; array real(3) TRAN_ID TRAN_DT  amt; array copy(3) tran_id2 tran_dt2 amt2; retain copy; if not last.Tran_id then do; do i=1 to dim(copy); copy(i)=real(i); end;                 end; if last.Tran_id then do; do i=1 to dim(copy); real(i)=copy(i); end; output;                 end; keep TRAN_ID TRAN_DT  amt; run; ... View more