when we use quotes for macro it resolves with the quotes i.e.  %let a = "sas";   %put &=a;   a="sas"   Hope I made it clear ... View more

I don't think merge will give you the desired result, the best way to do this is by proc sql. ... View more

Thank you so much for such a nice explanation 🙂 ... View more

data test; do until eof; set sashelp.class end=eof; number= _n_; output; end; run; sorry I did not got it, how come the value of number is always 1, although the whole dataset is being read. Can someone please explain ... View more

the first occurence div got is education and hence the length is 9. ... View more

I am not sure, if I understood the requirement correctly, but as far as i understood this is the solution :   data new; set department; last_name= scan(names,2,','); pos=indexc(names,','); first_name = substr(names,1,pos-1); drop pos; run; ... View more

whenever you use * in the select clause of sql, it always means selecting all columns. In the contradictory you can also select particular columns. Select * from table will select all coulmns and select col1,c0l2 from table ... View more

since you are defining x as a charaacter and there is no length statement.. so it takes the length of x as the first statement it encounters.   if your second program would be : data test5; x='1'; x='11'; x='311'; run;   u would have got the result 3.    And if you write it as : data test5; length x $ 3.; x='1'; x='11'; x='311'; run;  you would get 311   Hope I answered your query ... View more

Hey..yes I know this does not makes sense.. I just tried to simplify the whole big program I was working on... 🙂 ... View more