Hi, The two barchart statements give the same result. In the first one x= and y= are used. In the second one, category= and response= are used. Similar possibilities occur for other graphs like piechart. Which one should be preferred? I guess there are some historical reason for one or the other but I have no clue which one was introduced first or last.   proc template; define statgraph xxbarchart; begingraph; layout overlay; barchart category=age response=frequency; endlayout; endgraph; end; run; proc template; define statgraph yybarchart; begingraph; layout overlay; barchart x=age y=frequency; endlayout; endgraph; end; run; ods exclude CrossTabFreqs; ods output CrossTabFreqs=class_stat (keep=sex age frequency _type_ where=(_type_='11')); proc freq data=sashelp.class; table sex*age; run; proc sgrender data=class_stat template=xxbarchart; run; proc sgrender data=class_stat template=yybarchart; run; ... View more

I was wondering what is the value of memtype to designate a template store?   Of course, I can be really specific and delete a store if no other sas file has the same name using a delete statement or delete all the sas files but the ones named in a save statement.   But if I know the value of memtype= in proc datasets for a store, I could delete all the stores whatever their name using the kill option.   Thanks     Program 1 : creating in the proejct library a catalog, a dataset, a view and a style in a store libname project "..."; proc format lib=project; value $sex 'M'='Male' F='Female'; run; data project.class; set sashelp.class (keep=name age sex); run; data project.vclass / view=project.vclass; set sashelp.class (keep=name age sex); run; proc template; define style styles.pearl2 / store=project.classpink; parent = styles.pearl; class header / backgroundcolor = pink; end; run; libname project clear; Program 2 libname project "..."; *deleting the style in the store; proc template ; delete styles.pearl2 / store=project.classpink; run; quit; *test 1; proc datasets lib=project memtype=all kill; run; quit; *test 2; proc datasets lib=project nolist; delete classpink / memtype=all; run; quit; *test 3; proc datasets lib=project nolist; save class / memtype=data; save vclass / memtype=view; save formats / memtype=cat; run; quit; libname project clear; ... View more

Hi,   Can you think of any case where the i modifier would give a different result from the u modifier? - i ignores case - u adds uppercase letters to the list of characters   Just an example with countc, but it could be with any function allowing these modifiers. data test; length x $12; x='bca1-abcABC2'; countc_x_abc_i=countc(x,'abc','i'); countc_x_abc_u=countc(x,'abc','u'); run; proc print data=test; run; ... View more

Hi,    When importing an Excel file, the excel engine multiplies by 3 the size of character variables. If we attempt to reduce the length using dbsastype= option, values get truncated.   Do you know how to avoid id or at least how to reduce the length afterwards without altering the data ?   proc export data=sashelp.class outfile="&test./reporting/test.xlsx" dbms=xlsx replace; sheet=class; run; libname demo xlsx "&test./reporting/test.xlsx"; *libname demo excel "&test./reporting/test.xlsx"; ods select position; proc contents data=demo.class varnum; run; proc print data=demo.class; run; libname demo clear; It is ok with xlsx engine (see below). I'm just trying to understand excel engine here. ... View more

Hi, I've been asked to explain this without any further detail/data/output: " Arrays werden in einem datastep als Variable in ein workfile geschrieben; wie lese ich diese Variablen in einem neuen datastep wieder ein". which could translate into something like this I suppose: " Arrays are written as variables in a workfile in a datastep; how do I read these variables back in a new datastep?". But I'm not even 100% if I translate it properly, as I never your workfile when talking about a SAS dataset and I've never defined an array in a data step to use it in another one. Does anyone understand the question better than me and could explain it with simple words or an example? ... View more