About ArtC

ArtC · ‎02-11-2015

For the traffic lighting I would like to conditionally execute the CALL DEFINE. That part is straight forward. so far when I build my formats with that specify colors to codes, not all the colors show up. I have however been using color names ('blue' and such), not RGB colors as @Peter suggested.

ArtC · ‎02-11-2015

Peter, are you saying that while not all colors can be addressed by name, within a style, that all of the RBG colors are available regardless of style?

ArtC · ‎02-11-2015

Perhaps I am doing something else wrong, but i found that not all colors (certainly by name) are available for any given style.

ArtC · ‎02-10-2015

I am using CALL DEFINE in a PROC REPORT step to control traffic lighting. Usually when doing this sort of thing the colors are fixed and known. However I currently am in the situation where I need to use quite a few colors and the style is not known until run time. I would like to be able to retrieve the available list of colors from the specified style and then use them for the traffic lighting. Thoughts on how I might do this?

ArtC · ‎04-08-2014

I am actually struggling with a similar problem - extra variables. The CSV file is generated by MS Access (I believe). I have checked for duplicate headers and long names. The TERMSTR= option does not help. My suspicion was extra trailing commas, but that did not seem to be the case. The data seem to go where they should and the extra columns (VAR31 and VAR32 in my case) are missing. Converting to xlsx and then back to CSV (hoping to remove odd characters) does not help. Before I just DROP VAR:; i would like to discover why - probably just to be sure. The system generates quite a few of these csv files not all have this issue. *** update *** As I continued to work on this I have found a parsing problem in the IMPORT process that generates the DATA step that actually reads the CSV file. I have not solved this yet, but what I think I know so far is that a long DSD string is incorrectly parsed. the field in question contains a quoted string and some special characters such as: "blah blah ""special blah"" other blah + more blah" The resulting DATA step has incorrect lengths assigned to the INFORMATs and an extra VARxx. Ultimately the data go into the correct fields, but with the incorrect lengths there is truncation. I will try to get permission to post the CSV or a portion of it. Message was edited by: Art Carpenter

ArtC · ‎04-07-2014

Love it - tho I just discovered it.

ArtC · ‎06-25-2013

Thanks Data _NULL_. I wish that I could give you a "correct answer" for your 'sincere' praise

ArtC · ‎06-25-2013

That was what I thought, but was hoping that I had missed something. Brute force it will be. Thanks

ArtC · ‎06-24-2013

I would like to use PROC IMPORT and force all variables to character. Since I am reading CSV files, I cannot use the MIXED= option.The attributes of the files are unknown and I am hoping that I will not have to build something to parse them individually.

ArtC · ‎05-14-2013

My understanding is that the table is cleared from memory when the DATA step is terminated. I have not heard of any memory bleeds or any that there would be any improvement in the memory clean up by first deleting the hash object.

ArtC · ‎04-09-2013

This could be an informat issue. Take a look at your INFORMAT for that field. Can we see your INPUT statement?

ArtC · ‎04-04-2013

Teach me not to read the question more closely. Might there be a system environmental variable that contains that information? If so then it could be used in Ron's solution, and thus avoiding multiple CFG files.

ArtC · ‎04-03-2013

First take a look at your FILENAME statement. I do not know Linux so do not know if the * will sufficiently concatenate the files - if not there are other ways. But at least there is a missing /. filename dir "&subdir./*.sas7bdat"; have you verified that the data set NEW contains the list? What are its variable values?

ArtC · ‎04-03-2013

The userid is stored in the automatic macro variable &SYSUSERID. The data set name becomes something like: _TD10996_&SYSUSERID._MYSERVERNAME_

ArtC · ‎03-29-2013

Formats do not change how the value is stored. they control how the value is displayed. If you want the month name to appear in Excel, try converting it to a character value and pass the character string. moname = put(date, monname5.);

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