proc cas; fcmpact.addRoutines routineCode={"function myadd(a, b); return(a+b); endsub;"}, package="mypackage", funcTable={name="myfuncs", caslib="casuser", replace=true}; run;
proc cas; fcmpact.addRoutines routineCode={ "function myadd(a, b); return(a+b); endsub;", "function mymultiply(a, b); return(a*b); endsub;" }, package="mymathpackage", funcTable={name="mymathfuncs", caslib="casuser", replace=true}, saveTable=true; run;
proc cas; /* Step 1: Create the initial table with one function */ fcmpact.addRoutines routineCode={"function myadd(a, b); return(a+b); endsub;"}, package="myaggpackage", funcTable={name="myaggfuncs", caslib="casuser", replace=true}; /* Step 2: Append a new function to the exis...
proc cas; /* In Python, this would be: df = pd.DataFrame({'model': ['Mustang', 'F-150'], 'msrp': [27000, 35000]}); s.upload_frame(df, casout={'name':'cars', 'caslib':'casuser'}); */ table.addTable / caslib='casuser' table='CARS' vars={{name='model', type='varchar', length=10},{name='msrp', ty...
proc cas; /* Python equivalent: s.upload_frame(df, casout={'name':'sales_data', 'caslib':'casuser', 'replace':True, 'promote':True}, var_attr={'product_id':{'label':'Product Identifier'}, 'sale_date':{'format':'DATE9.'}}) */ table.addTable / caslib='casuser' table='SALES_DATA' ...
proc cas; builtins.addUserActionSetPath / caslib="mycaslib"; run;
proc cas; /* Step 1: Define a simple action set and save it */ source myActions; action myEcho(string text); print "Echo: " || text; endaction; endsource; builtins.actionSetFromTable / table={name="myActions"} actionSet="myCustomActions"; /* Step 2: Add the ca...
proc cas; action activeLearn.alJoin / table={name='raw_data'} annotatedTable={name='annotations'} id='i' joinType='INNER' casOut={name='joined_data_inner', caslib='casuser', replace=true}; run; quit;
proc cas; table.alterTable / caslib='casuser' name='CARS_DATA' rename='AUTOMOBILES'; run;
proc cas; table.alterTable / caslib='casuser' name='AUTOMOBILES' label='Car Information'; run;