Unable to concatenate date to end of the data set

[bharadwaj6560]

Hi Folks

I have 3 sample data sets named 1)x

                                                        2)y

                                                        3)z

I tried to concatenate 3 data sets as x021218.sas7bdat ,y021218.sas7bdat,z021218.sas7bdat.

For this to happen i have used below mentioned line of code 

%let x = %sysfunc(cats(x,%sysfunc(intnx(day,%sysfunc(date()),-1),mmddyy6.)));

but i could see my out put as x21218.sas7bdat .

could you please help me in getting the desired output

[PeterClemmensen]

When you say "concatenate datasets", what do you mean? Do you want to stack them op top of each other? Do they share the same variables?

Please be more specific

[bharadwaj6560]

concatenate in my perspective means adding a previous date in mmddyy6. format to dataset

for example my output data set requirement is x021218.sas7bdat 

so i used this line of code for example %let test = %sysfunc(cats(x,%sysfunc(intnx(day,%sysfunc(date()),-1),mmddyy6.)));

but my output is in following format x21218.sas7bdat

[Satish_Parida]

This Works as you described.

data _null_;
x=today();
y=put(x,ddmmyy6.);
call symput('dates',y);
run;

data x_&dates.;
set x;
run;

data y_&dates.;
set y;
run;

data y_&dates.;
set y;
run;

Let us know if it worked.