About Steelers_In_DC

Steelers_In_DC · ‎09-07-2012

What I'm trying to do is get a response for each variable independently of the others, I can write each variable separately in it's on proc sql; but there are over 500 variables that I'm trying to do this with so I didn't want to do that. It will be too much text and take too much time when I try to put them all together after.

Steelers_In_DC · ‎09-07-2012

I hope I'm not being too much of a bother but I have one more question. If you understand what I'm trying to do, have each one of the when/then statements as independent statements, is it possible to do that without writing each variable in it's on proc sql; statement? I'd like to put an end at the end of each line, so I can have all of the individual statements combined into the lacs column. I guess this is not the best way to go about that.

Steelers_In_DC · ‎09-07-2012

That is very helpful, what I am attempting to do is get one variable named 'LACS', then I'm running a proc freq and seeing how the count changes over time. I'm still not sure why the order would change, all of the variables are unique to the naming convention. I was thinking of 'when/then' statements as if it was if/then/end, running them in my mind independently of each other. I have a lot of work to get back through editing. Thanks for help.

Steelers_In_DC · ‎09-07-2012

I split the above code into three sections by variables, then put them back together in a data step formatting lacs to a reasonable length. That gets me the result that I was looking for. I still don't understand why the first code didn't work. I question what I've been doing up until this point and wonder if I've been missing errors in the past. Do you see anything in the original code that would prevent the desired results?

Steelers_In_DC · ‎09-07-2012

I'm not sure I understand, when 'g' then 'general delivery', if it's not g it has to be one of the other options given, else 'missing'. I noticed after I posted that I use 's' twice but they are for two different variables so I didn't think that would matter. the resulting field lacs isn't meaningful. I picked it randomly to give the field a name. Does that matter? Go Steelers

Steelers_In_DC · ‎09-07-2012

Hello, I've been putting together some information with the assumption I was using select case correctly. It has seemed to be working but is not in this specific case. The variable names and titles I'm using are very different in length, in the past they have not been. I've gone back to verify that what I have been doing has been working and it seems that it has been but in this case it is not: PROC SQL; create table test as select case when lacslink_addr_typ = 'G' then 'General Delivery' when lacslink_ind = 'S' then 'Secondary number dropped' when lacs_ind = 'L' then 'Lacs Hit' when lacslink_ind = 'Y' then 'LacsLink Match' when lacslink_ind = 'N' then 'No Match' when lacslink_ind = 'F' then 'False Positive' when lacslink_addr_typ = 'S' then 'Street Address' when lacslink_addr_typ = 'F' then 'Firm' when lacslink_addr_typ = 'H' then 'High Rise' when lacslink_addr_typ = 'R' then 'Rural Route' when lacslink_addr_typ = 'P' then 'PO Box' else 'Missing' end as LACS from prd_eds.v_address_household where ver_start_day_key <= &prev_lock and ver_end_day_key > &prev_lock; I am doing this to combine two dates, then merge and get the difference in between the two. I'm not getting the desired results and I'm wondering why. The only thing I can think of that is different is the length so I've moved around the order and it changes the results but still never gives the desired results. I'm wondering if I've been wrong about the syntax or the purpose of this exercise all along. Any help will be appreciated. Thank You,

Steelers_In_DC · ‎08-13-2012

Thanks for the help last week, I thought I'd follow up with you and let you know what I found, unfortunately I had you on a wild goose chase, there is nothing wrong with the hash code, the issue was elsewhere in code that I did not post for propriety reasons.

Steelers_In_DC · ‎08-08-2012

I looked at that dataset and it hasn't been changed for years while this code is run weekly. I'm going to replace the hash with a data step merge to verify that it's the hash that's causing the issue. I can't find anything wrong with it and I suppose it could be something else, it's only these variables that change from one run to the next so I wanted to start here. Thanks so much for taking a look.

Steelers_In_DC · ‎08-08-2012

I checked and all of the anly_seg_keys are unique.

Steelers_In_DC · ‎08-08-2012

I think the hash is used so sort doesn't matter, unless something was actually manipulating the table it shouldn't matter.

Steelers_In_DC · ‎08-08-2012

Would the hash itself sort that dataset? I'm not sure, is there another method I can use rather than replace to check what your theory is?

