To the OP: if you want to pursue this type of anomaly, you will be best served by going directly to SAS Tech Support and opening a track to ask the question, given what you have uncovered. Scott Barry SBBWorks, Inc. ... View more

Are you licensed for SAS/Graph? Use PROC SETINIT to see what you have installed for your SAS system. Scott Barry SBBWorks, Inc. ... View more

As I mentioned, the PUTLOG command would have given you the answer to your latest curios question about SAS MERGE processing. Scott Barry SBBWorks, Inc. ... View more

You need to generate some self-initiated diagnostics in your SAS log to see why your SAS DATA step behaved as you explain. Add this statement and I believe that you will have the answer to your question: PUTLOG _ALL_; Scott Barry SBBWorks, Inc. ... View more

Although I believe that the COUNT function relates only to SAS CHARACTER type variables. Scott Barry SBBWorks, Inc. ... View more

The OP is wishing to generate the SELECT statement dynamically using a SAS file which is not properly supported. One alternative is to read up the member list, generate a SAS macro variable and then reference that variable as the SELECT statement data value. Scott Barry SBBWorks, Inc. ... View more

Need to know the exact error - which determines what type of SAS variable (CHAR or NUMERIC) is being referenced when attempting the INPUT function with effdat (or effdate - whatever). Also, for clarification about "CC", please provide an example of what you expect the value to be for a given calendar year? There are various SAS formats (using PUT, not INPUT, depending on the source variable format CHAR or NUMERIC) that may convert your DATE variable properly. Scott Barry SBBWorks, Inc. ... View more

Look at using SAS PROC TRANSPOSE in the SAS PROCEDURES documentation; also you will find much supplemental technical / conference reference material on the SAS.COM support website and likely in these forum archives. Scott Barry SBBWorks, Inc. ... View more

You only have one explicit OUTPUT statement coded inside a DO/END. Add this SAS statement at various points in your DATA step to analyze the processing by dumping all SAS variables to your SASLOG (change/identify each unique PUTLOG with the "nn" literal-constant): PUTLOG '>DIAG-nn>' / _ALL_; Scott Barry SBBWorks, Inc. ... View more

Use DATA step with MATCH merge on you FSALDU variable. Then for any no-match conditions, you will then need to create your FSA variable as you have described in with SUBSTR in an assignment statement for positions 1-3, and do another DATA step match-merge with a MERGE / BY statement on FSA. It's quite possible, as well, with PROC SQL. Scott Barry SBBWorks, Inc. ... View more

I have to ask why you double-posted your query/problem in this forum? Recommend you stay with one post, one topic-point or issue/problem/query....suggested forum etiquette. Here's your first one: http://support.sas.com/forums/thread.jspa?threadID=14647 Scott Barry SBBWorks, Inc. Message was edited by: sbb ... View more

For some self-initiated desk-checking, consider adding the SAS program line below (add the code-line one or more places with "nn" identification as unique string to generate much more info to your SASLOG so you can interrogate the processing flow: PUTLOG '>DIAG-nn' / _ALL_; Otherwise, you will want to share your SAS log, not a selected portion of your program. Scott Barry SBBWorks, Inc. ... View more

Again - why would you need/want to "require" a DATA step, if the task can be completed in fewer SAS programming statements and possibly more efficiently? And, so, with a DATA step, you must first sort your data, and then use BY GROUP PROCESSING to identify FIRST. and LAST. conditions for your defined BY variable list and the . Explore the available DOC -- see the GOOGLE search below. Scott Barry SBBWorks, Inc. Suggested Google advanced search argument, this topic / post: data step by group processing site:sas.com ... View more

Have a look at the VVALUE / VVALUEX function. Scott Barry SBBWorks, Inc. Suggested Google advanced search argument, this topic / post: return value of variable site:sas.com Message was edited by: sbb ... View more

Searching the SAS.COM support website, you will need to contact your SAS admin for assistance - here is a Google advanced search argument that revealed a SAS USAGE NOTE: ERROR: Insufficient authorization to access PIPE site:sas.com Usage Note 16109: Insufficient Authorization to access pipe error message when connecting to Spawner programs http://support.sas.com/kb/16/109.html Scott Barry SBBWorks, Inc. ... View more