Well, all I can guess is that you don't have a record that all of pr1-pr15 are missing at the same time. The reason you had hits before  is probably because you have included more variables and there happen to be cases in which  15 of them missing. The straightforward way to figure it out is using the previous version to single out some obs, then check them out: if cmiss(of pr:)=15 then output; Haikuo ... View more

In that case, use cmiss(of pr1-pr15). Haikuo ... View more

Hi Ashwini, 1. CMISS() returns the counts of missing values within its arguments. 'pr' basically represents any variables start with 'pr'.  in your case,'pr:' is the short way to address your variables from pr1 to pr15. So if cmiss() returns 15, which will mean that all of your 15 variables from pr1 to pr15 are missing. 2. you can check it by limiting the input table to a managable number, such as 100: data library.nismicathcabg4; set library.nismicathcabg4 (obs=100); ..... 3. Addtional point: When you doing test run, I suggest that you assign different names to input and output tables, so it is easier for you to track if something goes wrong. my 2 cents, Haikuo ... View more

Try this: data library.nismicathcabg4; set library.nismicathcabg4; array dxtrialpci{15} pr1-pr15; if cmiss(of pr:)=15 then call missing(pci); else do; do i=1 to 15; if dxtrialpci{i} in ('0066', '3604', '3606', '3607') then do;      pci=1; return; end; else pci=0; end; end; run; Regards, Haikuo ... View more

Sounds like a homework data want; set dataset1(keep=salary); run; ... View more

Try this: data have; input Rollnumber $     Dob     :$10. Salary     experience; cards; 1     11/12/87     2500     2 5     12/04/56     3400     3 3     03/06/79     1200     4 2     04/05/94     44560     4 4     03/07/99     12908     3 6     03/07/99     12908     7 ; data want; set have; tol_sal+salary; run; proc print;run; Regards, Haikuo ... View more

Linlin, Your solution only works when 'rollnumber' in two dataset are paired up exactly the same, no jump in numbers. First of all, I would say this is NOT a job for 'set', it is a 'merge' job. But you could do it by brutal force like this: data h1; input Rollnumber $     Name $     Age     Gender     $ Mark     Dept $; cards; 5     don     23     M     45     Science 4     andrew     45     M     33     Maths 1     michael     12     F     29     Physics 2     steve     44     F     54     Chemistry ; data h2; input Rollnumber $     Dob     :$10. Salary     experience; cards; 1     11/12/87     2500     2 5     12/04/56     3400     3 3     03/06/79     1200     4 2     04/05/94     44560     4 4     03/07/99     12908     3 6     03/07/99     12908     7 ; data want; set h1; do i=1 to nobs until (eof); set h2 (rename=rollnumber=r) end=eof nobs=nobs point=i; if rollnumber=r then output; end; run; proc print;run; Regards, Haikuo ... View more

We need to know what kind of join you are aiming: an intersection (inner join) or outer join (left, right or full). So you will have up to 4 different results depending on what you want. Sorry I had to borrow the SQL terms, when you said you want to use 'set'. Regards, Haikuo ... View more

oops. There were some obvious errors, I did not reference the hash name. Try this: data want (drop=_:);   if _n_=1 then do;      set geog.mutualcom (obs=1 rename=(year=fyear zip=_zip)); dcl hash h(dataset:'geog.mutualcom(rename=(year=fyear zip=_zip))', multidata:'yes', hashexp:16); h.definekey('fyear'); h.definedata('_zip'); h.definedone(); end; set geog.comp;    _ct=0;    _rc=h.find();    do while (_rc=0);       if .< zipcitydistance(zipcode, _zip)<=60 then _ct+1; _rc=h.find_next(); end;     mutual_density=log(1+_ct); run; ... View more

Not by your definitions. _ct has already included the self-match, which by your definition is 1+count of match to others, so you don't need to use 1+_Ct to replace _ct in this context. Haikuo ... View more