topic Re: Delimit in SAS Enterprise Guide https://communities.sas.com/t5/SAS-Enterprise-Guide/Delimit/m-p/111207#M9505 <HTML><HEAD></HEAD><BODY><P>Hi Shiva,</P><P></P><P>It worked ! <BR />THANKS ALOT !!!! </P></BODY></HTML> Thu, 19 Jul 2012 03:47:34 GMT cody_q 2012-07-19T03:47:34Z Delimit https://communities.sas.com/t5/SAS-Enterprise-Guide/Delimit/m-p/111204#M9502 <HTML><HEAD></HEAD><BODY><P>Hey all</P><P></P><P>I have a question to do with delimiting . Here are some examples :</P><P></P><P>when?</P><P>prizes!</P><P>(age)</P><P>end.</P><P>;house}|+</P><P>*note</P><P>hh`GG1</P><P></P><P>Basically, just to remove all symbols and to leave them as clean dictionary words .</P><P></P><P>Is there a macro to do this ? Because our data runs in thousands</P><P></P><P>Thank you</P><P>YL</P></BODY></HTML> Thu, 19 Jul 2012 03:22:59 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Delimit/m-p/111204#M9502 cody_q 2012-07-19T03:22:59Z Re: Delimit https://communities.sas.com/t5/SAS-Enterprise-Guide/Delimit/m-p/111205#M9503 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Try this..Hope it helps..</P><P>data have;</P><P>input dict $ 20.;</P><P>new=compress(dict,,'ka');</P><P>cards4;</P><P>when?</P><P>prizes!</P><P>(age)</P><P>end.</P><P>;house}|+</P><P>*note</P><P>hh`GG1</P><P>;;;;</P><P>run;</P><P>Thanks,</P><P>Shiva</P></BODY></HTML> Thu, 19 Jul 2012 03:31:36 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Delimit/m-p/111205#M9503 shivas 2012-07-19T03:31:36Z Re: Delimit https://communities.sas.com/t5/SAS-Enterprise-Guide/Delimit/m-p/111206#M9504 <HTML><HEAD></HEAD><BODY><P>Hi Shiva,</P><P></P><P>could you explain what is the usage of new=compress(dict,,'ka'); AND ;;;; ??</P><P></P><P>Thank you.</P></BODY></HTML> Thu, 19 Jul 2012 03:37:50 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Delimit/m-p/111206#M9504 cody_q 2012-07-19T03:37:50Z Re: Delimit https://communities.sas.com/t5/SAS-Enterprise-Guide/Delimit/m-p/111207#M9505 <HTML><HEAD></HEAD><BODY><P>Hi Shiva,</P><P></P><P>It worked ! <BR />THANKS ALOT !!!! </P></BODY></HTML> Thu, 19 Jul 2012 03:47:34 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Delimit/m-p/111207#M9505 cody_q 2012-07-19T03:47:34Z