hello But when I am running same code on SAS Host which I think is using SAS 9.2 there I am getting the , in the result Is this thing works on SAS 9.2 but not on SAS 9.4 ?
... View more
hello I agree to you point that It removes leading and trailing spaces.But i have used the delimiter , in below statement zz=catx(',',x,z); Why comma(,) is not coming in the output ?
... View more
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
If I select prompt type as timestamp then it does not give me the option to select the values from sql server table.The only option that comes up is to provide the default value only
... 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
not really what my aim is that I want to extract each word and then apply scan function for example in this case %let x='a''b' once i get the value as 'a' 'b' the i can easily apply scan function and extact 'a' and 'b' separately
... 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
I have below macro variable %let x=2019-10-31 00:00:00.447000; This macro variable is having a value as character .i want it to convert to numeric 26 How can i do that ?
... View more
