SAS Data Integration Studio can be extended with your own user written transformations, so you would need to code it once and then just use it again and again. The code for such a transformation could look like this: %macro myCheckData; %global trans_rc; data _A_%sysfunc( compress(&transformID, .)); set &_input(obs=1); run; %put NOTE: &=sysnobs &=syserr; %if &sysnobs = 1 %then %do; %let trans_rc = 0; %put NOTE: OKOKOKOKOK; %end; %else %do; %let trans_rc = 8; %put NOTE: NOTOK NOTOK NOTOK NOTOK; %end; %put NOTE: &sysmacroname &=trans_rc; %mend; %myCheckData You can use then the normal Return Code Check transformation.
... View more
Hi Bruno, Thank you very much for this description. This is great! Hi Tom, Thank you too for further clarifications on positional parameters. Hi Viollete, Than you for your inputs which was further clarified by Tom, Best regards to all, Mirisage
... View more
Hi Cynthia/Bruno, Thanks for your suggestion... it worked... I really appreciate all the assistance provided... you guys rock!!! Best Regards
... View more
Hi Bart Stored Process Input parameters are written to the corresponding macro varibales. You could use code similar to the one below to capture the contents of the macro variables: proc sql; create table myParms as select * from dictionary.macros where name like "/_%" escape "/" order by name ; quit; The code above will only select macro variables starting with "_", but you can change the WHERE clause to get what you need Bruno
... View more
FYI beginning with SAS9.4 MEDIAN is also an aggregate function and can be used with proc sql, see sample below. See also doc here SAS(R) 9.4 SQL Procedure User's Guide proc sql; create table sample as select make , model , invoice from sashelp.cars group by make having median(invoice) = invoice ; quit;
... View more
Hi NTVM Please mark this discussion as answered, maybe also provide the approach you did take. This will help others when searching for this. thanks Bruno
... View more
hi Kamalakar this message indicates, that the font was not found in the SAS registry. To see which fonts are defined in the SAS registry, you can use the following code: proc registry startat="\CORE\PRINTING\FREETYPE\FONTS" list ; run; Then check the log. All the fonts that are on your system are usually registered during the install process of SAS. However you can register fonts later using Proc FONTREG, see sample below proc fontreg mode=add msglevel=normal usesashelp ; truetype "c:\windows\fonts"; run; Please also check the documention for Proc REGISTRY and Proc FONTREG for more information. Bruno
... View more
Not a lot to look up on it (http://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/viewer.htm#a002605538.htm), but the anydtdte informat appears to be able to read dates that give all of the other date informats problems. A useful system option to supplement it is the: options datestyle=mdy in order to guide the informat regarding the order of the three date parts.
... View more
Hi Ashwini In general the intermediate result tables/views are automatically deleted at the end of a job, since they are in the WORK library. If you want to delete them earlier you could add a User Written transformation and add your own code to delete the tables/views. You can simply connect the result tables/views from transformation to your User Written transformation. The code below will delete all the tables which are connected to the User Written transformation. Please be careful about when to run this transformation, as it might delete tables/views which are needed in subsequent transformations %macro myDelete; %local i; proc sql; %do i = 1 %to &_INPUT_count; %if &&_input&i._memtype = DATA %then %do; drop table &&_input&i; %end; %if &&_input&i._memtype = VIEW %then %do; drop view &&_input&i; %end; %end; quit; %mend; %myDelete See also attached picture what it might look like Bruno
... View more
Hi Bruno, Thank for your advice, i think i shall used back my method because this process related to dynamically read external file. Static is much better... Thanks again.. Liang Ck
... View more
