Hello friends, please help me to understand this code, this is not my code, its existing code
I am testing code where one dataset "test" resolving with 3 observation
date file_name
20Jan16 test_file_20160120.txt
19Jan16 test_file_20160119.txt
18Jan16 test_file_20160118.txt
Now after this dataset (test) created, below code is running and its giving only 1 observation, i really don't know why it is resolving to one but i am expecting it should has 3 observation
%macro test (x_date);
%let store_x_date="null";
data test_2;
retain stop_ind;
if _N_ = 1 then stop_ind = 0;
set test;
by DESCENDING DATE;
if last.DATE = 1 then do;
if stop_ind = 0 then do;
output;
Author_DATE = put(DATE, date.);
call symput("&x_date.",Author_DATE);
end;
stop_ind = 1;
end;
if stop_ind = 0 then output;
run;
%mend;
%test (store_x_date);
Thank you
Some contributing factors:
I hope this is enough ... there's really no substitute for understanding what the statements do.
This is where formatting your code helps. Note that there's an output statement nested in an IF condition and a second one in the last statement. The goal seems to be to create a macro variable.
%macro test (x_date);
%let store_x_date="null";
data test_2;
retain stop_ind;
if _N_ = 1 then stop_ind = 0;
set test;
by DESCENDING DATE;
if last.DATE = 1 then do;
if stop_ind = 0 then do;
output;
Author_DATE = put(DATE, date.);
call symput("&x_date.",Author_DATE);
end;
stop_ind = 1;
end;
if stop_ind = 0 then output;
run;
%mend;
%test (store_x_date);
Some contributing factors:
I hope this is enough ... there's really no substitute for understanding what the statements do.
Thanks a lot Astouning and Reeza, appreciate your input,
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.