Yes you can, using a single DATA step, however you must list each of the 10 SAS data sets on the DATA statement for the SAS DATA step. Explore SAS documentation and using the MDY function (within the DATA step) to assign a SAS DATE (numeric type) variable in the DO loop, incrementing the year-portion of your SAS variable via the MDY function. Apply a SAS FORMAT statement to your SAS variable. Scott Barry SBBWorks, Inc. ... View more

Overview of the Time Series Forecasting System Introduction http://support.sas.com/onlinedoc/913/getDoc/en/etsug.hlp/tfintro_index.htm Scott Barry SBBWorks, Inc. ... View more

Use SAS PROC SUMMARY with MAX and MIN to get your CLASS variable value ranges for selection, creating a separate SAS file. Then using a DATA step and your data file sorted appropriately, MERGE (with a BY on your CLASS variables) back in the MIN/MAX range file and use IF THEN OUTPUT; to subset your data file. Scott Barry SBBWorks, Inc. ... View more

Good point - a SAS-generated (from mainframe document) can be stored there and hosted, if a web server, such as the "free" z/OS HTTP Server is active. Or the document could be generated and stored/transfered to another file server, where a web server has access. And, so, for these instances, the SAS-generated EMAIL would be able to send a text-format message containing the URL link to the document (very good idea and possibly more efficient, as well). Scott Barry SBBWorks, Inc. ... View more

Also, if you have a particular SAS programming problem, requesting input / feedback from the forum subscribers is a great location to get assistance. Preferably, one post per problem/question for applicability to the SUBJECT, as stated -- not "multiple part question". So, if you have attempted to use the code provided to you and you still have a very specific problem with said code, then it's time to open a new post (with a pertinent SUBJECT) and provide SAS code and preferably available SAS log output to share with the forum. Info was shared in a previous reply stating what you need to consider in order to generate a max value for a particular month (in the PROC SQL code). Maybe you missed the information in the long-winded thread! Scott Barry SBBWorks, Inc. ... View more

Though I have no personal experience, you will likely find technical reference and SAS product documentation at the SAS support http://support.sas.com/ website, either using the SEARCH facility or possibly using the Google advanced search argument listed below: Principal components analysis class syntax site:sas.com From the results I found, the PROC PRINCOMP as a pertinent SAS PROCEDURE. Scott Barry SBBWorks, Inc. ... View more

My experience using the feature, as documented, is that the PDV is not altered (behavior I would definitely want to occur) - you will want to test rc (in your code) to determine how to proceed. The interpretation of your observation "..then 'nothing' is returned..." is not totally clear to me. Scott Barry SBBWorks, Inc. SAS(R) 9.2 Language Reference: Dictionary - FIND method: http://support.sas.com/documentation/cdl/en/lrdict/61724/HTML/default/a002588683.htm ... View more

Suggest using SAS PROC SETINIT to determine definitively what SAS products are installed (not necessarily licensed) with each SAS version on your system. Scott Barry SBBWorks, Inc. ... View more

Review the ODS HTML and FILENAME EMAIL engine parameters when using SAS on the mainframe (presumed IBM's z/OS MVS environment), either as an attachment or as an instream HTML-formatted EMAIL document. The SAS support website http://support.sas.com/ has technical reference documents as well as SAS (z/OS MVS companion supplement guide) with details on the topic. Here is one related tech support document: TS-605 Sending Electronic Mail within the SAS System under OS/390 http://support.sas.com/techsup/technote/ts605.html Also, you will need to configure the SAS system option EMAILHOST= to specify a valid SMTP mail server, if one is not installed on z/OS. Scott Barry SBBWorks, Inc. ... View more

Suggest the SAS Support website http://support.sas.com/ and the SEARCH facility on this topic. Also, the Google advanced search argument below against SAS.COM also generated several hits: sas 64 bit support site:sas.com Scott Barry SBBWorks, Inc. ... View more

I tend to agree with feedback posted - it would be more reasonable to see a post with a SAS coding problem, given a particular data-manipulation, calculation or info-output challenge, considering that time is part of the SAS application development process (to include time set aside for learning and as much self-initiated debugging). To continue on one thread topic with multiple questions, after engaging someone's response, detracts from the purpose of the original post. Scott Barry SBBWorks, Inc. ... View more

It appears that on this forum, the factor "time" is far too often a challenge, thereby compromising one's opportunity to learn through DOC reading, digestion, code-composition, self-diagnosis and interpretation. How unfortunate. Scott Barry SBBWorks, Inc. ... View more

In SAS 9.1.3, the SET stmt FIRSTOBS=MAX parameter generates an error, unfortunately, for what appears to be an incorrect "last observation" calculation (based on the error message). Scott Barry SBBWorks, Inc. data x; do i=1 to 21; output; end; stop; run; data _null_; set x (firstobs=max); putlog _all_; stop; run; ... View more

With the DATA step approach, there are SET statement options NOBS= and POINT= for this use - sample shown below. Scott Barry SBBWorks, Inc. data _null_; set sashelp.class nobs=obscount point=obscount; putlog _all_; stop; run; ... View more

You really need to validate the content of your format - that's something only you can do, given the large size and the limits of this forum environment. One test to validate your SAS format is to unload it with PROC FORMAT and CNTLOUT= to a SAS file, for close inspection, as compared to your data file. After doing a CONTENTS against the CNTLOUT= file to get familiar with it, review the SAS-generated variables START, LABEL, and HLO data values, to start, if you are working with explicit values in the format (rather than value ranges -- a bit more complicated). Then sort your two files and do a MERGE in a DATA step. If you cannot get the MERGE to work, then you have some type of garbage in the format (determined from a PROC PRINT of START variable with a hex-type character display format. Scott Barry SBBWorks, Inc. ... View more