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 strongm 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: jdvtr
  • Order by date
  1. jdvtr

    Append ODS HTML

    Does anyone know how to append additional information to an excel spreadsheet using ODS HTML? Need to add several hundred records, but obviously don't want to add that number of additional pages in excel. Hope this makes sense! Joe
  2. jdvtr

    How to use .first variable in SAS data step

    You might try: proc sort data=FirstVisit; by UserID descending DATE RecordNo; run; or/and use NOPDUPLICATES or NODUPKEY on the sort.
  3. jdvtr

    estimation problem with MCMC method

    Typo maybe? Dalta2 should be Delta2?
  4. jdvtr

    LOG and OUTPUT window full

    Just come across this one! You could alternatively try writing the following code at strategic parts of your program: DM 'Clear log' ; DM 'Clear Out' ; Say, after each instance of writing something to the output - proc report/tabulate/print etc.
  5. jdvtr

    ERROR: The EXCEL engine cannot be found

    Insert excel into your libname. libname myxls excel "C:\demoA1.xls"; HTH
  6. jdvtr

    Import raw data from fixed format .txt file - SAS 9.0

    This might point you in the right direction: http://www.albany.edu/~msz03/epi514/papers/truncover.pdf
  7. jdvtr

    How to reference Macro Variable in PROC SQL

    Silly question(s) maybe. Have you tried running the code 'stand alone' without using macros to see whether there are errors? There may be additional code within your SQL step, but as it reads there, why do you need to use SQL for what appears a straightforward subset? Wouldn't a proc sort with...

Part and Inventory Search

Back
Top