Ladies and Gentlemen: How can I join two table just like the follwoing proc sql syntax did below using data step with hash table? proc sql _method buffersize=1G;      create table want as            select a.*, b.target_id                 from big_have as a, small_have as b                      where b.beg_date <= a.date < b.end_date and a.id = b.id; quit; Thank you! ... View more

The attached dataset has time in 24 hour format, see below: 000257 000341 000419 000433 000437 000451 002538 002719 002903 003029 003135 003141 So 133846 indicates 1 pm 38 minutes 46 seconds.  But the value is in string.  How could I convert the TIME string into SAS time?  I used the following code: data WANG;      set HAVE;      time_numeric = input(time, time5.); run; But it doesn't seem to work.  SAS reports: NOTE: Invalid argument to function INPUT at line 24 column 8. time=000257 timej=. _ERROR_=1 _N_=11 NOTE: Invalid argument to function INPUT at line 24 column 8. time=000341 timej=. _ERROR_=1 _N_=12 Could you guys help me~~ ... View more

Dear All: Could you please tell me how to count a variable only if certain criteria is met in the proc sql syntax.  For example, I want to count both people and Hispanic people.  So I coded the following way, but the calculated p_count and chm_count is the same.  Also, if I want to count rows in which certain variable called sex is F, could I go for count(sex = "F")? My old but stupid way is to use proc sql two time with the where statement and then join these two tables.  That is not cool. Thanks! proc sql;      create table ipums2 as            select distinct year, statefip, county, count(pid) as p_count, count(race=4) as hs_count                 from ipums                      group by year, statefip, county                            order by year, statefip, county; quit; ... View more