It would help if you more clearly explained your problem. I go by the assumption that you do not have a unique id and want a way to make one.   "If" manufacturer and model together are unqiue, this would be one way:   Data a_sales ; set _class_s.a_sales; keep Unique_id Manufacturer Model ; Unique_id = md5(cats(Manufacturer, Model)); run; proc print data=a_sales; run; Data a_sales ; set _class_1.a_sales; drop Manufacturer Model ; Data a_sales ; set _class_s.a_sales; keep Manufacturer Model ; run; proc print data=a_sales; run; Data a_sales ; set _class_1.a_sales; drop Manufacturer Model ; Unique_id = md5(cats(Manufacturer, Model)); run; proc print data=a_sales; run; run; proc print data=a_sales; run; MD5() or it's more modern sibling SHA256() make a hash of it's character argument in a reproducable way. Another approach would take the row number but that can change and is not my preference. But it's up to you.   Hope this helps, - Jan. ... View more

Hi Ryan,   I ran you code and there seems to be nothing unexpected. So maybe you can help us understand  what exactly you are expecting and what it is you are getting.   Maybe you are exceeding the limit of the destination that proc print uses. If it is text than 200 is it. If you use PDF than Dodson is in the  proc print output.   What may help is that the log shows the HTML contains records longer than the SAS maximum of 32K (you max at 30000 but this can be bumped a little). This is the bit of log that tells me: NOTE: 665 records were read from the infile JUNK. The minimum record length was 0. The maximum record length was 30000. One or more lines were truncated. So you may loose player info due to the truncation. If that's the case consider reading the file differently where you do not go line by line but use a streaming approach and gobbling up the file in chunks ingnoring record terminators. There are plenty examples out there that use RECFM=N or similar. But always beware HTML is not exactly easy to interpret as it combines data and presentation. You will have to separate one from the other which can become tedious.   Hope this helps, - Jan.   ... View more

Do I correctly rephrase your question as:   "I have code in an external .sas file and want that rsubmitted."   ?   If so, there is no straightforward syntax to do that that I know of. (Would be nice if there was, though). Can't you add the rsubmit/endrsubmit pair to the file you %include? Otherwise, how about running a datastep that reads your SAS code into a temp file with rsubmit/endrsubmit added and then %include that temp file?   Untested:   filename runme temp; filename source '...'; data _null_; infile source end=eof; put runme; if _n_=1 then put ' rsubmit'; input; put _infile_; if (eof) then put 'endrsubmit;'; run; %include runme; Hope this helps, - Jan. ... View more

Hi @Hari2,   If you rsubmit an rsubmit statement than that second rsubmit gets executed on the remote server. And thus it will only work if that remote server is itself also connected to a SAS/Connect session via signon. The message you see indicates that is not the case.   I would need more detail on what needs to run where in order to help you figure out the proper way of doing things.   Kind regards, - Jan. ... View more

I found the preparation guides for the Programming I and II certification very densely filled with use cases and detailed info. Highly recommended. And while you're at it, take the exam!   Otherwise the SAS For Dummies and The Little SAS Book are very popular for a good reason.   And of course, on a case-by-case basis, Google is your friend.   - Jan. ... View more