You just need to remove the format from your statement, try changing it to this:   %let DatePublication = %sysfunc(today()); ... View more

If they are always in order you could do something like this:   data one; input visit $; cards; week1 week2 week3 week4 week5 week1 week2 week3 ; data new; set one; if visit='week1' then days=7; else days+7; run; proc print; run; ... View more

If you leave the macro variable formatted and you are trying to compare it to a SAS date value then you can use a date constant, for example:   where date(Service_date1) >= "&report_start"d and date(Service_date1) <= "&report_end"d   ... View more

Can you attach the exact code that is not working for you? ... View more

How are you sending the SAS data set to excel for viewing? ... View more

Something like this:   DATA want; SET have; row_number = _N_; row_number_adj = row_number + 2; Excelformula = COMPRESS("=(W"||row_number_adj||'+'||'Y'||row_number_adj||')'); row_score = cats(Excelformula,'*(20/26)'); RUN; ... View more

 Are you wanting SAS to create something like this:   =(W3+Y3)*(20/26) =(W4+Y4)*(20/26) =(W5+Y5)*(20/26) ... ... View more

If I understand your question you could  do something like the following:   data one; input col1 $ col2 $ col3 $ col4 $ col5 $ col6 $ col7 $ col8 $ col9 $ col10 $; cards; PM MM JM MM PM PB . . JM . PM MM JM MM PM PB JM . . . PM MM JM MM PM MB PM JM . . PM MM JM MM PM PM MM MB . PB PM MM JM MM PM PM MM DB . AB ; data new; set one; flag=0; array list(*) col1-col10; do i=1 to dim(list); if list(i) IN ('PB','MB') then do; do j=i to dim(list); if list(j) ne ' ' then flag=1; end; end; end; drop i J; run; proc print; run; ... View more

This is really all you need:   data Have; input ID Name $; cards; 1 . 1 Yes 2 . 2 No 3 . 3 Yes 4 No 5 . 5 . 5 Yes 6 No 8 Yes ; data new; set have; by id; if last.id then output; run; data final; merge have(in=a) new(rename=(name=name2)); by id; if a; run; ... View more

Here is one way to accomplish your task:   data Have; input ID Name $; cards; 1 . 1 Yes 2 . 2 No 3 . 3 Yes 4 No 5 . 5 . 5 Yes 6 No 8 Yes ; data new; set have; by id; if last.id then output; run; data final; merge have(in=a) new(rename=(name=name2)); by id; if a; run; data final2; set final; retain name2; by id; if first.id then new=name2; if name ne . then new=name; keep id name2; run; proc print; run; ... View more

Not sure what you mean when you say 'unable to search for more than one string at a time'.   My macro call below searches for the string 'macro' and 'print' (I could list as many strings I want here as long as it is under ~64K) : %search(c:\my_folder,macro|print) ... View more

Here is a technique I use that uses PRXMATCH to search for multiple strings.  Hope you find it helpful.   %macro search(dir,string); filename listing pipe "dir &dir\*.sas /b"; data new; infile listing truncover ; input filename $80.; filename="&dir\" || filename; infile dummy filevar=filename end=done truncover; do while (not done); input x1 $100.;   if prxmatch("m/&string/oi",x1) > 0 then output; end; run; %mend search; /** macro and print are the two strings I am searching for.  You need the | between each string you are searching for **/ %search(c:\my_folder,macro|print) proc print; run; ... View more

Could you give an example of how you would like the output to look? ... View more