I have this small code .Could anyone please help me how to limit TOP 10 highest transaction.
proc sql; select make,origin,invoice from sashelp.cars group by make,origin order by make, invoice desc; run; quit;
... View more
Hi @ballardw. Thanks for the information Lets say if variables have different lengths in the all of the given data sets.How will i append that data. Just to understand how the process works?
... View more
I am not gonna use this anywhere for now maybe at some point. As I said earlier am just learning . I came across this question and just wanna see how to resolve it This is purely for my learning @PaigeMiller - Thank you very much for your support
... View more
Hey @PaigeMiller
What I am trying to do here is below is my input data
DATA HAVE;
INPUT ID NAME$;
DATALINES;
1 Animesh
1 Mardi
1 abc
;RUN;
And the ouput data I required is :
1 Animesh Mardi ABC
... View more
Hey @Paige Miller Appreciate your advice , but I am just learning I was wondering if we could do the extract using _numeric_ but ideally we can't as explained below. But yeah Thank you very much for helping out really appreciate
... View more
Thanks @PaigeMiller .For the _NUMERIC_ function I was hoping we could use only this function (_NUMERIC_ ) to extract numeric variable from string.
... View more
