Hi,I got a table and there is a column "switch_time" and looks like: switch_time 8:00:15 9:12:13 18:20:36   I want to use :   PROC SQL; CREATE TABLE MC_ET AS SELECT sum(case when switch_time between "8:00:00" and "9:00:00" then 1 else 0 end) as Count_of_8, sum(case when switch_time between "9:00:00" and "10:00:00" then 1 else 0 end) as count_of_9, ... FROM have ; QUIT; ... View more

I am using example on:http://support.sas.com/documentation/cdl/en/acreldb/65247/HTML/default/viewer.htm#p0bodejpo614gxn1vkvdpwch86xs.htm to using hive sql instead of sas sql Use implicit pass-through SQL to extract only 10 rows from the newtab table and load the work SAS data set with the results. proc sql; connect to hadoop (server=hxpduped); create table work.a as select * from connection to hadoop (select * from newtab limit 10); and the connection information is the case of our school,how should I write a right connection code in sas?   ... View more

A raw data file is listed below. 1---+----10---+----20---+--- 01/05/1989 Frank 11 12/25/1987 June 13 01/05/1991 Sally 9   The following SAS program is submitted using the raw data file as input: data work.family; infile 'file-specification'; input @1 date_of_birth mmddyy10. @15 first_name $5. @25age 3; run; proc print data=work.family noobs; run; Which one of the following is the result? a. The program executes, but the age values are missing in the output. b. The program executes, but the date values are missing in the output. c. The program fails to execute because the age informat is coded incorrectly. d. The program fails to execute because the date informat is coded incorrectly. Correct answer: a Values for the variable age are missing in the output because the informat for age is coded incorrectly. Since age is standard numeric input, it should use the w.d informat to specify a field width of 3 in the INPUT statement. You can learn about the w.d informat in Reading Raw Data in Fixed Fields     I think maybe the answer and the explanation are not right?Since the point is at 24？and the age is integer,it is supposed to read one number for each?and no need to set its format into w.d     ----------------------------------------------------------------------updade------------------------------------------------------------------------ this is the origin question on pdf file,mine paste seemd disorder the format. ... View more

data _null_; if 1=1 then call execute('%extractTable();'); call execute('%scoreUpdate()'); call execute('%writeTable();'); call execute(        'proc sql noprint;            insert into tableA(date,tag)             set date=today(),              tag=1;'); else call execute('%writeIndex();'); run;   return Error 160-185:no match if-then statement   the problem is caused  calling execute multiple macros..please fix the sas codes..thanks! ... View more

when I merely used macro:   %extracTable();   there is no error..   however when I am using : data _null_; if 1=1 then %extracTable(); else put @@@do not insert@@@; run;   it return : error:unquote array:Execute error:388-105 error 76-322 error:180-322   why and how to fix it...I am weak at sas Marco grammar..thank you ... View more