HI i am having data in some obs the data will be repetative i want to supress that records how can i do i.i dont know the length as it may be 3 or 100 how can i do.I want to supress them ex data Test; input id$ 1-100; cards; AAA VVVVVVVVVVVVVVVVVVVVVV EEEEEEEEEEEEEEEEEEEEEEEEEE RTYUY QWEPO ZZZZZZZZZZZZZ KKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKK KOOL GONE RUN; OUTPUT SHOULD BE: RTYUY QWEPO KOOL GONE ... View more

Splitting the data in to differnt rows id name      value2              value3 1  a,b      a:1,b:1              a:2,b:2 2  a,b      a:3,b:4              a:3,b:4 3  a        a:5                  a:6 4  a,b,c,d  a:10,b:20 c:30 d:40  a:10,b:20 c:30 d:40 Output I am having a variable Name it should split base on the commas and the correspoding value(value2 and value3) sould come. id Name value2    value3 1  a  a:1    a:2 1  b  b:1    b:2 2  a  a:3    a:3 2  b  b:4      b:4 3  a  a:5    a:6 4  a  a:10    a:10 4  b  b:20    b:20 4  c    c:30    c:30 4  d    d:40    d:40 For ef you can view in txt ... View more

I wnat to find the 7 th positon of delimter '?'  as (i am having 120 delimiters in a line  as i have given below as example) data a; input id$ 1-10; i=findc(id,'?'); do until i=32; cards; 1?2?3445??6?7?8?9?10 ; run; ... View more

I am doing like this. data l2; input id no; cards; 1 100 2 200 3 300 run; proc sql; select count(max(no)) into :l2 from l2 where id=3; quit; i am getting this ERROR ERROR: Summary functions nested in this way are not supported. i want the output that macro L2 should have count as 1. ... View more

data l; infile cards missover truncover; input add $ 1-100; cards; q w e r t y r t t t qwerret w a d f g g run; data l2; set l; if (SCAN(add,5,' ') EQ '' |  LENGTH(COMPRESS(add, ' ') ) <10 | LENGTH(COMPRESS(add, ' ')) >200) then do; add_QC1 =''; add_QC2 =''; add_QC3 = ''; end; else do; add_QC1 = add ; add_QC2 = ''; add_QC3 = '' ; end; run; Actually i am checking if it is having 5 words and length <10 and length greate than 200 i want the output to be : obs add                                  add_QC1 ---  --- 1.  q w e r t y                          q w e r t y 2.  r t t t 3.  qwerret w a d f g g     qwerret w a d f g g                ... View more

I am having a table old with variable Test with length=20 now i want to increase the length how can i do it . can we do by proc datasets procedure ... View more

Hi  i am having sepecial characters like this ╥Bç_┐▌lær“Y╓╤╙╥I  how can i compress them ,i am may get these kind of special characters in the future i can use the compress function and do it is there any way to compress all this kind of special characters like this for the unknown special characters like this. New=compress(old,'╥Bç_┐▌lær“Y╓╤╙╥I'); ... View more