About ANKH1

ANKH1 · ‎02-27-2023

We have this dataset. Each ID is an item sold at a store. OLD_NEW is whether the version of the item is old or new. Months is time it took for the item to sell. Type1 is equal to A if it got sold before 12 months. ID STORE OLD_NEW MONTHS type1 100 1 OLD 34 . 101 1 NEW 11 A 102 2 OLD 45 . 103 2 NEW 15 . 104 3 NEW 6 A 105 3 OLD 34 . We would like to create a variable type2 that will only be filled out if the other item in the same store had type1=A. Like the following: ID STORE OLD_NEW MONTHS type1 type2 100 1 OLD 34 . B 101 1 NEW 11 A . 102 2 OLD 45 . . 103 2 NEW 15 . . 104 3 NEW 6 A . 105 3 OLD 34 . B

ANKH1 · ‎02-27-2023

Yes, ID is each item and year is year of manufacturing. We want to determine within the same store, which item is older based on when manufacturing date (year).

ANKH1 · ‎02-27-2023

We have this dataset. There are only two items from the same store. And we want to determine items as new/old within the same store based on the year. ID YEAR STORE 100 2001 1 101 2003 1 102 1999 2 103 2004 2 104 2005 3 105 2007 3 This is the desired output ID YEAR STORE OLD_NEW 100 2001 1 OLD 101 2003 1 NEW 102 1999 2 OLD 103 2004 2 NEW 104 2005 3 OLD 105 2007 3 NEW

ANKH1 · ‎02-27-2023

I was just wondering if there should be prior step but it works great. Thanks!

ANKH1 · ‎02-24-2023

Your code worked perfectly. I was just wondering if a proc sort will be necessary in order not to mess up the pairings? Since the group variable is based on observation number?

ANKH1 · ‎02-24-2023

Thanks. We need for ID 11 and ID 12 to belong to the same unique group. ID 12 shows that it is related to ID 11 by showing in var2 that 11 is the ID it is attached to. var1 shows that ID 11 is number 1 in the list and ID 12 is number 2.

ANKH1 · ‎02-24-2023

Yes to the first two questions. No, only 2 records per group.

ANKH1 · ‎02-24-2023

group indicates that ID 11 and ID 12 are associated. var2 indicates that ID 12 is related to ID 11 (value 11).

ANKH1 · ‎02-24-2023

There is this dataset. Var1 shows the place within a group. Var2 shows the ID to which the member is related to. site ID var1 var2 1 11 2 . 1 12 1 11 2 21 2 . 2 22 1 21 2 31 2 . 2 33 1 31 We need to create a variable that shows that two IDs belong to a group. site ID var1 var2 group 1 11 2 . 1 1 12 1 11 1 2 21 2 . 2 2 22 1 21 2 2 31 2 . 3 2 33 1 31 3

ANKH1 · ‎02-23-2023

Ok, so manually change in the SAS datasets' names the "-" to "_". I didn't understand your second option. What do you mean if I cannot find one just use a number? Sorry, I'm new to programming.

ANKH1 · ‎02-23-2023

Hi, I ran the following code and the symbol "-" is not recognized. I cannot change it since I am importing more than 100 csv files with the symbol "-" in most of the file names. Is there a way for SAS to recognize the symbol? data TEST.ABC-POST; %let _EFIERR_ = 0; /* set the ERROR detection macro variable */ infile "&DATA_PATH.CSV files/ABC-POST.csv" delimiter=',' ... run; This is the log: 207 208 209 *ABC-POST variables; 210 data TEST.ABC-POST; _ 22 200 ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, (, /, ;, _DATA_, _LAST_, _NULL_. ERROR 200-322: The symbol is not recognized and will be ignored.

ANKH1 · ‎02-06-2023

Thanks! It worked.

ANKH1 · ‎02-06-2023

Sorry the semicolon was not added to the post but it was included the code when I ran it.

ANKH1 · ‎02-06-2023

Hi, I've ran proc contents. Var3 is in the dataset. Is it maybe that Var3 is type numeric but the format is YESNO? The type and format come from the imported dataset (I didn't create the dataset). How can I change the format or type? Thank you.

ANKH1 · ‎02-02-2023

1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; NOTE: ODS statements in the SAS Studio environment may disable some output features. 73 74 PROC REPORT DATA= test NOWD MISSING SPLIT='~' SPACING=2 75 style(header)=[background=white font_face=Arial font_size=8pt font_weight=bold] 76 style(column)=[background=white font_face=Arial font_size=8pt font_weight=medium] 77 style(report)=[rules=all frame=hsides cellpadding=1.2pt background=white font_face=Arial font_size=8pt 77 ! font_weight=medium]; 78 79 columns var1 var2 var3; 80 81 define var1 / display "GROUP" style(column)=[cellwidth=3.0in asis=on just=center] style(header)=[just=center]; 82 define var2 / display "NUMBER" style(column)=[cellwidth=3.0in asis=on just=center] style(header)=[just=center]; 83 define var3 / display "CHECKED" style(column)=[cellwidth=3.0in asis=on just=center] style(header)=[just=center]; 84 85 run; WARNING: var3 is not in the report definition. NOTE: There were 113 observations read from the data set WORK.test. NOTE: PROCEDURE REPORT used (Total process time): real time 0.12 seconds cpu time 0.11 seconds 86 ods rtf close; 87 title; 88 footnote; 89 90 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 103

Online Status	Offline
Date Last Visited	‎09-28-2025 09:47 AM

Re: What do when referencing a macro variable which value is 0?

What do when referencing a macro variable which value is 0?

Re: Using proc report how can you generate a pdf with repeated columns...

Re: Dataset containing only rows where DATE_DOSE2 is after DATE_DOSE1 ...

Using proc report how can you generate a pdf with repeated columns and...

Dataset containing only rows where DATE_DOSE2 is after DATE_DOSE1 by I...

Re: Median and confidence intervals missing when using proc lifetest

Re: Median and confidence intervals missing when using proc lifetest

Re: Median and confidence intervals missing when using proc lifetest

Re: Combine multiple columns into one

Re: Dataset containing only rows where DATE_DOSE2 is after DATE_DOSE1 ...

Re: Median and confidence intervals missing when using proc lifetest

Re: Filter data by multiple variables

Re: porc phreg output interpretation

Re: porc phreg output interpretation

Create a variable dependent on value from another row

Re: Create a variable a new variable based on two other variables when...

Create a variable a new variable based on two other variables when gro...

Re: Create a new variable based on other variables

Re: Create a new variable based on other variables

Re: Create a new variable based on other variables

Re: Create a new variable based on other variables

Re: Create a new variable based on other variables

Create a new variable based on other variables

Re: A symbol is not recognized and will be ignored.

A symbol is not recognized and will be ignored.

Re: PROC REPORT Warning: variable is not in report definition

Re: PROC REPORT Warning: variable is not in report definition

Re: PROC REPORT Warning: variable is not in report definition

Re: PROC REPORT Warning: variable is not in report definition