About Elliott

kajal_30 · ‎06-21-2020

Can you please help me if we want to write in reverse? as I have the main frame values but I want to convert that into SAS date.

Elliott · ‎07-16-2019

I used anydigit to get what I needed. Thank you Reeza

Reeza · ‎07-02-2019

Use the CATX() function.

Reeza · ‎07-02-2019

COUNTW() is correct, please try it and let us know. If it's not, post the code you've tried and show an example of a case it doesn't find. @Elliott wrote: no, I need to identify if the business name is only a single word, no matter how many characters. The user feels this may be an invalid name and wants to review the information. They feel a single name with no spaces is an invalid business name and should be flagged. Thanks,

Tom · ‎01-05-2019

PROC EXPORT using DBMS=CSV will automatically add quotes around fields where they are required. The same is true for the data step solutions using the DSD option on the FILE statement. Do you want to force quotes around character variables even for values that do not require quotes?

ballardw · ‎12-04-2018

And: Weekend= WEEKDAY (somedatevalue) in (1,7); https://communities.sas.com/t5/SAS-Communities-Library/Working-with-Dates-and-Times-in-SAS-Tutorial/ta-p/424354 has a PDF with much information about dates. So a data set created something like should get you started. Data datelist; do date = '01JAN2019'd to '31Dec2019'd; HolidayName='Weekend'; if weekday(date) in (1,7) then output; end; HolidayName='Christmas'; date= holiday('Christmas',2019); output; format date date9.; run; Make sure to set a length for Holidayname long enough to hold the longest text as the above will set it to 7 characters which won't hold Christmas

Reeza · ‎10-31-2018

Google: "commandline password protect zip file" https://stackoverflow.com/questions/28160254/7-zip-command-to-create-and-extract-a-password-protected-zip-file-on-windows If you're using GZIP, change zip to GZIP in the search https://superuser.com/questions/162624/how-to-password-protect-gzip-files-on-the-command-line

Elliott · ‎09-28-2018

This is wonderful, one more question.. how do I get the title variable name to not display at the top? I tried a label stmt with title = '' but then instead of the word title it had ' Thanks

Elliott · ‎09-27-2018

Thanks!

Reeza · ‎09-11-2018

This user answer the question here: https://communities.sas.com/t5/ODS-and-Base-Reporting/ODS-EXCEL-Clickable-external-hyperlink/m-p/494561#M21687

ChrisNZ · ‎09-04-2018

Many people cannot/will not open MS Office files. Avoid them. If you are attaching an image use the "Photos" icon.

Elliott · ‎08-14-2018

Thanks, I have requested the data be sent in a .csv. Hopefully that will take care of my issues. Thanks!

Elliott · ‎06-01-2018

Thanks!

Reeza · ‎04-24-2018

Why wouldn't your process alert you to the fact that it failed. I think you should fix the source here, not account for the issue.

ballardw · ‎04-10-2018

@Elliott wrote: I know it makes no sense. I an just trying not to have the code error in a production environment. Sometimes there are no records that meet the criteria to sample from. I just need a blank data set in that case to produce a empty sheet in the reporting I am providing. Are you wanting the Surveyselect tables with the selection method and summary of input/output sets with weights or something else? What exact type of selection are you doing? Does your current empty input set generate errors?

Online Status	Offline
Date Last Visited	‎01-29-2024 05:13 PM

Re: ODS tagattr for credit value

Re: ODS tagattr for credit value

Re: ODS tagattr for credit value

Re: ODS tagattr for credit value

Re: ODS tagattr for credit value

ODS tagattr for credit value

Re: proc export tab delimited txt file missing last row

Re: proc export tab delimited txt file missing last row

Re: proc export tab delimited txt file missing last row

proc export tab delimited txt file missing last row

Re: how to summarize transactional data for report

Re: Appending daily datasets into a monthly dataset

Re: Use RETAIN to re-order variables

Re: Compare values within records of same group

Re: How do I eliminate the remerging summary data note?

Re: scrub character field for all numeric value

Re: Convert SAS date to Mainframe date

Re: scrub character field for all numeric value

Re: creating 1 variable from multiple variables and separating the val...

Re: Need to query for a variable value that only contains a single wor...

Re: Creating a .csv of large dataset data

Re: dataset of weekend and holiday dates

Re: Using ODS to password protect file

Re: ODS Excel display data vertically in a report

Re: converting a date in a character field to an actual date

Re: assigning hyperlink to a variable

Re: creating hyperlinks

Re: Importing xlsx daily and appending to dataset

Re: Resolving a Macro Variable within a Macro

Re: evaluate directory for daily files

Re: proc surveyselect question