Steelers_In_DC · ‎08-08-2012

Hello, I am new to using hash and doing most of my learning while troubleshooting old code. The following code has been used for a while, this is a small segment of a much larger piece. If I run the code more than once the variables that start with 'pre' will not be consistent, meaning the code doesn't do the same thing two times in a row. If anyone can look at this and see what the issue is I will be very appreciative. I'm going to keep looking through sas papers and try to find the issue myself as well. I'm not able to add this as a word doc so I added it as a pdf, if you would like it in any other format let me know. I'll also paste it below: Thanks, ********************************************************************************; *** MERGE MIGRATION DATA WITH DISCO AND SEGMENT TABLES ***; ********************************************************************************; DATA WORK.&FILE_TYPE._&START_DATE._2; LENGTH ABB_CORE_SEGMENT ABB_CORE_SEGMENT_2 ABB_CORE_SEGMENT_3 $16 PSU_VIDEO PSU_HSD PSU_DP MDS 3. VIDEO HSD DP ABB_LVL_1 $8; DECLARE HASH SEG(); RC = SEG.DEFINEKEY ('ANLY_SEG_KEY'); RC = SEG.DEFINEDATA ('ABB_CORE_SEGMENT', 'ABB_CORE_SEGMENT_2', 'ABB_CORE_SEGMENT_3', 'ABB_LVL_1', 'PSU_VIDEO', 'PSU_HSD', 'PSU_DP', 'MDS', 'VIDEO', 'HSD', 'DP'); RC = SEG.DEFINEDONE(); DO UNTIL (EOF_SEG); SET TWR0TXV.ANALYSIS_SEGMENT END = EOF_SEG; RC = SEG.REPLACE(); END; DO UNTIL (EOF_UNIVERSE); SET WORK.&FILE_TYPE._&START_DATE._1 END=EOF_UNIVERSE; *PRODUCT HOLDING DETAILS*; ABB_CORE_SEGMENT=''; ABB_CORE_SEGMENT_2=''; ABB_CORE_SEGMENT_3=''; ABB_LVL_1=''; PSU_VIDEO=.; PSU_HSD=.; PSU_DP=.; MDS=.; VIDEO=''; HSD=''; DP=''; RC=SEG.FIND(); /* POST IS USED IN 1ST PASS FOR RC-AD, PRE IS USED FOR RD-DD */ IF SEG.FIND()=0 THEN POST_SGMNT_MATCH = 'Y'; ELSE POST_SGMNT_MATCH = 'N'; RENAME ABB_CORE_SEGMENT = POST_ABB_CORE_SEGMENT ABB_CORE_SEGMENT_2 = POST_ABB_CORE_SEGMENT_2 ABB_CORE_SEGMENT_3 = POST_ABB_CORE_SEGMENT_3 ABB_LVL_1 = POST_ABB_LVL_1 PSU_VIDEO = POST_PSU_VIDEO PSU_HSD = POST_PSU_HSD PSU_DP = POST_PSU_DP MDS = POST_MDS VIDEO = POST_VIDEO HSD = POST_HSD DP = POST_DP; OUTPUT; END; STOP; RUN; DATA WORK.&FILE_TYPE._POST_TRANSACTIONS_2_&END_DATE.; LENGTH ABB_CORE_SEGMENT ABB_CORE_SEGMENT_2 ABB_CORE_SEGMENT_3 $16 PSU_VIDEO PSU_HSD PSU_DP MDS 3. VIDEO HSD DP ABB_LVL_1 $8; DECLARE HASH SEG(); RC = SEG.DEFINEKEY ('ANLY_SEG_KEY'); RC = SEG.DEFINEDATA ('ABB_CORE_SEGMENT', 'ABB_CORE_SEGMENT_2', 'ABB_CORE_SEGMENT_3', 'ABB_LVL_1', 'PSU_VIDEO', 'PSU_HSD', 'PSU_DP', 'MDS', 'VIDEO', 'HSD', 'DP'); RC = SEG.DEFINEDONE(); DO UNTIL (EOF_SEG); SET TWR0TXV.ANALYSIS_SEGMENT END = EOF_SEG; RC = SEG.REPLACE(); END; DO UNTIL (EOF_UNIVERSE); SET WORK.&FILE_TYPE._PRE_POST_TRANSACTIONS_&END_DATE. END=EOF_UNIVERSE; *PRODUCT HOLDING DETAILS*; ABB_CORE_SEGMENT=''; ABB_CORE_SEGMENT_2=''; ABB_CORE_SEGMENT_3=''; ABB_LVL_1=''; PSU_VIDEO=.; PSU_HSD=.; PSU_DP=.; MDS=.; VIDEO=''; HSD=''; DP=''; RC=SEG.FIND(); /* PRE IS USED IN 2ND PASS FOR RC-AD, POST IS USED FOR RD-DD */ IF SEG.FIND()=0 THEN PRE_SGMNT_MATCH = 'Y'; ELSE PRE_SGMNT_MATCH = 'N'; RENAME ABB_CORE_SEGMENT = PRE_ABB_CORE_SEGMENT ABB_CORE_SEGMENT_2 = PRE_ABB_CORE_SEGMENT_2 ABB_CORE_SEGMENT_3 = PRE_ABB_CORE_SEGMENT_3 ABB_LVL_1 = PRE_ABB_LVL_1 PSU_VIDEO = PRE_PSU_VIDEO PSU_HSD = PRE_PSU_HSD PSU_DP = PRE_PSU_DP MDS = PRE_MDS VIDEO = PRE_VIDEO HSD = PRE_HSD DP = PRE_DP; OUTPUT; END; STOP; RUN;

