Search results for query: *

the problem is that we run SAS on a unix box, so the put statement is not win formatted. i know this probably looks strange to you SAS pros (im only a few years into sas coding - and not an every day thing) but this JUST about worked... it still has an odd CR here and there but at least...

Is there a way to make the FILE...PUT method work for dos/windows? i open the file in notepad and its no good. tried using FILE NOPRINT but it didnt seem to make any difference? Help!

I actually figured it out! Havent tried the libname export..(and yes, they are formatted text in the dataset) Creating an html output, and using the htmlstyle on the text columns ensures they come out as text!!!!! Took HOURS of testing and tweaking and testing last night lol. in case anyone is...

I am stuck.. I am trying to export to an excel file (which works fine) but i cannot get the text column to remain as text. instead of 7568626110106 i get 7.56863E+12 I found one solution but it forces EVERYTHING to text.. no good since then the number columns dont add. ODS CHTML...

FANTASTIC... that shaves off a good 30 seconds! Thank you!

here is the real original code.. with the path name x'd out data tbs (KEEP=CUSACCID DOCNUMB SERVITEM LINESTAT ACCTNO SREQSTAT ACCTPRCD LMODDATE ACTIND ANI IDENTCD CKTDESID COMPNAME); set '/home/xxxx/xxxx/tbsanis'; IF ACCTPRCD = 'NVA' AND SYST = 'EAST' AND...

yes, sorted & nodups SELECT DISTINCT X,Y,Z FROM '/home/xxxx/xxxx/tbs' WHERE X=1 AND Y=2 ORDER BY X,Y,Z that way I can squish 2 steps into 1.

Im still new to SAS. I am trying to condense a long script by using some PROC SQL statements. currently there is a data step (changed info ;)) data tbs_tmp (KEEP=FIELD1 FIELD1 FIELD1 FIELD1 FIELD1); set '/home/xxxx/xxxxxx/tbs'; run; then I am running a SQL statement pulling from...