It is called a block.  If you have one statement after the conditonal you just put the one statement.  If you have multiple statements then they become a block, defined by do end.  See the documentation: http://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/viewer.htm#a000201951.htm ... View more

It should be noted that the LEAVE statement is not valid within a non-looping/non-iterative DO-END block (an error message would occur!), unless this block is in turn located in a SELECT-END block or in a DO loop (as in your example).   In the latter situation, both the remaining iterations of the DO loop and the statements following the LEAVE statement in the DO-END block (if any) are skipped. In your example (with missing TYP{14} and provided that TYP{15} is not missing) IK is set to 15 and no further IF-checks are performed. ... View more

Here is something you may clone to your specific needs.... This is just one way of getting the output you desire... a bit lengthy but simple code....   data have; input v1:$5. v2:$5. v3:$5. v4:$5.; datalines; Tom Peter Henry Jack 100 101 102 103 ; run; data name; set have; if _n_ = 1; run; proc transpose data=name out=names(drop=_name_); var v1 v2 v3 v4; run; data id; set have; if _n_ = 2; run; proc transpose data=id out=ids(drop=_name_); var v1 v2 v3 v4; run; data final; set names(rename=(col1=name)); set ids(rename=(col1=id)); run; proc print data=final; run; It produces the following output for your reference...   Obs name id 1 Tom 100 2 Peter 101 3 Henry 102 4 Jack 103 Hope this helps...!!! Good Luck...!!! ... View more

This selects the range, including 30 and 33:   data want; set have; where food_type between 30 and 33; run; ... View more

As @PaigeMiller already wrote: SAS provides a whole set of calendar functions which do all the magic for you. No need to try and code this.   I suggest you ask the person who provided this code what it's supposed to do - and then re-write the intended logic using SAS calendar functions. ... View more

Hi @apple   The difference between "recoding" and "formatting": With recoding you modify the actual internal value of a variable and then assign the result to a new variable. With formatting you don't change the internal value but just change the way this value gets printed.   I believe you should go for "recoding". Below an example illustrating how this works. data have; infile datalines truncover; input name $20.; datalines; Tan Peter Tan John Mike Tan John Doe Tanner Tolbert ; run; /* recode */ data want_recoded; set have; length name_rec $20; if findw(upcase(name),'TAN',' ') then name_rec='the Tans'; else name_rec=name; run; The challenge you're facing with names are different spellings and variations (like Bill and William). With names you normally need first to apply some sort of standardization process.   Below the code sample for "formatting". This code is "advanced" and not what you should be concentrating on if you're "new to SAS". data have; infile datalines truncover; input name $20.; datalines; Tan Peter Tan John Mike Tan John Doe Tanner Tolbert ; run; /* format */ proc fcmp outlib=work.funcs.name_recode; function name_recode(in_name $) $; length out_name $20; if findw(upcase(in_name),'TAN',' ') then out_name='the Tans'; else out_name=in_name; return(out_name); endsub; run; options cmplib=work.funcs; proc format; value $name_group (default=20) other = [name_recode()] ; run; proc print data=have; var name; format name $name_group.; run;   ... View more

No it doesn't. It compares character by character. You need to convert your characters to numeric for such a comparison. 23 data _null_; 24 types='2'; 25 if types<='10' then put 'TRUE'; 26 else put 'FALSE'; 27 28 if input(types,best32.)<=10 then put 'TRUE'; 29 else put 'FALSE'; 30 31 run; FALSE TRUE     ... View more

Note: with your datastep, Hsehold_Ref_No groups having no observations with LVL_OF_EDN either '0' or '1' will be skipped, i.e. you will never get PriStd_cnt=0. If you want the zero counts, you should drop the WHERE statement and use : data stud_Pri (keep =HSE_ID HH_NO Hsehold_Ref_No PriStd_cnt); set stud_dev; by Hsehold_Ref_No; if first.Hsehold_Ref_No then do;   PriStd_cnt = 0;   end; PriStd_cnt + (LVL_OF_EDN in ('0', '1')); if last.Hsehold_Ref_No then output; run; PG ... View more

Hi, Subquery is not required here , also it slows down the performance. Proc Sql; select distinct House_ID from have where House_ID <> '02' and Apple=1 ; quit; Just confirm the syntax for not equal to expression : <> Vishal ... View more

One more way, Data test; input a b ; cards; 01 9 01 3 02 9 03 1 03 2 run; Proc Sql; select A,b from test where a not in (Select distinct a from test where b eq 9); quit; Thanks, Sanjeev.K ... View more

Use the OTHER keyword. value $X   ' '='Missing'   other ='Present' ; ... View more

The quantiles in this case (5) are quintiles. Investigate      Proc Ranks groups =  5 data = have  out = want /*descending ? */;           Var income ;           Ranks income_group ;      Run ; [untested] This will number your income values in groups labelled 0 - 4 (4 highest, use descending to reverse the numbering).  Add 1 to income_group to get labels 1 - 5.  Multiply by 20 if you want labels like 20, 40 60, 80. Richard ... View more

HI Try this, If a is char: data test; input a $; if a ^=: '111'; cards; 11122 12222 11111 31222 ; If a is numeric: data test; input a; if cats(a) ^=: '111'; cards; 11122 12222 11111 31222 ; ... View more

HI Apple, Try this ............... DATA want ; x=449; if substr(cats(x),1,2)='44' then want=1; run; Cheers, Karthik ... View more