Sas commands

libname TESTS oracle path="BIXXXP1" schema="XXX_DST"
user="XXX_BATCH[XXX_DST]" pw="password" DB_LENGTH_SEMANTICS_BYTE=NO
DBCLIENT_MAX_BYTES=1 encoding='utf-8';

libname out '/home/s2753g;

%put &SYSUSERID;

proc setinit;

proc contents data=SEB_RDD._all_;
run;

proc compare
	base=Scratch.H_XXX_1
	compare=Back_L.H_XXX_1
	novalues;
run;

data XXX_TEST;
set SEB_RDD.XXX_TEST (where=(TIME_PERDIOD = 202310));
run;

data XXX_TEST2;
set SEB_RDD2.XXX_TEST (where=(TIME_PERDIOD = 202310));
run;

proc compare
    base=XXX_TEST
    compare=XXX_TEST2;
run;

proc compare base=YOUR_BANK.POSTAL compare=YOUR_BANK2.POSTAL out=comparison_result outnoequal;
id POSTNUMMER;  /* Specify a common key to match rows */
run;

data work.POSTAL;
set your_bank.POSTAL;
run;

data 2.POSTAL;
set your_bank.POSTAL;
run;

data x;
length a $3;
a="abc";
output;
a="sjö";
output;
a="åöä";
output;
run;

%macro test_weight_control;
   %put Hello, World;
   %let x = 5;
%mend;

%include 'test_weight_control.sas';

%test_load_control;

%put The value of x is &x;

filename sasFile filesrvc folderPath = '/Jobs/YES' name='test_work_control.sas';
%include sasFile / source2;
filename sasFile clear;

%test_work_control;

proc pwencode in='my password';
run;

proc sql;
    select count(*) as TotalRows
    from SCHEMA.POINTS_D_XXX;
quit;