About gzr2mz39

Dazz_D · ‎10-25-2017

Hi: These comments fit my issues - Thanks again Cynthia!!!

gzr2mz39 · ‎09-18-2017

Thank you.

gzr2mz39 · ‎07-27-2017

The strategy I'm currently using is to divide the datasets into smaller parts and then generate Cartesian Products with PROC SQL. After merging I use geodist to calculate the distances.

SASKiwi · ‎02-23-2017

So what is your full question then? You can assign a libname using the EXCEL engine and then add the DBLABEL to a DATA statement writing to the LIBNAME.

Kurt_Bremser · ‎12-19-2016

Using ods tagsets.excelxp or ods excel (if you run SAS 9.4) allows you to create formatted spreadsheets. But be aware that it will take more work than just hitting ctrl-t.

ShannonMoore · ‎09-22-2016

gzr2mz39, Since the Add-In shares the same .NET code-base as Enterprise Guide, you have all the same functionality in the Add-In task as you would have from the Task in Enterprise Guide. For example, I was able to run both a One Way Frequency and Arima Task and get the summary statistics saved either in a permanent library or work library. You select the Results in the Task and set options on that dialogue. Does this help? Shannon

Reeza · ‎08-12-2016

Depending on your version of SAS it may not be the latest version though.

SASKiwi · ‎07-06-2016

For your LIBNAME to be available in Excel, it needs to be set up so it is run automatically whenever a SASApp session is started. The easiest way to do this is by creating it as a Data Library in SAS Management Console: http://support.sas.com/documentation/cdl/en/bidsag/68193/HTML/default/viewer.htm#n0l9lj112qvz7tn0z2rzmqui1du0.htm You could also put the LIBNAME in a SAS AUTOEXEC program but that is trickier to set up.

jklaverstijn · ‎06-30-2016

Likely the trailing spaces that are implicitly present in your strings play a role. You can omit them from the comparison by adding the t modeifier to the third parameter. find_hmbp=find(permit,facility_hmbp_3,'it') Hope this helps, - Jan.

kritima · ‎03-16-2016

Thank you very much Chris, The problem is on Windows Task Scheduler

gzr2mz39 · ‎04-29-2015

I found that _BIC_CST was equal to 01APR1715. I fixed that record and proc export ran successfully.

PGStats · ‎09-16-2014

The kind of documentation that would always be required.: /* Create a dataset called all */ data all; /* Read all datasets with names starting with allinj. Create a variable called src_file that will hold the actual name of the dataset being read. */ set allinj: indsname=src_file; /* Copy the name of the dataset being read to a variable called excel_file */ excel_file=src_file; /* List the names of variables which will be part of the all dataset */ keep clm_num doi x excel_file; run; PG

gzr2mz39 · ‎08-25-2014

This works great. Thank you.

gzr2mz39 · ‎08-05-2014

This works. Thank you.

Peter_C · ‎07-02-2014

although you have one solution, here is another difference = range( date1, date2 ) ; Here is some code to demo the result . data ; do date1 = today() - 3 to today()+2, . ; do date2 = today() - 3 to today()+2, . ; diff= range( date1,date2) ; output ; end; end; stop; format date: date. ; run ;

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: excelxp: proc report header cell height problem

Re: Calculate mean using proc sql and case when

Re: compute distances between latitude/longitude points

Re: SAS 9.4 dblabel error

Re: output excel as an Excel table (ctrl+t)?

Re: Add-in for Microsoft Office: extract summary statistics?

Re: ExcelXP tagset when using Enterprise Guide connected to a server

Re: Add-In for Microsoft Office: connect to library

Re: how do I find words in text using find()

Re: VBScript error: could not locate automation class

Re: proc export using accesscs: datetime field overflow error

Re: append many files and add a new variable

Re: Insert rows with count=0 for categorical variable combinations tha...

Re: converting times from character to 24-hour

Re: difference between dates