What is the way to concatenate two macro variables without space between them in %let statement? %let a_b=&a.&b.; is not good because there is space between them? Why space is created here? %let a=783; %let b=9828888223; %let a_b=&a.&b.; /**No good due to space**//**...
Ideally all the combining data sets have same variables, but in case they have different number of variables, then in the result all the variables appear, with missing values for the smaller data set.SyntaxThe basic syntax for SET statement in SAS is −SET data-set 1 data-set 2 data-...
until x. with a range previously defined (combination of r1 and r2 variables) The issue that I am getting is with "r" variable that I want to concatenate with "r1" and "r2". Mu dataset has 2500 observation and variable "range" has 25 ranges --That´s why I am doing this on my...
Don't miss out, May 6-9, in Orlando, Florida. View the full agenda. Register now! How to Concatenate Values Learn how use the CAT functions in SAS to join values from multiple variables into a single value. Find more tutorials on the SAS Users YouTube channel. SAS Training: Just a ...
View solution in original post 1 Like 1 REPLY Kurt_Bremser Super User Re: I want to Concatenate Date & Character Variables Posted 11-03-2019 05:22 AM (3793 views) | In reply to RADAGBE9 newvar = cats(put(date,mmddyy10.),c1,c2); Maxims of Maximally Efficient SAS Programmers...
until x. with a range previously defined (combination of r1 and r2 variables) The issue that I am getting is with "r" variable that I want to concatenate with "r1" and "r2". Mu dataset has 2500 observation and variable "range" has 25 ranges --That´s why I am doing this on my...
until x. with a range previously defined (combination of r1 and r2 variables) The issue that I am getting is with "r" variable that I want to concatenate with "r1" and "r2". Mu dataset has 2500 observation and variable "range" has 25 ranges --That´s why I am doing this on my...
@SAS93 wrote: I have 2 numeric variables for day and month respectively: DD_LV and MM_LV. I also have a general YY_ variable for year. I know I have to turn them into character variables first, but I ultimately want to concatenate them into a single MM/DD/YY date vari...
Is there a way to concatenate quoted variables? Basically, I am trying to remove from sas programs all hard coded parms. I am working on z/OSand trying to feed the parms from a file. For simplicity I am showing the parms on JCL inline below. I am trying to replace lines like...
Is there a way to concatenate quoted variables? Basically, I am trying to remove from sas programs all hard coded parms. I am working on z/OSand trying to feed the parms from a file. For simplicity I am showing the parms on JCL inline below. I am trying to replace lines like...