Thank you for the help . I can check and see 🙂 ... View more

go to File > New > Ordered List This will take you to a screen that allows you to "Add" programs. Click on Add, then use ctrl and mouse to click all the table(s) you would like in the ordered list. Once you have the list, you can re-order the list. When you run an Ordered List, it will run from top to bottom in that order regardless of how you have them tied together in your Process Flow. You can have more than one Order List in a Project.  Hope that helps.  ... View more

Just give a long enough length, such as:   length state1 $ 20000;   Also use the global option COMPRESS=YES so that if you assign extra space, that extra space won't be needed for storing the value.   If you transfer the value to a macro variable, use CALL SYMPUTX, not CALL SYMPUT.  That way, the extra blanks won't be transferred. ... View more

This condition: %if %sysfunc(qsubstr(&p_taxd_no,7,2)) = 01 or 02 or 03 %then %do; is semantically and syntactically equivalent to this condition: %if (%sysfunc(qsubstr(&p_taxd_no,7,2)) = 01) or (02) or (03) %then %do; A numeric, non-zero/non-missing value is always considered as a boolean true. What you want is %if %sysfunc(qsubstr(&p_taxd_no,7,2)) = 01 or %sysfunc(qsubstr(&p_taxd_no,7,2)) = 02 or %sysfunc(qsubstr(&p_taxd_no,7,2)) = 03 %then %do; Alternatively, activate the minoperator system option and use IN as @bstarr suggested. ... View more

To what end, what is it you want out at the end.  The reason being is that Base SAS is a really powerful language for data manipulation and can do this type of work far better than macro which only generates Base SAS code.  You you take this prompt and want to run a macro on all datasets within the given libraries.  You could go your way, or you could just say: data _null_; do i=1 to countw("&x.",","); call execute(cats('%domacro (l=f_',put(input(scan("&x.",i,","),best.),z3.),');')); end; run; This will loop over each comma delimited value in &x, and for each one call the macro domacro, with the parameter f_ and the value from the list.  Far simpler.  Macro is not a replacement for Base SAS! ... View more

Here's an alternative:  run two proc transposes, one for numerics (naming vars NUM1-NUMn)  and one for character (naming vars CHAR1-CHARn), where n is the number of observations in the source data set.  Each of the result files will get the same number of variables (n,  excluding the new variable _NAME_).   Then just SET them both, and convert NUM1-NUMn to character form in CHAR1-CHARn.  Drop the NUM: vars.  No need to determine how many variables of character vs numeric there are: proc transpose data=sashelp.class out=tn prefix=num; run; proc transpose data=sashelp.class out=tc prefix=char; var _character_; run; data want; set tn (in=in_n) tc; array n {*} num: ; array c {*} char: ; if in_n then do I=1 to dim(n); c{I}=put(n{I},8.); end; drop num: I ; run;     ... View more

Two details to add to @Haikuo's suggestion   1) if your dataset names have a common prefix, you can use a dataset list in the set statement: SET TABLE: ; 2) If you want to remember which dataset the rows came from, you can add a third field to the data:   DATA OUT.want; length from $32; SET table: INDSNAME=DS; from = scan(DS, 2, "."); RUN; ... View more

Ok, not a lot of specific information here, so my suggestions are rather generic.   Firstly, verify you can open Enterprise Guide, load the SAS project and run it manually. (No point scheduling a project which doesn't work.) Once tested and saved, in EG, click File -> Schedule Project. This should fire up the Windows Scheduler, allowing you to create a schedule for running the EG project. Note: I am (naturally) unaware of any restrictions have been placed on your environment by your Citrix administrator..   Good luck..   ... View more