Currently I do it manually, but I want to automate it. This is how I currently set the variables to every Friday in YYMMDDn8. format. %let week1=20150403; %let week2=20150327; %let week3=20150320; %let week4=20150313; %let week5=20150306; %let week6=20150227; %let week7=20150213; %let week8=20150206 I have tried and this is what I come up with, but how to assign it to a variable? data _null_; do i = 0 to 54 by 7;   dt=intnx('day','3apr2015'd,-i);   call symput('week',d);   put week=; end; run; ... View more

There are many data sets in a library, as below. CUST_201501 CUST_201502 CUST_201503 CUST_20150306 CUST_20150313 CUST_20150320 CUST_201501 is the month-end data for January CUST_201503 is the month-end data for March CUST_20150306 is the week-end data for 06th March 2015 CUST_20150313 is the week-end data for 13th March 2015 I want to achieve this: data CUST_weekly; set CUST_20150306 CUST_20150313 CUST_20150320 run; How do I go about automating the above? The below is the best I can come up with. Where do I put the SET statement? data cust_weekly; misdate='06MAR2015'd; format misdate yymmddn8.; j=1; do while (j lt 5);   j+ +1;   put misdate=;   misdate=intnx('days',misdate,7); end; run; ... View more

Hi, Is there any wrong with the below code? I want to group by formatted values. And I am not getting distinct values for the month of 201404. And let's say I don't want to use SELECT DISTINCT proc sql;   select   customer_number   ,mismonth   ,put(pf_account_level_5 ,$pnl.) as account   ,put((product_level_5),$product.) AS PRODUCT   ,sum(base_amount) as base_amount   from CAbal1   group by customer_number   , mismonth   , account   , PRODUCT ;quit; Output: Customer_Number MisMonth Account Product base_amount ZC00496500X 201402 AVGLIAB SGDCA 211036.2 ZC00496500X 201402 EOPLIAB SGDCA 210461.4 ZC00496500X 201403 AVGLIAB SGDCA 103288.7 ZC00496500X 201403 EOPLIAB SGDCA 90446.23 ZC00496500X 201404 AVGLIAB SGDCA 88210.63 ZC00496500X 201404 AVGLIAB SGDCA 88210.63 ZC00496500X 201404 EOPLIAB SGDCA 88596.22 ZC00496500X 201405 AVGLIAB SGDCA 88232.96 ZC00496500X 201405 EOPLIAB SGDCA 88408.44 ... View more