About mhoolsema

mhoolsema · ‎03-04-2020

That was it! I changed the name of the dataset to DATA_DICTIONARY and it worked fine.

mhoolsema · ‎03-04-2020

I am trying to do a simple SQL join and keep getting this error message. I'm can't figure what is wrong with my query that is causing the error. Where is there a missing period? proc sql; create table included_var as select a.NAME, b.field_name from varlist as a left join dictionary as b on a.NAME = b.field_name ; quit; I get the following message in my log: 2003 2004 2005 proc sql; 2006 create table included_var as 2007 select a.NAME, b.field_name 2008 from varlist as a left join dictionary as b -- 78 ERROR 78-322: Expecting a '.'. 2009 on a.NAME = b.field_name 1 . - 78 200 1 . - 78 200 1 . - 78 76 ERROR 78-322: Expecting a '.'. ERROR 200-322: The symbol is not recognized and will be ignored. ERROR 76-322: Syntax error, statement will be ignored. 2010 ; 2011 quit; NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE SQL used (Total process time): real time 0.01 seconds cpu time 0.00 seconds

mhoolsema · ‎09-13-2019

I am trying to create a Dot Plot to show comparisons from a pre-test to a post-test. Similar to what I copied below. I want to have a categorical Y axis, and a numeric X axis, with two dots showing the values for the pre- and post-test for each category. Ideally they could be connected with a line in between. It would also be ideal to include data labels for each dot, either inside the dot or to the left/right. These are easy to do in R and Tableau, and can be made with some wrangelling in Excel/Powerpoint, but I have not been able to find a way to create what I want in Visual Analytics. I have tried creating this using the graph builder in SAS VA 8.3 on VIYA by combining different chart types, but have not had any luck getting what I want. Both the Dot Plot chart and the Vector Chart require you to have a numeric Y axis. I can't seem to get them to communicate with a chart that has a Categorical Y axis. Any ideas would be great! http://r-statistics.co/Top50-Ggplot2-Visualizations-MasterList-R-Code.html#Bubble%20Plot

mhoolsema · ‎08-13-2019

When I use this I get the following note in the log: NOTE: The execution of this query involves performing one or more Cartesian product joins that can not be optimized. Is this something to be worried about, or something that can be ignored?

mhoolsema · ‎08-13-2019

I have a panel dataset that is unbalanced. There are not currently observations for every subject in every year. I would like to create a balanced dataset that has a row for every subject at every year, but have missing observations for the other variables where the data is currently missing. This is easy to do in STATA using the tsfill command, but I can't find a way to easily do this in SAS. I'm assuming I need to create some kind of loop in a data step, but I'm not sure how to apply the loop only to time periods that are currently missing. My file has about 100,000 records before expanding to the balanced panel, so I need to be able to do this programmatically and not looking at each individual case. data have; infile datalines ; input id:$8. Year:8. Department:$8. Program_Code:$8.; datalines; PersonA 2000 DeptA Prog20 PersonA 2001 DeptA Prog20 PersonA 2002 DeptA Prog20 PersonA 2003 DeptA Prog20 PersonB 2002 DeptB Prog15 PersonB 2003 DeptB Prog15 PersonB 2004 DeptB Prog15 PersonC 2001 DeptC Prog05 PersonC 2002 DeptC Prog05 PersonC 2003 DeptC Prog05 PersonC 2004 DeptD Prog25 PersonC 2005 DeptD Prog25 ; run; data want; infile datalines ; input id:$8. Year:8. Department:$8. Program_Code:$8.; datalines; PersonA 2000 DeptA Prog20 PersonA 2001 DeptA Prog20 PersonA 2002 DeptA Prog20 PersonA 2003 DeptA Prog20 PersonA 2004 . . PersonA 2005 . . PersonB 2000 . . PersonB 2001 . . PersonB 2002 DeptB Prog15 PersonB 2003 DeptB Prog15 PersonB 2004 DeptB Prog15 PersonB 2005 . . PersonC 2000 . . PersonC 2001 DeptC Prog05 PersonC 2002 DeptC Prog05 PersonC 2003 DeptC Prog05 PersonC 2004 DeptD Prog25 PersonC 2005 DeptD Prog25 ; run; The post at https://communities.sas.com/t5/General-SAS-Programming/How-to-balance-the-quot-unbalanced-data-quot-and-transpose-the/td-p/172063 said this can be done with PROC TRANSPOSE, but I need the data in the long format, and not the wide format. I have tried PROC Expand, but because it is character data I haven't been able to get that to work.

mhoolsema · ‎04-25-2019

From the drop-down menu choose Tools -> Options -> Keys. Then choose what F key you want to use (I use F12). Type this for they key shortcut you want. F12 log;clear;output;clear;odsresults;clear;wpgm; Then go to File -> Save while the KEYS window is active. Now every time you press F12 this will send sas to your log window, clear it, send sas to your output window, clear it, send sas to your ODS results window, clear it, and then return to the enhanced program editor window.

Online Status	Offline
Date Last Visited	‎04-07-2020 03:33 PM

Re: ERROR 78-322: Expecting a '.'

ERROR 78-322: Expecting a '.'

How to create a Dot Plot with Categorical Y Axis (Barbell Chart)

Re: Create a balanced dataset from unbalanced panel data?

Create a balanced dataset from unbalanced panel data?

Re: Clearing Results Viewer in 9.3

Clearing Results Viewer in 9.3