About gzr2mz39

gzr2mz39 · ‎03-21-2014

Thank you. All that's missing is to add an "as" to this line: create table fall_all

gzr2mz39 · ‎03-21-2014

Hi, How do I join these two summary tables on the ydoi variable? The ydoi variable contains the values: 2012, 2013, and 2014 on both summary tables. proc sql; create table fall_comb_yr as select ydoi, sum(x) as incid_cnt, sum(osha) as osha_cnt, sum(dart) as dart_cnt from classified0 group by ydoi xxxxxxxx select ydoi, sum(x) as incid_all, sum(osha) as osha_all, sum(dart) as dart_all from classified0 group by ydoi ; run;quit; Thank you.

gzr2mz39 · ‎03-05-2014

Thank you.

gzr2mz39 · ‎03-04-2014

Hi, How do I put all the column names on the same row? Currently, OU and Department are showing up on the row beneath 2013 and 2014 (i.e. the years from the ydoi variable). Thank you. proc report data=ou_sum nowd out=test style(header)=[font_weight=bold background=CX90D9D7 ]; options missing='0'; column bu operating_unit ydoi, (dart_tot); define bu / group style(column)={just=l} "OU"; define operating_unit / group style(column)={just=l} "Department"; define ydoi / across ""; define dart_tot / style(column)={just=r} ""; run;

gzr2mz39 · ‎02-21-2014

Thank you.

gzr2mz39 · ‎02-20-2014

I have two datasets and I want to create a new a dataset. The new dataset (i.e. bird_sub) will be a subset of bird1. bird1 will be subset using values of sys_id. These values need to be passed from bird_all using the following criteria: year=2014 and primary_grp=1. What I don't want to do is proc print all the values of sys_id from bird_all that meet the criteria and then copy and paste these values into a where statement. For example, data bird_sub; set bird1; where sys_id in (1,2,5,9); run; I would like to create a SQL block of code that does this. Thank you.

gzr2mz39 · ‎02-20-2014

I would like to subset a dataset (i.e. bird1) using the IDs (i.e. sys_id) that are returned from the query of a different dataset (i.e. bird_all). So, I would like to create a new dataset (i.e. bird_sub which is a subset of bird1) that only contains the IDs that matched the following criteria in bird_all: year=2014 and primary_grp=1. Can anyone show me the SQL code for this? Thank you.

gzr2mz39 · ‎01-22-2014

I don't have missing information in the data step. Only when proc report creates the table do I have blank cells due to combinations being created that don't exist in the data step. I could manually create these combinations in the data step, but that would be quite a bit of manual coding.

gzr2mz39 · ‎01-21-2014

That works. Will a compute block allow me to show blank cells as 0%, 0? Or is there a better way? Thank you.

gzr2mz39 · ‎01-21-2014

tot_per=catx("% ,",per_task,tot) where per_task and tot are both numeric values. I'm trying to create the following table: proc report data=task_groups1 nowd contents="Claims" out=test style(header)=[font_weight=bold background=CX90D9D7]; options missing='0'; column task_grp bu, (tot_per); define task_grp / group 'Task' order=data; define bu / across ''; define tot_per / '' style(column)={just=c}; run; How do I fix the following error? "ERROR: There is no statistic associated with tot_per." Thank you.

gzr2mz39 · ‎12-17-2013

Hi, Can anyone provide me with information (or a link to a paper) that describes how to import a kml (or kmz) file into SAS? Thank you.

gzr2mz39 · ‎11-22-2013

You might need to add code for a proxy. For example: filename foo url 'http://www.a.com/test.dat' proxy='http://www.gt.sas.com';

gzr2mz39 · ‎10-29-2013

Thank you for the reply. I ran the following code: http://support.sas.com/kb/38/279.html For "owner" I only see: BUILTIN\Administrators 8 1 8 2 2 5 Do you know what this is referring to?

gzr2mz39 · ‎10-29-2013

Hi, Does anyone have SAS code that retrieves the file attibutes of all files/folders in a directory? I'm particularly interested in date modified and owner name. Thank you.

gzr2mz39 · ‎10-24-2013

Hi, I would like to import an excel (xlsx) file where the variable names are on the 8th row and the data starts on the 9th row. How should I go about accomplishing this? proc import OUT=WORK.spill datafile="C:\Users\Spill_Data\&file_in..xlsx" dbms=EXCEL REPLACE; RANGE="&file_in.$"; GETNAMES=NO; MIXED=NO; SCANTEXT=YES; USEDATE=YES; SCANTIME=YES; run; Thank you.

Online Status	Offline
Date Last Visited	‎08-23-2020 05:17 AM

Re: Combine PROC SQL code blocks that have different where statements

Combine PROC SQL code blocks that have different where statements

Re: prxparse with hyphens, numbers, and parenthesis

prxparse with hyphens, numbers, and parenthesis

extracting words from a text field based on their first 2 letters

proc sql from dictionary.columns where column names begin with "CDD_"?

Re: change the values of multiple variables with same prefix

change the values of multiple variables with same prefix

regular expression (prxparse) question

Re: reading records from a file into macro

Re: Combine PROC SQL code blocks that have different where statements

Re: Combine PROC SQL code blocks that have different where statements

Re: improving the efficiency of regex with a long list of patterns and...

Re: improving the efficiency of regex with a long list of patterns and...

Re: improving the efficiency of regex with a long list of patterns and...

forward slash (/)

proc sql from dictionary.columns where column names begin with "CDD_"?

VBScript error: could not locate automation class

Re: proc sql: join two summary tables

proc sql: join two summary tables

Re: Proc Report: column names on the same row?

Proc Report: column names on the same row?

Re: SQL query: use the results from one query in a separate query

Re: SQL query: use the results from one query in a separate query

SQL query: use the results from one query in a separate query

Re: proc report error: There is no statistic associated with tot_per

Re: proc report error: There is no statistic associated with tot_per

proc report error: There is no statistic associated with tot_per

import .kml file into SAS?

Re: sas http error (connection has timed out...)

Re: Retrieve file attributes from all files/folders in a directory

Retrieve file attributes from all files/folders in a directory

proc import: variable names on the 8th row