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...

Thanks everyone. Yes Jymm this was helpful. This was an interview question so I think the short def is what they were after. I use NODUPKEY because we usally we have a specific key that can be used. I never used the NODUPLICATE command.

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

What does the NoDuplicates command do?

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

(date-c.svc_init_date) year(4), tenure_date ok what if the user want to see something like year and days or year and month With days rounded up or down. Cosmetically the user want the column named tenure and the data to be 1year 25days or 1 year and 1 month Thanks

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...