Steelers_In_DC · ‎07-25-2012

This is a beginner's questions. I'm wondering what the syntax error in the following is: data work.ds2; array Response{*} a b c d e; run; data ds2; set ds2; input; datalines; 1 2 3 4 5 ; run; I don't know why the 1 2 3 4 5 isn't entering in the the original table. I tried it with/without input; with no luck. Thanks for any help.

Steelers_In_DC · ‎07-19-2012

Thanks so much. That is exactly what I needed!

Steelers_In_DC · ‎07-19-2012

I am trying to generate two separate do loops within one macro. Anytime I get it to go through it goes like an array which I do not want. Without a macro the code looks like this: data cus_hsd_&month1; set cus_hsd_&month1; format ver_start_day_key ver_end_day_key 8.; ver_start_day_key= &lock1; ver_end_day_key= &lock0; run; I have 18 of these which I'd like to do in one step, I want the start date to be separate from the end date (the last two lines) I'm not sure how to do that so I tried it with two do loops: %macro ver_dates; %do sd=1 %to 17; data cus_hsd_&&month&sd; set cus_hsd_&&month&sd; format ver_start_day_key ver_end_day_key 8.; ver_start_day_key = &&lock&sd; %do ed=0 %to 16; ver_end_day_key = &&lock&ed; %end; run; %end; %mend; %ver_dates; I've tried it many different ways, anytime it does work it's an array and the only date saved is the last date that ran. The first do loop runs through with every step, the last do loop runs at the very end and the last date is saved for every end_day_key. Any help or suggestions will be appreciated. I'm not sure if I'm going about this the right way at all, just trying to neaten up some code in my spare time. Thanks,

Online Status	Offline
Date Last Visited	‎07-12-2025 12:12 PM

sql server using 'with'

Re: hive show table and column

hive show table and column

proc sql using or

find edge node

Re: Fill in rows with previous value if next value is the same.

Re: Fill in rows with previous value if next value is the same.

Re: Fill in rows with previous value if next value is the same.

Fill in rows with previous value if next value is the same.

Re: reg ex extract

Re: proc sql using or

Re: Adding quotes to a Macro Variable

Re: How to run a program in EG5.1 without connecting to a server

Re: macro variable in set statements based on today()

Finding all single linked chains: the allChains macro

find edge node

infile 'red x' with no error in log

Re: Extracting Month, Year and quarter

Re: Which Date function can be used to extract month(Character) from t...

Re: How to assign a column value based on another column ??

Re: proc sql; select case - end

Re: proc sql; select case - end

Re: proc sql; select case - end

Re: proc sql; select case - end

Re: proc sql; select case - end

proc sql; select case - end

Re: Hash Check

Re: Hash Check

Re: Hash Check

Re: Hash Check

Re: Hash Check

Hash Check

datalines into an existing dataset

Re: two do loops in one macro

two do loops in one macro