About LawrenceHW

LawrenceHW · ‎12-02-2016

After a bit of research and some trial and error I found that the following VTL works: <CodeTemplate> <![CDATA[ #if ($textExample.empty=="false") $textExample #else NULL TEXT #end ]]> </CodeTemplate> So this piece of code checks whether the Input Text variable is empty/missing ("true") or non-missing ("false"). I wanted to use this for optional macro parameters that require text when creating a Tasks to create a standard macro wizard.

LawrenceHW · ‎11-24-2016

Hi, I'm finding my way around defining custom tasks within SAS Studio (v3.5) and I was wondering if there's a way of checking whether the Velocity variable for the INPUTTEXT option element exists or not. So I only want this Velocity variable to appear in the SAS code if the INPUTTEXT has been completed by the user.

LawrenceHW · ‎01-03-2014

Hi, We run server-based SAS (v9.2 ... should be moving to v9.4 soon) and we occasionally experience issues with users creating static SASHELP.VCOLUMN data sets (usually by using code like PROC SORT DATA=SASHELP.VCOLUMN; BY xxxxx; RUN;). Obviously one thing we can do is to send out communications to our user base about this type of issue but I was wondering if it's possible to set the SASHELP libref to ACCESS=READONLY (in the config file) or would this have an impact on how SAS runs? We use the SASHELP viewtables quite a bit (another solution is to use the dictionary tables of course) and I was wondering if setting the libref to read-only would have an impact on the functionality of these viewtables?

LawrenceHW · ‎04-20-2009

You can get this inforrmation in a couple of ways (provided you're running in batch mode). 1. Use the SYSPROCESSNAME automatic macro variable 2. Use something like: %LET sysin=%SYSFUNC(GETOPTION(sysin)); Both of these give you the program name and path.

LawrenceHW · ‎04-20-2009

Susan, If you just want to count the number of unique ID per YEAR why not just use something like: PROC SQL; SELECT DISTINCT year , COUNT(DISTINCT id) AS n_identifier FROM alldata GROUP BY year ; QUIT;

LawrenceHW · ‎04-03-2009

If the X and Y values are menat to be the actual values then your XSYS and YSYS values should be 2. Absolute values in the Data area.

LawrenceHW · ‎03-24-2009

Anthony, The only way I've found of doing what you're requesting is the pre-processing route. Cynthia's solution is very elegant but unfortunately isn't really what is needed for AE tables. What I do is create page breaks (i.e. a paging variable) based on the number of available lines for my table. Make sure that you take into account skips and continued class headings. I then run a 2nd data step to add an extra line where a class page breaks in the middle of the class. This is where I add the "(Cont.)". Hope this helps. Lawrence

LawrenceHW · ‎01-22-2009

Hi, Has anyone got any ideas on how I can align text columns in a proc report? My data (simplified) looks like: COL3 213 (96.3%) 10 (5.4%) 0 In non ODS I would just have: define col3 / display left width=13 "heading"; Using ODS I've tried: define col3 / display "heading" style(column)=[cellwidth=2.5CM just=left] style(header)=[cellwidth=2.5CM just=center]; define col3 / display "heading" style(column)=[cellwidth=2.5CM textalign=dec] style(header)=[cellwidth=2.5CM just=center]; and neither work properly. Is there any way of forcing ODS RTF to respect the leading spaces I've got in COL3? Cheers, Lawrence

LawrenceHW · ‎12-12-2008

SYSPROCESNAME will return DMS Process if you're executing interactive SAS which is what (I suspect) is happening here. SYSPROCESSNAME will return the program path and filename when batch executing. You can check what SYSPROCESSNAME gives you in the LOG file but submitting "%PUT &SYSPROCESSNAME;" in the program editor. Lawrence Message was edited by: LawrenceHW

LawrenceHW · ‎05-21-2008

Hi Cynthia, Thanks for the (usual) speedy response. I'll trawl through those websites you've found. Cheers, Lawrence

LawrenceHW · ‎05-21-2008

I know this may not be strictly MS Office but it's (kind of) related. I'm interested in building a VB front end to access SAS data sets and to process this information in SAS macros in a process controlled by VB. Does anyone have any information on VB/SAS interaction? Cheers, Lawrence Message was edited by: LawrenceHW

LawrenceHW · ‎03-18-2008

Proc CATALOG (and also DATASETS) are very useful procedures for cleaning up your SAS WORK areas. I use these procedures all my current WORK macros and data sets when I want to start a new program but without starting a new SAS session. You can use the dictionary tables (or the SASHELP views which are the same thing, just less efficient) to give you the information to delete all user-defined macro variables.

LawrenceHW · ‎02-19-2008

Try the ODS OUTPUT models. To find out what these are add: ODS TRACE ON; PROC LOGISTIC..... RUN; ODS TRACE OFF; Check your log file and the output table names should be there. These will correspond toa specific section of your output. You can then save these using the ODS OUTPUT statement prior to you LOGISTIC. Cheers, Lawrence

LawrenceHW · ‎02-14-2008

Another alternative is that you calculate your frequency counts and totals using a summary procedure (FREQ, SQL, MEANS, UNIVARIATE - take your pick - I've seen lots of different methods) and merge the totals and frequencies together. Calculate %age, create a character variable {xx (xxx%)} and use PROC REPORT to print out the xx (xxx%) variables along with labels, headers, footers, etc. That's pretty much what I do anyway ... mainly because I dislike TABULATE ...

LawrenceHW · ‎01-25-2008

If people don't like querying dictionary tables (and I don't understand why not) you can always use the following code: %LET dsid=%SYSFUNC(OPEN(work.dataset)); %LET nobs=%SYSFUNC(ATTRN(&dsid.,NOBS)); %LET rc=%SYSFUNC(CLOSE(&dsid.)); The number of observations is then held in a macro variable [NOBS]. %IF &Nobs. EQ 0 %THEN %DO; .... %END; etc. etc. Message was edited by: LawrenceHW

Online Status	Offline
Date Last Visited	‎05-24-2022 08:42 AM

Re: Numer of months between 2 dates

Re: Finding a value across all datasets in a library

Re: Finding a value across all datasets in a library

Finding a value across all datasets in a library

Re: Parallel processing in a Grid - sort of works

Parallel processing in a Grid - sort of works

Re: Indenting rows in ODS EXCEL - it works in TAGSETS.EXCELXP

Re: Indenting rows in ODS EXCEL - it works in TAGSETS.EXCELXP

Re: Indenting rows in ODS EXCEL - it works in TAGSETS.EXCELXP

Indenting rows in ODS EXCEL - it works in TAGSETS.EXCELXP

Browsing SAS data sets in Enterprise Guide without locking

Autosave/backup projects

Expanded Details Regarding Compiled Macros

Create ROW_NUMBER() function for PROC SQL

Re: Check if the table is empty

Re: Finding a value across all datasets in a library

SAS Studio Task - in clause for a where statement

Re: How to get count of occurrences of a record

Re: Custom Tasks: Checking whether inputtext has a value

Re: Custom Tasks: Checking whether inputtext has a value

Custom Tasks: Checking whether inputtext has a value

SASHELP library - can this be set to readonly?

Re: Macro Value for SAS Program Name

Re: Necessary to repeat sorting?

Re: Annotating in Proc Gplot

Re: how to put text when a variable CONTinues on the next page in proc...

PROC REPORT and decimal alignment/justification

Re: Looking for Windows option similar as UNIX option

Re: Sharing SAS data with Visual Basic

Sharing SAS data with Visual Basic

Re: Deregistering/removing a macro

Re: proc logistic -- how to output Somer'D and C to a data set

Re: Data Manipulation and Freq

Re: Check if the table is empty