Efficient programming

Link: http://support.sas.com/resources/papers/proceedings09/041-2009.pdf

Cancel titles

A statement to cancel the titles:

title;

RSASUSER System Option: OpenVMS

To delete the following message in the log, try the command line option -RSASUSER, indicate SASUSER is for READ-only.

“WARNING: Unable to copy SASUSER registry to WORK registry. Because of this, you will not see registry customizations during this session.”

Link: RSASUSER

Proc Import trick

PROC IMPORT DATAFILE="c:\sas\ego.csv" OUT=jeeshim.egov  

             DBMS=CSV REPLACE; 
             guessingrows = 1000;

run;

GUESSINGROWS=1 to 32767;
specifies the number of rows of the file to scan in order to determine the appropriate data type and length for the columns. The scan data process scans from row 1 to the number that is specified by GUESSINGROWS=. The default value is 20. However, you can change the default value in the SAS Registry under SAS REGISTRY -> PRODUCTS -> BASE -> EFI -> GuessingRows.

Default:	20
Requirement:	This number should be greater than the value that is specified for DATAROW=.

CSV macro to read CSV file into SAS

Link: www.nesug.org/proceedings/nesug03/ps/ps019.pdf

Exporting data using ODS tagsets

Link: http://support.sas.com/rnd/base/ods/odsmarkup/tableeditor/index.html#export

SAS Papers Collection

Here

Base SAS Tip Sheets

Here