About Reeza

Reeza

Yes, SAS VA is closer to PowerBI or Tableau and I'm not sure the intention there is statistical analysis such as Chi Square. The intention is to visually present your data. The analysis tool is SAS Studio.

Quentin

Glad you got it working. In order to "close" this question, please select an answer to mark as the accepted solution. And feel free to post your own bespoke solution and accept that.

vishnukumaroff

<redacted> is my whatsapp number kindly add me in the group .

DrAbhijeetSafai

I found that I had given name of same dataset in the data statement. After correcting that, this error got resolved. My programme was something like: data TAJ TAJ; set indata; run; I corrected it to: data TAJ; set indata; run; Thank you. - Dr. Abhijeet Safai

Reeza

I mean, we did create these reports with SAS so there's a ton of functionality available to automate. There were 132 different reports created. So it depends on the amount of effort you want to put in to the report, but it's definitely doable. Super basic starting ideas: https://github.com/statgeek/SAS-Tutorials/blob/master/Turning%20a%20program%20into%20a%20macro.md

Reeza

proc print; title "Count:" &countofpop.; quit; This will print the most recent data set (also no quit with a proc print, it's a run). If you want that title you can use ODS TEXT= or multiple TITLE statements. I also recommend the quote function for adding quotes, though I question if those are actually needed. data _null_; as_of_date = today(); year=year(today()); call symput('as_of_date', quote(put(as_of_date,mmddyy10.)) ); call symput('Year',compress(year)); run; %put &as_of_date; %put &year; proc sql noprint; select count(*) into: countofpop from population; quit; %put &countofpop; ods text= "Count:" &countofpop.; title "Data B"; proc print data=DATA_B; run; title "Data B Column"; proc print data=Data_B; var ColumnX; run; title "Data C"; proc print data=Data_C; run;

lredon

Thank you so much! Very useful

Reeza

Similar in SAS Studio You won't get the same functionality with the library navigation on the far right, but the process does allow you to more easily see output datasets. On the program tab, there's another tab that allows you to navigate to output datasets from the program specifically, which is nice as you're not filtering through multiple libraries in some cases. @Franck1048 wrote: We are currently in the process of evaluating the migration from SAS Base 9.4 to SAS Viya with cloud computing. If I understand correctly, the only coding interface available in SAS Viya is SAS Studio. Now, I tried SAS Studio, and unless I'm missing something, the configuration options are quite limited. I can't reproduce a window arrangement to see the explorer, code, log and result viewer at the same time. Running code and switching between tabs to see the log and results seems inefficient. Furthermore, SAS Base might not be the prettiest interface but it's more responsive. I attached a screenshot of an example of window arrangement we use for coding. Is there any way to setup the same workflow with SAS Viya? Thank you

PamG

@Ksharp Thank you so much. This is exactly what I was looking for!!!

Reeza

https://gist.github.com/statgeek/e0903d269d4a71316a4e *Run frequency for tables; ods table onewayfreqs=temp; proc freq data=sashelp.class; table _numeric_; run; *Format output; data want; length variable $32. variable_value $50.; set temp; Variable=scan(table, 2); Variable_Value=strip(trim(vvaluex(variable))); keep variable variable_value frequency percent cum:; label variable='Variable' variable_value='Variable Value'; run; *Display; proc print data=want(obs=20) label; run; @Ronein wrote: Hello I want to run proc freq for all numeric variables. I want to export it to a data set and not print it. In this code I see the distribution only for one variable. Why?? proc freq data=sashelp.class noprint; tables _numeric_/ out=want (drop = percent); run;

Reeza

Couple of things - ensure that categorical variables are character (class variables) and sorted the same on each dataset. Out of curiosity, if you run the example the OP posted, what do you get as a result?

Ninja_turtle

The issue is formatting how can I get extact format and color. I tried but it seems to be very ugly and not as per what my requirement is! Please help me with code if you can 🙂

Ksharp

data example; input SEGM_DATE datetime18. CLIENT_ID :$9. AVG_WEIGHT; format SEGM_DATE datetime20.; datalines; 01MAR2012:00:00:00 1-ET-1500 8 01APR2012:00:00:00 1-ET-1500 10 01JUN2012:00:00:00 1-ET-1500 13 01JAN2012:00:00:00 2-ET-1500 12 01JUN2012:00:00:00 2-ET-1500 18 ; proc summary data=example nway; class CLIENT_ID; var SEGM_DATE; output out=temp min=min max=max; run; data temp2; set temp; do i=0 to intck('dtmonth',min,max); SEGM_DATE=intnx('dtmonth',min,i);output; end; drop i; keep CLIENT_ID SEGM_DATE; format SEGM_DATE datetime20.; run; proc sql; create table want1 as select a.*,b.AVG_WEIGHT from temp2 as a natural left join example as b order by CLIENT_ID,SEGM_DATE; quit; data want2; set want1; AVG_WEIGHT_month_ago =lag(AVG_WEIGHT); if CLIENT_ID ne lag(CLIENT_ID) then call missing(AVG_WEIGHT_month_ago); AVG_WEIGHT_2month_ago=lag2(AVG_WEIGHT); if CLIENT_ID ne lag2(CLIENT_ID) then call missing(AVG_WEIGHT_2month_ago); run;

TomC4188

Thank you. No worries there. I know for certain that there is no SAS on any server that I have access to.

Reeza

1. Do you want code efficiency or just working code? 2. If #1 you can use an AI assistant for programming specifically, not generic ChatGPT. 3. If you want efficient code, hire a programmer to do the conversion and remove report redundancies and develop an efficient process. This is time intensive and expensive. Currently sort of doing this for different systems (Oracle Reports to PowerBI) and it's a lot of work.