Manipulation Techniques Pdf 17: Sas Programming 2 Data

DATA output-dataset; MERGE dataset1 dataset2 ...; BY variable; RUN;

DATA sales; INPUT region $ salesrep $ sales amount; LABEL region = 'Region' salesrep = 'Sales Representative' sales = 'Sales Amount'; FORMAT sales dollar10.2; INFILE 'sales_data.txt'; /* data manipulation statements */ RUN; The PROC SORT procedure is used to sort a SAS dataset in ascending or descending order. Sas Programming 2 Data Manipulation Techniques Pdf 17

DATA output-dataset; ARRAY array-name n variable1 variable2 ...; /* array manipulation statements */ RUN; DATA output-dataset; MERGE dataset1 dataset2

PROC UPDATE DATA=sales; UPDATE sales_updates; BY sales_id; RUN; The ARRAY statement is used to create a temporary array to store values. MERGE dataset1 dataset2 ...

DATA dataset-name; INPUT variable1 variable2 ...; LABEL variable1 = 'label1' variable2 = 'label2' ...; FORMAT variable1 format1 variable2 format2 ...; INFILE 'file-name'; /* data manipulation statements */ RUN;