About kiranv_

Priyanka_b · ‎06-05-2017

Thanks every one for inputs! Looks like issue appeared to be with view name being different in Teradata. Modifying it resolved the syntax error.

stc200896 · ‎06-05-2017

I tried both solutions and they both worked! Thank you so much!

ayin · ‎06-04-2017

The problem has been found. Should've used double marks: "memname contains upcase("&fileName")", rather than "memname contains upcase('&fileName'). Thank you guys!

Tom · ‎06-03-2017

You cannot change the format attached to a variable from observation to obsevation any more than you could change the name of the variable from observation to observation. If you wanted to record the fact that for the second observation the time part is unknown then you need to store that information into another variable. One way you could do that would be by storing the format that you want to use to display it. Then at some point in the future you could use the PUTN() function to generate the strings that you see in column B. Or why not store the date and the time into date and time variables instead of combining them into a singel datetime variable? You could then very easily make a user defined format for the time that will display zero as blanks. You might also be able to create a user written format, most likely requiring a user written function, that will display the datetime value differently when the timepart is zero. You could then attach that new format to your numeric variable. http://support.sas.com/documentation/cdl/en/proc/70377/HTML/default/viewer.htm#n1eyyzaux0ze5ln1k03gl338avbj.htm

PaigeMiller · ‎06-03-2017

Well @Akarsh91, that's nice that you have selected my comment as the answer, but my comment was in reply to a solution from @kiranv_, who provided the code that worked. Of course, the PROC EXPAND solution I provided earlier in the thread gives the same answer, and I suspect the other solutions in this thread also give the same answer.

Ksharp · ‎06-03-2017

data have ; input id $ sp_num $ type $ date_1 yymmdd8.; format date_1 date9. ; datalines; 101 a01 p 20160102 101 a01 b 20160103 101 a01 b 20160105 102 b02 b 20160104 102 b02 b 20160105 103 c03 p 20160106 103 c03 b 20160107 103 c03 p 20160108 104 d04 p 20160102 104 d04 b 20160104 ; run; data temp; set have; by id; if first.id or last.id; run; proc sql; create table want as select * from temp group by id having count(distinct type)=2; quit;

mdsaraiv · ‎06-02-2017

Thanks, but it is not in a list, I have to grab the original questionnaire and fix it, and I want the correction to be written in sas-editor as a register so that other people will know the date was wrong and now correct. The answer of adding quotas and "d" worked well. Thanks so much for your help

Yegen · ‎06-01-2017

Thanks for the clarification, @ballardw. Also, thank you for the helpful link, @Reeza.

hhchenfx · ‎06-01-2017

OMG, great thanks to you. HC

PBsas · ‎06-01-2017

Thank you for your resposes. 🙂

kiranv_ · ‎05-31-2017

I might be better if done in netezza as where table_date=current_date-2 and create a work sas table and then run the report on it

Kurt_Bremser · ‎05-30-2017

proc sql; create table want as select year, sum(TOR) as TOR, sum(TOE) as TOE from have group by year; quit; or proc summary data=have; class year; var TOR TOE; output out=want (drop=_type_ _freq_) sum(TOR)=TOR sum(TOE)=TOE ; run;

sas_td2016 · ‎05-28-2017

Thanks a lot. Highly appreciated. This works. I will check out the link you provided for more info.

SASAna · ‎05-26-2017

Thanks for the links and tips , it is really helpful 🙂

PeterClemmensen · ‎05-25-2017

@ballardw, never knew about the indsname option. Very cool stuff, thank you 🙂

Online Status	Offline
Date Last Visited	‎08-08-2024 04:59 PM

Re: 2023 Customer Awards: ICON - Curious Thinker

Re: Macro code to iterate through list

Re: Creation of SAS library via macro variable

Re: removing the special code value

Re: Regular expression: Negative Lookahead

no overwriting of results in result window of SAS EG

Re: Floating Point Zero Divide

Re: SQL to Proc SQL

Re: ERROR: Result of WHEN clause 2 is not the same data type as the pr...

Manipulating Data in Base SAS® Part 4 – Lookup

Re: How do i list all libraries and libref in SASApp

2024 Customer Awards: Holland Numerics Ltd - Curious Thinker

Using PROC DQSCHEME Part 1: Utilizing the CREATE statement

3rd Place Winner - 2023 Customer Awards: ICON - Curious Thinker

Re: Column not Accepted when Creating Oracle Table from SAS Dataset

Re: Macro code to iterate through list

Re: Creation of SAS library via macro variable

Re: How to convert date character type to numeric?

Re: Monotonic function with group by proc sql

Re: Syntax error after migration to teradata

Re: how do I merge 2 datasets on 2 different timestamps

Re: Updating global macro variable using macros

Re: A numerical variable contains both partial and non-partial iso8601...

Re: Multiplying observations that is values in the first row by the se...

Re: Select most recent row with changed value along with the related e...

Re: Correcting dates

Re: Multiple if then / else then statement in one argument

Re: Word function Index()

Re: Roll Up Data

Re: best practice for daily query fetch date

Re: Convert Quarterly data to Annual data

Re: Date / Time Formatting Issue

Re: SAS Dataset to Oracle table merge

Re: Perform Test on Particular Variable across Multiple Data Sets

SAS Inner Circle Panel

SAS Analytics Explorers