I need help with an issue I am struggling with. I have a table with two variables. The ID variable is a unique identifier and the Cust_ID field is the customer IDs for the unique ID values. An ID can have one or multiple cust_ids. I want to create a third variable multi_cust_id which lists all cust_id values for each IDs. As you can see in my table below for ID '1' there are two cust_ids so the new multi_cust_id has both cust_ids listed in both lines where ID = 1. They all need a single quote surrounding them and be separated by a comma.    So, how do create the multi_cust_id variable?   Below is my made up table. Thanks a lot. ID Cust_id multi_cust_id 1 12345 12345', '56789' 1 56789 12345', '56789' 2 23456 23456', '67890', '34567', '78901' 2 67890 23456', '67890', '34567', '78901' 2 34567 23456', '67890', '34567', '78901' 2 78901 23456', '67890', '34567', '78901' 3 35678 35678' 4 54321 54321', '23459', '34557', '54390' 4 23459 54321', '23459', '34557', '54390' 4 34557 54321', '23459', '34557', '54390' 4 54390 54321', '23459', '34557', '54390' 5 34889 34889'   ... View more

I have a code that creates 3,000 individual excel reports through ODS Tagsets in SAS. Some of them are created even if there is not data in the source dataset. So, when you open the excel report there is no data in it. I do not want to create the excel report if there is no data in the dataset. How do I program that? I tired to copy my table but for some reason I could not do it so I do not have any table to show you.   Thanks in advance.          ... View more

I have three numeric variables that I am multiplying. I get different results when I multiply them by a calculator and by SAS. Below are three variables and an example of values.   A = 4345 B = .0057 C = .40   a * b * c = x   by calculator: 4345 * 0057 *.40 = 9.9066   by SAS: 4345 * 0057 * .40 = 9.831   I believe the culprit it '0057' number. I am thinking that may be it has to with rounding so I tried but did not work. May be I am not rounding it correctly?   How would I get 9.9066 from SAS?   Thanks in advance     ... View more

I have below macro in my SAS code. I have total of 2,000 customers that I run a report for. I have assigned them values from 1,000 to 3,000. When I run the code, at the end, it creates a table called ‘file_&i_allyrs’. I do not get data for same number of customers every time I run it. Sometimes, I get this table for only 1,000 customers and sometimes for 1,800 customers. The ‘i’ below is customer number assigned between 1000 and 3000.   %macro Read_ALL; %do i = &beg %to &end;   data cont_&i; set file_&i_allyrs; cust = “&i”; run;   /* appending rest of the file_&i._allyrs tables */   proc append base = all_files_allyears            data = cont_&i force; run;        %end; %mend ; %macro byyr(beg, end);              %Read_ALL; %mend; %byyr(1000, 3000);   So, first it reads 'file_1000_allyrs' table. If this file does not exist, it gives an error and goes to read 'file_1001_allyrs' table..and so on. Every time the file does not exist, it gives an error. Below is part of the error it gives.   ERROR: File FILES_1000_ALLYRS.DATA does not exist.   I would like the macro to skip the file it does not exist OR I would like to stop getting an error if the file does not exist.   How do accomplish that?   Thank you in advance ... View more

I have a dataset that has two variables. The first columns has string variable called savings and another column has dollar amount of savings. There are three types of savings. So, basically, there are three rows and two columns. I use this table to create an excel file using ODS tagset.   I do not want to create an excel file if there was no dollar amount in ALL three savings I second column.   Savings Saving_Amount ABC   DEF   GHI       How do I program this?   Thanks for your help. ... View more