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
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...
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...
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.
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...
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.
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...
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...
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...
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
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.