@sujaybshha wrote: Could you provide an example x command to copy a text file using SAS Studio? In most environments i have access to, the xcmd is disabled in SAS Studio session. So you may want to check the status of xmcd: proc options option=xcmd; run; ... View more

I think this is your problem:   http://support.sas.com/techsup/notes/v8/2/429.html   You should try running queries in an Oracle tool to verify if there are any dates outside the SAS date range. ... View more

Here's a DATA step method: data have; input ID_no ID_Val $; cards; 1234 line1 1234 line1 1234 abcd 2345 line1 2345 line1 2345 abcd 3456 line1 3456 line2 ; run; data want; set have; by ID_no; length ID_Flag $4; retain ID_Flag; if first.ID_no then ID_Flag = 'none'; if ID_VAL = 'abcd' then ID_Flag = 'abcd'; if last.ID_no then output; keep ID_no ID_Flag; run; ... View more

And if you don't understand the do loop before the SET statement here's another, old fashioned method. @FreelanceReinh solution is probably more efficient.   data want; set have; by id; length var $100.; retain var; if first.id then call missing(var); var=catx('/', var, text); if last.id then output; run; proc print;run; ... View more

And the version of SAS. BTW, sometimes Eguide can import SAS datasets that PROC IMPORT cannot. ... View more

Astounding wrote: Is there some reason you have to use PROC SUMMARY to accomplish this?  PROC FREQ is built for this task: I would claim that PROC SUMMARY is also built for this task (as well as other tasks) ... View more

If SAS is telling you that there is an overlap, then there really is an overlap.  Plain and simple.  You just haven't found it yet.  Here are some cases to look for. Ranges can overlap: 1-10='Low'  8-15='Medium'; Values can be repeated: 'M' = 'Male' 'M' = 'Male' You'll find at least one of these somewhere, even if it's part of a range that uses LOW or HIGH. Good luck. ... View more

I think you should post some sample data and output you want to clarify your question. Ksharp ... View more

Thanks Ksharp for the colon modifier. I learned something. - PG ... View more

Hi, yes we can use the Timepart function for the same Data DateTimeExtract; Set OriginalDateTime;       TimeForDate = Timepart(DateField);    If ’14:00:00’t le TimeForDate le ’17:00:00’t; Run; ... View more

I was using proc export and due to file size being very large, unable to get thru. Proc download can also be used, but not sure if this works for infile/outfile references. ... View more

Yes, the solution that I provided should do that. Notice that the contents of fmtlib1 and fmtlib2 get combined in the MERGE, so both get used to regenerate fmtlib1. It is possible that this won't work, depending on how the additional entries mesh together.  For example: In fmtlib1, fmtnm1 contains this range:  20 - 30 = 'Medium' In fmtlib2, fmtnm1 contains this range:  25 - 35 = 'Medium' That's why you need to run the program and see if it works. And as forewarned, make copies of the two format libraries first. Good luck. ... View more

Create a format from maps.us2 using proc format and the cntlin option. ... View more

As Tom said, when you do not define an OTHER= range the default is to echo the input just beware that the default length on output is not the input length but the widest string you have defined in your user format (or the value you can define with value $gender(default=5) 'M'='Male' 'F'='Female' other='NA'; ... View more