Top "Sas" questions

sas adding 7 days to a date

I would need to add to a date format variable 7 days. The variable is creation_date and is like 01JAN14:00:08:04. …

date sas days

Open code statement recursion detected during exporting a file

I try to export a file in SAS but I get "Open code statement recursion detected." error. Since I export …

recursion sas export sas-macro datastep

Substitute text in a macro variable in SAS

I want to change any instances of a period in a macro variable to underscore. What am I doing wrong? %…

sas sas-macro

SAS PROC SQL NOT CONTAINS multiple values in one statement

In PROC SQL, I need to select all rows where a column called "NAME" does not contain multiple values "abc", "…

sql sas proc-sql

Are statistical programming languages like R/SAS considered functional or procedural

I still don't understand the difference after reading this So, rather than asking what is the difference between functional vs …

r functional-programming sas procedural-programming

Macro sas difference between %str and %bquote

Sample Code :- %Let a = begin; %let b1 = %str(&a); %let b2 = %nrstr(&a); %let b3 = %bquote(&…

sas sas-macro

How to use Boolean datatype in SAS?

In many mainstream programming languages you can use Boolean data-type (for instance, value can be either true or false) - …

data-structures sas boolean

How can I make a character variable equal to the formatted value of a numeric variable for arbitrary SAS formats?

If I have a numeric variable with a format, is there a way to get the formatted value as a …

sas

Using SAS to delete a text file

Am looking for a piece of code, preferably OS independent and macro based, for deleting a text file (or any …

sas sas-macro

SAS script to list all SAS server users from metadata

I need a way to import a list of all SAS users from SAS metadata into an Excel worksheet. I …

excel sas admin administration sas-metadata