topic Re: Conditional Transpose in SAS Programming

Conditional Transpose

roshnigupta1602 — Mon, 01 Aug 2022 12:42:11 GMT

i want to transpose the dataset with the condition.

if there is no observation available in dataset only variable is present then no transpose .

and if observation is present then transpose the dataset.

Please help me in this.

Thanks in advance.

Re: Conditional Transpose

Kurt_Bremser — Mon, 01 Aug 2022 12:59:02 GMT

Query DICTIONARY.TABLES, then execute code conditionally:

%let count = 0;

proc sql noprint;
select nobs into :count
from dictionary.tables
where libname = "YOURLIB" and memname = "YOURDATASET";
quit;

% if &count. gt 0
%then %do;
  /* transpose code */
%end;

Re: Conditional Transpose

PaigeMiller — Mon, 01 Aug 2022 13:00:23 GMT

I think you would have to do this conditional transpose with a macro, or with a macro %IF statement. In this example, I am looking for the number of observations in SASHELP.CLASS. Naturally you would replace SASHELP and CLASS with the actual libname and data set name. (Note: if the data set is in the WORK library, you have to use libname="WORK" in your SQL WHERE clause).

%macro cond_transp;
    proc sql;
         select nobs into :nobs from dictionary.tables where libname="SASHELP" and memname="CLASS";
    quit;
    %if &nobs>0 %then %do;
        proc transpose data= ...;
            /* Other proc transpose statements go here */
         run;
    %end;
%mend;
%cond_transp

Re: Conditional Transpose

Kurt_Bremser — Mon, 01 Aug 2022 13:03:44 GMT

Note that, with a reasonably recent maintenance level of SAS 9.4, you can use %IF %THEN %DO - %END in open code, so you do not need a macro definition.