About Scott_Mitchell

Scott_Mitchell · ‎07-24-2013

You could also create a Picture Format. PROC FORMAT ; PICTURE DYYMMDD LOW-HIGH = "D"'%Y%0m%0d' (DATATYPE = DATE) ; RUN ; %LET WANT = %SYSFUNC(PUTN("&SYSDATE."D,DYYMMDD.)); %PUT ************** &WANT.; LOG: SYMBOLGEN: Macro variable WANT resolves to D20130723 ************** D20130723

Anotherdream · ‎08-08-2013

The anydtdte function (not anydate) function was the one I was looking for, thank you.

Peter_C · ‎07-22-2013

Alrernatively DTDATE9. presents dateime values in date9. style

Ksharp · ‎07-21-2013

Hi Scott, Sorry. I have no idea. All my knowledge about Perl Regular Expression is from SAS documentation -- dictionary. Ksharp

Cynthia_sas · ‎07-18-2013

Hi, What you are experiencing might be partly destination based. Without going into Macro issues or file creation issues, I made a copy of your logo called c:\temp\logo_cardiff.jpg and did not get any error messages when I ran this. And the output shows the logo in the box. Code shown in screen shot. Depending on your destination, the \\file location may not work for -every- destination, but that would be something to check with Tech Support. Inserting logos won't work in LISTING output -- I just picked PDF because the image is embedded in the PDF file. cynthia

Reeza · ‎07-18-2013

No macros needed: http://listserv.uga.edu/cgi-bin/wa?A2=ind1211e&L=sas-l&F=&S=&P=8001 Libname in 'C:\Park\bhupindertest.xlsx'; Proc contents data = in._all_ out = a noprint;; run; Data _null_ ; set a (keep = memname) end = eof;; name = compress(memname, '$'); name = translate(trim(name) , '_', ' '); str =compbl( "Data " || name || "; set in.'" || memname ||"'n;" ); Call Execute (str); if eof then do; str = 'run;'; call execute (str); end; run;

kegyp20057 · ‎07-17-2013

Hi Reeza, Hopefully, I'm replying to the correct message. I'm new to this forum. Thanks for your help. This definitely solves my problem. Karen

Scott_Mitchell · ‎07-17-2013

I agree with BallardW. This works: PROC SQL; CREATE TABLE WORK.AE_LINE_DELTA_VOC AS SELECT CL1.SEX AS SEX1, CL2.SEX AS SEX2 FROM SASHELP.CLASS CL1, SASHELP.CLASS CL2 ; QUIT; This doesn't: PROC SQL; CREATE TABLE WORK.AE_LINE_DELTA_VOC AS SELECT CL1.SEX AS CL1.SEX1, CL2.SEX AS CL2.SEX2 FROM SASHELP.CLASS CL1, SASHELP.CLASS CL2 ; QUIT; ERROR 22-322: Syntax error, expecting one of the following: a quoted string, ',', AS, FORMAT, FROM, INFORMAT, INTO, LABEL, LEN, LENGTH, TRANSCODE. ERROR 76-322: Syntax error, statement will be ignored.

Edwinl · ‎08-02-2013

Thanks Cynthia your explanation was very clear and very helpful Thank you Eddie

jakarman · ‎04-04-2014

Agree on that Andre. I made the remark on propierty format for that reason. All third party interfaces are possible based on reverse engineering. You never know hitting something they missed. As for data-exchange for incompatible systems it would be better using the XML format (adding zip) as that is designed for that purpose. My advice would be: asking for XML version of the needed data

abcd123 · ‎07-13-2013

Thank you all for great help.

Scott_Mitchell · ‎07-12-2013

That is a fantastic way to create dynamically named datasets. Thanks for posting it. I am sure this will come in handy.

mkpk · ‎07-25-2013

Thank you Very much. This has helped me a lot.

SeanZ · ‎07-10-2013

Hi Scott. You are right in this way, but a bit long in coding compared to the one solution above. Thanks anyway.

inuman · ‎07-08-2013

Thank you so much for both of your answer (Ksharp and Scott_Mitchell). I'll try your suggestion and see which one is the most efficient way. I'll be back here if I find any unresolved issues. Thank you once again. Best, Wisnu

Online Status	Offline
Date Last Visited	‎09-28-2023 08:59 AM

DI Studio SQL Merge Transformation User Guide

Re: Excel AMO - Deleting Stored Process Object and Retaining Values us...

Excel AMO - Deleting Stored Process Object and Retaining Values using ...

Re: SAS AMO - Passing Output Parameters To Excel

Re: SAS AMO - Passing Output Parameters To Excel

SAS AMO - Passing Output Parameters To Excel

Re: SAS AMO - Silent Execution of Stored Process

SAS AMO - Silent Execution of Stored Process

Re: PROC FCMP - Output Character Value Truncation

Re: PROC FCMP - Output Character Value Truncation

Re: PROC FCMP - Output Character Value Truncation

Juletip #1 - Finding Missing data

Re: Populating All Missing Variables With the Right Most Non-Missing V...

syntax for a stored procedure issue using proc sql

Re: Upcase Column headings

Re: What is the difference between PROC PRINT and PROC REPORT?

Extracting Substrings Via PRX Functions

Re: Using the IFC and IFN functions

Re: I wanted to list all library under which my dataset is present.

Re: Time stamp format help

Re: Creating a ddccmmyy macro

Re: Convert Date strings to actual dates

Re: converting datetime to date9.

Re: Remove the leading zero after converting from numeric to character...

Re: Load .jpeg into proc tabulate "box="

Re: Macro function which can read Excel spreadsheets with multiple tab

Re: Can I use SAS to create a report on the number of valid and missin...

Re: Syntax Error

Re: missing values/ counting line of data

Re: How to load sas7bdat without SAS installation?

Re: SAS index function

Re: Slicing a SAS datset

Re: Calculating the observations

Re: How to drop observations with counts less than a number

Re: Help with merging

SAS Community Nordic

SAS Analytics Explorers