Hi, I'm working to enhance an EG report with some new calcs to be used for determining shipping measurements  My data set will have 3  numeric data columns with whole numbers & numbers with decimal positions.   IE: 5 17.72 13.47 15 6.15   For the values that have no decimal positions, I need to leave those numbers 'as is' Any value that has a decimal position, I need to always round up to the next whole number with no decimal positions   so my expected results will be: 5 18 14 15 7   Does anyone know of a function or routine I can use for this?  Any help would be appreciated! ... View more

HI.   perhaps someone can help.  I have a large .sas program that generates an error at this particular part of the code when I run directly on our unix server, but when I run the same piece of code in EG, I have no issue and my output creates as expected.  So.. I'm assuming that this statement is interpreted differently as .egp.. and therefor I need to use some sort of unix syntax equivilant?   this is my code    PROC SQL; CREATE TABLE work.CustRespChanPlatALLGFGB AS SELECT DISTINCT compress(t1.Source_ID || put(t1.'WEB ORDER ID'n,best.)) as SrcAndWebNbr ,t1.'ORDER #'n as OrderNumber ,t1.'MASTER CHANNEL'n as MasterChannel FROM ADS.CUST_RESP_CHAN_PLAT_ALLGFGB t1 ; QUIT;   these are the errors I get:   ERROR: Column WEB ORDER ID could not be found in the table/view identified with the correlation name T1. ERROR: Column ORDER # could not be found in the table/view identified with the correlation name T1. ERROR: Column MASTER CHANNEL could not be found in the table/view identified with the correlation name T1. ERROR: Numeric format BEST in PUT function requires a numeric argument.     I have attached the source table specs so that you can see what the input table contains.     Any help or advice would be truly appreciated.   ... View more

Hello SAS world.   Today I'm trying to find an easy way (hopefully) to do some column rounding based on a value in the first digit to the RIGHT of a decimal point, with a computed column in EG   Essentially If the first digit is a '1' or greater,  I want to round UP to the next whole number, otherwise.. it remains the same whole number. At the end.. the result data column will be formatted to be only a whole number, no decimal positions.   So: '2.0122' would be returned as '2.00' or '2.0122'    '2.1203'  would be '3.00' or '3.1203'                    '4.6129' would be '5.00' or '5.6129' '0.099' would be '0' '0.111' would be '1' or '1.111'     My first thought was to convert the value to a character value, then use a sub-string to get the first 'digit', then to use a case statement to determine what to do..   I'm sure there is something easier, more efficient to do this with. I just haven't learned it yet.   I looked into FLOOR, CEIL, ROUND functions.. but I don't see anything that suggests I can control what position is judged, and how the controlling argument (.1) is assigned.   Any Ideas would be very appreciated.           ... View more

HI All,   I am a novice programmer and facing a new programming challenge.    I'm working with enterprise guide to create a data set to be exported ultimately..  (I estimate about 1.7 million records..)   A character column within it contains periods (.) in some of the rows. (the value is not always found, or in the same position within the string) I'd like to scan the column and replace them if possible with a blank. I am not sure if the is a function that I can use with creating a calculated column OR, how I can create a data set, then run a proc statement against it to read the rows, scan/replace if found the value and update the data.   I have tried searching the community for answers, but was unsuccessful.  Any help would be appreciated!     ... View more