Or. You maybe need into SAS Management Console , make sure to choose all the read right ( not deny all these right ) in Default ACL . Ksharp ... View more

If you want to remove metadata but have it around in backup form just in case you need it again, the best thing to do is create an export package with unneeded items and then delete those items from the repository. After deleting the items, you'd want to follow the same approach you did before (backup with REORG=YES, MetaCleanse). Export only covers a subset of the metadata object types, however, so this isn't a general solution. Attempting to get below the 3 GB mark and stay there is a bit like trying to keep you Inbox clean - it's only going to help for a little while. If you're nudging up against this boundary, we'd strongly recommend an upgrade to a 64-bit OS and to 9.2. After doing this, you'll never face this problem again. Thanks, Tim Stearn ... View more

Hi, I guess you can refer to the following document: http://support.sas.com/resources/papers/proceedings09/334-2009.pdf ... View more

Take a look at PROC SPDO. /Linus ... View more

: You really ought to create a new discussion rather than just ask a new question as a reply to an old discussion.  In that new discussion you really ought to describe your problem better, specifically to show the code you are using.  SAS can read all columns from an Excel 2007 workbook. ... View more

The "K" functions can be used to manipulated strings where a character may take more than one byte. For instance, you could use KLENGTH to get the length of the string, then pick characters out of the string with KSUBSTR in a loop. A log snippet showing this is at the bottom of this post. Jason [pre] 19 data _null_; 20 text = 'abcdef'; 21 do i = 1 to klength(text); 22 c = ksubstr(text, i, 1); 23 put c; 24 end; 25 run; a b c d e f [/pre] ... View more

You aren't using Learning Edition, are you? If so, you are limited in the number of observations, so you could be hitting that limit. ... View more

In your first post you mentioned space/space/letter/letter/number/space/space [pre] data _null_; input target $32.; retain rx; if _n_ eq 1 then rx= prxparse('/( [A-Za-z]{2}\d )/'); f = prxmatch(rx,target); x = prxposn(rx,1,target); put _all_; put x $char32.; cards; a LL3 b a LL4 B a LL5 B a LL3 c a bb3 b a ca4 B ;;;; run; [/pre] ... View more

Very quick and dirty: But it may give you a starting point. data urn; u = 1; output; run; data two; do i = 3 to 7; output; end; run; data three urn(keep = u) ; retain urn; merge two(in = t) end = eof urn; if _n_ = 1 then urn = u; urn = urn + 1; if t then output three; if eof then do u = urn; output urn; end; run; ... View more