proc sql; create table work.add_class as   select ac.date_shipped, ac.order_id, ac.brand_code, ac.customer_id,atso.classification, atso.brand_code as atsbrand    from work.add_cust as ac left join work.temp_orders as atso     on ac.invoice_number = put(atso.odr_number,char13.); quit; Example: data have1; input id $ var $; cards; 1 a 2 b 3 c ; run; data have2; input id var $; cards; 1 a 2 b 3 c ; run; proc sql; create table want as select a.* from have1 a left join have2 b on a.id=put(b.id,char1.); quit; proc contents data=want; run; ... View more

In proc sql data have; input x $5.; cards; label ; run; proc sql; create table want as select x, (quote(x))||'=' as y from have; quit; proc print; run; ... View more

Quote function does that. Below is an example. data _null_; x='label'; y=quote(x); put y; run; ... View more

If you can adjust your date format, it can be acheived easily with the below code. Hope it will help you a bit %macro diff_date    (begin =    ,end   = today()    ,y     = years    ,m     = months    ,d     = days     ); *--number of full months between dates; &m = intck('month', &begin, &end)   -(day(&end) < day(&begin)); *--number of full years between dates; &y = floor(&m / 12); *--remainder of full months after removing full years; &m = mod(&m , 12); *--number of days remaining after removing years and months; &d = ( day(&end) < day(&begin))   * day(intnx('month',&begin,1)-1)   + day(&end)   - day(&begin); %mend; data _null_; ValuationDate= '31jan2008'd; MaturityDate= '01mar2009'd; %diff_date(begin=ValuationDate, end=MaturityDate) put years= months= days= ; run; ... View more

data have; input  var1 var2 var3 var4 var5; cards; -10  -5  50  50 100 3    23  42  -1  23 1    -5  -7  44  12 ; run; %let howmany = 5; %macro want(howmany); %IF &howmany GT 0 %THEN   %DO;    data want;     set have;     %do j=1 %to &howmany;      if var&j. lt 0 then       var&j.=0;      else var&j.=var&j.+(-15)*(var&j./200);     %end;    run;   %end; %mend want; %want(5) ... View more

You mean the last earning for person 1 is  23 person 2 is 32 etc... ... View more

To add the last earning date column data have; input person earning Date; format Date yymmdd10.; informat Date yymmdd10.; datalines; 1 12 2001-01-23 1 34 2001-02-03 1 23 2001-02-25 2 45 2001-03-04 2 32 2001-03-27 3  7 2001-04-04 3 34 2001-05-05 3 65 2001-05-26 3 33 2001-06-06 3 23 2001-07-02 4 33 2001-02-03 4 12 2001-03-05 ; run; Edited: proc sql; create table want1 as select distinct person, sum(earning) as sum_earning,max(date)-min(date) as earning_period, max(date) as max_date format yymmdd10. from have group by person; quit; ... View more

data have; input person earning Date; format Date yymmdd10.; informat Date yymmdd10.; datalines; 1 12 2001-01-23 1 34 2001-02-03 1 23 2001-02-25 2 45 2001-03-04 2 32 2001-03-27 3  7 2001-04-04 3 34 2001-05-05 3 65 2001-05-26 3 33 2001-06-06 3 23 2001-07-02 4 33 2001-02-03 4 12 2001-03-05 ; run; proc sql; create table want as select distinct person, sum(earning) as sum_earning,max(date)-min(date) as earning_period from have group by person; quit; ... View more