I'm trying to figure out if the following is possible.  A picture is worth a thousand words... I would like to have the cell in the rows under the across header link to other output. Clicking on the data value in the cell (the n-statistic in this example) should link to an anchor corresponding output for [table][dn] Example data: data x; input k q; datalines; 1 2 1 2 1 2 2 7 2 8 2 8 2 9 3 100 ; data y; input p r; datalines; 0 0 1 1 2 2 3 3 3 3 3 3 3 3 3 3 4 1 4 2 ; proc sql ; create table xf as select 'x' as table, k, count(distinct q) as dn from x group by k; proc sql ; create table yf as select 'y' as table, p, count(distinct r) as dn from y group by p; data fs ; set xf yf; run ; proc sql; create table x2 as select *, count(distinct q) as dn from x group by k order by dn, k ; create table y2 as select *, count(distinct r) as dn from y group by p order by dn, p ; ods html file='r.html' style=plateau; proc report data=fs; title 'counts'; column table dn ; define table / group ; define dn / across ; run ; proc print noobs data=x2; title 'x2'; by dn ; run; proc print noobs data=y2; title 'y2'; by dn ; run; ods html close;   ... View more

I ran a dataset through proc freq and noticed I had missing values when I didn't expect any. Is there a way to output those values or print them so that I can determine what the issue might be? ... View more

I have almost 10 years association with SAS technologies but I am very concerned to see the migration to R/Python/Pyspark/Altair etc. Is SAS doing any concrete work like increasing reach out to customers, considering decrease of prices of licenses, increasing flexibility to install packages as per user's will, improving performance /visualization features  providing value add on services etc..? I am very concerned with my career and the way that I observe that the way it is going,  SAS engagements will enterprises will shrink more and it would be very disheartening for me to see that. Are there any enterprises which have shifted to new technologies and have come back to set up SAS shop? I would highly appreciate if I get replies from senior persons at SAS or within SAS community.  The clarity would be required for motivation to chart the future path for me. ... View more

Good morning all - I wonder if someone could help with what I thought would be a simple task. I am trying to read into SAS [using SAS Studio 9.4 ODA on Windows 10] a small database that I saved as a dump file on my desktop and then uploaded this dump file onto the server [hardly 5-6 tables each with max 15 rows - total file size < 200 KB] so that I can then practice using PROC SQL queries to access specific data [learning exercise] from this database. I have tried various ways but in vain.  A couple of attempts are below:- [thanks in advance!]   Attempt No. ONE. caslib mycaslib desc='MySQL Caslib' dataSource=(srctype='mysql', host='localhost' username='root', password='[******]', database='cardiotech', schema='mySchema'); RUN; Log when I ran above code: 1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 68 69 70 71 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 81   Attempt No. TWO: data _null_; file "/home/myusername/sasuser.v94/SQL/bdump.sql"; put 'select * from sashelp.class;'; run; options source2; proc sql; %include "/home/myusername/sasuser.v94/SQL/bdump.sql"; SELECT * FROM patients, chest_pain WHERE patient.patient_id = chest_pain.patient_id; RUN; Error message when I run No.2 code above:- 78 SELECT * FROM patients, chest_pain 79 WHERE patient.patient_id = chest_pain.patient_id; ERROR: File WORK.PATIENTS.DATA does not exist. ERROR: File WORK.CHEST_PAIN.DATA does not exist.   Apologies if I an missing something v empirical, but I hope this Q sparks some interest/enthusiasm, and that someone can find a few minutes to help out! Tysm again!   ... View more