>"Jinto83" <jinto83@sina.com> wrote in message >news:hnauiu$2nqm$1@adenine.netfront.net... >Hi, > >2 quick questions. > >1. How to declare a variable? For example, declare VarA=numeric6.2 >Is it using put or input?

The most complete declaration uses the ATTRIB statement. You can do "partial" declarations with statements like LENGTH, FORMAT, and INFORMAT. Or you can not worry about it and let SAS handle the declarations implicitly from context. No guarantees that SAS will assign what you really want.

>2. How to remove all occurence of the symbol ' and the symbol " >Tranwrd in SAS won't take ' or " > >companyname=John's "R" Shop >desiredoutput=Johns R Shop

TRANWRD can handel multiple character string targets, while TRANSLATE works on single character targets, and it appears that you're working with single characters. Either can handle single or double quotes if you quote things properly, though the quoting can cause a case of fumble fingers, like so:

84 data _null_; 85 companyname = "John's " || '"R" Shop'; 86 put companyname=; 87 newname = translate(companyname, ' ', "'", ' ', '"'); 88 put newname=; 89 run;

companyname=John's "R" Shop newname=John s R Shop NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds

--- news://freenews.netfront.net/ - complaints: news@netfront.net ---