Hy, when I open a dataset often sas studion does not select all the variables but only some. If I want to see all the columns in the dataset I have to select them manually. Is there a way to let sas studio show all the columns every time I open a dataset ?   If the problem is not clear please let me know. Thanks for your help, Daniele   ... View more

Hi! I would like to show proc means result with commax20. format. For example I want see this report in commax20. and not in the default bestw. format. I add a format statement but it dosn't work.   proc means data = sashelp.citiday sum; var snydjcm;   format snydjcm commax20.; run; Thank for your help. Daniele   p.s. I'm using Sas Studio version. ... View more

Hi, I am a new user in Sas Studio. After I've run a data step,  Sas Studio automatically show the new dataset in the "Output data" window and in some cases it is a waste of time. I was wondering if there is a way to set up the Sas Studio session to automatically view the log window instead of the "output data" window after running a datastep. Thenk for your helps! Daniele ... View more

Hi, I am studying for SAS Advanced programmer certificate. I can't solve this problem. This is the exam question: %macro one (input); %two; %put the value is &date; %mend; %macro two; data _null_; call symput('date','12SEP2008'); run; %mend; %let date = 31DEC2006; %one (&date); What is the result when the %put statement executes? A macro variable DATE with the value 12SEP2008 is retrived from the local symbol table for the ONE macro A macro variable DATE with the value 12SEP2008 is retrived from the local symbol table for the TWO macro A macro variable DATE with the value 12SEP2008 is retrived from the global symbol table A macro variable DATE with the value 31DEC2006 is retrived from the global symbol table The correct answer is the 3. But I can't understand why. I thought the corret anserw was 2 and the macro was stored in the local symble table beacause the code is inside of a macro defintion. Can you help me? Thanks a lot, Daniele   ... View more

Hi, I hava a dataset like this:   data have; input provision1 provision2 provision3 provision4 flow $20.; datalines; 5 5 8 7 increase 0 0 4 4 inflow 0 2 3 3 inflow 8 8 8 0 outflow ; run; I'm trying to create a new variable (impact) and, if flow = "Inflow", I would like assign it the first provision greater then zero, in my example provision03 for the 2nd observation and provision2 for the third observation. In the other case provision will be missing.   I am trying with this code: data test; set have; array prov {*} provision1 provision2 provision3 provision4; if flow = "inflow" then do; impact = 0; do i = 1 to 4 until(prov{i} eq 0); impact = prov{i+1}; end; end; run;   I think there is some problem because the value for impact in the new dataset are 0 (2nd obs) and 2 (3rd obs) and not 4 and 2 as I would like.   I hope I have explained my need well, could you help me please...? Thanks, Daniele ... View more

Hi, I'm trying to use exist function, but it seems doesn't work as I would like. I want assign macrovalue different value conditionally if a dataset exist or not. I provide an example:   /***** TEST DATA ******/ DATA test_1; x = 2; run; DATA test_2; x = 2; run; /* assing different value to macrovalue date1 and date2 if ds test_1 and test_2 exist or not */ %let ds1_in = work.test_1; %let ds2_in = work.test_2; %macro exist; %global date1 date2; %if %sysfunc(exist(&ds1_in.) %then %do; %let date1 = 20171231; %let date2 = 20180131; %end; %else %if %sysfunc(exist(&ds2_in.) %then %do; %let date1 = 20180131; %let date2 = 20180228; %end; %else %put "error"; %mend; %exist; %put date1 = &date1.; %put date2 = &date2.;  I surly make some errors because when I submit macro program the follow massage is written in the log:   NOTE: Remote submit to RHOST commencing. 47 %macro exist; 48 %global date1 date2; 49 %if %sysfunc(exist(&ds1_in.) %then %do; ERROR: Macro keyword DO appears as text. ERROR: A dummy macro will be compiled. 50 %let date1 = 20171231; ERROR: Macro keyword LET appears as text. 51 %let date2 = 20180131; ERROR: Macro keyword LET appears as text. 52 %end; ERROR: Macro keyword END appears as text. 53 %else %if %sysfunc(exist(&ds2_in.) %then %do; ERROR: There is no matching %IF statement for the %ELSE. ERROR: Macro keyword IF appears as text. 54 %let date1 = 20180131; ERROR: Macro keyword LET appears as text. 55 %let date2 = 20180228; ERROR: Macro keyword LET appears as text. 56 %end; ERROR: Macro keyword END appears as text. 57 %else %put "error"; ERROR: There is no matching %IF statement for the %ELSE. ERROR: Macro keyword PUT appears as text. 58 %mend; ERROR: Macro keyword MEND appears as text. 59 %exist; 60 %put date1 = &date1.; ERROR: Macro keyword PUT appears as text. 61 %put date2 = &date2.; ERROR: Macro keyword PUT appears as text. NOTE: Remote submit to RHOST complete. Can you explain me why? Mybe is better to use exist function in a datestep than in a macroprogram? Thanks for your help and time...I have spent several days on this but I can't fix it.   ... View more

Hi, I am trying to assign different value to macro "dt_rif_short_Ifrs9" depending on the "dt_riferimento" macro value but the macro program seems doesn't work correctly. (for example if &dt_riferimento = "31MAR2018"d, &dt_rif_short_Ifrs9  = 201709 and not 31MAR2018 as I want). Do you know why? I think there is some problems with date value...let me know.  I am using SAS University Edition. Thanks for your time and help. Daniele     %let dt_riferimento = "31MAR2018"d;   macro ifrs9 ();     %global dt_rif_short_Ifrs9;                %if "31DEC2017"d   <= &dt_riferimento. < "31MAR2018"d   %then %let dt_rif_short_Ifrs9 = 201709;     %else %if "31MAR2018"d  <= &dt_riferimento. <   "30JUN2018"d   %then %let dt_rif_short_Ifrs9 = 201803;     %else %if "30JUN2018"d   <= &dt_riferimento. <   "30SEP2018"d   %then %let dt_rif_short_Ifrs9 = 201806;     %else %if "30SEP2018"d   <= &dt_riferimento. <   "31DEC2018"d  %then %let dt_rif_short_Ifrs9 = 201809;                                                                                                                %else %let dt_rif_short_Ifrs9= "error"; run; %mend; %ifrs9 (); %put the value of the macro variable dt_rif_short_Ifrs9 is: &dt_rif_short_Ifrs9.; ... View more