Home

vmurray

It would be nice to be able to copy text from an individual cell in the list table. This is possible in a crosstab but it would be nice to mimic the excel function of copying from a regular table/cell for the list table.

PaigeMiller

I am trying to perform SG Annotation with BY Variables. In this trivial example, I want one plot with a red arrow for the plot of Male data; and one plot for the females with a green arrow, depending on the value of SEX in SASHELP.CLASS Here's my code that doesn't work (stealing from the example here). %sganno data sgannodata; set sashelp.class(obs=2); if sex='M' then do; %sgarrow(x1=51, x2=30, y1=30, y2=30, linecolor="red") end; else if sex='F' then do; %sgarrow(x1=51, x2=30, y1=30, y2=35, linecolor="green") end; keep sex; run; proc sort data=sashelp.class out=class; by descending sex ; run; proc sgplot data=class sganno=sgannodata; scatter x=age y=weight; by descending sex; run; Here's the incorrect output (the correct output would be the red arrow on the males and the green arrow on the females, not both arrows on both plots)

zihdonv19

I tried ("cou" is 1,2,3,4,5.....; "var" is continuous variable with decimal points): proc sql; create table mt as select cou, pctl(75, var) as var_p75 from check_1 group by cou; quit; But it returns me with multiple rows per cou.

Patrick

There have been quite a few spam questions over the past few months where it took sometimes days until they got removed. Proposal Implement an automated process that moves questions from the visible list to some hidden queue for investigation if marked by multiple users an inappropriate content. To avoid that this process can get misused: Only include users that marked the question if they are not New Users but already on a certain level (to exclude fake users). And just thinking: Eventually request from New Users for their first few post some additional identification step when posting a question to make it a bit harder to automate posting such questions.

IgawaKei29

I am having an issue where I am trying to create a volatile table using SAS, then being able to connect and review this table. Ultimately I am trying to join a Teradata Volatile table with Hadoop data, but I figure this is the first step. You can see a sample layout of my code below, and the only error I get when running is that my_VTD_Test doesn't exist, which is true at the start of the program. Everything else completes just fine, but when I try to look at the table data, I get an error that it doesn't exist again. So it looks like its running but not gathering any data. I appreciate any feedback with this. libname tdwork teradata AUTHDOMAIN=MYAUTH mode=teradata server="myserver" connection=global dbmstemp=yes; PROC SQL NOERRORSTOP; CONNECT TO TERADATA (AUTHDOMAIN=TDAUTH server="myserver" connection=global mode=teradata); execute (drop table my_VTD_Test) BY Teradata; execute( create volatile table my_VTD_Test as (select Name, Place, Service from MYTDSCHEMA.Table_NAME ) with data primary index(Name) On Commit Preserve Rows ) by teradata; DISCONNECT FROM teradata; quit;