About dan_waldo

dan_waldo · ‎10-08-2015

Yep, that solved the problem ... thanks, PGStats!

jakarman · ‎09-05-2014

No need for headaches for using lag it is more the common queue function http://en.wikipedia.org/wiki/Queue_(abstract_data_type) With the implementation of that you see some problems as of the pull/push and sizing. SAS development could have done this in a better way.

data_null__ · ‎12-30-2012

Sounds like you want the PROC FORMAT option NOTSORTED combined with with ORDER=DATA. Consider the following code. Proc Format; Value $nia(notsorted) "NIA Lvl 1"= "NIA 1" "NIA Lvl 2"="NIA 2" "NIA Lvl 3"="NIA 3" "NIA X" = "NIA XYZ" "NIA O"= "NIA Old" "NIA No"="NIA None" "NIA Miss"="NIA Missing" ; Run; data test; length nia $16; nia = "NIA Lvl 1"; output; run; proc summary data=test nway completetypes; class nia / preloadfmt order=data; format nia $nia.; output out=example / levels; run; proc print; run;

dan_waldo · ‎08-07-2012

Thanks, folks, for taking the time to reply. As SASKiwi notes, TERMSTR= is needed, and as KSharp notes, ENCODING= is needed too. I ended up using INFILE "xxx" ENCODING=EBCDIC037 RECFM=S370V TERMSTR=NL; which worked like a champ in the Windows environment.

dan_waldo · ‎01-11-2010

Did the trick. Thank you!!

Online Status	Offline
Date Last Visited	‎10-08-2015 01:06 PM

Re: outputting trimmed means from PROC UNIVARIATE

outputting trimmed means from PROC UNIVARIATE

Re: Must I reset the value of lag() when using BY variables?

Must I reset the value of lag() when using BY variables?

Re: Proc Format variable order

Re: End-of-record character 21x

End-of-record character 21x

Re: specifying end-of-record character in PC-SAS INFILE statement

specifying end-of-record character in PC-SAS INFILE statement

Re: outputting trimmed means from PROC UNIVARIATE

Re: outputting trimmed means from PROC UNIVARIATE

Re: Must I reset the value of lag() when using BY variables?

Re: Proc Format variable order

Re: End-of-record character 21x

Re: specifying end-of-record character in PC-SAS INFILE statement