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.; /*...

Chris, Thank you very much for this!! You've been a great help. Ant

Thanks that helps! Another one. I am creating my file like this... data _null_; set outmain3(drop=var_chk); file 'S:\CH\Risk\Cust_Assist\DDAHierarchy\outmain_test.data'recfm=f lrecl=314; put @1 var; run; However the 314 record length is working but each records follows the previous, can I get...

Hi I am uploading a file against our mainframe and its expected length is 314 bytes. This is made up of other variables but after the acct number, phone number, status code it leaves me needing 56 for the comment field and 31 for an additional filler. the comment is 56 as that is the longest...

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