( 0 . 0 5 7 4 % )
1 2 3 4 5 6 7 8 9
Just count, and use the proper number for the fractional digits.
Which tells you the format should be PERCENT9.4
... View more
@elmoreoocyte wrote:
I tried it myself with the data I'm working with. Doing a left merge with SAS I had the 25k results I expected, no duplicated rows. Using proc sql join, SAS merges on the missing ID and duplicates rows.
Which is what happens in a m:n situation. The DATA step MERGE will result in max(m,n) observations, the SQL JOIN in m*n observations. In both cases, missing values are used as valid keys.
... View more
@Ronein wrote: The question is- about running time? Which way do you think is lowest running time? Should have significant difference in run time?is proc sql have the history running time??
Once again, Maxim 4: Try It.
But @Tom 's single step approach must be faster than your 300 SQL steps.
... View more
Why have manual program runs by multiple people in the first place?
What you describe is clearly a task for scheduled execution; this means that a single user will run the programs, and the scheduler will have control when the programs run (e.g. at nighttime when system load is low) and how many will run concurrently (avoiding deterioration of performance caused by saturation of resources).
... View more
In UNIX, deleting a file starts with removing a directory entry. So the necessary permission for deleting a file is the write permission on the directory; if you also need to be able to create files there, removing the write permission is not feasible.
One trick you can do from the OS: create a second physical (within the same physical filesystem) link to the file (ln command). If you accidentally remove the first link, the second link will prevent the actual delete (which means removing the inode and freeing the used clusters), and you can recreate the original directory entry.
Having a system backup (daily/incremental) is a total must, of course.
... View more
And if this is some kind of homework, tell your teacher that the purpose of a SAS course is to learn the efficient use of the SAS system, not wasting time with stupid things you'll never do in real life.
... View more
