Search results for query: *

I am trying to import an unknown number of text files into SAS. I have found some codes but none seem to work... filename indata pipe 'dir d:\requests\miller\testfiles /b'; data file_list; length fname $20; infile indata truncover; /* infile statement for file names */ input fname $20.; /*...

How can I create a variable that will always 56 bytes long regardless of how many characters are in the original text string? I need to add trailing blanks so that the variable is always 56 bytes long. I can format and ensure the length is 56 but when I perform the length function on the...

How can I export from one sas data set to multiple excel tabs on one spreadsheet. I want to segment the dataset using a variable I have created which denotes which department the records belong to. Thanks Anthony

am i able to segment a dataset of x records into deciles by using the _n_ function? (the dataset is already sorted by the required variable so no further sorting can be done) so that SAS calculates what the last record number is and then divides by 10 and uses that number to create a variable...

I need to know how to count the number of specified charecters within a string of text. i.e. how many B's appear within "BBB12BBB" = 6. Thanks

Is it possible to transfer data from excel to other applications using a macro? how can you get the macro to open the other applications and then paste the data in a specific area, i.e. an account number. thanks