Search results for query: *

data test; Infile 'C:\Documents and Settings\C-sophie\Desktop\Star_200505.txt' DSD missover; input svc_accs_id 1-10 score 59; Run; I have the following code. When I use the infile statement to create a sas data set It make the data set column a number 8. How do I make it a 10 long? Most if...

What the difference between the noduplicate command and the no dup keys command.

What is the difference between NON DUPKeys and NONDUPLICATES?

If you had a table that had a primary key.. say a ss number and you had one other field in your table that was a date field. What would be the easiest way to find the 2nd most recent date or the second oldest date in the table

I would like to find out what is the syntax for subtrating a current_date from in_service date date is mm/dd/yyyy so something like date - in service date = new tenure date My PM want to see a list of home long individuals have had service with our company. Thanks

Has anyone out there worked with the append statement I have three files for three months. Really they just contain a service key and contract number and zip code and I want to make them into one file so that I can send it to my user. I looking in the help section and am following the code same...

I have code that I know works in queryman. I think transfer it to sas and create a volatile table and then save those rows and put then in a table in sas that I can then manipulate. Problem is when I do this my query never finishes because it runs out of spool space. Anyone else have this...