, FWIW, while your code delivers the top 3 obs, it will still read through the whole 'test' table. It would take a toll on your efficiency if the 'test' is big (billion records in heath care or financial data) or fat (seen 100k variables in some Microarray data) or both . I would recommend the following tweak: data name;   set test;   if _n_>3 then stop; run; Haikuo ... View more

see also The Answer supplied by a Little Birdie: http://www.sascommunity.org/wiki/MINDELIMITER_Macro_In_Delimiter Ron Fehd  in.tu.it maven ... View more

Thanks! I am held to higher standards now! - PG ... View more

Hi saspert, Please look at the below code and it will serve your purpose. data a; input date1 : mmddyy10. date2 : mmddyy10.; format date1 date2 date9.; datalines; 07/31/2011 07/01/2011 12/31/2011 12/01/2011 ; data b; set a; if date1='31dec2011'd then output;     // adding a 'd' is possible only with date9. date format and not with mmddyy date format. run; Note - In the above example i am reading  the nonstandard date value , sas stores date values in numeric format, then i am using format statement to convert the date value into a comparable format. Let me know in case of any queries. Thanks, Ankit ... View more

It works just fine! Many thanks Ankit! ... View more

Friend, Please find the below code , this will you the output as per your needs:- data test; input @1 full_name $10.  @12 city $7. @20 state $  @23 h_rc1 comma5. @28 p_rc1 comma5. @32 s_rc1 comma5. @37 t_rc1 comma5.; datalines; Rice Brown Raleigh NC $167 0   0    0 Rice Brown Raleigh NC 0    0   $123 0 Rice Brown Raleigh NC 0    124 0    0 Rice Brown Raleigh NC 0    0   0    $125 ; data test1; set test; by full_name city state; if first.state then s=0; if first.state then s1=0; if first.state then s2=0; if first.state then s3=0; s+h_rc1; s1+p_rc1;s2+s_rc1;s3+t_rc1; if last.state; h_rc1=s; p_rc1=s1; s_rc1=s2; t_rc1=s3; run; ... View more

Friend, I hope the below code will suffix your problem, if not please do update me to make corrections data test; input id date date7. sales; format date date7.; datalines; 1 01Jan11 12 1 02Jan11 20 2 12Jan11 34 2 23Feb11 21 ; proc sort; by id descending date; run; data test1; set test; by id; if first.id then total_sales=0; total_sales+sales; if last.id; run; proc print; run; ... View more

Or Under Patrick's suggestion. [pre] data work.test; infile cards missover; input (a b c) ($1.) x y z; cards; abc 2 2 3 def 3 4 5 abc 2 2 3 abc 2 2 3 ;;;; run; %let dsid=%sysfunc(open(test)); %let nvar=%sysfunc(attrn(&dsid,nvar)); %let dsid=%sysfunc(close(&dsid)); data want; set test; if cmiss(of _all_) ge &nvar then delete; run; [/pre] Ksharp ... View more