What should happen if the dataset exists in both libraries? ... View more

Names of columns must be unique, so if sas encounters a name a second time, it does not just add a number to that name, it starts with var1. To read a text file, i would write a data step. ... View more

Afaik: In order to run a program the sas-process owned by the user muss be able to read it. Exception: If the sas code is executed by a SAS Stored Process, then the user does not need read-access to the code. ... View more

This has been asked many times before, the search function will reveal code that will, most likely, just need some tweaks to work in your environment. ... View more

Do you want to extract the date from the filename or get the date shown in file explorer? ... View more

If the last word is longer than two chars it should not be removed, right? Are words separated by blanks only?   If both assumptions are true, then i would use: b = findc(trim(string), ' ', 'b') to find the position of the last blank calculate the difference between b and the length of the string, if the result is smaller than 3: substr to extract anything before b ... View more

Using the scan functions should work: scan(email, 1, '@'). ... View more

This "solution" demonstrates how to avoid loops: options missing = '#'; data want; set have; length value $ 10 all $ 200 p baseline 8; array one lle9-lle14; array two R9AGEY_B R10AGEY_B R11AGEY_B R12AGEY_B R13AGEY_B R14AGEY_B; value = put(coalesce(of one[*]), best.); all = catx(' ', of one[*]); p = findw(all, strip(value), ' ', 'e'); baseline = two[p]; *drop value all p; run; options missing = '.'; While coalesce still sees "missing", catx keeps missing values and displays them as #, so findw returns the number of the "word" matching the first non-missing value, which is the value of array two becoming the value of baseline.   In real-life i would use the second suggestion posted by @ballardw  ... View more

The default note about creating macros: Start with working code that solves the problem for one year. Then think about macros. The default note about asking for help: Post the log. The complete log. And, if macros are used, always activate the options mprint and mlogic, so that the log show what the macro did actually.   Why do you have to create that many datasets at all?     ... View more

You could use select/when or use the format show by @ballardw in a data step. If you need to the re-coding in multiple places, using a format is my preferred technique, because you have the definition in one place. Easier to read is the second way shown by ballardw, but whether such way exists depends largely on the re-coding itself.   data want; set have; bucket = put(year, myear.); run; ... View more

Just don't use a format at all, when storing dates in macro variables, if you don't want to use them in titles, footnotes etc. ... View more

The following table is displayed on  https://documentation.sas.com/doc/de/pgmsascdc/9.4_3.5/procstat/procstat_freq_syntax01.htm ... View more

Looking at the docs of proc freq, it seems an option exists preventing all printed output. ... View more