Top "Sas" questions

SAS distinct in proc sql vs proc sort nodupkey

I have following dataset: data work.dataset; input a b c; datalines; 27 93 71 27 93 72 46 68 75 55 55 33 46 68 68 34 34 32 45 67 88 56 75 22 34 34 32 ; run; I want to select all distinct records …

sql sorting sas distinct proc

In SAS, what is the difference between Proc Means And Proc Summary?

What exactly is the difference between Proc Means and Proc Summary? Many sites state that both these are the same, …

sas

Dropping a table in SAS

What is the most efficient way to drop a table in SAS? I have a program that loops and drops …

sas proc-sql drop-table

Extract left part of the string in SAS?

Is there a function SAS proc SQL which i can use to extract left part of the string.it is …

sas proc-sql

How to convert sas7bdat file to csv?

I want to convert a .sas7bdat file to a .csv/txt format so that I can upload it into …

csv hadoop hive sas hdfs

How do I save a TextEdit (mac) file with a custom extension (.sas)?

So, I'm in the process of writing some code for SAS and I realized I have to save the file …

sas textedit

SAS: Calling one macro from another...Order of Macro Definitions

In my code I have several macros. Macro A is the main macro. Macro A then calls macro B which …

sas sas-macro

In SAS, what does the option "dsd" stand for?

I have a quick question. I am learning SAS and have come across the dsd= option. Does anyone know what …

sas

SAS : Convert character to numeric without creating another variable

I want to convert x to numeric. DATA test; input x $1.; cards; 1 2 0 ; run; I tried different ways : With *1 : /* trial1 */ DATA …

type-conversion sas

Saving results from SAS proc freq with multiple tables

I'm a beginner in SAS and I have the following problem. I need to calculate counts and percents of several …

sas sas-ods