About Palucci

Sajid01 · ‎11-19-2021

Assuming that a user is trying to connect to a SAS server and there is a login failure, then the metadata server log will typically have a reason for it. Now if the user is not able to login and there is no mention of the failure in the metadata server log, then possibly the user was not able to connect to the metadata server. It could be network connectivity issue. The SAS Administrator on site should be the first person to contact for help.

PaigeMiller · ‎11-19-2021

data have; input hip date :yymmdd10. ubez; cards; 124545 2021-09-30 119348 123981 2021-10-31 119419 ; data want; set have end=eof; prev_hip=lag(hip); prev_ubez=lag(ubez); prev_date=lag(date); output; if eof then do; if date<prev_date then do; hip=hip-prev_hip; ubez=ubez-prev_ubez; end; else do; hip=prev_hip-hip; ubez=prev_ubez-ubez; end; call missing(date); output; end; drop prev_: direction; format date yymmddd10.; run;

s_lassen · ‎11-05-2021

You function call is not correct. Whet you will get with YEAR(TODAY()-4 is 2021-4, that is 2017. If you format that as a date, you will get a date that is 2017 days from 01JAN1960. Instead, use the INTNX function: %let date_old=%sysfunc(intnx(year,"&sysdate9."d,-4), yymmd7.) Instead of the TODAY function, I used the automatic variable SYSDATE9, which contains the date that the SAS system was started (would normally be today). If you must use the TODAY function, you must enclose that in as %SYSFUNC call as well: %let date_old=%sysfunc(intnx(year,%sysfunc(TODAY()),-4), yymmd7.);

Palucci · ‎11-04-2021

Hello Reeza, Thanks its working but my graph shown y=0,1 how to change it ? to for example 100 , 200, 300, 400 ?

Cynthia_sas · ‎11-03-2021

Hi: You can do what you want to do with PROC REPORT, but it will take some different coding. You are showing your desired results. For CUSTOMER to be used as an across variable, the data has to look different than what you show in your first post. Consider this code and the report it produces. The 19 rows in SASHELP.CLASS are shown with AGE as the GROUP item and with height nested within each value of SEX, which is the ACROSS variable. If you want to add an extra summary line at the bottom, then you have to do data manipulation like I show in this paper https://support.sas.com/resources/papers/proceedings17/SAS0431-2017.pdf in Example 2, 3, 4 or 5. Probably #5, but without really seeing your actual data, it's hard to guess. Cynthia

PeterClemmensen · ‎11-03-2021

Something like ods html close; ods excel file = "S:\SASPC\PNC\class.xlsx"; proc print data = sashelp.class; run; ods excel close; ods html;

Online Status	Offline
Date Last Visited	‎11-24-2021 08:13 AM

Re: Substract value in dataset and create proc reports

Substract value in dataset and create proc reports

Connection failed problem

How to set up a macro differences between years

Re: How do simple bar chart for two variable

How do simple bar chart for two variable

PROC PRINT to EXCEL

Re: How to add a summary to Proc Reports

How to add a summary to Proc Reports

Re: How to set up a variable that shows the previous years

Re: How to set up a variable that shows the previous years

Re: How do simple bar chart for two variable

Re: Connection failed problem

Re: Substract value in dataset and create proc reports

Re: How to set up a variable that shows the previous years

Re: How do simple bar chart for two variable

Re: How to add a summary to Proc Reports

Re: PROC PRINT to EXCEL