I have a .txt data file like this: Title desc1 date name type bday alan card 11/15/1950 bob e-card 08/23/1951 I want to read into SAS ignoring the line1-3 and get the data like this: name type bday alan card 11/15/1950 bob e-card 08/23/1951 I tried proc import or infile, but none of them succeeded. proc import datafile = 'text.txt' out = data1 dbms = dlm replace; delimiter = ' '; getnames= yes; namerow= 4; datarow= 5; run; data data2; infile 'text.txt' dsd dlm=' ' truncover firstobs=4; run; I was not able to figure out how to assign the starting row to read, and at the same time how to get the column names.   Thanks ahead for any suggestions!         ... View more

Hi, I wanted to count events on dates using count() in proc sql. Here is the sample code: data have0; infile cards truncover expandtabs; input ID $ CODE DATE :date9. DEPT $ ; format date date8. ; cards; A0001 7001 12Oct2015 ETA A0001 7002 12Oct2015 ETA A0001 7001 12Nov2015 ETA A0001 7001 15Nov2016 ETA A0001 7002 13Oct2016 ETB A0001 7003 13Oct2015 ETB A0002 7001 12Oct2015 ETA A0002 7002 12Oct2015 ETA A0002 7003 12Oct2015 ETA A0002 7001 20Oct2016 ETB A0002 7002 23Oct2016 ETB A0002 7003 30Nov2016 ETB ; run; PROC SQL; CREATE TABLE events_ct AS SELECT count(*) as line_cnt ,count(distinct ID) as ID_cnt ,count(distinct CODE) as CODE_cnt ,count(distinct case when DEPT="ETA" then CODE end) as EtA_CODE_cnt ,count(case when DEPT="ETA" then DATE end) as events_cnt FROM have0 ; QUIT; The results for events_cnt shoud be 3 because I want to count the total distinct dates for each ID.   What I need actually is something like this: count(distinct case when DEPT="ETA" then (DATE from have0 group by ID) end) as events_cnt but this code doesn't work as it is now. It there any solution to modify the count(case when DEPT="ETA" then DATE end) as events_cnt and get what I need? Thanks a lot !      ... View more