Hello, in SAS Web Report Studio 3.1 I need to count distinct occurences for selected dimensions and display the results in a crosstable. According to the SAS Support Web site this aggregate function is not supported in cross tablulations, but maybe there is a work-around? Thank you and best Regards Nadine ...
I am working on a report in Base SAS 8.1(OpenVMS). I need it to have 1 page per observation...similar to below. I can't find anything that shows how to do this with PROC PRINT or PROC REPORT. Is there any way to do this other than with the PUT statement? Upgrading or adding modules isn't an option unfortunately. Any help is appreciated. ...
is there a short way to make ALL macro variables created inside a macro global in scope? ie: %macro x; %global _all_; * ??? ; %let x=1; %let y=1; %let z=1; %mend; ...
Is there any inherent method in SAS to find the sort order of a dataset? ...
When you look at the Business Intelligence arena, there are many big players, including SAS. In my time in this space I am noticing more big players moving to a more user friendly tool that doesn't require coding skill sets. Also, I am aware that SAS is trying to protect their market share by introducing tools that are more point and c...
Are there any advantages in using SQL PAssthrough facility along with SAS. ...
What exactly is the difference between Proc Means and Proc Summary? Many sites state that both these are same, but unless each has something unique will SAS create it? ...
Whats the difference between 12 mtd , 12 mtd rolling and ytd calculation ...
Support.sas.com provides this syntax for creating a prediction ellipse. The output dataset includes only the correlation results for the dataset. Is there any way to get information for the individual cases, such as labeling them in the graph or having the output include values for the individual cases? I've tried adding the ID option...
Would some be able to help me with some links on how FPA is done for SAS related projects.If someone of yuo have already done I guess it would be even more usefull if yuo could share some tips on how it could be done ...
I would like to know if it is possible (and if so how) to add buttons to the SAS Application Toolbar via SAS script. For instance, I have a button which submits "signoff" via the command line, and would like to distribute this to the rest of the team via our shared autoexec. ...
Is it possible to allocate a SAS script or macro to a Toolbar button in Base SAS? ie can you 'dm' a macro or sas script? ...
When submitting SAS code via the SAS Toolbar (eg cmjohns response) the compiler knows that the code is being "DM'd" and will not run certain code (eg %window). Is there a way to trick SAS into believing that code submitted from the Toolbar is coming from the Editor, therefore allowing interfaces (using %window) to be triggered via poi...
I am using SAS 9.1 and wish to make my toolbar available regardless of which window is in 'focus' (eg log, editor, output). My code looks like this: libname temp678 "\\MyDrive\Team Autoexec"; dm "toolload bar temp678.profile.MycustomToolbar"; libname temp678 clear; However when I run it, it only gets applied to the Log window! I'v...
We have a signon script that requires a Windows password in order to access and validate against the SAS metadata server. The problem is that if the windows password is changed, and the script is run a few without being updated, then the user gets locked out and has to call IT support for a password reset. What is the simplest way of u...
I have a string which looks like this: "ABAR_VAL", "ACQ_EXPTAX_Y", "ACQ_EXP_TAX", "ADJ_MATHRES2" and I'd like it to look like this: ABAR_VAL ACQ_EXPTAX_Y ACQ_EXP_TAX ADJ_MATHRES2 ie no apostrophes or commas and single space seperated. What is the cleanest / shortest way to do so in SAS 9.1.3 ? preferably something along the lin...
Hi, I have a SAS application that I am testing with the newly released SAS 9.2. I have a call to the metadat_newobj function to create a new Library object in the SAS metadata repository: rc = metadata_newobj( "SASLibrary", URI, Name ); In 9.1.3, when the function executed successfully (rc = 0), the URI variable was populated with th...
I am running SAS version 8.1 on the OpenVMS 8.3 platform. I have tried 2 different ways to import a csv data file and cant seem to get either of them to work properly. It would be great if anyone has any ideas as to what I may be doing wrong. This seems like a rather simple thing to do. CSV file SSID,field1,......(etc) AA9999999,0438...
I am working on SAS code that will run under UNIX. Ideally the IDE will have: intelligent code formatting (autocomplete is not necessary). ability to transfer code to server via SFTP/SSH/SCP. Ability to execute code on the server via ssh and -e Ability to pull the logs back down and have those formatted as well. Thoughts? I'm lo...
I'm using SAS 9.2 on OpenVMS to connect to an external data source over a socket specifed with a filename statement: filename extsrc SOCKET "extserver:port" recfm=v; data foo; infile extsrc; input; .... some statements to read stuff ...; run; This works (as it should) 99% of the time. However, once in a while the program that is supp...