About tomcmacdonald

tomcmacdonald · ‎11-28-2017

OK, looks like I figured it out. Checking over this help file: https://support.sas.com/resources/papers/proceedings13/122-2013.pdf I used "?" between the variable name and informat.

tomcmacdonald · ‎11-28-2017

I'm trying to parse an ebcdic encoded sequential file downloaded via FTP from a z/OS mainframe and it's cutting off rows. The code looks something like this: filename f ftp <DSN> host=<HOST> user=<USER> password=<PASSWORD> port=<PORT> passive lrecl=<LRECL> recfm=F; data foo; infile f; input @<start1> <col1> <encoding1> @<start2> <col2> <encoding2> ... @<startn> <coln> <encodingn>; run The log file is registering that SAS recognizes the appropriate number of records it just stops on a bad row. There is packed decimal encoding so encoding directly to ASCII isn't trivial. How should I go about dealing with this in a SAS environment?

tomcmacdonald · ‎11-22-2017

Is it possible to do this without using PROC CIMPORT and PROC CPORT? I'm getting this error: ERROR: Unrecognized or unsupported transport file format. And I'm at a loss as to why.

tomcmacdonald · ‎11-21-2017

Is it possible to do a SELECT DISTINCT ON in PROC SQL?

tomcmacdonald · ‎11-20-2017

Is it possible to inform SAS to skip faulty lines in an infile statement? I'm trying to parse a dirty sequential mainframe file and it's stopping on the bad record.

tomcmacdonald · ‎11-15-2017

>What type of errors are you concerned with? Any error. >In data step code or procedures? Either >And what would you like to happen when the program stops? Stop executing any process and rollback to the previous state. >Also is this interactive or in batch mode? Either >And is the code in an %include file? Not the code I'm working on now. Basically in my code one procedure depends on output from another procedure and it seems like wasting time to continue processing if any point in that chain fails.

tomcmacdonald · ‎11-14-2017

I'm sorting a large dataset on PC SAS and am running into some space issues. I would like to set the temporary directory to a network drive instead of my local C drive. How would I do this?

tomcmacdonald · ‎11-14-2017

How do I tell SAS to exit the program on the first error it encounters?

tomcmacdonald · ‎11-14-2017

Just trying to take the first of a group. In SQL I use window functions. Any equivalent in PROC SQL?

tomcmacdonald · ‎10-18-2017

ERROR: An exception has been encountered. Please contact technical support and provide them with the following traceback information: The SAS task name is [DATASTEP] Segmentation Violation Traceback of the Exception: ERROR: An exception has been encountered. Please contact technical support and provide them with the following traceback information: The SAS task name is [DATASTEP] Segmentation Violation I'm getting this message while trying to parse a ~2GB CSV file using UNIX SAS 9.4.

tomcmacdonald · ‎09-25-2017

That works too. I guess the semicolon is a modifier to the length portion of the statement. I sure do wish the documentation specified this. http://support.sas.com/documentation/cdl/en/hostwin/69955/HTML/default/viewer.htm#chifoptfmain.htm

tomcmacdonald · ‎09-25-2017

Adding a length statement seems to do the trick DATA TEST; INFILE 'C:\test.csv' DLM=',' MISSOVER DSD FIRSTOBS=2; LENGTH VISIT_DATE $10; INPUT ACCTN $ PURPOSE $ VISIT_DATE $ ENTITY $ ID $; RUN;

tomcmacdonald · ‎09-25-2017

Hello, I'm trying to import a CSV file. This is the first 5 rows with the header: ACCTN,PURPOSE,VISIT_DATE,ENTITY,ID 12282,3,7/17/2012,5,API 20083,8,6/12/2012,5,LEO 20082,9,6/12/2012,5,LEO 20129,8,6/14/2012,5,LEO 20063,8,6/14/2012,5,LEO This is my data step to bring it in: DATA TEST; INFILE "C:\test.csv" DLM=',' MISSOVER DSD FIRSTOBS=2; INPUT ACCTN $ PURPOSE $ VISIT_DATE $ ENTITY $ ID $; RUN; This is the output: VISIT_DATE is cut off. I guess I don't understand how SAS is working here. I thought by specifying the delimiter character it would give the VISIT_DATE field a variable length but it always cuts it off at 8 length. When I try changing the length to 10 it moves past the delimiter into the other field. So I guess SAS can only read fixed width files? What am I missing here?

tomcmacdonald · ‎06-19-2017

Nevermind, found it: http://support.sas.com/documentation/cdl/en/hostunx/69602/HTML/default/viewer.htm#n1i4pqnd1humrrn1ijrc1r5l5aod.htm

tomcmacdonald · ‎06-19-2017

I can't find the documentation anywhere.

Online Status	Offline
Date Last Visited	‎03-21-2019 06:42 PM

Pipe filename executed locally and not on server

Re: How to redirect put statements to the result instead of the log?

How to redirect put statements to the result instead of the log?

Re: Join eating up all available resources

Re: Join eating up all available resources

Re: Assessing column in table during DATA step merge

Re: Assessing column in table during DATA step merge

Re: Join eating up all available resources

Assessing column in table during DATA step merge

Join eating up all available resources

Re: Start to finish how do I import a CSV file with the DATA step?

Re: Start to finish how do I import a CSV file with the DATA step?

Re: End of line anchor in regular expression does not seem to work

Re: SAS 9.4 exporting corrupted XLSX files

Re: SAS 9.4 exporting corrupted XLSX files

Converting a datetime into a date

Re: SAS 9.4 exporting corrupted XLSX files

Getting around insufficient space issues

Re: Problems parsing ebcdic encoded sequential file

Problems parsing ebcdic encoded sequential file

Transferring SAS files from z/OS mainframe to UNIX

SELECT DISTINCT ON

Skipping bad lines in infile

Re: Stop on error?

Setting temporary directory path

Stop on error?

Window functions in PROC SQL?

Segmentation Violation?

Re: Getting hung up on a trivial CSV import

Re: Getting hung up on a trivial CSV import

Getting hung up on a trivial CSV import

Re: UNIX SAS batch commandline options

UNIX SAS batch commandline options