**StudySAS Blog: Mastering Clinical Data Management with SAS**

In my view, Display Manager commands didn’t get much attention of SAS programmers as they should be. It may be because... 1) SAS Documentation has very little information about how to use this facility. 2) Even Google searches aren’t helpful enough. Here is the list of Display Manager Commands I know… dm "log; clear; out; clear;" ; *Clears Output and Log Window; dm " vt work.dsn" ; *Opens the dataset DSN in a View table window; dm "vt &syslast" ; *Opens the dataset recently created; dm 'next viewtable:work.dsn; end; ' ; *Closes the VT window of DSN; dm 'keydef f12 submit' ; *Assigns the submit command to the F12 key ; *Assigns clear log and output commands to F2 Key; dm "keydef F2 'cle log; cle output; submit'" ; *applies detail view to explorer window; dm   "next explorer; detail" ; dm "next log; detail" ; *Opens the Log Window; dm "next output; detail" ; *Open...

One of my favorite methods of exporting excel or .csv file is to use the ‘ DEXPORT ’ command-line command. This certainly reduces the amount of typing required to export the SAS dataset. Another interesting point is DEXPORT command works fine in UNIX and PC .   Syntax: dm “ DEXPORT libref.dsn 'filename.xls ' replace ;   "libref" is a library , "dsn" is the name of a SAS data set, and "filename.xls" is the name of the tab delimited text file(excel) being created. If we don’t specify the Libname or it is work then the dataset ‘dsn’ from the WORK directory is exported in a excel format to a specified location. Replace option … replaces the file if it already exists.     Use DIMPORT command-line command to convert/import a tab delimited (excel or .csv etc) into a SAS dataset. Syntax: dm “DIMPORT ‘filename.csv’ exc" replace; DIMPORT command tells SAS to import or convert the tab delimited file (filename.csv) to a SAS dataset named ‘ex...