About ballardw

ballardw · ‎03-17-2011

Possibly using ODS PDF Text=" " before your procedure call. Add appearance options as needed/available. I don't use PDF much but have done this MANY times for RTF output when I have similar needs.

ballardw · ‎03-16-2011

You may be looking for the function NBSPACE which lets you insert a specified number of spaces into text. You may need to use TEXT instead of TITLE though. ^{NBSPACE ( )}

ballardw · ‎03-16-2011

Did you try putting any blanks within the quotes? Like TITLE ' '; SAS generally treats 2 adjacent quotes as a way to say "print one". An example is: TITLE 'This title displays a single '' quote within a title';

ballardw · ‎03-14-2011

I find that most real CSV data files don't get handled well by the defaults or even available options with PROC IMPORT. I go to the log after running PROC IMPORT and find the generated lines of code, copy and paste into the editor. Then clean up the informats, formats, input statemement and add labels.

ballardw · ‎03-10-2011

How did you summarize and combine the previous output? You may be creating extra work with that approach.

ballardw · ‎03-09-2011

What the output of the example data look like?

ballardw · ‎03-09-2011

Which procedures are generating these messages? Some procedures that support run group processing may not close the dataset until either a "run;" or "quit;" is encountered.

ballardw · ‎03-08-2011

If &NJcomplist resolves to having any special characters, you may need to call it as st= %str(&NJcomplist) Habitual use of a trailing "." with macro variables when you are not concatenating can get you into trouble as well.

ballardw · ‎03-07-2011

if _n_ = 1 put "header 1" "header 2" "header3"; is a minimal way to get something as a header.

ballardw · ‎03-07-2011

The error: ERROR: You cannot open WORK.ITEMBYTHRESH.DATA for output access with member-level control because WORK.ITEMBYTHRESH.DATA is in use by you in resource environment DMS Process. means that some other program has the output data set open and/or locked so the referenced data step can't use it. It is likely you opened the data set to see the results previously and didn't close it from the table view.

ballardw · ‎03-07-2011

Again, I haven't worked in a multiple OS environment such as you currently have for a long time, but some of the mainframes differentiate between HIGHLIGHTING, moving through a list with keys, and then SELECTING the highlighted one. I vaguely remember tabing through lists and then using a + key to select in CMS for example. It may be that the selection hasn't happened.

ballardw · ‎03-04-2011

I don't have references for AF currently but I would look at the methods associated with listboxes. I vaguely remember being able to do something like: rc =get_selected(listboxidentifier); But I think the RC was the list item identfier not the actual value displayed in the box. It didn't matter if you used a mouse or key strokes to navigate the list.

ballardw · ‎03-02-2011

Instead of creating additional datasets using a data step I would suggest looking into PROC DATASETS which lets you modify datasets and properties of the variables within the dataset.

ballardw · ‎02-24-2011

If this string may have varying "/" characters then you may want to look at the modifier B option to search backwards for the last one instead of a specific numbered position.

ballardw · ‎02-24-2011

You can have multiple delimiters specified. So DLM=' ,' should treat the comma between city and state as desired.

Online Status	Offline
Date Last Visited	Wednesday