I look up to you for SAS!! Thanks a lot 🙂 I am going to get that book!! ... View more

Thanks @novinosrin   and the book  Author Ron Cody Learning SAS by example  is good for a basic SAS user like me?(to start) 😛 ... View more

@novinosrin thanks a lot!!   Could you please suggest a few topics that I should study or practice to be able to write such queries by myself? ... View more

Thanks a lot @novinosrin!! ... View more

Thank you so much @novinosrin for taking the time to explain this 🙂 I got it 🙂 ... View more

Thank you sooooooo much @novinosrin 🙂   I know this might be asking a bit too much , but can you run 1 iteration for me:   eg: when n=1 inc_rain_snow would have the name of the elements of the array which are : Income Rain Snow      how will be column area get its value of  A A A ?    value (10,100,1)  (which is the first row in have table) will get transposed when j=1     ... View more

@novinosrin Thanks a lot!! I understood it better !! I will read up about the implicit loop , I still didnt understand that part completely do over j; Inc_rain_snow=vname(j); value=j;   For, Inc_rain_snow=vname(j), SAS would do : I          R        S         How will it know to put the areas(A,B,C,D) in the next column..(through the retain statement??)     ... View more

hahah, yes, it is !! Please go ahead and prepare for your mid-term! Good Luck 🙂   When you are back, read below and let me know if it makes sense..this is how I understand it: data t;      // so here you are creating a new table which is blank at the moment but will hold values as you assign them?// retain Inc_rain_snow area value;           // new column names ??// set have;                                                //what does set do??// array j income--snow;                            //a blank array containing j(a variable) income rain snow(income rain snow from table have) ?? do over j;                                               //no idea what this means// Inc_rain_snow=vname(j);                     //assigning j which is the first column in table "t" the name Inc_rain_snow ??// value=j;                                                 //how does this work?? How will the values be picked?? // output;                                                  //suppose this is part of syntax??// end;                                                      /suppose this is part of syntax??// keep Inc_rain_snow area value; run; proc sort data=t out=want; by Inc_rain_snow area; run;   If there is a source where I can understand this with the help of an example, please let me know 🙂 ... View more

Thanks  I didnt quite understand it 100percent, but thanks a lot:) ... View more

You rock Novinosrin!!   Can you explain this solution pleaseeeee ... View more

    Thanks Novinosrin!   The output I get using this is :   BUt I want the output as : AS in I want Income/Rain/Snow to be the first Column  ... View more

Area Income Rain Snow A 10 100 1 B 20 200 2 C 30 300 3 D 40 400 4   Income A 10 Income B 20 Income C 30 Income D 40 Rain A 100 Rain B 200 Rain C 300 Rain D 400 Snow A 1 Snow B 2 Snow C 3 Snow D 4 ... View more