About ArtC

ArtC · ‎08-13-2010

You should not need an INFORMAT to read positive or negative numbers. The positive numbers are correctly read in with or without the plus sign. [pre]data posneg; input value; datalines; +123.12 -123.12 345.2222 -.003 run; proc print data=posneg; run; [/pre] If you need to display the plus sign for positive numbers you can use the appropriate PICTURE format shown above.

ArtC · ‎08-11-2010

Good suggestion on the use of %SYSEVALF. Much simpler.

ArtC · ‎08-11-2010

As a minimum you need to chat with the Technical Support folks (include a link to this thread). There may be a hot fix. Otherwise shortening the format name(s) or using SAS9.2 are alternatives.

ArtC · ‎08-11-2010

The SCAN function should do the trick as well: [pre] name = scan(wholename,1,'('); [/pre]

ArtC · ‎08-10-2010

In the macro world you will have to force the conversion of the data constant. One way to do this is with the PUTN function. [pre]%macro test(now, then); %put now &now; %put then &then; %mend test; %test(%sysfunc(putn("&sysdate"d,6.)), %eval(%sysfunc(putn("&sysdate"d,6.))-5)) [/pre]

ArtC · ‎08-10-2010

Using Cynthia'a code and SAS9.1.3 I was able to duplicate the original issue. It seems to be a problem with the way VIEWTABLE handles the longer format name. Good catch Peter. The format is assigned correctly and works correctly - in TABULATE and CONTENTS, however VIEWTABLE seems unable to properly use it or even display it. VIEWTABLE seemed to work fine in SAS9.2. Message was edited by: ArtC

ArtC · ‎08-10-2010

Your code worked fine for me in both 9.1 and 9.2 (windows xp). How did you check the attributes (proc contents, viewtable, columns window)? In your statement of the problem you say both that the format was not assigned, but it was also assigned incorrectly. If you were checking the column attributes under the ViewTable was the format not actually shown as LBWSAM01F14.? The 14 is the width and is an artifact of the way the format was created.

ArtC · ‎08-09-2010

The merge that SASKiwi suggests is one of several types of table look-ups. Read more about other look-up methods at http://caloxy.com/papers/43-i_how_table_lookups_from_ift.pdf .

ArtC · ‎08-05-2010

Both the FEXIST and the FILEEXIST functions allow you to verify that a file (or even a directory) exists on your system. The function returns a value which you can test.

ArtC · ‎08-05-2010

Take a look at the FEXIST function. It can be used in the DATA step or with %SYSFUNC. There are other solutions as well, but check this one out first.

ArtC · ‎08-04-2010

We are not seeing all of your program. Specifically you have not shown us the full definition of the macro CHECK_N (which currently has all the shown code commented out). Nor do we see where or how the macro variable N_LCG is called. Consider using a %PUT N_LCG &N_LCG; statement to verify that the macro variable exists and has a value.

ArtC · ‎08-04-2010

The X statement (or one of its variations) might be a good place to start. It allows you to submit OS level commands from within a SAS program.

ArtC · ‎08-04-2010

Here is a simple macro that will loop through a series of months and years. You can easily adapt it to subsets of months etc. [pre]%macro dates; %local months year month mon; %let months = Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec; %do year = 1997 %to 2010 %by 1; %do month = 1 %to 12 %by 1; %append(month=%scan(&months,&month),year=&year) %end; %end; %mend dates; %dates [/pre]

ArtC · ‎08-04-2010

If you really do want to use a more complicated macro solution take a look at Example A1.6.4 in Carpenter's Complete Guide to the SAS Macro Language, Second Edition

ArtC · ‎08-02-2010

You can find some information about processing episodic data at http://www2.sas.com/proceedings/sugi29/260-29.pdf I am unfamiliar with PROC TIMELINES, and do not understand your example are you looking for a break in the dates?

Online Status	Offline
Date Last Visited	‎06-20-2021 07:11 PM