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.                 ... View more

My first quesion: After I imported the datafile, I wrote PROC IMPORT DATAFILE= 'D:\sasprogramming\EX1.xls' OUT= EX1 DBMS=xls REPLACE ; GETNAMES= yes; RUN; options FIRSTOBS =2; then the output data will read the data from the third row, but even if I delete this statement (OPTION FIRSTOBS=2), and re-run the import statement, the SAS will still read the datafile from the third row, then how could I eliminate the effet of the option statement?   The second question:  My data looks like: the variables are in the second row, If I use the following codes: PROC IMPORT DATAFILE= 'D:\sasprogramming\EX1.xls' OUT= EX1 DBMS=xls REPLACE ; GETNAMES= yes; RUN; the headline of the output will be A B C D..., Apprently SAS threat the A B C D as the variables. then if I add options FIRSTOBS =2;  SAS will read the data from the third line, then the variables id, dates....will disappear, so if I want to read the second row as my varibles, what I can do? ... View more

I have seen some questions related to this in this forum, but still not very clear yet, so I would like to post my quesion here.   I want to read in a 'sas7bdat' , here is my codes:   LIBNAME Website 'D:\Desktop'; DATA Website; INFILE 'Websites.sas7bdat'; RUN; It seems that the LIBNAME statement is usually used as a method to read a data with this format, I point out the path for SAS, then read inthis data by a DATA step,    The error appears: ERROR: Physical file does not exist, C:\Windows\system32\Websites.sas7bdat. I didn't point out the file to the C drive, so this error is weird. Could anybody tell me more about this? ... View more

I want to extract the first name from a name with a space and also reverse it, and here is my codes:   PROC IMPORT DATAFILE='D:\Wow.xlsx' OUT= Wow DBMS= XLSX REPLACE; RUN; DATA Names; SET Wow; First_Name = SCAN(REVERSE(Reversed_names),1); RUN; The result is:   The content is empty, which is not what I want. Could anyone tell me what is the problem with my codes? (see attachment with the dataset)                   ... View more