"Proc sort will happily corrupt your source data" LOL. ... View more

Check the TYPE , LENGTH and any FORMAT that is attached to your variable. If the TYPE is NUM then check the range of the values using PROC MEANS or PROC SQL. If the variable has DATE values then the range of values would probably fall in the interval from today's date, which is day number 22,749 down to the earliest date in your data.  For example if you date goes back to beginning of 1960 then the smallest value is zero.  If it goes back further you might have negative numbers.   If the variable has instead DATETIME values (number of seconds) then value falls in the interval from now, which second number 1,965,578,801 down to the earliest timepoint in your data.  For example if you datetime values go back the start of 1960 then the smallest value is zero.  If it goes back further you might have negative numbers.   If your code does not work then please post the SAS log from the step you ran that did not work. Include any error messages and notes.  Make sure to use the Insert Code icon in the forum editor to paste the lines of text from the SAS log so the formatting is preserved.  If there are no error messages in the LOG then explain why you know it did not work. ... View more

The reason why an ARRAY is used is hard to discern without the context in which it is used.   In general the idea is repeat the same series of statements of each variable included in the array.  I reduces the need to write wallpaper code. data want; set have ; array measures m1-m100; do over measures; measures=measures**2 ; end; run; Or you want to reference the variable from a list based on an index into that list that is not known it advance. data want ; set have; array monthly jan feb mar apr may jun jul aug sep oct nov dec; monthly[month(date)]=cost; run;   ... View more

What part don't you understand? PROC SQL? SELECT? COUNT() function? COUNT(*)? INTO? :? FROM? What do you think it does from the context of the program where it was used? ... View more

See Maxim 46 and always keep its consequences in mind. ... View more

Hello saskiwi, This is not doable. That has legal consequences. Regards, blue & blue ... View more

@BrahmanandaRao wrote: Use IF statement it converts any data type num to char and char to num this is the one  difference between  IF & Where  where can not convert char to numeric But you can put functions in Where statements such as where year(somedatevariable)= 2022; Unless that "year" variable is to be used for something else it is not even needed. Many times when you need a "year" variable it may be quite possible that applying the YEAR format to a date variable will suffice. ... View more

@GN0001 wrote: Hello all, Year function return year as character,  NO. WAY. The YEAR() function returns a numeric value, PERIOD. If you use a variable that has already been defined as character on the left side of the assignment, SAS will convert the value on its own and write a corresponding NOTE in the log. Please post the complete log of the step where you use the YEAR() function. ... View more

Hello team, It means variable A from first dataset looks at the field A second dataset and brings a value from anther field. For Example: If cervical cancer from table A is found in string of column A of second dataset (cervical cancer screening), then bring the code which exists in a different column in second dataset in the result of the query.   cervical cancer is a substring of cervical cancer screening, then bring code that is in the observation of cervical cancer screening, but in a different column. Hope this makes sense.   Regards, blue blue     ... View more

SOURCE is the variable name. CLASS is a common SAS statement that is supported in various ways by a lot of SAS procedure.  It basically is for telling the procedure to group the data by the levels of that variable. For more information read the documentation on PROC SUMMARY (also known as PROC MEANS). ... View more

Hello Kurt, What you have directed me are links after links. If I want to get that route, I would be lost and each day, I need to start working in a new company. Obviously, reading is essential part of gaining education, I always read and search and then I post my question here. I clicked on the links then other links came up and then till seven layers deep that I forgot what I wanted. Anyway, thank you for sending me the direction that I go back and read them after I deliver my projects. I have short deadlines.   Respectfully, Blue & Blue ... View more