About paulkaefer

paulkaefer · ‎09-20-2016

What you're looking for is known as a debugger. I'm not finding anything by digging in the menus and Googling it. I'd recommend waiting to see what others say, and if there is no solution, you can submit it as an idea to the SASware Ballot. I'd vote for it.

paulkaefer · ‎09-20-2016

How's this? DATA WORK.TEST; INPUT product_cat $ Group $ TOB COUNT; if TOB = 5 then do; do i=1 to 5; output; end; end; else; output; drop i; cards; X A 1 2 X A 2 3 X A 3 4 X A 4 3 X A 5 5 X B 1 3 X B 2 5 X B 3 6 X B 4 7 X B 5 3 Y A 1 12 Y A 2 13 Y A 3 14 Y A 4 13 Y A 5 15 Y B 1 13 Y B 2 15 Y B 3 16 Y B 4 17 Y B 5 13 ; run;

paulkaefer · ‎09-19-2016

Try including it in the PROC TABULATE call instead: proc tabulate data=tabhow style=[vertical_header]; via this paper.

paulkaefer · ‎09-19-2016

Ah, so you want rotated text. Try this solution.

paulkaefer · ‎09-16-2016

Another solution is the DEQUOTE function. Call dequote(variable) if the first character is a single or double quote character. It will also remove any text after the closing/right quote(s). [ref] I know this is an older post, but it was one of the first results when searching this, so I figured including this solution here would be a good idea.

paulkaefer · ‎09-15-2016

A data step would work nicely: data EGTASK.MACLISTID; input 'GER Pharm'n $ Instate $ Code_MAC $ MAC_List $; datalines; CVS . . NONMAC CVS . MAC01 MAC1001A1J ... ; Also add t2. MAC_List to the SELECT clause. ...and for the record, you can use more descriptive aliases. I'd likely use d instead of t1 and maybe m in place of t2. Just so the letters match the original table names. Up to you.

paulkaefer · ‎09-15-2016

If you use PROC SQL instead of a DATA step, you can use case-when statements, which are known as switch statements in other programming languages. This paper explains them. See also the documentation. It will definitely look cleaner.

paulkaefer · ‎09-14-2016

This paper suggests using VJUST. From the documentation, looks like you can specify VJUST=TOP, BOTTOM, or MIDDLE.

paulkaefer · ‎09-14-2016

See in the log output: Unable to sample external file, no data in first 5 records. What does your file look like? Are there a few blank rows? If so, try the DATAROW= option.

paulkaefer · ‎09-09-2016

There are some suggestions on StackOverflow. This page discussed sending results to specific cells on a selected sheet. Does this help?

paulkaefer · ‎09-09-2016

One issue is that "01SEP2016" is not in the same format as " yymmdd10. " I am able to run it like so, and it works: data WORK.datetimes2 ; excel_datetime="01SEP2016:18:11:34"dt; excel_millis = 54; datetime = compress(put(excel_datetime,datetime27.)||"."||put(excel_millis,z3.) ); datetime2 = input(datetime, datetime23.3); format datetime2 datetime23.3; run;

paulkaefer · ‎09-09-2016

As @ScottBass mentions, the variable as-is does not work properly. So what I would do is parse the string for dates and times, and combine them with the DHMS function. This worked for me: data WORK.timestamps; TM_INS_C = "2016-09-05-17.38.51.717187"; date = input(substr(TM_INS_C, 1, 10), yymmdd10.); time = input(substr(TM_INS_C, 12, 10), time10.); date_time = dhms(date, 0, 0, time); format date yymmdd10. time time10. date_time datetime.; run;

paulkaefer · ‎09-08-2016

I won't be attending in person, but I'm excited to be able to listen in on a few of the live-streamed presentations!

paulkaefer · ‎09-08-2016

Are there Certification badges for the SAS Communities forum? If not, would there be benefit to having them? I think it could be nice to see what certification(s) people who answer questions have.

paulkaefer · ‎09-07-2016

I'm proud to say I've passed my first SAS certificaion exam. For how long is the certification valid? If I now have my SAS Base certification for SAS 9, will it be less valuable when SAS 10 is released sometime in the future? Is there a comprehensive list somewhere of all the possible certifications (including historical) and whether or not they are still valid? (current certifications are listed here)

Online Status	Offline
Date Last Visited	‎05-11-2020 01:18 PM

Re: Can SAS filter multiple possible LIKE conditions, without an OR?

Can SAS filter multiple possible LIKE conditions, without an OR?

Re: what's the tips for learning SAS quickly?

Re: A different kind of “3 things” for SAS admins: November 2018

Re: using asterisk in system commands?

using asterisk in system commands?

Re: Sharing in SAS Drive (part 1)

Re: Reading gzip files

Re: How Far Are You Willing To Go To Get To SAS Global Forum 2018

Re: Do you use best practices for writing and sharing code? Do you wan...

Re: Multiple Cursors

SAS Packages - Live Demo / Workshop - the User point of view

Re: SAS Packages - Live Demo / Workshop - the User point of view

SAS Global Forum 2020 on GitHub!

Re: SAS Global Forum 2020 on GitHub!

add any_value window function to SAS SQL

Re: EG: Remember ‘old’ where clauses

Re: Allow definition and use of a named group of variables

Re: A different kind of “3 things” for SAS admins: November 2018

SAS Enterprise Guide: add word wrap as option for editor & log

Code Like It Matters: Best Practices from Software Engineering, Applie...

Re: I would like a feature in Enterprise Guide that I can find in SAS ...

Re: Data Step Problem

Re: vertical text alignment in proc tabulate

Re: vertical text alignment in proc tabulate

Re: How do I remove quotation marks from character strings?

Re: IF/THEN/DO Can I make it more concise?

Re: IF/THEN/DO Can I make it more concise?

Re: vertical text alignment in proc tabulate

Re: importing csv file in sas studio

Re: Output to Excel, multiple procs on a sheet

Re: Convert text to timestamp

Re: Convert text to timestamp

Re: Plan your agenda for the Analytics Experience next week in Las Veg...

Certification badge on SAS Communities forum?

For how long is SAS certification valid?

SAS Global Forum 2018