cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Ovaty
‎06-19-2019
  • 10 Posts
  • 3 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: PROC TRANSPOSE from Wide to Long

by Fluorite | Level 6 in New SAS User
‎06-18-2019 01:30 PM
‎06-18-2019 01:30 PM
Hi Kurt, thanks for your fast response, but I've no success yet!   Look the result:   Material YYMM OD ID ord COL2 COL3 COL4 110411 201808 533425 10 BA00020902 BA00020906 BA00020915   110411 201808 533425 10 AC15870200 AC15870600 AC15894100   110411 201901 539757 20 BA00023631 BA00023638 BA00023679 BA00023682 110411 201901 539757 20 AC16139200 AC16139900 AC16193100 AC16193400 ... View more

PROC TRANSPOSE from Wide to Long

by Fluorite | Level 6 in New SAS User
‎06-18-2019 09:56 AM
‎06-18-2019 09:56 AM
Hi guys, good Morning !   I need to do a transpose table only by some variables. I've try and has no success.   Base table Material YYMM OD ID ORD_1 ORD_2 ... ORD_23 110411 201808 533425 10 BA00020902 AC15870200     110411 201808 533425 10 BA00020906 AC15870600     110411 201808 533425 10 BA00020915 AC15894100     110411 201901 539757 20 BA00023631 AC16139200     110411 201901 539757 20 BA00023638 AC16139900     110411 201901 539757 20 BA00023679 AC16193100     110411 201901 539757 20 BA00023682 AC16193400       Want table Material YYMM OD ID ORD 110411 201808 533425 10 AC15870200 110411 201808 533425 10 AC15870600 110411 201808 533425 10 AC15894100 110411 201808 533425 10 BA00020902 110411 201808 533425 10 BA00020906 110411 201808 533425 10 BA00020915 110411 201901 539757 20 AC16139200 110411 201901 539757 20 AC16139900 110411 201901 539757 20 AC16193100 110411 201901 539757 20 AC16193400 110411 201901 539757 20 BA00023631 110411 201901 539757 20 BA00023638 110411 201901 539757 20 BA00023679 110411 201901 539757 20 BA00023682   Thanks a lot! Gustavo ... View more

Re: Colum ordenation to make a sequence - Enterprise Guide

by Fluorite | Level 6 in New SAS User
‎06-05-2019 03:08 PM
‎06-05-2019 03:08 PM
Hi Ksharp, I've send a example file. ... View more

Re: Colum ordenation to make a sequence - Enterprise Guide

by Fluorite | Level 6 in New SAS User
‎06-05-2019 12:02 PM
‎06-05-2019 12:02 PM
Great Ksharp! Tks a lot. One last question... How can I put each values like A|B|C|D in each column? Gustavo. ... View more

Re: Colum ordenation to make a sequence - Enterprise Guide

by Fluorite | Level 6 in New SAS User
‎06-05-2019 08:30 AM
‎06-05-2019 08:30 AM
Hi Tom! I'm not trying to traverse any graph. The data is a trail, looks like a production sequence. To make a car, I've to do many steps and after all steps I've the production sequence. Did you understood my explanation? Is it clear? ... View more

Colum ordenation to make a sequence - Enterprise Guide

by Fluorite | Level 6 in New SAS User
‎06-04-2019 04:19 PM
‎06-04-2019 04:19 PM
Hi everybody! Good afternoon.   Today I've a issue to solve in my job. I've a database that have 2 columns to ordinate them into a sequence. The colum t0 (is the origin) and t1 (is the receptor). I need to do a program to make a sequence linked t0 to t1.   Let's show you my example:     t0 t1 Line 1 H G Line 2 B A Line 3 P O Line 4 C B Line 5 Q P Line 6 I H Line 7 D C Line 8 R Q Line 9 J I   I need to create 3 sequences (in order origin-receptor) in this example. Like this:   seq1 A B C D seq2 G H I J seq3 O P Q R     Thaks a lot to everyone!! Gustavo. ... View more

Re: Link between 3 tables - and no register found

by Fluorite | Level 6 in SAS Enterprise Guide
‎05-14-2019 09:26 AM
‎05-14-2019 09:26 AM
If 201810 was the present month, we have to consider that.   The rule is: t1.anomes is the main KEY. If I found the similar date in t2, great. But if I did't find similar date in t2, I must consider the present month in t2.   @PeterClemmensen wrote: What if 201810 was actually present in t2?     ... View more

Link between 3 tables - and no register found

by Fluorite | Level 6 in SAS Enterprise Guide
‎05-14-2019 08:59 AM
‎05-14-2019 08:59 AM
Hi guys, good morning!   I have 3 tables like below (t1, t2 and t3) t4 is the result that I want to do.    How can I link t1 -> t2 -> t3, when the t1.anomes is not found in t2.anomes. In this case I must consider the current month (201905-2019 Q2).   After that I find the cars in t3, based on t2.quarter (2019 Q2).   t1   t2     t3     t4 result   anomes   anomes quarter   quarter car   t1.anomes t3.car 201810   201901 2019 Q1   2019 Q1 BMW   201810 Nissan     201902 2019 Q1   2019 Q1 MB   201810 Ferrari     201903 2019 Q1   2019 Q1 Posrche   201810 Audi     201904 2019 Q2   2019 Q1 Tesla   201810 VW     201905 2019 Q2   2019 Q1 Jaguar   201810 Mazda     201906 2019 Q2   2019 Q2 Nissan           201907 2019 Q3   2019 Q2 Ferrari           201908 2019 Q3   2019 Q2 Audi           201909 2019 Q3   2019 Q2 VW           201910 2019 Q4   2019 Q2 Mazda           201911 2019 Q4                 201912 2019 Q4               Thanks a lot ! Gustavo. ... View more

Re: Merge/Transpose Help - Some column must be fixed

by Fluorite | Level 6 in New SAS User
‎04-03-2019 03:37 PM
‎04-03-2019 03:37 PM
Yes, its great!!   Thanks a lot!! ... View more

Merge/Transpose Help - Some column must be fixed

by Fluorite | Level 6 in New SAS User
‎04-02-2019 04:34 PM
‎04-02-2019 04:34 PM
Hi everybody!   I need your help to solve my issue. I need to do a merge/transpose column and leave some columns fixed.   Ex.: Car State City Part1 Part2 Part3 Part4 BMW MI Detroit 1 2 3 4 BMW MI Detroit 5 6 7 8 BMW MI Detroit 9 10 11 12 Jaguar UT SLC 20 21 22 23 Jaguar UT SLC 24 25 26 27 Jaguar UT SLC 28 29 30 31   I need this exit below for BMW: Car State City Part BMW MI Detroit 1 BMW MI Detroit 2 BMW MI Detroit 3 BMW MI Detroit 4 BMW MI Detroit 5 BMW MI Detroit 6 BMW MI Detroit 7 BMW MI Detroit 8 BMW MI Detroit 9 BMW MI Detroit 10 BMW MI Detroit 11 BMW MI Detroit 12   Thanks a lot!!! Gustavo. ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎06-19-2019 06:27 PM
Likes given to
View All
Quick links