How to delete labels and formats from SAS variables?
To delete labels and format from a variable, use the PROC DATASET procedure and attrib statement.… (0 comment)
All Posts in How To
8 Ways to count the number of observations in a SAS dataset and pass it into a macro variable
SAS data sets consist of a descriptor portion and a data portion that contains the data values. The descriptor portion of a SAS data set holds the detailed information about the data set. This information includes: Dataset name and its ember type Creation time of the dataset The number of observations The number of variables The… (0 comment)
4 Methods to find values in one table that are in another table
It is one of the most common data manipulation task to find records that exist in table one that also exists in the table two. In other words, finding common rows that exist in both the tables. This post includes 3 methods with PROC SQL and 1 method with data step merge to solving it. Suppose… (0 comment)
How to exit from a SAS data step or a Program?
There are a number of statements, options, functions, and programming alternatives that are well suited to controlling how and when all or a portion of a program can be stopped conditionally. Sometimes we want to control the flow of the individual data steps of the program. This may include the termination of a step or even the SAS job itself. There are several exit strategies depending on the objective.… (0 comment)
How to Password protect SAS datasets ?
Password Protecting SAS datasets Password Protecting SAS datasets means using access control on your data to prevent unintended access and secure your data. SAS has provided three levels of Access controls over the data and is implemented using passwords. Those access controls are read-write and alter. Passwords are hierarchical in terms of gaining access. For… (0 comment)
Save SAS log to an external file : Proc Printto in SAS
PROC PRINTTO procedure is used to redirect log output and procedure output to files or printers. To save the output in an external file, specify the external file or the fileref in the PROC PRINTTO statement. Syntax: PROC PRINTTO <options>; Options in Proc Printto LABEL= It provides a description for a SAS log or procedure… (0 comment)
How to delete datasets in SAS?
It’s an everyday SAS activity to manually delete all or some of the data sets that your SAS Program generates. It is an efficient programming practice to delete a dataset if it is not used anymore. There’s no need to add up unnecessary disk space. Additionally, it will make your libraries simpler to navigate and… (0 comment)
How to create folders in SAS?
Table of Contents 1 DLCREATEDIR2 DCREATESyntax:X md (an X Statement)3 Deleting a Directory To create folders in SAS, there are a variety of system options, functions and commands that you can use. These tools can be automated to perform repetitive routine tasks and which avoid manual work and save a great deal of time.Enter your… (0 comment)
How to use the IN operator in SAS macro?
IN operator is used in the data step to replace multiple OR conditions. However, if you try to use IN Operator in SAS Macro then you will find that the IN operator is not available… (0 comment)