@GN0001 wrote: Thanks from both for great explanation. The only thing I didn’t understand is what -type f. -newer. I know the value of this string is assigned in findparm. But what happens If we simply say - type without f and without -newer? Respectfully Bittenapple We don't know since the macro variable is not used for anything in the code you shared.   Like I said I expect it will be used to generate a Unix command.  From the name and the options mentioned I would guess the find command.   ... View more

@GN0001 wrote: Hello team,  I have two fields with date data types: their format is yyyy-mm-dd. I used intck function as monthdidd(month, startdate, finaldate). Some of the rows doesn’t show correct result . For example, it should show 10 months, it shows 1440. What is causing this?   appreciate your response. blue in the sky Provide the actual values that are doing this, both formatted and unformatted. If this is happening with only a few values,  I would guess that somewhere along the line that what was thought to be yymmdd type data was entered incorrectly. If it happens with almost ever pair of values then one starts to suspect that the source values may be in different formats but read with the same informat. Also, show the entire data step where you are using the function and best would be to copy that from the log with all notes and then paste the entire log text into a text box opened on the forum with the </>. ... View more

Your code won't run anyway because of syntax errors: set mydata1 where (keep this that datatime where=(datepart(datetime) >= "01012021" mydata2 (keep=datetime fileNum); You have four opening, but only two closing brackets. Do you really want to include a dataset named "WHERE"? The result of DATEPART is a number, so comparing it to a string won't work. ... View more

Hello team, I have not tested it. Please give me some time to test it. Blue berry ... View more

SAS logs don't lie. If there was no error last month and there is this month then your data has changed to cause it. The challenge is to find what that is. ... View more

I suspect you ran code similar to this to get the SAS log notes in your post: proc datasets library = WORK kill nolist; run; quit; The reason you get those notes is because your SAS session has those SAS files open for the entirety of the session as they are using to store session settings. You can't delete them, but they will be deleted when you close your SAS session as your complete SAS WORK library is removed at that point. ... View more

That is what the WHERE statement I posted earlier was for. To select the observations to include in the result set of the SQL query. ... View more

@GN0001 wrote: Hello, Here, when I came to type in, I inserted a space, there is no space in the original code. blue&blue Easy solution: Copy text from editor or Log. Open text box with the </> icon. Paste text. No fuss, no muss and quicker than retyping.   ... View more

The macro variable (it's not a macro call, because those start with a percent sign) can contain anything that is valid code at this place. It must contain a list of variable names (because of the asterisk), but it could also contain a $ sign (or VARCHAR) to specify a character array, and it could also contain a list of initial values.   If you want to know what is actually used, add a %put &mbr.; statement right before the ARRAY statement.   To see what may appear in the macro variable, study the documentation of the ARRAY Statement. ... View more

rc= Based on the observation from SOMETABLE, look in the hash table for matching value for IDKey.  Retrieve the values for 'Thisfield' and 'Thatfield' from the hash table, based on a match for IDKey.   if rc ne 0 If the search through the hash table does not find a matching value for IDKey, assign missing values to 'Thisfield' and 'Thatfield' ... View more

CATS concatenates the arguments; CATX uses the first argument as a delimiter between all the following arguments. Both functions remove leading and trailing blanks before concatenating. ... View more

You will rarely ever want to the the MISSOVER option. Use the TRUNCOVER option instead.   The difference is when you try to read using a fixed length format and there are not enough characters on the line. With missover the characters that are there are ignored and the value is set to missing. With truncover the characters that are there are read.   So you have a variable length text file with a DATE value that can be up to 10 character wide. 12/23/2022 1/4/2021 01/20/2022 And you want to read it with this input statement. input date mmddyy10. ; If you use MISSOVER option that middle line will be missing because there are only 8 characters and not 10. But if you use TRUNCOVER option instead then the date will be properly read. ... View more

To understand what YOUR program is doing we need to see YOUR program.  What statements is it running that might modify the macro variable SYSCC.  What it is doing when the values is greater than 999.  Whether the code really has a space between the % and the DO .   To read more about SYSCC look at the SAS documentation.  Search: @sas.com syscc automatic macro variable Read: https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/mcrolref/p11nt7mv7k9hl4n1x9zwkralgq1b.htm   ... View more