Hi rao A statement that I've seen working sending attachements from a Mainframe was: attach =("datasetname" ct='text/plain' extension="TXT") If it's 'only' about special characters: If you dare not to be part of the (US-) English realm in the world then I remember quite a bit of problems with finding the accurate translation table for EBCDIC/ASCII conversions. Does it work in 'normal" email text with the translation of special characters? HTH Patrick ... View more

Hi sas-learner2 I was honestly too lazy in trying to understand your code to the last bit. May be the following is anyway of some help to you as it implements a modulo10 check as described in http://en.wikipedia.org/wiki/Luhn_algorithm for any string with digits only. There might be more elaborate ways to do it and I'm almost sure this wheel is already invented in the SAS world. The code below is what I can come up with right now. HTH Patrick data _null_; input id $ 1-30; length AddIt $2; ChkStr=left(reverse(id)); do pos=1 to length(ChkStr); if mod(pos,2) then /* odd positions */ do; AddIt=substr(ChkStr,pos,1); end; else /* even positions: digit*2 */ do; AddIt=put(2*input(substr(ChkStr,pos,1),2.),2.); end; /* add digits */ do i=1 to length(AddIt); ChkSum+input(substr(AddIt,i,1),2.); end; end; /* Check if ID is valid or not (if ChkSum ends with Zero) */ if mod(ChkSum,10)=0 then do; put 'This is a valid ID: ' ID= ChkSum=; end; else if mod(ChkSum,10) ne 0 then do; put 'This is a invalid ID: ' ID= ChkSum=; end; datalines; 123456789 3847592 48573726264859560 2843759 00028434305834 442308239586 ; run; ... View more

You have to use a INformat to read data. Formats are used to write data. ANYDTDTMw. is a very convenient informat to read datetime values as it digests a number of different datetime STRINGS and converts them to a number representing a SAS datetime. http://support.sas.com/onlinedoc/913/getDoc/en/lrdict.hlp/a001239776.htm What do you mean by "field is numeric"? Where do you try to read the data from? Could it be that this is more a data conversion problem (i.e. from ORACLE to SAS)? If the field you want to read is already in SAS and contains a datetime value then it's only about: newvar=datetimevar; ...and you might want to use a format to WRITE the values of this new var, i.e" format newvar datetime21.; http://support.sas.com/onlinedoc/913/getDoc/en/lrdict.hlp/a001263753.htm HTH Patrick Message was edited by: Patrick ... View more

Hi chinnu I agree with everything sbb said. Just 2 other approaches: 1. In case SAS/Integration Technology is installed in your site: You could run the job from your PC SAS accessing the files via rsubmit - and then save the resulting SAS tables in a PC SAS environment. 2. You could run your existing code on the mainfraime. Write an additional job which pack the resulting SAS file (proc cport), and send it per ftp put to a windows directory - unpack the SAS file with PC SAS using proc cimport. HTH Patrick ... View more

> Why burden the caller with having to code quote marks? Because according to the example it could be pass-through SQL - and Oracle for example doesn't like double quotes. On the other hand the example shows very clear that the value has to be passed as character string. ... View more

I prepared myself using the self-paced eLearning and this was enough. As much as I know the book covers exactly the same but as print-out. There was not one question in the exam which hadn't been covered in the preparation material. What I consider to be very important is to do the test questions at the end of each chapter. To pass the exam it's very important to train on how to read the questions asked. The points I achieved in the test exam were close to what I've got in the real exam. HTH Patrick ... View more

The macro variable will resolve to a string - Proc SQL will see this string. Therefore pass exactly the needed string to the macro variable as if you would write it directly in the SQL statement. %let mydate='2005-05-31'; Proc sql, . . . where file_date=&mydate; ... View more

Hi aabb That's how you create the numeric vars A1-A600 and the character vars B1-B600; data want; array A {600}; array B {600} $10; run; proc contents data=want short; quit; The renaming part you asked for would also be possible but needs a bit more programming. Why do you need this renaming? It sounds a bit odd... Regards, Patrick ... View more

SAS is quite powerful for tasks like this - but to give you an answer you will have to explain a bit more in detail what you have and what you want to achieve. ... View more

Dear forum admin(s) It seems that there is a little bug in the HTML encoding/decoding in this page for lines with '<' and a slash '/'. Just copy the line above and and use it in a new post and you'll see what I'm talking about. ... View more

Hi Linus What is this "NWKDOM" function? I don't know it and can't find it in the SAS OnlineDoc. Cheers, Patrick ... View more

Hi Thomas Not sure if that will help you: What I encountered in DI was that options (macrovars) were somehow quoted which caused problems when using the macrovar values in comparisons. What helped was (in user written code) to %unquote() them. if myvar=%unquote(&myoptionMvar) then.... HTH Patrick ... View more

First reorganise your data in a way that you have one subject per observation. The following code then creates a sample with a given number of observations, selects all observations with the same likelyhood and doesn't select twice the same observation. The code is as provided by SAS. data work.rsubset(drop=obsleft sampsize); sampsize=10; obsleft=totobs; do while(sampsize>0); pickit+1; if ranuni(0) lt sampsize / obsleft then do; set sasuser.revenue point=pickit nobs=totobs; output; sampsize=sampsize-1; end; obsleft=obsleft-1; end; stop; run; Vasile: Your code could pick the same observation more than once (i.e. ranuni returns once 0.8... and once 0.7....). HTH Patrick Message was edited by: Patrick ... View more

Ignore this post. Message was edited by: Patrick ... View more