The following is my codes, and I want to order id cash ticket (low- high) and quantity (high-low), but I found that I can't order all of
this variables at the same time as I want. For example, if I want to order id from low to high, then I can't order the cash from low to high anymore since the orders of this two variables are conflict, and that is logical.
DATA HAVE; INPUT id 4. ticket 3. quantity 3. cash 3.; DATALINES ; 3000 15 1 92 3002 1 0 86 3002 24 0 86 3009 3 5 91 ; RUN; PROC SORT DATA=HAVE OUT=WANT; BY id cash ticket DESCENDING quantity; RUN;
output:
I want to confirm that Is it true that it is impossible to order several variables at the same time if their orders are conflict?
I am not sure, maybe there is other way that I can't think up.
Off topic (combination SAS/R solution -casino slot machine like problem)
see
You may be able to spin both columns independently with a SAS or WPS hash?
Also probably easy with SAS/IML.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.