I'm guessing but it is probably something like this:
%include "C:\Users\jaiga\Desktop\SAS_Test_Practise\Macro\Macro1.sas"
You can get the correct path by navigating to the folder in Windows Explorer then copying and pasting from the navigation bar at the top.
... View more
Yes, if you do the following you will see the grouping. data have; attrib a b c d e format=best.; do I=1 to 10; do j=1 to 5; do k=1 to 7; do l=1 to 6; do m=1 to 3; a=i; b=j; c=k; d=l; e=1; output; end; end; end; end; end; run; data want; set have; by a b c d e; if first.e or last.e then Tick="Y"; run;
... View more
Also if you want to know the different nth values, try the below code data have; string="X!3.479!3.49902!3.43968!3.49919!3.5432!3.69513!3.52109!3.53714!"; do i = 1 to 10; new=scan(string,i,'!'); output; end; run; Thanks, Jag
... View more
thanks Tom, that's right - I was wondering why my new files had a time & some had the year (need to brush up on Unix)! I've just coded round it. cheers
... View more
Here is a link to read multiple raw data files with the same structure in one data step. Hope this helps. http://www.ats.ucla.edu/stat/sas/faq/multi_file_read.htm Thanks,
... View more
