topic How to insert observations based on the environment variable in SAS Programming

How to insert observations based on the environment variable

VVDR — Thu, 05 Sep 2019 04:52:30 GMT

Hi All,

I have a SAS Data set with BATCH_NO, SNAPST_DT and TABLE_NM variables and some values.

I have a .sas file. Upon executing this .sas file it creates some values to the environment variables. Now, I want to insert those values into the SAS dataset. Please suggest me how can I do that.

I found a way of updating the SAS data set update by using the below code:

proc sql;
update Lib1.A_batch_table_met_one
set No_Of_Records=input(sysget('NEW_TABLE_ROW_VAL'),best.)
where Batch_No=input(sysget('BATCH_NO'),best.)
AND Table_Name=sysget('TABLE_NM')
;
quit;

Re: How to insert observations based on the environment variable

Jagadishkatam — Thu, 05 Sep 2019 05:55:46 GMT

This is an untested code, you should try to join the two tables lib1.a_batch_table_met_one and the one table have with new variables and join them on BATCH_NO and TABLE_NM variables.

proc sql;
create table want as select a.*,b.var1,b.var2 from lib1.a_batch_table_met_one as a left join have as b on a.batch_no=b.batch_no and a.table_nm=b.table_nm;
quit;