Hello, Another solution: data range; infile datalines ; input ; array year{3}; do i=1 to 3; year{i}=put(mdy(1,1,substr(_infile_,i+2*(i-1),2)),year4.); end; datalines; 01/01/11 02/23/05 03/15/15 05/09/06 ; drop i; run; ... View more

Hello, You just have to delete the semicolon from &variable=&new_var; The rename syntax of proc datasets is: rename a=x b=y etc. ... View more

Hello, Maybe this: data have; infile datalines truncover; input ID Application_No $ Version Action & :$22. Date $12.; datalines; 1 ABCDEFX2 1 Submit For Approval  01 July 2014 2 ABCDEFX2 1 Return  02 July 2014 3 ABCDEFX2 2 Submit For Approval  01 July 2014 4 ABCDEFX2 2 Return  02 July 2014 5 ABCDEFX2 2 Submit For Approval  05 July 2014 6 ABCDEFX2 2 Approve  06 July 2014 7 ABCDEFX2 3 Submit For Approval  05 July 2014 8 ABCDEFX2 3 Approve  06 July 2014 9 ABCDEFX2 3 Approve  05 July 2014 10 ABCDEFX2 3 Financed  06 July 2014 ; proc sort data=have; by Application_No date Action  version; run; data want; set have; by Application_No date Action ; if first.action; run; ... View more

hello, if i have understood correctly (you are looking for products that are also components) this may be one solution: proc sql; select a.product from have a, have b where a.product=b.component; quit; ... View more

As RW9 stated - you just have to choose the appropriate format (you can find them at the link mentioned in my previous post). Ther is no format named iso860 within SAS . ... View more

Hello, Just add within the proc sql the create index line: PROC SQL;    CREATE TABLE Table_result AS    SELECT DISTINCT t1.Key       FROM Table_test t1;      create index key on Table_result; QUIT; ... View more

Hello, Maybe you'll find this link useful: http://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/viewer.htm#a003169814.htm ... View more

Hello, Another solution: data have(index=(comp=(pkey xpot))); input pKey  diagg $ pid @27 xpot mmddyy6. xdist; format xpot date9.; cards; 1998    G03     17752     080707     5 2727    E003M     185355  040188     9 1124     G03     85174    110101     3 1998     G03     65510    030912     5 2727     G03     319013   011096     8 4493     G02     881244   050709     3 ; proc contents; run; data want; array diag{10} $; do i=1 to 10 until(last.pkey); set have; by pkey xpot; diag{i}=diagg; end; run; ... View more

Hello, A starting point below: data holiday; input a date9.; datalines; 26AUG2014 01SEP2014 ; run; proc sql noprint; select a into :holiday separated by " " from holiday; quit; %put &holiday; data have; input Item_ID Start_Date mmddyy10. End_Date mmddyy10. Payment Payment_Frequency  $; datalines; 1 8/25/2014 9/29/2014 20 Daily 2 8/25/2014 9/29/2014 20 Monthly ; proc format; invalue $ freqs   'Daily'='day'   'Monthly'='month' ; run; data want(drop=i); set have; by Item_ID notsorted; freq=input(Payment_Frequency,$freqs.); i=0; format payment_date date9.; do while (payment_date lt End_Date); payment_date=intnx(freq,Start_Date,i,'s'); if  payment_date gt End_Date then   payment_date=End_Date; if not(find("&holiday",compress(put(payment_date,best12.))))  then output; i+1; end; run; ... View more

Hello, One solution below: data have; length b $ 7 ; infile datalines truncover; input a $200.; if length(compress(a,,'ad')) gt 1 then b="Special"; else if length(compress(a,,'d')) gt 1 then b="Letters";   else b="Digits"; datalines; sdijgh68%#$kjs 436346 gsgs #$%& eyeryt547&& GtreUI ; run; ... View more