Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: jonnysnow
  • Content: Threads
  • Order by date
  1. jonnysnow

    Resizing PDF - how can I get rid of orphan lines?

    I have a PDF document of 4 pages. Page 1 is full, but page 2 has only one line at the top. Page 3 is full, but page 4 has only two lines at the top. How can I force this to only two pages, where the odd-numbered pages will "take in" the orphan lines on the even-numbered pages?
  2. jonnysnow

    Minor annoyances in PC SAS 9.2

    I've noticed two things that annoy me in the way PC SAS 9.2 behaves. 1) When I double-click on a SAS program icon, SAS opens up, but instead of displaying the selected program in a single Enhanced Editor window (the way I'm used to), it opens two windows. One window, in the default location...
  3. jonnysnow

    Programming quality control

    I have been asked to help develop guidelines for verifying the output of programming projects. (As an exercise, I was also asked to check another programmer's work on a specific project, and complete the same project and compare results.) Since our office primarily works in SAS, I thought I...
  4. jonnysnow

    Enhanced Editor on UNIX?

    This should be an easy question. Does UNIX SAS have an Enhanced Editor window? I just moved from a job using SAS on Windows to one that runs SAS on UNIX. By default, I don't get an Enhanced Editor window, and I can't find any options that seem to start one. I'm suspecting that maybe UNIX SAS...
  5. jonnysnow

    Excel: How to add TAB character

    I haven't found this in the FAQ or when searching the forum: How can I add a literal TAB character in Excel? Right now I want to replace every instance of a double-space with a TAB. How can I enter a TAB character in the Replace: window for text replacement? While I'm at it, let me ask how...
  6. jonnysnow

    Excel: Want repeating headers, EXCEPT on last page

    I have a document in Excel that should have column headings repeated on all pages, except that the last page is a summary page and doesn't have the same formatting at all. I want to find some way of turning off the automatic header. Right now (using Excel 2003), I go to 'Page Setup', go to the...
  7. jonnysnow

    Macro window: Is it possible to make global text changes?

    I have a long macro that sets many control properties, based on many conditions. Examples of conditions are: [Reports]![rptCVD]![Flag] = 0 [Reports]![rptCVD]![Flag] = 1 [Reports]![rptCVD]![Flag] = 2 [Reports]![rptCVD]![Flag] = 3 Examples of actions are to SetValue for the...
  8. jonnysnow

    Can I have two page headers?

    I want to print a "main" page header on every page of my report. I also want to print a subreport header below the "main" header on each new page. I've seen a number of posts that refer to the "Repeat Section" property. It looks like I can set this property and I'll get the repeated headers...
  9. jonnysnow

    How can I see what the formats are?

    I received a dataset with built-in formats. How can I print out a listing of the raw values together with formatted values? Thanks!
  10. jonnysnow

    Function to select text strings

    There should be a function I'm just not familiar with. I have a table with a coded variable, CLINIC. I want to produce a string on a report, depending on what the variable CLINIC holds. Example: CLINIC could be: MGH, HMC, JMH and on the report, I want: MGH = Meadowbrook General Hospital...
  11. jonnysnow

    Formatting unexpectedly changes

    I have a series of reports in Access 2000. They each fit on one page, and in design view, they look fine. The first time I open Access and run the reports, they come out OK. If I run them a second time (and nothing should have changed), the report goes to four pages, because it's now too wide...
  12. jonnysnow

    Saving output twice (can FILE command do this?)

    I have a program that produces formatted output. What I want is to have SAS (1) send the output to the printer, and (2) save a copy of the formatted output. I figured out how to send output to the printer-- filename laserjet printer; data rpt1; file laserjet; put ..... put ..... ......... Is...
  13. jonnysnow

    How to confirm CD is blank

    I received a CD with important data on it, yet when I go to open it, my computer (running Win98) reports that the CD drive is not ready. I've tried to use MS-DOS as a more forceful way to try to read this CD or even see if there's anything on it, but I don't really know how to do this. I...
  14. jonnysnow

    DOS: Can "CALL" run without carriage return?

    Is there an easy way to call "CALL" in a batch file, but not have it send a carriage return (CR) to the DOS window? What I'm trying to do is get user input and test its value, and I want to control the CR's. My batch file looks something like this, using some dummy commands...
  15. jonnysnow

    REAL BASIC: What is a memory stick???

    Someone in my office will be making a slide presentation at a conference. Conference specs say that speakers can bring their presentations on USB Memory Stick. She asked me, "Can we use memory sticks?" I've never heard of memory sticks before. But obviously people in this forum...
  16. jonnysnow

    Batch file pauses unexpectedly

    I wrote a batch file that does a whole slew of things-- builds environment variables, copies files, does text substitution, runs DBMS/Copy in batch mode, runs SAS in batch mode, etc. This was working smoothly, but recently, it's been stopping at the end of some of the steps (like DBMS/Copy) and...
  17. jonnysnow

    Forcing variable into macro text string

    How can I get a filename to contain the current month/year? It's easy to get numeric variables: mth = month(today()); yr = year(today()); But, later on I want a filename to actually contain these as strings, something like: data file200310; I've tried: %let M = mth; %let Y = yr; data...
  18. jonnysnow

    Warning from admintool

    I just added a user on my Solaris system and I got the following: Admintool: Warning the user and uid entries are bieng used in the name service user map I'm not an expert at systems administration and I need some help knowing if this is a bad warning or no big deal. What does it mean?
  19. jonnysnow

    Merge by date range, not exact date

    I have one dataset (HOSP) with hospitalization data and another (EVENT) with procedure data. How can I merge these two so that I get a match whenever a procedure was done during a matching hospitalization? The problem is that the data in EVENT may not exactly match any field in HOSP. Example...
  20. jonnysnow

    Help stop batch run on double-click in Windows

    I use SAS (8.0) on several different Windows computers at work. On all except one, the default behavior when a *.sas program file is double-clicked is that SAS opens with the program ready in the Enhanced Editor window. But on one, a double-click starts the program in batch mode. This drives...

Part and Inventory Search

Back
Top