About eagles_dare13

eagles_dare13 · ‎07-30-2014

I know that "Informat 8.2 has width of 8, 5 digits before decimal one for decimal and remaining two after decimal"...but question is different..how come 8. and 8.2 are same as suggested by the article?

eagles_dare13 · ‎07-30-2014

In this paper: http://support.sas.com/publishing/pubcat/chaps/59498.pdf This pharagraph: Line 3 uses the numeric informat 8.2. The w.d informat provides instruction to read the numeric data having a total width of 8 (8 columns) with two digits to the right of the decimal point. SAS will insert a decimal point only if it does not encounter a decimal point in the specified w columns. Therefore, we could have coded the informat as 8. or 8.2. How come 8. and 8.2 are the same? 8. will truncate the decimal portion of the input, correct?

eagles_dare13 · ‎07-29-2014

I am using Di Studio 4.4 and I get this error on a job from time to time when I open it: 40008 - "This job has changed since it was last opened" message displays when opening a SAS® Data Integration Studio 4.21 job Before installing a fix, I just wish to know what is the cause of this error. Thank you!

eagles_dare13 · ‎07-28-2014

yes Iam using DI. Is there a way to get around this?

eagles_dare13 · ‎07-28-2014

I have this code: proc append base = s1 (COMPRESS = YES) data = WORK.s2 () force ; MPRINT(ETLS_LOADER): run; I get: NOTE: Appending WORK.s2 to s1. ERROR: Attempt to append a view to itself. Now how am I appending view to iself...I did not write proc append base = s1 data = s1...so what is the problem. It is true that s2 is a dataset that is 'derived' from s1 throguh a series of transformations....but is that a problem?

eagles_dare13 · ‎07-24-2014

When I write: %let x = 0.32; How can I make sure that x is initialized as a numeric variable and not a character variable? I want to be able to do numerical operations on x.

eagles_dare13 · ‎07-23-2014

Thanks. I changed the example slightly and it still does not work after putting semi colon. data test; INFILE DATALINES DSD ; INFORMAT varname $32.; INPUT varname $ var1 var2 var3; DATALINES; "test",,,1 "test",,624.5,1 "test",624.5,741.5,2 ; run; Does not work as in only some fields are being read...not all.

eagles_dare13 · ‎07-23-2014

When I run: data test INFILE DATALINES DSD; INFORMAT varname $32.; INPUT varname $ var1; DATALINES; "ALPHA",-3.64693629 "BETA1",-0.584778408 "BETA2",-0.808085584 ; run; Why do I get 3 blank records as output?

eagles_dare13 · ‎07-10-2014

What function can I use to change: 2014-07-09 11:42:34:826 --> 2014-07-09 11:42:35:000 i.e round the millisecond to the nearest second and put 000 in the millisecond portion. I need to use the rounded value in a join condition.

eagles_dare13 · ‎07-04-2014

If I am reading data from a comma separated text file and in my input step i declare 5 columns and if in the input file there are only 3 comma separated values, will I get exception? Or will the resultset be created with 5 columns with 3 columns populated and the other columns as null?

eagles_dare13 · ‎06-25-2014

If I have a SAS transformation Step like Join/Extract and I use the Mappings tab to map Source and Target tables, and I go to 'Code' tab , I can see generated code. When I switch to 'User Written Body' from 'Automatic' I can put in my own code that overrides those mappings. The default mappings are greyed out. I know that when I run it, the code written by me will be executed over the one greyed out in 'User Written Body'. The thing is, I was expecting the greyed out code to be commented, I just want to confirm that the greyed out code will be ignored.

eagles_dare13 · ‎06-13-2014

Some times in SAS Data Integration Studio, there will be a step (e.g a SQL JOIN) that will show some mappings when you click on 'Select' on the right hand navigation menu inside the step. But then if you go to 'Code' tab, there will be code that overrides those mappings with different mappings. In this case, at execution time, will the program executed what is in hte 'Code' tab or what is on the 'Mapping' tab?

eagles_dare13 · ‎05-30-2014

I have: proc sql; select COL1, count(distinct COL2 ) as cnt from TBL group by COL1; quit; If TBL contains: col1 col2 A A XX Then my output says: col1 cnt A 1 But the cnt should be 2. Why is it neglecting the null value?

eagles_dare13 · ‎05-27-2014

I am trying to use a SAS channel to publish a message with an xls attachment. Once published, users subscribed to that channel will get an email with the attachment. I am not able to find the sample code to do it. Can anyone please help me here?

eagles_dare13 · ‎05-22-2014

When SAS concatenates data sets with the union all statement and each data set has the exact same column names and column data types, will SAS use the ordering of the columns to figure out the corresponding columns or the actual names?

Online Status	Offline
Date Last Visited	‎11-27-2015 06:07 PM

What can a stored process do that a normal SAS program cannot

What ML algorithms are part of base SAS

SAS global macro variable not being resolved

How to use a sql statement ina DATA step

Re: How to simulate a Weiner process in SAS

Re: How to generate a list of random numbers in SAS

How to simulate a Weiner process in SAS

Re: How to generate a list of random numbers in SAS

How to generate a list of random numbers in SAS

Re: How to convert to char from numeric without losing decimals

Re: SCD Type 2 Loader vs Change Data Capture

Re: SCD Type 2 Loader vs Change Data Capture

Re: What is the use of 'Propagate Columns' feature in SAS DI studio

machine learning using base SAS

How to send SAS email to multiple people

Re: SAS informat with decimal

SAS informat with decimal

This job has changed since it was last opened

Re: Attempt to append a view to itself

Attempt to append a view to itself

SAS let statement defines the variable as character or numeric

Re: SAS datalines not reading properly

SAS datalines not reading properly

How to round up a date to nearest second

Input file has less columns than what is defined in input step of sas ...

Will greyed out code be ignored in 'User Written Body' in SAS DIS

DI studio has different mappings in Mapping tab as compared to Code ta...

SAS sql not counting null values

SAS publish message with attachemnt to a channel

Re: How to append data and remove duplicates in SAS with some constra...