cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
ender_akpil
‎09-01-2015
  • 11 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Dynamically assign column name

by Calcite | Level 5 in SAS Programming
‎12-21-2011 03:28 AM
‎12-21-2011 03:28 AM
Hi everybody, I have a data that i want to transform it. Here is the original data and the data that i want. data target; id=1; year=2007; Jan=10; Feb=11; March=12; Apr=10; May=8; June=6; July=7; Agust=8; Sep=9; Oct=10; Nov=11; Dec=12 ; output; id=1; year=2008; Jan=11; Feb=12; March=13; Apr=11; May=9; June=7; July=8; Agust=9; Sep=10; Oct=11; Nov=12; Dec=13 ; output; run;   Obs    id    year    Jan    Feb    March    Apr    May    June    July    Agust    Sep   Oct    Nov    Dec             1      1    2007     10     11      12      10     8       6       7       8           9        10     11     12             2      1    2008     11     12      13      11     9       7       8       9          10        11     12     13 i want this data in that form:                                                       Obs    year    goal                                                          1    2007     10                                                          2    2007     11                                                          3    2007     12                                                          4    2007     10                                                          5    2007      8                                                          6    2007      6                                                          7    2007      7                                                          8    2007      8                                                          9    2007      9                                                         10    2007     10                                                         11    2007     11                                                         12    2007     12                                                         13    2008     11                                                         14    2008     12                                                         15    2008     13                                                         16    2008     11                                                         17    2008      9                                                         18    2008      7                                                         19    2008      8                                                         20    2008      9                                                         21    2008     10                                                         22    2008     11                                                         23    2008     12                                                         24    2008     13 I do it  this way: data test(keep=year goal); array v_month{12} Jan Feb March Apr May June July Agust Sep Oct Nov Dec  ; set target; do c=1 to 12;     yil=id;     goal=v_month{c};     output; end; run; i wonder is there any other way, since in the orginal source table sometimes more than 100 columns!!! ... View more

data step execution

by Calcite | Level 5 in SAS Programming
‎12-21-2011 02:58 AM
‎12-21-2011 02:58 AM
Thanks Tom.. Still i want to ask, should lag function should use same que? i mean this is more meaningfull isnt it? I come across with this problem while i was searching equivalent of oracle partitioned analytic query ( row_number over (partition by a order by b asc) ) Is there a anoher way to do this? ... View more

data step execution

by Calcite | Level 5 in SAS Programming
‎12-20-2011 06:23 PM
‎12-20-2011 06:23 PM
Thanks Tom, this is very nice code.. I have a question about lag2 variable, if lag's in the data step follw their own que then lag2 values should be: lag2=. lag2=1 lag2=2 lag2=2 lag2=3 lag2=4 lag2=5 lag2=6 lag2=7 lag2=8 lag2=9 but according to ypur result in line 6 in turns to normal flow? ... View more

data step execution

by Calcite | Level 5 in SAS Programming
‎12-20-2011 06:14 PM
‎12-20-2011 06:14 PM
OK .. i understand the last time execution.. but then i have to ask  last time execution of if part is different from last time execution of else part? since according to to Tom else part is not executed in every iteration? but then there must be a log or something else that with help of it  lag knows from where it will continue? isnt it? Lets create a scnenario: there is data and if then-else statement and lag function in each part: Observation 1: if part true  and lag in the if part is executed. lag in the else part is not executed Observation 2: if part true  and lag in the if part is executed. lag in the else part is not executed Observation 3: if part false and lag in the if part is not executed. lag in the else part is executed what is the value of lag in the third observation? ... View more

data step execution

by Calcite | Level 5 in SAS Programming
‎12-20-2011 05:49 PM
‎12-20-2011 05:49 PM
thanks for the asnwer, but i still dont get it..  if and else part use same que ? or not? if they use same que then the lag function prodce same result for both part of if staatement.. if they dont use the same que then why? where the que for the else part? how can i reach it? ... View more

data step execution

by Calcite | Level 5 in SAS Programming
‎12-20-2011 05:47 PM
‎12-20-2011 05:47 PM
Thanks for the answer Mike, it was helpful.. But i still searching lag function how determine the previous? if it gets from que why if and else part use different que? ... View more

data step execution

by Calcite | Level 5 in SAS Programming
‎12-20-2011 05:46 PM
‎12-20-2011 05:46 PM
this is very suprising for me!! why there is a extra missing step i couldnot understand.. but thanks i will think about it.. ... View more

data step execution

by Calcite | Level 5 in SAS Programming
‎12-20-2011 05:33 PM
‎12-20-2011 05:33 PM
in the else part of the if satatement, lag fonctions will pull the value from previous, to determine the previous what value it will check? row number_ obs? _n_? which one? thanks ... View more

data step execution

by Calcite | Level 5 in SAS Programming
‎12-20-2011 05:24 PM
‎12-20-2011 05:24 PM
Actually i have one more question. Why the lag function in the if and else part acting diffferently? they are on the same input line? ... View more

data step execution

by Calcite | Level 5 in SAS Programming
‎12-20-2011 05:18 PM
‎12-20-2011 05:18 PM
Thanks Tom, you are right.. ... View more

data step execution

by Calcite | Level 5 in SAS Programming
‎12-20-2011 04:50 PM
‎12-20-2011 04:50 PM
Hi everybody there is two code which are acting differently. can anybody explain why? Hint: Lag function puls from queue!! According to me they must procedure the same result!!! data test; INFILE datalines DLM=',' DSD; input a b c ; datalines; 4272451,17878,17878 4272451,17878,17878 4272451,17887,17887 4272454,17878,17878 4272454,17881,17881 4272454,17893,17893 4272455,17878,17878 4272455,17878,18200 run; DATA TEST1; RETAIN   F ( 1) ; laga = lag(a); lagb=lag(b); SET TEST; IF A^=laga OR laga =.  THEN do;    f=1;end;  ELSE IF  A=laga AND b>lagb THEN do; f=f+1  ; end; RUN; proc print data=test1; run; DATA TEST2; RETAIN   F (  1) ; SET TEST; IF A^=LAG(A) OR LAG(A)=.  THEN do;    f=1;end;  ELSE IF  A=LAG(A) AND b>LAG(B) THEN do; f=f+1  ; end; RUN; proc print data=test2; run; ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎09-01-2015 07:11 AM
Quick links