Hello Friends, i am using below code and once i got "work.date" after end of the proc contents step, i want to use "create date" and "last modified date" variable in %macro step for multiple if statement. Can someone please tell me how i can use those two variable in next %macro step? ---------------------------------------------------------------- filename filelist pipe 'dir "f\shares\jim\finance\*.mdb" /b'; data work.use_date;   infile filelist truncover lrecl=256;   input filename $256.;   name=scan(filename,1,'_'); run; proc sort data=work.use_date;   by name; run; proc contents data=work.use_date out=work.date; run; ------------------------------------------------------------------------------------------ /*i want to use  "create date" and "last modified date" from work.date here */ %macro xyz; %if create_date=today() %then %do;         data....                  .....                   ....                  ....         run; %else %do;        data....               ....                  ...        run;            data....                 ....                      ...            run; data....                 ....                      ...            run; %end; %mend; %xyz; ... View more

Hello friends i am another proc sql query if someone can help please... i have variables like, date store_no item_no sale_qty onhand_qty i want to see unique ItemNbr per store  +   sale_qty onhand_qty for that item_no on particular date so may be my outcome would be like, date               store_no         item_no        sale_qty       onhand_qty -------------------------------------------------------------------------------------------------------- 26mar14         123456             90055678         12                100                                              90065656           0                10                                              90078785         10                 50                                              78528521           9                   1                                              78585522           2                 35 I am using following logic but not working properly... proc sql; create table a as select date, item_no, count(item_no) as item_no_cnt, sum(sale_qty) as sale_qty_sum, sum(onhand_qty) as onhand_qty_sum from testdataset where date='26mar14'd group by item_no having item_no_cnt>-1 order by item_no_cnt desc; quit; ... View more

Hi Friends - i have one SAS dataset with around 1/2 millions of records with some duplicate records on field SKU. I want to know which SKU has maximum duplicate record itself and which has minimum duplicate records for same field, SKU? Can someone please tell me how can i do this? Thanks! ... View more

Hello Friends - can someone please help on my question? is there any way we can perform "proc contents" for all SAS data sets into one particular folder where we have all SAS data sets RATHER than doing it individually? i am talking about performing below code for all SAS data sets at same time. proc contents data=jim.test; run; - Thanks! ... View more