First you need to convert the XPT file to SAS Dataset.
/* Convert XPT to SAS Dataset */
libname SAS_DS 'E:\SASUniversityEdition\SandBox\Datasets';
libname xptfile xport 'E:\SASUniversityEdition\SandBox\Files\Input\FFQRAW_C.XPT' access=readonly;
proc copy inlib=xptfile outlib=SAS_DS;
run;
There are several ways to delete rows from a dataset depending on how you want to delete them, one way is as follows
PROC SQL;
delete from SAS_DS.FFQRAW_C
where WTS_FFQ is null;
quit;
Also there are several ways to insert data like:
/* Insert values manually */
proc sql;
insert into SAS_DS.FFQRAW_C
values (1,2,3,4,.....)
values (2,3,4,5,5....);
quit;
/* Insert values from existing table */
proc sql;
insert into SAS_DS.FFQRAW_C
select * from another_table;
quit;
... View more
