Hello friends please help me to create two or multiple macro variable for existing dataset. I have dataset "a" where variable "date" has two values as mentioned below. I want to create two macro variable for this two value, how can i create it? I don't know how can i replicate do statement here...Thanks...Also sometime this "date" variable has more than 2 values...so in that case i will need to create more than 2 macro variable.... date 20141002 20141001 like &date1 should be 20141002 and &date2 should be 20101001 ... View more

Hello friends please help me to count interest rate I have some discrepancy in counting interest rate with Bank calculator and with SAS I am counting interest for $9000.00 @ 2.49% for 12 month. Bank is giving me monthly payment $760.00 which would be $9120.00 at end of the 12 months (so basically i am paying 120 more than actual amount) where as if i use below code i am getting something different... data test;     capital=9000;     interest_rate='2.49%'; do month=1 to 12;     interest=2.49/100*capital;    output;     capital+interest; end; run; /*12TH OBS WILL BE 11796.113263 2.49% 12 293.72322026 */ OR data test2;     capital=9000;     interest_rate='2.49%'; do month=1 to 12;     interest=capital*.12/12;    output;     capital+interest; end; run; /* 12TH OBS WILL BE 10041.01512 2.49% 12 100.4101512 */ is this happening coz of my code is adding interest every time when its counting interest for amount...? if so how can i do "capital-interest" ... View more

Hello please help me to write x command to copy single file. using Base SAS 9.1 I have &dir resolves to w:\woo\finance\ and    &fname resolves to send file name 09-18-2014.txt and then i am using below x command to transfer the file option noxwait; data _null_; x "copy &&dir..&fname \\server_path"; run; this is not resolving to w:\woo\finance\send file name 09-18-2014.txt and file not getting transfer and giving warning message like The quoted string currently being processed has become more than 262 characters long.          You may have unbalanced quotation marks. can someone please help??????? ... View more

Hello please help me on how can i use latest available date from all similar list of files. lets say i have 50 text files with same name uploaded on different date in directory "d:\woo" and lets say latest date file is 9/11/2014 and i want to use that file - how can i get that file in use... /*i am using this code to read all files at once*/ /*but then how can i use latest file*/ %let ext=txt; %let dir=f:\woo\; data files_list; length fname1 $200; infile "dir &dir.*.&ext /tw " pipe truncover lrecl=3000 ; input fname1 $200.; run; Thanks - ... View more

Hello friends - this could be dumb question but can you please tell me how we can use dataset which look like this... sales_20140819 sales_19aug2014 THESE DATASETS WILL KEEP CHANGIN DATE DATE SO TOMORROW WE WILL HAVE sales_20140820 sales_20aug2014 so i want to use like this; data test; set anylibrary.sales_&sysdate; run; Please help - thanks! ... View more