Your datetime fields are already measured in seconds.  So  you could use: duration = Application_DateTime - Loan_DateTime; dif_in_minutes = int(duration / 60); dif_in_seconds = duration - 60*dif_in_minutes; ... View more

First step:  run a PROC CONTENTS on the data set.   This will verify whether the names that you are looking at are actual variable names, rather than variable labels. ... View more

The answer is hidden within the replies you have received.    As you know, this statement fails to change the numeric ZipCd to the character NewZipCd.   ZipCd = PUT(NewZipCd, 2.); The correct statement would be: NewZipCd = PUT(ZipCd, Z5.); The PUT function converts from numeric to character.  (Just for the record, it can also convert from character to character.)  The Z5 format requests 5 digits, with leading zeros as needed to flll out the five characters.   SAS statements that assign a value require the new variable name being created to appear before the equal sign, and the value to assign should appear to the right of the equal sign.     ... View more

Computers can have trouble getting exact numbers.  It's just a function of the storage system for numeric values.  Try it this way:   where round(theta, 0.000001) = 1.6; Some detail on the issue:  https://documentation.sas.com/doc/en/lrcon/9.4/p0ji1unv6thm0dn1gp4t01a1u0g6.htm   ... View more

Is it possible that a SOURCE/TARGET might contain two separate date ranges that do not overlap? If so, what should the result be? ... View more

Since the "unfinished code" begins with the word PROC, it looks like you should use a SAS procedure, and not a DATA step.   Take a look at PROC MEANS.   You will need to run it twice (once for the fathers and once for the mothers), because excluding fathers age 99 might exclude an observation needed for processing the mothers. ... View more

You copied some notes you received about the EDU format. Where did you find those notes? ... View more

For me, handling correlated independents was part of a class that overwhelmed me and put me to sleep 50 years ago.  I leave it to the heavy-duty stats people to sort this one out . ... View more

The one time I had to do something like this, I started with the distribution of start month from the treatment group.  I used that distribution to randomly assign a start month to the control population.  Then I used the complete set of characteristics to find matches. ... View more

@elbarto, Whichever method you use, searching through a 1000-character string can be time-consuming.  If speed is an issue, you can probably speed things up by taking advantage of the fact that "Venture Capital" is a subset of "Corporate Venture Capital".  Consider this structure:   VC = (whatever method you choose); if VC then CVC = (whatever method you choose); else CVC = 0; This avoids searching for "Corporate Venture Capital" in cases where it definitely won't exist. ... View more

I agree, with @PaigeMiller that your objective isn't clear.  Why not use a simple program with no macro language? proc freq data=sashelp.cars noprint; tables make / out=makes; tables type / out=types; tables origin / out=origins; tables drivetrain / out=drivetrains; run; What is the reason for complicating any of this with macro variables?  Is there some secret "next step" that would benefit from macro variables?  (That next step might also be possible without any macro language, but we would need to know what it is.) ... View more

Just some small considerations...  Some of your comparisons are redundant and can be removed.  For example, consider: or srce=:"Groi" or srce=:"Groin" The first comparison will automatically select any values that the second condition would pick up.  The second comparison can be removed.  SImilarly here: or srce="Urin" or srce=:"Ur" or srce=:"Urine" The middle comparison is all that is needed, since it selects all cases that meet the other two conditions.  Reduce the three to: or srce=:"Ur" ... View more

First, realize that you will eventually need to deal with realistic questions.  What should happen with ROI: Is exactly equal to the median? Has a missing value? Here is an approach that extends tools that you already know, to get the result: proc summary data=have; var roi; output out=medians (keep=roi_median) median=roi_median; run; That gives you the median in a data set, which can be used in a subsequent step.: data want; set have; if _n_=1 then set medians; roi_group = roi >= roi_median; drop roi_median; run; Note that the logic can easily be expanded to compute/group for more than one variable, without increasing the number of steps.  For example, you could begin with: proc summary data=have; var roi margin turnover; output out=medians (keep=roi_median margin_median turnover_median) median=roi_median margin_median turnover_median; run;  Also note that the assignment statement that computes roi_group could have been accomplished with IF/THEN statements, but would take more code: if roi >= roi_median then roi_group=1; else roi_group = 0; But the assignment statement shown above accomplishes the same with a shorter program. ... View more