Hi, I've imported data from an Excel spreadsheet and some variable names have spaces characters that SAS doesnt like too much. In the data step how would i rename these variables? i've tried RENAME "VAR ONE" =VAR_ONE ; or RENAME "ACCT#" = ACCOUNT_NUMB ; but that didnt seem to work. Thanks for your help. ... View more

Hi, I’m using proc sql and selecting all records from an ID But I only want to start from the second record on, so skip the first transaction. Example of data: ID DOL 1 5 1 8 1 10 1 3 2 10 3 4 etc. proc sql ; select id ,dol from example_data where id = 1 ; run ; I just want : ID DOL 1 8 1 10 1 3 Thanks for your help. ... View more

Hi, If I have a set date, and want to create date variables that are, 1 month, 2 month 6 month before that set date, is there a function that will be able to get me that? for example: set_date = 12DEC11 i want to create a new var with date 1 month before the set_date: set_date_last_1mth = 12NOV11 ; 2 months: set_date_last_2mth = 12OCT11 ; is there a simple way to do this? currently I use set_date_last_1mth = set_date - 30 ; -60 -120 etc. which isnt entirely accurate or the best way to do this. Thanks for your help. ... View more

Hi, I can't seem to figure out how to export text file of my data with the following custom delimiter: |~| Any help is greatly appreciated, thanks! ... View more

Hi, I'm running a proc means with stats of MAX and SUM the report may look something like this: Variable MAX SUM var1 10 100 var2 5 72 etc. I was wondering if it is possible to have an output data set that would append the statistic to the end of the variable name? In this example the output data set would look similar to: Variable Value var1_max 10 var1_SUM 100 var2_max 5 var2_SUM 72 etc. Thanks for your help. ... View more

Hi, I was wondering if its possible to embed a parameter into the title statement. I have the parameter %let cur_monthend = 20110731 ; and I want to have a title statement before my proc means something similar to , Title ' Summary Report &cur_monthend' ; but of course the above doesnt work, the &cur_monthend comes out as a text, I was wondering if it was possible so that it uses the parameter to output the value so the title would look something like "Summary Report 20110731" Thanks for your help. ... View more

Hi, I have a transactoin table with transactionid and contactid. There can be same transactionid for multiple contacts. I'm trying to figure out how to get the count of unique transactionid AND contactids, but im not sure how to use the 'distinct' function correctly to get it, so far i have: proc sql; select count (distinct transactionid contactid) as unique from transaction_table ; quit ; im getting a syntax error on the count statement. thanks for your help. ... View more