http://www.lexjansen.com/wuss/2006/data_presentation_and_business_intelligence/DPR-Choate.pdf I never found a good reason (some exceptions) why the order of variables would be important. See PDV reference. SAS(R) 9.3 Language Reference: Concepts, Second Edition and http://support.sas.com/resources/papers/proceedings12/255-2012.pdf Unless some thinking habits are taken from some other tool like Excel, I don not understand this type of questions needing some order position number of a variable when you aree starting to use SAS. ... View more

Check Below One.. Might Help. http://www.tek-tips.com/viewthread.cfm?qid=1404586 ... View more

As you read the other thread.... 1/ you have to deal with firewall-s and routers. 2/ conflicting requirements like requirement of ssl (supported starting at 9.4) You did not get a Syntax Error. That doesn't indicate the processing of sending was succesful. Do not expect correct error messages or notes of something happening outside the SAS world. SAS(R) 9.3 System Options: Reference, Second Edition ( EMAILAUTHPROTOCOL= System Option) I would expect to be set to Yes as SMTP has normally no security by using valdiatied lines/machines (bulk mail). Google Gmail: Account must be set open to use IMAP/POP (go to mail-settings) Checking SSL/TSL What Are the Gmail SMTP Settings? - About Email ... Gmail is requiring SSL/TLS and SAS is supporting it with 9.4. Do you have 9.4? ... View more

Flavio, Perhaps difficult to explain as you are probably commonly used to see one computer / one environment your Windows desktop. With Eguide (and AMO) you get access to three additional environments. The difference between AMO and Eguide should be minimal when using the same credentials/startup. 1/ Libraries.   That are all type of tables. If you have used the old DMS approach you will miss the SAS-catalogs.   What is delivered off this depends on you (host/dbms) authorized access to these tables.   SASUSER is normally missing (hidden . read-only)  with Eguide.   The differences AMO/Eguide could be indicating you have used a different key or startup code 2/ Files.   This is very similar to the Windows explorer but is running at the server side.      What is delivered off this depends on you (server side) authorized access and the home - starting point (MyDocuments) on the server.   Be amazed you can drag and drap files from windows explorer to this part in Eguide. A not very visible with menus upload feature. 3/ SAS metadatafolders   This an other dedicated area with a similar lay-out of folders/maps. You could save your EG projects there (save as select server) in the same way as with windows-desktop. Finding a file/librarie in this with a helpfull naming convention could help to see what is happening (use properties if available) ... View more

or if your loan_numbers are not sorted at all here another way to go without the need to sort anywhere. data sample(drop=_:);     input loan_number;     if _n_=1 then     do;       length loan_id 8;       declare hash h1();       _rc=h1.defineKey('loan_number');       _rc=h1.defineData('loan_id');       _rc=h1.defineDone();     end;     if h1.find() ne 0 then     do;       loan_id=_n_;       _rc=h1.add();     end; cards; 111222                                         112333                                         112333                                         231111                                         143111                                         333333                                         333333 112333                                         ; run; ... View more

There a some good notes about native and foreign format of SAS tables/datasets. Moving and Accessing SAS(R) 9.4 Files  (Creating or Changing a SAS File's Format) As the sorting order is possible dependent on the NLS coding and the local machine there is an issue to able to definen that on an other machine. Looking at the documentation of transfering data all options have advantages and disadvantages. cport cimport can possible regress to V6 naming convetnions. SAS/connect is requiring more technical skills te let it work well. The proc upload/download procedures are reacting as separated process not knowing by default the status. The move option is not available. RLS (remote libraru Services) might offer a transparant processing by hiding the translation. You could be hit by some effects of the translation and automatic steps hidden in that.    ... View more

We are using the SAS BI environment and some of our users run stored processes, with user-modifiable parameters, via SAS Add-in for Microsoft Office (AMO). The underlying SAS code for each stored process is called from an SVN repository, which only we (the IT people) can modify. Users do not have access to the SVN repository, and cannot see the underlying SAS code (except via log output). However, log output can be suppressed so that the user cannot see source code statements in the log. ... View more