data have; input a $30.; cards; abc %ak% %ak% hjk %kl% %kl% hygllllkjk %ko% %ko% hygllllkjk %ko% ; run; data want; set have; want=prxchange('s/(\s+\S+)(\1)+$/\1/',-1,strip(a)); run; ... View more

If you need a specific format in your output, you use the proper format. You can't force a numeric variable in SAS to have the appearance you want any other way.     data a;     a=12.10;     format a 5.2; run; ... View more

It takes less time to run (besides, for complex transpositions, much, much less time to code), so I can't see how it could be more compiler intensive. It take less cpu and processing time than running proc transpose.   It's not intended as a proc transpose replacement, as there are still things one can do with proc transpose that the macro wasn't intended to accomplish.   As for making it an autocall macro .. that is totally up to the user since any macro can be compiled and stored that way. Take a look at: http://analytics.ncsu.edu/sesug/2008/SBC-126.pdf    Art, CEO, AnalystFinder.com   ... View more

Not quite right. With EXPLICIT array reference you include the array index value when you reference the array.  So you would use references like  do i=1 to dim(x); x(i) = x(i) *100; end; With IMPLICIT array reference the index value is always in the same variable (default variable is _I_) and if you want to change which element in the array your reference means you change the value of that specific variable.  So you do not add anything in the statement that references the variable. do _i_=1 to 5 ; x = x * 100; end; or  do over x ; x = x *100; end; Not sure why SAS has dropped the DO OVER from the manuals. Personally I feel it is much clearer when you want to apply the same operation to every element in the array.  Especially when the index has no meaning of its own, for instance if the elements in the list are not ordered in any meaningful way.    Perhaps they feel it is too hard for the compiler to tell which references are array references if you use implicit array references?  Or feel it is too confusing for programmers.   The main thing to know is that for each array you have to stick with just one method of referencing it.  You can't use implicit in one statement and explicit in another statement. ... View more

Thanks Everyone for your support... ... View more

Thank you.. ... View more

@rajeshalwayswel For the sample data you've posted there isn't any need for a custom picture format to get your desired result. Is your sample data representative? Or why else do you see a need for a custom picture format? data have; input a; format a best32.; cards; 1 33 556 1 ; run; ... View more

@rajeshalwayswel To subset data many procedure allow for a WHERE statement (which is more like SQL syntax).   When working with SAS tables you can also use a WHERE statement as data set option to subset records: Proc <some proc> data=source(where=(<condition>)); ... ... View more

It's tricky too...but new to learn from it...Thank you... ... View more

Thanks Reeza.... ... View more

Good question. I just want say.   NOTE: There were 19 observations read from the data set SASHELP.CLASS. data a; set sashelp.class sashelp.class;output; set sashelp.class;output; run;   NOTE: There were 1 observations read from the data set SASHELP.CLASS. data a; set sashelp.class sashelp.class;output; set sashelp.class;output; run;   NOTE: There were 19 observations read from the data set SASHELP.CLASS. data a; set sashelp.class sashelp.class;output; set sashelp.class;output; run; ... View more

When I started with SAS 5.1 Proc means only sent output to what is now the Listing destination. If you wanted similar output into a data set Proc Summary was required.   Default output datasets often have different structures for what appears to be identical code. Please see: Proc means data=sashelp.class; class sex; output out=work.meansoutput ; run; Proc summary data=sashelp.class; class sex; output out=work.summaryoutput ; run; I actually continue to use Proc Means and Summary separately so when I look at my code I can quickly tell which was to create data sets and which was to display summaries.   ... View more