data one; cc='abc'; cchex=put(cc,hex4.); put cc= hex4.; /* If you need to keep the original variable name of cc, but as a character variable, then use the DROP and RENAME statements following the PUT function. */ cchex=put(cc,hex4.); drop cc; rename cchex=cc; put cc=; run; I read this from the doc trying to understand how to use put but get more confused, what is it doing ? ... View more

data range; *set pf_lemon; length score_lbl $9. sort_order 8.; score_lnl="500<=score<540"; sort_order=1; output; score_lnl="540<=score<560"; sort_order=2; output; score_lnl="560<=score<580"; sort_order=3; output; score_lnl="580<=score<600"; sort_order=5; output; run; proc sort data=range; by score_lnl;run; I tried this but is it how it suppose to be used? do I add a set statement in to include data set I am looking at? I find this very strange.      ... View more

I read the doc but dont understand as the example is not complete. I try the code attached, data pf_lemon; input scorefmt $; datalines; low-539 540-559 560-579 run; proc format data=pf_lemon; value scorefmt low-539 ="apple" 540-559="540<=SCORE<560" 560-579="560<=SCORE<580"; run; proc print data=pf_lemon; run; how can I make it work? ... View more

if you format something into 17.2 it means length of 17 before decimal and 2 after decimal? or 17 is including decimal and anything after? ... View more

when you create a variable and have not assigned value to it , does it equals to "null" or zero?   ... View more

length mob DQ_6 $20.; Does this mean putting both mob and DQ_6 into format of length 20 ? ... View more

  data lemon: set pf_lemon end=last; tot_up+up; tot_down+down; ar=tot_up/tot_down; if last: where sub_product='lemon'; run; can you let me know how to interpret this program.. when are the third to fifth lines getting run? when if last?  if it is not run, what would be tot_up, tot_down and ar? what are initial values of tot_up and tot_down, null?           ... View more

I come across  data pd4; set pb3; by region product sub_product; if first.product then do; cum_active=0; cum_default=0; end; cum_active+active; cum_default+Default; cum_active_percent = cum_active / total_active; cum_default_percent=cum_Default / total_Default; run; Hi I read the doc and couldn't understand the significance of assigning first, last to 1,0 etc in the above programs. Could you kindly explain? Aso could you explain the statements   cum_active+active; cum_default+Default; are they assigning values to some variable? are they boolean? what are they doing?   ... View more

data hello; merge apple (in=1) orange (in=b); if weight~=1, by fruit_id; if a and b; FORMAT size 10.4 price 5.4; if weight>20 OR price>30 then do: margin=20; end; run; my questions what does if a and b means here and is its significance to the action of merging? does the merging only happen when the few lines of lf then else statement is true? ... View more