topic I need help using proc http in SAS Procedures

I need help using proc http

Jay1 — Tue, 08 Nov 2011 16:32:29 GMT

I feel I'm close - can anyone help. The link is: http://www.dgsweb.state.pa.us/Debarment_list/default.aspx

My SAS Code is here:

filename file1 'C:\out.txt';

filename file2 'C:\in.txt';

DATA _NULL_;

input;

file file2;

put _infile_;

datalines4;

__EVENTTARGET=&__EVENTARGUMENT=&__LASTFOCUS=&__VIEWSTATE=%2FwEPDwUKMTQ4NjEyMDk4NQ9kFgICAw9kFgYCAQ9kFgoCAQ8QZBAVAwpDaG9vc2UgT25lBkFjdGl2ZQZMb2cgSW4VAwpDaG9vc2UgT25lBkFjdGl2ZQZMb2cgSW4UKwMDZ2dnFgECAWQCAw8QZGQWAWZkAgsPEA8WAh4HVmlzaWJsZWhkZBYAZAINDw8WBB4EVGV4dAUiQ2hvb3NlIG9uZSB0byBzcGVjaWZ5IHNlYXJjaCBhcmVhLh8AaGRkAhUPEGRkFgECAWQCAw9kFgYCCQ8QZA8WRGYCAQICAgMCBAIFAgYCBwIIAgkCCgILAgwCDQIOAg8CEAIRAhICEwIUAhUCFgIXAhgCGQIaAhsCHAIdAh4CHwIgAiECIgIjAiQCJQImAicCKAIpAioCKwIsAi0CLgIvAjACMQIyAjMCNAI1AjYCNwI4AjkCOgI7AjwCPQI%2BAj8CQAJBAkICQxZEEGVlZxAFBUFnaW5nBQIxMGcQBQtBZ3JpY3VsdHVyZQUBNGcQBQdCYW5raW5nBQE1ZxAFG0NlbnRlciBmb3IgSnV2ZW5pbGUgSnVzdGljZQUEODEwN2cQBRhDaXZpbCBTZXJ2aWNlIENvbW1pc3Npb24FAjMyZxAFC0NvcnJlY3Rpb25zBQIxMWcQBQREQ0VEBQIyNGcQBQREQ05SBQIzOGcQBSZEZXBhcnRtZW50IG9mIEVudmlyb25tZW50YWwgUHJvdGVjdGlvbgUCMzVnEAUeRGVwYXJ0bWVudCBvZiBMYWJvciAmIEluZHVzdHJ5BQIxMmcQBQlFZHVjYXRpb24FAjE2ZxAFG0Vudmlyb25tZW50YWwgSGVhcmluZyBCb2FyZAUCMzdnEAUYRmlzaCBhbmQgQm9hdCBDb21taXNzaW9uBQIyMmcQBQ9HYW1lIENvbW1pc3Npb24FAjIzZxAFEEdlbmVyYWwgU2VydmljZXMFAjE1ZxAFBkhlYWx0aAUBN2cQBQlJbnN1cmFuY2UFATlnEAUUTGlxdW9yIENvbnRyb2wgQm9hcmQFAjI2ZxAFHU1pbGl0YXJ5IGFuZCBWZXRlcmFucyBBZmZhaXJzBQIxM2cQBRRNaWxrIE1hcmtldGluZyBCb2FyZAUCMjdnEAUYT2ZmaWNlIG9mIEFkbWluaXN0cmF0aW9uBQQ4MTAxZxAFGU9mZmljZSBvZiBHZW5lcmFsIENvdW5zZWwFBDgxMDJnEAUbT2ZmaWNlIG9mIEluc3BlY3RvciBHZW5lcmFsBQQ4MTAzZxAFFE9mZmljZSBvZiB0aGUgQnVkZ2V0BQQ4MTA0ZxAFFk9mZmljZSBvZiB0aGUgR292ZXJub3IFATFnEAUdUEEgSHVtYW4gUmVsYXRpb25zIENvbW1pc3Npb24FBDgxMDVnEAUUUEEgUHVibGljIFRWIE5ldHdvcmsFAjM0ZxAFBFBDQ0QFBDgxMDZnEAUEUEVNQQUCMzFnEAUtUGVubnN5bHZhbmlhIEhpc3RvcmljYWwgYW5kIE11c2V1bSBDb21taXNzaW9uBQIzMGcQBShQZW5uc3lsdmFuaWEgTXVuaWNpcGFsIFJldGlyZW1lbnQgU3lzdGVtBQI3MWcQBRlQZW5uc3lsdmFuaWEgU3RhdGUgUG9saWNlBQIyMGcQBQhQRU5OVkVTVAUCMzNnEAUUUHJvYmF0aW9uIGFuZCBQYXJvbGUFAjI1ZxAFKVB1YmxpYyBTY2hvb2wgRW1wbG95ZWVzIFJldGlyZW1lbnQgU3lzdGVtBQI3MmcQBQ5QdWJsaWMgV2VsZmFyZQUCMjFnEAUDUFVDBQIxN2cQBQdSZXZlbnVlBQIxOGcQBRVTZWN1cml0aWVzIENvbW1pc3Npb24FATZnEAUFU3RhdGUFAjE5ZxAFIVN0YXRlIEVtcGxveWVlcyBSZXRpcmVtZW50IFN5c3RlbQUCNzBnEAUXU3RhdGUgRXRoaWNzIENvbW1pc3Npb24FAjQwZxAFHFN0YXRlIFRheCBFcXVhbGl6YXRpb24gQm9hcmQFAjM2ZxAFDlRyYW5zcG9ydGF0aW9uBQE4ZxAFBlNlbmF0ZQUCNDFnEAUYSG91c2Ugb2YgUmVwcmVzZW50YXRpdmVzBQI0MmcQBQ9BdWRpdG9yIEdlbmVyYWwFATJnEAUIVHJlYXN1cnkFATNnEAUQQXR0b3JuZXkgR2VuZXJhbAUCMTRnEAUVTHQuIEdvdmVybm9yJ3MgT2ZmaWNlBQIyOGcQBQVQSEVBQQUCMzlnEAUmTGVnaXNsYXRpdmUgQWdlbmN5IG9mIEdlbmVyYWwgQXNzZW1ibHkFAjQ1ZxAFGkxlZ2lzbGF0aXZlIFNlcnZpY2UgQWdlbmN5BQI0NmcQBSZMZWdpc2xhdGl2ZSBCdWRnZXQgJiBGaW5hbmNlIENvbW1pdHRlZQUCNDdnEAUWSnVkaWNpYWwgQ29uZHVjdCBCb2FyZAUCNTFnEAUSQ29tbW9ud2VhbHRoIENvdXJ0BQI1OGcQBQ1TdXByZW1lIENvdXJ0BQI2MGcQBSdJbmRlcGVuZGVudCBSZWd1bGF0b3J5IFJldmlldyBDb21taXR0ZWUFAjYzZxAFF1BBIEdhbWluZyBDb250cm9sIEJvYXJkBQI2NWcQBSNQaGlsZGVscGhpYSBSZWdpb25hbCBQb3J0IEF1dGhvcml0eQUCODhnEAUgU3RhdGUgU3lzdGVtIG9mIEhpZ2hlciBFZHVjYXRpb24FAjkwZxAFE1R1cm5waWtlIENvbW1pc3Npb24FAjkxZxAFIFB1YmxpYyBTY2hvb2wgQnVpbGRpbmcgQXV0aG9yaXR5BQI5OGcQBS9Hb3Zlcm5vcidzIE9mZmljZSBmb3IgTWFuYWdlbWVudCAmIFByb2R1Y3Rpdml0eQUEODEwOGcQBRNDb3VuY2lsIG9uIHRoZSBBcnRzBQQ4MTA5ZxAFHkNhcGl0b2wgUHJlc2VydmF0aW9uIENvbW1pdHRlZQUCOTlnEAUJUEEgQ291cnRzBQI1M2cWAWZkAhUPEGRkFgFmZAIdDxBkZBYBZmQCBQ9kFgQCAQ8QZGQWAWZkAgUPPCsADQBkGAIFEWdyZERlYmFybWVudExpc3QyD2dkBRBncmREZWJhcm1lbnRMaXN0DzwrAAoBCAIBZDtIKQzuOUvkzIcQ22nPMsJDDYX4&__EVENTVALIDATION=%2FwEWEQLH2ujdCgLRoIiFCALf68jbBQL4oL9tApnvpbIHAvmXzo0MAun45GMC9vjkYwKT9%2FrLBwL%2B6YyoCgLCi9reAwKtkuWiCgKXjq%2BFCAKIjq%2BFCAKY4YXrBALC34jvAwL6o4PRA5xSrzJgIdRAZfigZJrvkhhVoNXL&ddlSelect=Active&ddlSearchBy=0&txtContractor=&btnSubmit=Search&rblPaging=0&hidEdit=False&hidLogin=

;;;;

RUN;

PROC HTTP out=file1

in=file2

url='http://www.dgsweb.state.pa.us/Debarment_list/default.aspx'

method='POST'

ct='application/x-www-form-urlencoded';

RUN;ok

Re: I need help using proc http

FriedEgg — Tue, 08 Nov 2011 18:40:21 GMT

I have this running okay with wget. Not able to test with proc http at the moment.

wget submission line:

wget --post-file=post_data http://www.dgsweb.state.pa.us/Debarment_list/default.asp

contents of post_data

This is the post data you are using below:

Your post data works with wget as well. The differences between our versions is that I am retrieving the 'printable' version of the data from the site instead of the regular view, it should be easier to work with later...

Make sure that the post file you are creating contains all of the data you are telling it to. There may be restrictions on line length with datalines statement that you are exceeding with this rather long post, or it may get truncated on the write to the file without an appropriate lrecl option on your file statement.