Would be nice if you can provide a set of sample on both incoming and outcome data. ... View more

Ok, I feel your frustration, and I am telling you, myself been there done that. Although you have some confusion conceptually on 'Formated input' vs 'Column input', but that does not comprise the momentum of your question. Let me answer it quick, and then I will try to explain it using some code. In short, SAS does NOT care your column settings at the end of the line, if there is nothing there, SAS WILL move on to the next line by default, regardless what kind of input method you use, including 'Column input', until you tell SAS not to do it.   filename FT15F001 temp; data have; /*infile FT15F001 truncover ;*/ /*will read and keep, will not move on to the next line*/ /*infile FT15F001 missover ;*/ /*will not read the last variable if it is partial, will not move on to the next line*/ /*infile FT15F001 pad ;*/ /*this is to pad blanks to the end of the line to 80 chars so SAS can still respect your column instruction*/ infile FT15F001 ; /*will flower over, the default behavior*/ input v1 $ 1-2 v2 $ 4-30; parmcards; as abcd as asdlfk ;;;; run; ... View more

Another approach, first introduct a new variable 'sign' to mark the sign of the value, then 2X DOW get the job done: data have; infile cards truncover expandtabs; input date anydtdtm13. value; format date datetime25.2; sign=ifn(value < 0,-1,0); cards; 3/1/2016 4:55 -100 3/1/2016 5:00 -120 3/1/2016 5:05 -50 3/1/2016 5:10 -400 3/1/2016 5:15 -250 3/1/2016 5:35 45 3/1/2016 5:40 58 3/1/2016 5:45 -80 3/1/2016 5:50 4 3/1/2016 5:55 -52.8 3/1/2016 6:00 -150 3/1/2016 6:05 -400 3/1/2016 6:10 -42 ; data want; do totct=1 by 1 until (last.sign); set have; by sign notsorted; end; if sign > -1 then totct=0; do count=1 by 1 until (last.sign); set have; by sign notsorted; output; end; run; ; ... View more

Similar to what @data_null__'s suggestion, only add different format to help keeping time part information: DATA test; infile datalines TRUNCOVER EXPANDTABS ; INPUT date1 : mmddyy10. date2 : mmddyy10. date3 : & mdyampm25.2; FORMAT date1 date2 DATE9. date3 dateAMPM25.2; DATALINES; 6/6/11 4/4/2012 03/26/12 12:58 AM 7/6/11 3/4/2012 10/26/12 10:58 AM ; RUN; ... View more

Darn 64bit? we had the same issue before, so give a try to see if it fits yours. ... View more

Failed to see where 'first 8 character' kicks in, as there is no position nor length condition being addressed in your code, but error is due to you have a always true condition: WHEN CONTAINS 'SYS%' OR 'K%' THEN 'SYSTEM' try to change it to:   CASE WHEN (DSNAME CONTAINS 'SYS%') OR (DSNAME CONTAINS 'K%') THEN 'SYSTEM' the older way 'K%' will always be valued as 1 in boolean, as it does not evalue whether it contains, it evalues whether 'K%' is null, and it isn't.   ... View more

The main issue of this dummy variable making is the transpose, to make it dynamic is rather trivial, is this update what you need?   OPTIONS VALIDVARNAME=ANY; DATA HAVE; INPUT ID VAR $; CARDS; 1 ONE_1 2 TWO_2 3 THREE_3 ; PROC SQL NOPRINT ; SELECT VAR INTO :VAR SEPARATED BY ' ' FROM HAVE; QUIT; PROC TRANSPOSE DATA=HAVE OUT=HAVE2(DROP=_NAME_); ID VAR; COPY ID VAR; RUN; DATA WANT; SET HAVE2; ARRAY V &VAR.; DO OVER V; V=IFN(VAR=VNAME(V),1,0); END; RUN; ... View more

Though I knew little to zero about IML, I however still think IML can have a neat solution for this. Following is my quick and dirty way: OPTIONS VALIDVARNAME=ANY; DATA HAVE; INPUT ID VAR $; CARDS; 1 ONE_1 2 TWO_2 3 THREE_3 ; PROC TRANSPOSE DATA=HAVE OUT=HAVE2(DROP=_NAME_); ID VAR; COPY ID VAR; RUN; DATA WANT; SET HAVE2; ARRAY V 'ONE_1'N--'THREE_3'N; DO OVER V; V=IFN(VAR=VNAME(V),1,0); END; RUN;     Updated: To cope non-V7 compliance variable names.  ... View more