Hello everyone! There's a task I'm working on that seemed quite easy but I can't manage to pull it off. I have produced a table (lets call it source) whose records have two variables: TB1 and TB2. These two columns are the full path of a sas dataset, what I want to do is go through the whole source table and compare TB1 and TB2. If the two table have a different number of variables I increment a counter by one. In the end I display the number of different tables. Here's what I tried: OPTIONS NOQUOTELENMAX; %macro compare_variable_counts; /* Initialize counter */ %let counter = 0; /* Iterate over rows in table_comparison */ proc sql noprint; select count(*) into :num_rows from table_comparison; quit; %do i = 1 %to &num_rows; /* Read table names from table_comparison */ proc sql noprint; select STRING, STRING1 into :first_table, :second_table from table_comparison where monotonic() = &i; quit; /* Count variables in the first table */ proc contents data="&first_table" out=first_vars noprint; run; data _null_; set first_vars nobs=num_vars_first; call symputx('num_vars_first', num_vars_first); stop; run; /* Count variables in the second table */ proc contents data="&second_table" out=second_vars noprint; run; data _null_; set second_vars nobs=num_vars_second; call symputx('num_vars_second', num_vars_second); stop; run; /* Compare variable counts */ %if %eval(&num_vars_first ne &num_vars_second) %then %do; /* Increment counter if variable counts are different */ %let counter = %eval(&counter + 1); %end; %end; /* Display the final count */ %put The number of tables with different variable counts: &counter; %mend compare_variable_counts;   The problem is that I can't use the full path (it's just too long), so I'm kinda stuck. Any suggestion? ... View more

Hello everyone!   I am trying to build a data step dynamically, based on the value of the variable _N_. After some analysys and experimenting, it seems to me that I have to convert it to a macro before using it (I beg your trust on this part) but the problem is that the macro variable always resolves to the _N_ associated with the last observation of the ds in the set statement, if some_ds=SASHELP.CLASS then row_numbers resolves to 19.   This is very odd to me, it's my understanding that the call symput is an execution phase statement, and I expect it to run every time the data step goes through the implicit loop. In other words, for the sashelp.class example, I would expect the call symput to run 19 times, the row_number variable being progressively overswritten with values from 1 to 19. Here some code for clarification:     %macro my_macro; data final; set some_ds; call symput("row_number",_N_); output; %do i=1 %to &some_value; %if %sysevalf(&row_number=%substr(%scan(&my_peculiar_string,&i,"|"),2,2)) %then %do;          my_field=some_calculation;            %end;            %else %do;                 my_field=some_other_calculations;             %end; %end; %mend my_macro; The condition inside the %sysevalf is never met because the row_numbers resolves to 19 instead than 1,2,3,4,5,6...19. I found something online stating this:   "The macro variable created by CALL SYMPUT can not be referenced inside the creating data step. But CALL EXECUTE, SYMGET and RESOLVE can be used to reference a macro variable with in the data step. "    This is then followed up with    "CALL EXECUTE statements get resolved first and then moved to the input stack while iterating the data step. If the argument is a SAS statement then it gets moved to the input stack immediately and starts to execute at the data step boundary"   Maybe it's because I'm tired but I can't wrap my head around this, any bit of help would be really appreciated. Link to the article for reference: https://www.lexjansen.com/phuse/2009/po/PO15.pdf         ... View more

Hi everybody,   I have this task that I want to automate: I have a path containing multiple folders and subfolders. Each and every single one either contains a sas dataset or it is empty. I want to delete all the data in each one of these while keeping the structure of the table. For example if I have a table like the SASHELP.CLASS It will be converted to a table with zero rows but with all the metadata intact (SAS EG would display only Name Age Sex Weight and Height).   I could try to pipe some carefully crafted linux command to a file and then use each row for a libname statement, something like   filename libs_file PIPE 'find /my/path -d'  then I could write:   DATA libs;     INPUT path 1000 $;     INFILE libs_file;     IF eof THEN CALL SYMPUT("nlibs", _N_); RUN;   And then use this to somehow use a LIBNAME for each row.    Any input would be greatly appreciated. Thanks 🙂              ... View more