python (65.2k questions)

javascript (44.3k questions)

reactjs (22.7k questions)

java (20.8k questions)

c# (17.4k questions)

html (16.3k questions)

r (13.7k questions)

android (13k questions)

Questions - datastep

How to use a SAS Macro inside data step

I'm running a code similare to the following one and the data step is not working and I can't seem to understand why %macro macro_1(variable); rsubmit; data want_&variable. (keep = a b c); set hav...
test-img

Thomas Sere

sas

sas-macro

proc-sql

datastep

Votes: 0

Answers: 1

Latest Answer

You have defined the macro variable VARIABLE on the local machine, but the code that is using the macro variable is running on the remote machine. Try pushing the value to the remote machine before t...
test-img

Tom

how to control decimal point in SAS output dataset?

I am new to SAS programming and I trying to work on proc means statement. For controlling my decimal value in the output I have used maxdec option however when I tried to assign a new dataset to the o...
test-img

Hari Chandana Bollimpalli

sas

ssas

decimal-point

datastep

procstat

Votes: 0

Answers: 1

Latest Answer

The MAXDEC option just controls how the PRINTOUT is generated. If you want to control the number of decimal places used when printing a dataset you need to attach a format to the variable(s). To cont...
test-img

Tom

Sas Macros to get schedule the program to run bi-weekly

I have a proc sql code that needs to run twice each month- 1st and the 16th. There is a where clause in the proc sql. When the report runs on say January 1st 2022, the where clause filters records tha...
test-img

Sindhu T

sas

sas-macro

proc-sql

datastep

Votes: 0

Answers: 1

Latest Answer

To automate date selection, add the following code to your macro. This will create two start/end-date macro variables that hold dates depending on the current day of month. data _null_; /* Beginn...
test-img

Stu Sztukowski

Posts

Questions

Blogs

Jobs