ods markup file='test.xml' tagset=event_map ; proc print data=sashelp.class ; run ; ods _all_ close ;
proc sql noprint; select distinct name into :STUDENT_LIST separated by ' ' from sashelp.class; %let NUM_STUDENTS = &sqlobs; quit;
data _null_; set sashelp.class end=eof; length student_list $200; retain student_list; student_list = ; /* Concatenate the current value of NAME to STUDENT_LIST. */ if eof then do; /* Add a CALL SYMPUTX statement to create the STUDENT_LIST macro variable. */ /* Add ano...
libname mycdh hadoop server='quickstart.cloudera' user=cloudera password=cloudera schema='default'; data mycdh.class; set sashelp.class; run;
proc export data=sashelp.class outfile="c:\sas\class.xls" dbms=excel; quit;
data x ; set sashelp.class ; run ;
data y ; set sashelp.class ; run ;
%initTestcase(i_object=_existVar.sas, i_desc=Test for numeric variable age) %let rc=%_existVar (sashelp.class ,age ,N ); %endTestcall; %assertEquals(i_expected=1, i_actual=&rc., i_desc=Numeric variable age exists) %endTestcase;
%initTestcase(i_object=_existVar.sas, i_desc=Test for character variable age) %let rc=%_existVar (sashelp.class ,age ,C ); %endTestcall; %assertEquals(i_expected=0, i_actual=&rc., i_desc=Character variable age does not exist) %endTestcase;
%initTestcase(i_object=_existVar.sas, i_desc=Test for variable name) %let rc=%_existVar (sashelp.class ,name ); %endTestcall; %assertEquals(i_expected=1, i_actual=&rc., i_desc=Variable name does not exist) %endTestcase;