SAS Support Communities

data new; x=' '; z='abc'; run;   data new1; set new; zz=catx(',',x,z); run;   I am trying to run this code but when I am opening the dataset new 1  Variable ZZ has value abc .It is not having ,   why ZZ is not having a value ,abc?         ... View more

    Hello   I am having a SAS EG project on 7.1.In that I have a prompt which is taking the values from one of the column in sql server table .That column is datetime .When user is going to run that  EG project he is going to see different values in the drop down of the prompt and he need to select one    Prompt type  is defined as Date  .But when i am running that SAS EG project by selecting one value in that prompt  I am getting the value of that prompt as Blank   I have tried to resolve  the value of prompt by  using %put    what could be the reason for getting the Blank value .   Prompt type does not have datetime option .The reason for blank value might be when we are taking the input in prompt it is datetime but the prompt type is date    please guide   ... View more

hello   I have a library called new which has 50 datasets.one of the dataset name is class   dataset class has 5 variables and 10 observations   Similarly we have other datasets which have some variables and observations     Now we have another library called old which also has 50 datasets with same name that we have in library new   I want to to append both the library datasets since they have same dataset name and variables   once way to acheive is write proc append like this for all the daatsest    proc append base=new.class data=old.class; run;   But what we need to do when we have 200 libraries and each library contain 10 to 15 datasets   what is the code that I can write other than proc append to acheive this ? ... View more

Hello   I have a  macro varible whose value can be like this    %let x='a''b'; %letx='ab''bc'; %letx='a''b''c';   what I want is have spaces between words my output should be 1st one ='a'  'b' 2nd one='ab'  'bc' 3rd one ='a'  'b'  'c'   how can i achieve this        ... View more