Is there a way to use IN operator to look for the values separated by pipe (|) instead of comma?  Value of macro variable is separated by pipe and I want to use the same value in where clause of proc print. I cannot control the macro variable value with pipe as separators.   Looking for dynamic solution when macro variable has either 1 or 3 or 4 values. e.g. ("Banking" or "Banking"|"Insurance"|"Textile")   Code: proc print data=have noobs; where &value_1 IN (&value_2); var &_field; run; Log: 30 %put ####value_2 is: &value_2.; ####value_2 is: "Banking"|"Insurance" 31 32 /*Filter and print the data*/ 33 34 proc print data=have noobs; SYMBOLGEN: Macro variable value_1 resolves to DIVISION 35 where &value_1 IN (&value_2); SYMBOLGEN: Macro variable value_2 resolves to "Banking"|"Insurance" NOTE: Line generated by the macro variable "value_2". 35 "Banking"|"Insurance" - 22 200 ERROR: Syntax error while parsing WHERE clause.   ... View more

I've used the format $hex50. to identify any special characters or invisible characters in the string. Value for the string is coming from .xls. Assume string value is "Urology". When I executed the program with $hex50. with the value "Urology", I got following message in the log. How to interpret this code to see if/what special characters in the string?    55726F6C6F67790D0A0D0A Following code is removing the spaces between the strings. I want to remove special characters (spaces, CR, LF) before and after the string and NOT between the strings   compress(string,'090A0C0D20A0'x))   ... View more

We're calling the macro as below which will help identify the environment (dev, test, prod) and the job name. Can someone help me where can I find the macro definition for the same? I searched in few folders for this macro but I couldn't locate it. I checked the log of this macro but I couldn't identify the location of the macro %env_jobname.   options symbolgen mlogic mprint; %env_jobname(var_name=path); ... View more

I've the following code which creates WANT dataset. Now I want to update the WANT dataset by doing sum(sales) and group by of other fields. I can do this in proc sql with create table statement but I don't want to create any  new dataset and instead I want to update the existing WANT dataset with the aggregation as told above. Any help?   data work.want; set work.have; upn = material; country = propcase(country_name); mon_intrvl = put(date, yymmd7.); sales_date = intnx("month",date,0,"b"); sales = delivery_qty; run; ... View more

I've the table as shown below. If I ignore the 'Serial_Num' field then there are few duplicate records. Now I want to identify the 'Serial_Num' of those duplicate records. Any help to achieve this using SQL?   Serial_Num Name Age Salary Gender 1 David 34 1000 M 2 David 34 1000 M 3 David 34 1000 M 4 Anu 36 900 F 5 Deepak 24 200 M 6 Deepak 24 200 M 7 James 44 1200 M 8 Anna 37 1000 F   Desired Output;   Serial_Num Name Age Salary Gender 1 David 34 1000 M 2 David 34 1000 M 3 David 34 1000 M 5 Deepak 24 200 M 6 Deepak 24 200 M   ... View more