Try using compress(var,'/') Good luck! ... View more

If you want to avoid the notes about invalid character values then read the field in as character. You can then use the anyalpha() function to check for characters and delete them. A input() funtion can then convert the remaining values to numeric. Good luck! ... View more

You could do something like month=floor(PROCESS_DT/10000), day=floor(PROCESS_DT/100)-month*100, etc. and then use date=MDY(month,day,year) to get a SAS date. There is a similar function for time, HMS(Hours, Minutes, Seconds). Good luck! ... View more

Would Process_Dt still have leading zeros for day of the month? For example Jan. 9th 2011 would be 10911 or would it be 1911? ... View more

The probnorm function returns the CDF, try using pdf('normal',z). Good luck! ... View more

It looks like PROCESS_DT and PROCESS_TIME are character variables (given the leading zeros). Do you want the result to be a SAS date/time variable or a character variable? ... View more

While you could use a custom format or a series of if statements try using the weekdate9. format on the original date variable with a put function. Good luck! ... View more

Asking why your macro doesn't work is not the issue. You need to show others that you are, at the very least, listening to them and putting forth some effort. sbb told you what you needed to do to get the code working and your reply was, "thanks for the advise. But can you please give out the fix that makes the code running because I'm tired of the piece of code." Asking what he meant by put the code within a macro would have been ok. Asking someone to do it for you because you are "too tired" is insulting. It implies that you think their time is worth less than your's. ... View more

You were already told how to get it to work. You need to put your %IF ... %THEN %DO ... %END inside of a macro and then call the macro. This is just 3 lines of code to add so why do you need someone else to write it for you? ... View more

Sorry about that, you also need to use do; data QMatrix; set Q_MATRIX_WR; IF _N_=1 or _N_=8 THEN do; skills1=1; skills2=1; skills3=1; end; run; ... View more

It should be : if _N_=1 or _N_=8 then s=1 s2=1 s3=1; run; Good luck! ... View more

Try the following: DATA _NULL_; FILE "TEST.TXT" MOD; SET ISO.POLTRANS; PUT (_ALL_) (+(-1)); RUN; ... View more

I would try either removing the stop statement or use point in the set statement(and get rid of the if statement). According to the documentation on the STOP statement: The STOP statement causes SAS to stop processing the current DATA step immediately and resume processing statements after the end of the current DATA step. It looks like the data step will never get past the first observation. ... View more

Because =ANY(...) is not a valid SQL statement in SAS. ... View more

These are automatic variables. To find them in the doc you need to look under the statement that creates them (not that helpful if you don't know what created it). For _N_ look under SAS System Concepts/SAS Variables. For _INFILE_ look under the infile statement syntax. Try searching 'automatic variables' on lexjansen.com and see if there is a paper summarizing the most popular ones. Good luck! ... View more