no usedate is for .xlsx ... View more

scandate or usedate? ... View more

I ended up geting sas 9.3 so I was able to use the stackods option, thank you all for the help. ... View more

I have sas 9.2 so maybe that is it? regardless I took out the stackods and it worked. Edit: I have gotten that output before, but how can I get the variables to fall under each other? ... View more

That looks like it may work. I just tried to run what you posted but it said that there was a syntax error with "stackods". Syntax error, expecting one of the following: ;, (, ALPHA, CHARTYPE, CLASSDATA, CLM, COMPLETETYPES, CSS, CV,               DATA, DESCEND, DESCENDING, DESCENDTYPES, EXCLNPWGT, EXCLNPWGTS, EXCLUSIVE, FW, IDMIN, KURTOSIS, LCLM, MAX,               MAXDEC, MEAN, MEDIAN, MIN, MISSING, MODE, N, NDEC, NMISS, NOLABELS, NONOBS, NOPRINT, NOTHREADS, NOTRAP, NWAY,               ORDER, P1, P10, P25, P5, P50, P75, P90, P95, P99, PCTLDEF, PRINT, PRINTALL, PRINTALLTYPES, PRINTIDS,               PRINTIDVARS, PROBT, Q1, Q3, QMARKERS, QMETHOD, QNTLDEF, QRANGE, RANGE, SKEWNESS, STDDEV, STDERR, SUM, SUMSIZE,               SUMWGT, T, THREADS, UCLM, USS, VAR, VARDEF. ERROR 202-322: The option or parameter is not recognized and will be ignored. ... View more

Yea something like that but really what I am looking for is how can I save the output as .csv file and have it look like the output that is in sas.  Currently the way I am doing it is something like this ods html file = '*filepath*.csv'; proc means data = data Q1 Q3 qrange/*mean std min max n qrange*/ maxdec = 3; run; quit; ods html close; However when I try to do that it gets exported as a html/csv file that is unable to be imported back into sas. The only way I can get it to work is by running half the program, opening the file in word saving it as a .csv and then continuing the code. What I need is to somehow be able to export the proc means as a .csv file and then reimport it without having to stop the code. ... View more

Is there anyway that I can get it to look like the output from the proc means statement.  It is all in one column right now. ... View more

Reeza you were right I figured that out awhile ago but I hadn't posted it yet, and I figured out that I had misspelled something which is why it wasn't working. Thank you for all of the help.  My last question is, is there anyway that I could get it to omit missing values? ... View more

The idea that you have as far as output is concerned is fine, I am just trying to figure out how I can get it to work considering that I am using variables with names other than var1 - var4.  I am mainly confused about the section below: select a._name_ as Variable label="Variable", a.var1, a.col1 as value,      case when a.col1 > u.col1 then "High"           when a.col1 < l.col1 then "Low"           else "" end as warning I am confused about what "a." is supposed to be and what "a.col1" is. EDIT: Ok so I think that I have figured out where my problem is, I am only getting 2 columns when I am supposed to be getting three.  I am assuming that is because I have already transposed it so that I could get the llimit and ulimit, therefore already having the variable "_name_".  ... View more

I am trying to get specifically outliers.  But also with proc univariate you can put nextrobs = (some number) after data and it will give you however many you put there to get that many on your lowest and highest.  So if you put "nextrobs = 10" you will get the 10 highest and lowest.. ... View more

I am not very familiar with proc sql, meaning basically that I have never used it.  I am sure that this will be the answer that will get me to where I am trying to go if maybe you could help me out a little bit.  I am not sure if this is what you were going for but I removed part of the proc transpose sequence because it was only giving me one column of data when there are about 100 in the actual data set. As far as using the "a.var1" " a.col1" int the proc sql sequence I am a little lost how I should convert them so that they work for me? ... View more

Yes, they are defined by ulimit and llimit. ... View more