Home

yp2609

For each unique value of Agent_Name, I want to export all relevant rows to an Excel file with the Agent's name in the filename. Can someone point me in the right direction? I'm using Base SAS 9.4 proc import datafile="\\columbia\dfsr1\Actuarial\Alice\Ohio PPA Agents\Filtered.csv" out=filter1_data dbms=csv replace; run; /* change the variable names */ data filter; retain agentname family_no unit_no zip effective_dt premC premP imp AnnPremC AnnPremP annImp imppct; set filter1_data (rename=( agentname = Agent_Name family_no = Family_Number unit_no = Unit_Number zip = Zip_Code effective_dt = Effective_Date premC = Single_Term_Current_Premium premP = Single_Term_Proposed_Premium imp = Single_Term_Impact_$ AnnPremC = Annualized_Current_Premium AnnPremP = Annualized_Proposed_Premium annImp = Annualized_Impact imppct = Impact_Percent )); run; /* change variable orders */ proc sql; create table filter_2 as select Agent_Name, Family_Number, Unit_Number, Zip_Code, Effective_Date, Single_Term_Current_Premium, Single_Term_Proposed_Premium, Single_Term_Impact, Annualized_Current_Premium, Annualized_Proposed_Premium, Annualized_Impact, Impact_Percent from filter where Agent_Name ne ''; quit; /* order dataset by Agent_Name */ proc sort data=filter_2 out=filter_2; by Agent_Name family_number unit_number; run;

AndreaVianello

I have a program that prepares a map proc gmap map=mappaRMV data=tblTOT all; id pro_com__t; choro percent / COUTLINE=green levels=5 ; format percent 6.2 ; run; The coloring of the areas is done in shades of blue (Enterprise guide) If I direct the output with ODS PDF and SAS 9.04.01M8 for Windows I get While if I direct the output with ODS PDF and same SAS 9.4 for Linux I get The sas code is EXACTLY THE SAME Why? Solutions?

rbettinger

I want to write a SAS/IML module that invokes ODS statements at execution time, not compilation time. Can this be done? If so, please show me via a code snippet so that I may be able to learn from it. For example: proc iml ; /* capture a graphic into a specified file */ run ODS_PDF( 'ods_file_containing_SGPLOT_output' ) ; submit ; /* SGPLOT statements here */ endsubmit ; run ODS_PDF() ; quit ; The IML module ODS_PDF will manage the creation of the file 'C:\path_to_SAS_directory_containing_IML_code_to_execute\ods_file_containing_SGPLOT_output.pdf' . When the argument list to ODS_PDF() is empty, the ODS destination will be closed. Is there some way to mask the ODS commands from immediate compilation? TIA, Ross

sukchb

A quick definition of Agentic AI "Agentic AI" refers to artificial intelligence systems that exhibit agency, meaning they can act autonomously toward achieving goals rather than just following predefined instructions. Hang on hang on…if after reading that you are thinking

NewUsrStat

Dear all, suppose to have the following dataset: data DB; input ID :$20. Start :$20. End :$20. TypeTransfusion1 :$20. TypeTransfusion2 :$20. TypeTransfusion3 :$20. Result1 :$20. Result2 :$20. Result3 :$20.; cards; 0001 2024-09-01 2024-10-01 RBC Whole blood . Positive Positive . 0001 2024-09-01 2024-10-01 . . Platelet . . Negative 0002 2016-NK-NK 2016-NK-NK . Whole blood Platelet . Negative Positive 0002 2016-05-02 2016-05-02 RBC Whole blood . Positive Positive . 0002 2016-05-05 2016-05-04 . . Platelet . . Negative 0003 . . . . . . . . 0003 . . . . . . . . 0004 2024-09-01 2024-10-01 RBC Whole blood . Negative Positive . 0004 2024-09-01 2024-10-01 . . Platelet . . Positive 0005 2025-11-03 2025-11-23 . Whole blood . . Positive . 0005 2025-11-03 2025-11-14 RBC . . Negative . . ; run; In one of my previous posts named: "From short to long format for SDTM programming," I asked for support to transpose the dataset. Gently the following help was provided to me: data want2; set db; length TypeTransfusion $20; array list TypeTransfusion1-TypeTransfusion3 ; do index=1 to dim(list); TypeTransfusion=list[index]; output; end; drop TypeTransfusion1-TypeTransfusion3; run; The initial dataset contained only the "TypeTransfusion*" variable. Now, another variable "Result*" has been added. How can I integrate this new variable into the code above? In other words, I need to do the same thing that I do for the TypeTransfusion variable also for the Result variable in the same piece of code above. Can anyone help me please? Best