Hello everyone, I have a general question about proc format. I am not writing a program or trying to fix an error. I just don't understand how the Value statement know which field it should look at. Here is an example from a sas manual: Data carsurvey; Infile 'c:\mydata\cars.dat'; Input Age Sex Income Color $; Proc Format; value gender 1 = 'Male' 2 = 'Female'; value agegroup 13 -< 20 ='Teen' 20 -< 65 = 'Adult' 65 - High = 'Senior'; value $col 'W' = 'White' 'B' = 'Blue' 'Y' = 'Yellow'; My question is how does each Value statement know which field it should look at? For example, the first value statement generates a numeric format "Gender" for sex. But where do we tell it to look at the field sex? Thanks for your input! ... View more

Hello everyone, I have created a macro (supp_waterfall) which is used to calculate the number of records dropped (RecDrop) at every suppression step. There are 16 suppression steps so the macro will be executed 16 times. The goal is to create 16 macro variables holding 16 drop counts. But I am not sure how to create and keep these 16 macro variables and their values. I would like to use them to calculate the drop total later in the program. Below is the portion of the code related to the drop count variable: %macro supp_waterfall (supp_file, supp_out, numstart, rptorder); /*pass in the input file, output file, record begin, report order */ data &supp_out set &supp_file; if _n_=1 then do; ~~ RecDrop=&numstart-RecKept; CALL SYMPUT('Drop&rptorder',RecDrop); ~~ %mend; %supp_waterfall(&supp_file, &supp_out, &numstart, &rptorder1, &numrecs); RecDrop is the variable I would like to keep for each of the 16 times this macro is executed. I have no idea how to create a macro variable for it so I tossed in the 'call symput' in there. I get syntax error for it. I attached '&rptorder' to the end of the variable DROP as an unique identifier for the 16 drop counts. So &rptorder goes from 1 to 16. rptorder is hardcoded and passed into the macro. Everything works except the CALL SYMPUT statement, which gives me a syntax error. I hope i have given enough information for anyone to trouble shoot. Any suggestions will be greatly appreciated. Thank you! ... View more

Hello, The below code works but I don't understand how. It uses ODS to create an output .html file. What I don't understand is why is it using ODS HTML with ODS PDF CLOSE? I was expecting to see ods html with ods html close. Thanks for your input. ODS Listing CLOSE; ODS HTML style=barrettsblue body="V:\TMT\\Output\MAP_&campaign_id._Excl_Waterfall.html"; proc report ....... ....... run; ODS PDF CLOSE; ODS LISTING; ... View more

Hello Everyone, I use %let to assign a value to a variable. But it's not working as I have hoped. At the top portion of my program I have: %let input1='20100121_REFI1001D.xls'; Down below in a proc import I have: PROC IMPORT out= test_sa_excls_addflds1 datafile= "c:\My Documents\&input1" dbms=EXCEL REPLACE; SHEET='LoanListAll (Page 1)'; getnames=yes; scantext=yes; mixed=YES; RUN; This is the error msg I get: ERROR: Unable to import, file c:\My Documents\&input1.XLS does not exist. The Excel doc is stored in c:\My Documents\20100121_REFI1001D.xls. Can anyone tell me what I am doing wrong? Thank you for any input!! ... View more