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 wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by dje

  1. dje

    Weird gplot

    I suggest looking at help in SAS for spider option charts or a reference to proc gradar. Those appear to be similar to what you may be looking for. I have minimal experience with them. dje
  2. dje

    De identification of data

    You may consider the statement data test;set confidentialdata; drop var1 var2 var3; ( var1 var2 and var3 are the variables that you want to protect) you may want to use some if statements to keep the fact that the variables exist but a more generic value is substituted via a if then...
  3. dje

    counter

    Not sure if this works in the stored procedures world but this is what I do for the intranet web programs. These lines are added to each program that is to be monitored. * log request in file; %INCLUDE "d:\prog\saslog.sas" ; *******************************; quit; This is the program...
  4. dje

    Using ODS with PROC REPORT when the no.of columns don't fit in a page

    I found the issue a problem as well. What I try to do is put it in a pdf file. I also use code to combine several variables into 1 field. That seems to help. key=LEFT(var1)||" var2= "||LEFTvar2)||" var3= "||LEFT(var3); you can add variable naming text to enhance readability.
  5. dje

    Using Wildcards

    Can you read those values in as numeric instead of characters? If so the filtering is more straight forward. Just a thought. dje
  6. dje

    Generating unique random values

    This is the way that I would try to do it. I am not sure I fully understood your desires. If this is not what you need you might be able to add some proc sort nodupkey; commands to filter unwanted duplicates if that is a problem. Good Luck, dje Code below: data gg; %macro samp...
  7. dje

    Search Variable for text string

    I would take the resulting data and do further filtering on that and filter based on "-1091" or " 1091 " You should be able to shrink your resulting file down to the pieces that you desire with multiple filter criteria.
  8. dje

    Automatically run a SAS script from a timer

    I use schedule wizard and it works fine. I installed schedule wizard on a dedicated machine that is always logged on and it runs my scheduled jobs from that dedicated machine. Therefore I dont have the logon issue. As I establish additional programs that I want to run routinely I add and...
  9. dje

    Export Excel file from SAS Server to local PC

    What code are you using to save the output to excel? Is there a different location that the output can be saved. The server would need access to that location. If that can be done, then modify to code to save the excel file to the more appropriate location. SAS could email the file if...
  10. dje

    Is it possible to make a dynamic web page using SAS and html?

    The product SAS Intrnet product is a product that you will likely find helpful. With that product you can establish web buttons that execute sas programs and the output can be directed to _webout which provides the html output of the results of the SAS program, charts, lists , stats...
  11. dje

    Substr Function (SAS)

    SAS Users Group Conferences are also a good economical source to help catch up on the use of SAS. http://support.sas.com/usergroups/ww.html
  12. dje

    Running a report automatically in SAS

    I use a 3rd party package called Schedule Wizard and it does a great job of allowing me to schedule sas jobs. It is from - Vince Sorensen Author Direct Shareware http://www.authord.com directsales@authord.com
  13. dje

    The Conversation Thread.

    Hello - My name is Dennis from Louisiana. I have used SAS for 20 years to do my work. I am a Process Engineer in a Manufacturing Environment. SAS Intrenet has worked well for me. I am not a sophisticated programmer but just trying to get the output that I need with the least amount of work...
  14. dje

    questions about SAS capabilities

    We use SAS as an information delivery tool for a manufacturing environment. The intranet product that SAS offers is a primary tool for us. We use Base, Stat, Graph, Intranet, QC,Stat, FSP, Share, Access to PC file formats, and Access to ODBC. This allows us to generate reports from live...
  15. dje

    Setting Max Column Width

    Sometimes on data with the large naratives sending the output to a pdf output may be useful. Just a thought.

Part and Inventory Search

Back
Top