Please try the below code data TEST_201312; test=1; run; data TEST__MONTH_201312; test=1; run; data TEST__YEAR_201312; test=1; run; proc  sql;   create table tab as select memname, cats(put(input(substr(left((compress(memname,,'kd'))),5,2),best.),monname3.),substr(left((compress(memname,,'kd'))),1,4)) as month_year  from dictionary.tables where upcase(memname) like "TEST%"; quit; output: Thanks, Jag ... View more

Alternately, PROC FORMAT;     VALUE $miss       " " = "Missing"       OTHER = "Non_Missing"; RUN; %macro freq(in,out); ods output OneWayFreqs=OneWayFreqs; proc freq data=have;   table &in / missing ;   format &in $miss.; run; ods output close ; proc transpose data=OneWayFreqs out=&out(drop=_name_); by table; id f_&in ; var Frequency; run; %mend; %freq(Customer_Id,want1) %freq(Gender,want2) %freq(location,want3) data all;   set want1 want2 want3; run; Thanks, Jag ... View more

is it possible for you to write another code in the same program where you can direct the output to a desired location. probably you can give a specific path, so that the generated chart be saved. After this code you can write the following code, which will send the chart as attachment to the email address mentioned filename myemail email from=("xxxx@xxxxxx.com") to=("xxxxx@xxxxx.com") Subject = "An email from SAS" Attach = "C:\Documents and Settings\chart.gif"; data _null_; file myemail; put "Please see attached."; run; During execution of the sas code, first the chart will be generated and will be saved in the desired location and then email code will execute which will send the attachment. Thanks, Jag ... View more

Please try data Data_set_name; set Data_set_name(keep = id_no cust_no cust_cde dataset_name date_end channel description purpose prod_hse credit_campaign Direct_Marketing); where prxmatch('/PHONE|BRN|BRANCH|FD|OKS|FFI|FIRSTDIREC|FIRSTDIRECT|OCC|OTHERCALLCENTRE|FPAS/',channel)>0 and contacted='Y' and Direct_Marketing = "Y"; run; Thanks, Jag ... View more

Alternatively by  SQL PROC SQL;    CREATE TABLE want AS    SELECT coalesce(t2.a,t1.a) AS a,           t1.b       FROM WORK.A t1            FULL JOIN WORK.B t2 ON (t1.a = t2.a); QUIT; Thanks, Jag ... View more

Hope you have selected "Multiple Values" under number of values like below while creating the prompt and have used "in a list" condition as suggested by Tom. Thanks, Jag ... View more

Hi Namrata, Please check the below code proc sql; /*need to delete if a firm appears twice in any year, preferably retain the firm observation with the positive value.*/ create table status as select distinct year,firm,industry, status, count(status) as count from test where status='A' and value > 0 group by year,firm,industry; /*.For each industry each year, I need to count the number of firms that have a positive value(count=A) and the total number of firms.*/ create table count as select distinct status,year,industry,firm,count(status) as count_status,count(firm) as count_firm from status group by year,industry; quit; The dataset count has the desired output. if i understood your requirement correctly you are expecting the below output. could you please check and let me know if this is not the desired output. Thanks, Jag ... View more