Please enable JavaScript.
Coggle requires JavaScript to display documents.
Base SAS - Coggle Diagram
Base SAS
You can have extentions to:
Data Access and Management
Reporting and Graphics
Business Solutions
Analytics
Visualization and Discovery
Used for:
Data Access
RDF - Raw Data File - format of data stored in Sas
Excel
Managing Data
Transformations
merging
subsets of data
validate clen data
create variables
Analyze
frequency count, averages
regression
forecast
SAS IS GOLD STANDARD FOR STATISTICAL ANALYSIS
Present Data - Reporitng
list reports
summary reports
graphics reports
publish your results - print into new data files
Exporting from Excel xlsx and csv
libname exdat excel 's:\workshop\bodyfat.xlsx'; -- zaciaga dane z excela i tworzy liblioteke o libref (referencja) 'exdate' ktora mozna otworzyc w sasie
proc print data=exdat.'bodyfat2$'n;
run;
-- uruchamia procedure ekstraktowania/printowania danych i uzywa juz obiektu exdat i jako attribute bierze sheeta (stad $), ale poniewaz mamy znaczek $ to musimy wziac to w cudzyslow i dopisac "n"
SUBSET OF DATA
How to load data from exel without creating library?
Exporting data from SAS database