Sounds like you want a summary reporting. Have a look at the GROUP option on the DEFINE statement. Have a look at the search option on the SAS support website http://support.sas.com/ or a Google advanced search using the keywords below will yield several matches with SAS DOC, technical papers (SGF, SUGI user conference). +"proc report" +summary site:sas.com Scott Barry SBBWorks, Inc. PROC REPORT DOC link: http://support.sas.com/onlinedoc/913/getDoc/en/proc.hlp/a000068725.htm SUGI/SGF technical paper on PROC REPORT: http://www2.sas.com/proceedings/forum2007/242-2007.pdf ... View more

Explain what you would like to see in your PROC REPORT output - a sample report illustration in your post might be helpful. Also, might I recommend using the SAS support website http://support.sas.com/ and I did the Google advanced search below, which revealed some matches using your keyword references: +"proc report" +distinct +count site:sas.com Have a look at the COMPUTE block to count BEFORE/AFTER a unique value Scott Barry SBBWorks, Inc. ... View more

The SAS support website http://support.sas.com/ has a technote on this item, found doing a search there. Your window macro is not supported with rsubmit. Scott Barry SBBWorks, Inc. http://support.sas.com/techsup/technote/ts697.pdf ... View more

A Google advanced search at the SAS support website http://support.sas.com/ using the following arguments revealed several interesting SAS technical (SUGI/SGF user conference) papers on this topic: combine text graphics pdf document site:sas.com Scott Barry SBBWorks, Inc. ... View more

Hopefully your SAS z/OS Admin will have experience setting other users up on the IBM mainframe z/OS TSO/USS environment, specifically with regard to your security package and adding what's called an "OMVS segment" providing you access to Unix System Services (USS), now pretty much required for SAS operation. And, you will need to work with your z/OS MVS storage management staff to get a zFS (or legacy HFS) data storage file, if you intend to maintain your SAS databases under USS as opposed to maintaining your SAS databases under the current/legacy mainframe-standard OS SAS data library datasets. As part of your migration, the determination will need to be made how you intend to publish and host your web-content that is SAS-generated, either using the IBM-supplied (note I didn't say free) HTTP Server, a z/OS web server, or the alternative which will require you to generate your HTML/graphics content on z/OS and then transfer that data to your web server platform (using pax likely). This could be cumbersome and must be well-planned. I would encourage you to push for using the mainframe-based HTTP (web) Server which is likely configured already by your z/OS SYSPROGs, but may not be ready for production usage. Scott Barry SBBWorks, Inc. ... View more

Here's the SAS 9 Macro Language Doc reference: http://support.sas.com/onlinedoc/913/getDoc/en/mcrolref.hlp/a000206943.htm Run this code: %let z = I am global; %macro x; %let y = I am local; %put _all_; %mend x; %x; Scott Barry SBBWorks, Inc. ... View more

The SAS interface for z/OS and TSO (or batch) is discussed in the SAS Companion for z/OS. You will want to contact your SAS admin for the z/OS (IBM mainframe) environment to determine how you access SAS under TSO. More specific to your Unix/TSO question, the SAS z/OS interfaces can access Unix System Services (USS) file structures (HFS, zFS libraries), but SAS itself does not have an interactive facility that runs under USS -- you must use SAS either in a batch job or from your TSO session. Also, there are SAS technical (conference) papers available at the SAS support website http://support.sas.com/ for review -- here is one on this topic, found with the search facility at the support website (FYI - the OS/390 operating system preceded the z/OS operating system -- you may see both of these referenced): TAKING ADVANTAGE OF THE SAS® SYSTEM ON THE OS/390 PLATFORM http://www.sas.com/partners/directory/ibm/os390.pdf Scott Barry SBBWorks, Inc. ... View more

I would recommend contacting SAS support for further guidance. I see no tech notes on the support website specifically about generation data sets and PROC SQL interaction. If PROC SQL is not supported, it should be clearly stated in the SAS DOC under the topic Understanding Generation Data Sets, in the SAS Language Reference: Concepts guide. Scott Barry SBBWorks, Inc. ... View more

I suspect that your SAS program has one or more of the following commands: %PUT _GLOBAL_; %PUT _AUTOMATIC_; If you set the following options, it should be pretty obvious where the code is, relative to other SAS processing: MACRO NOSOURCE SOURCE SOURCE2 MACROGEN SYMBOLGEN MLOGIC % OPTIONS NOSOURCE; Using SAS old-style (SAS 79) macro statements (as opposed to the SAS macro language), the character string "NOSOURCE" will be substituted with the data that follows. So, if there is any SAS code that turns off SOURCE, you can expect it to be turned back on with maximum SASLOG diagnostics information. Scott Barry SBBWorks, Inc. ... View more

Yes, what you are seeing is SAS normal behavior. Again, the SASLOG NOTE is the only indication, as demonstrated below: 1 data _null_; 2 if 1 = '1' then putlog 'We have a winner!'; 3 run; NOTE: Character values have been converted to numeric values at the places given by: (Line):(Column). 2:8 We have a winner! NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds Scott Barry SBBWorks, Inc. ... View more

The answer is: "it depends". If you birthdate variable is a character-type, you will need to convert it to a SAS numeric DATE variable using the INPUT function and the appropriate SAS DATE INFORMAT. However, if a SAS PROC CONTENTS on your SAS database file indicates that this variable is SAS NUMERIC and is using some SAS format to display (externally) the formatted value, then you can use SAS functions, such as INTCK, to determine age. Have a look at the SAS support website http://support.sas.com/ and the SAS Base documentation in the SAS Language guide. Also, at the support site (using the SEARCH option), there are technical papers (SUGI, SGF - user group conference proceedings) which explore this topic in great detail. Scott Barry SBBWorks,Inc. ... View more

You will see a SAS NOTE (no ERROR) in your SASLOG indicating that SAS converted character to numeric or vice versa, depending on the condition presented. On the other hand, if you attempt to combine SAS data sets which have same-named variables and different types, you will get a SAS error in the DATA step. Scott Barry SBBWorks, Inc. ... View more

Your objective here should be to have SAS DATETIME variables (not DATE variables for clarification), as explained in your post. Consider that SAS stores DATETIME type variables as numeric representing seconds since 01JAN1960:00:00:00. A SAS DATE variable, a SAS numeric variable as well, represents days since 01JAN1960. So, you should not want to do a PUT at all, with your conversion code, only the INPUT to convert the character string to a SAS DATETIME numeric variable value. Instead, perform your INPUT function, and also assign a SAS DATETIME FORMAT statement to the variable you are converting from character-format to numeric. Have a look at the SAS DOCUMENTATION on the SAS support website, where the topic about SAS DATE and DATETIME variables is discussed extensively -- URL link is http://support.sas.com/ for reference. Scott Barry SBBWorks,Inc. ... View more

Share SAS code related to creating and maintaining your SAS "data file" generation data set, for more meaningful feedback to your post. Scott Barry SBBWorks, Inc. ... View more