About Angel_Saenz

Angel_Saenz · ‎09-12-2022

thanks

Angel_Saenz · ‎09-10-2022

thanks ll the variables var var2 and var3 have duplicate, thats is ok, because I need is no is the duplicate value in combination of that three So there is no way to establish a unique to 3 variables together unless you do not have duplicates?

Angel_Saenz · ‎09-10-2022

Hi everyone, Is it possible to create unique index on more than one variable? For example I need unique index in three variables: proc datasets library=lib1; modify dataset1; index create var1 / unique; index create var2 / unique; index create var3 / unique; run; the problem with that code is that it gives me an error since only one can have the only one ERROR: Duplicate values not allowed on index var1 for file dataset1 and it's okay for var1 to have duplicates but not in combination with var2 and var3 I thought about concatenating var1, var2, var3 and giving that variable the unique index but I want to see if it is possible to do it directly in those 3 variables. Because I need that dataset not to have duplicates by combining those 3 variables Thanks

Angel_Saenz · ‎02-07-2019

ds2 coud be a report novinosrin

Angel_Saenz · ‎02-07-2019

I see PRODUCT A and PRODUCT B move to wrong way I need both products have both incomes like: PRODUCT A incomeA incomeB

Angel_Saenz · ‎02-07-2019

Hi, I know some steps to do it but I want to find best. I need to convert ds1 to ds2: ds1 product INCOME 1 INCOME 2 A 10 100 A 20 200 B 40 300 B 70 600 B 40 900 ds2 PRODUCT A PRODUCT B INCOME 1 AVG INCOME 2 AVG INCOME 1 AVG INCOME 2 AVG 15 150 50 600 is it possible with only one step? proc freq? summary? thanks

Angel_Saenz · ‎01-21-2019

Is it possible to use proc freq as like in proc sqp gruoup by? using some variables and counting? because if I use this: proc freq data=ds; table var1 var2; run; that creates two separate tables and what I want is to combine var1 and var2

Angel_Saenz · ‎12-26-2018

I need a list of all datasets in a library but showing number of observations of each one Like: proc datasets library=libname; run; But showing the number of observations of all datasets. Do you know if exists a proc for that? thanks

Angel_Saenz · ‎12-06-2018

Is there a function to round tens down? example data 111 1499 15251 data I want 100 1400 15200 but do not using /100 and after *100 I want if exits a function that simplifies it please

Angel_Saenz · ‎11-15-2018

I need some way to show all the datasets of a library showing the access permission of each dataset like but adding access permission: proc datasets library=inf; run; like: # Name Member Type File Size Last Modified Access Permission 1 DS1 DATA 2MB 10/22/2018 12:54:50 rw-rw-r-- 2 DS2 DATA 1MB 10/22/2018 12:54:50 rw-rw-r-- 3 DS3 DATA 1MB 10/22/2018 12:54:50 rw-rw-r-- Is it possible? thanks

Angel_Saenz · ‎02-22-2018

Let me try it SuryaKiran, I accepted other your answer, thanks a lot

Angel_Saenz · ‎02-22-2018

let me try your solution SuryaKiran I look a PROC SQL too because I have other plataform and in there only works SQL

Angel_Saenz · ‎02-22-2018

Thanks for your answer, but no, I dont want increment the account_number, I have a dataset with some account numbers that are not unique, some like this: account_number 1 1 1 2 3 3 3 3 4 4 4 So I want count this for each account_number: account_number var_I_WANT 1 1 1 2 1 3 2 1 3 1 3 2 3 3 3 4 4 1 4 2 4 3

Angel_Saenz · ‎02-22-2018

Hi, how can I generate a variable that consecutively counts the variable id? If I have a dataset where account_number is not unique. Example I want: varCONS account_number 1 1 2 1 1 2 2 2 3 2 1 3 1 4 2 4 3 4 4 4 If you can help me with two metods, data step and proc sql could be great, thanks

Angel_Saenz · ‎09-28-2017

I have 2 datasets: data dataset1; INPUT VAR1 VAR2 $; cards; 1 A 1 AB 1 ABC 2 A 2 AB 2 ABC ; RUN; data dataset2; INPUT VAR1 VAR2 $; cards; 1 Z 1 ZY 1 ZYX 2 Z 2 ZY 2 ZYX ; RUN; I need this result (one-to-many merge): VAR1 VAR2 VAR3 1 A Z 1 A ZY 1 A ZYX 1 AB Z 1 AB ZY 1 AB ZYX 1 ABC Z 1 ABC ZY 1 ABC ZYX 2 A Z 2 A ZY 2 A ZYX 2 AB Z 2 AB ZY 2 AB ZYX 2 ABC Z 2 ABC ZY 2 ABC ZYX Im doing this with this proc: PROC SQL; SELECT DATASET1.VAR1, DATASET1.VAR2, DATASET2.VAR2 AS VAR3 FROM DATASET1 INNER JOIN DATASET2 ON DATASET1.VAR1 = DATASET2.VAR1; RUN; But I want to know the most easy way to do it with SAScode, with DATA STEP How can I do it?

Online Status	Offline
Date Last Visited	‎09-12-2022 03:25 PM

Re: index unique in more than one var

Re: index unique in more than one var

index unique in more than one var

Re: Easy way to comvert ds1 to ds2

Re: Easy way to comvert ds1 to ds2

Easy way to comvert ds1 to ds2

proc freq like group by

List of all datasets in a library showing number of observations of ea...

round tens

All datasets of a library with access permission

Re: index unique in more than one var

Re: Easy way to comvert ds1 to ds2

Re: Easy way to comvert ds1 to ds2

Re: Easy way to comvert ds1 to ds2

Re: proc freq like group by

Re: index unique in more than one var

Re: index unique in more than one var

index unique in more than one var

Re: Easy way to comvert ds1 to ds2

Re: Easy way to comvert ds1 to ds2

Easy way to comvert ds1 to ds2

proc freq like group by

List of all datasets in a library showing number of observations of ea...

round tens

All datasets of a library with access permission

Re: variable consecutively counts account_number

Re: variable consecutively counts account_number

Re: variable consecutively counts account_number

variable consecutively counts account_number

Most easy way to do one-to-many in SAS, (DATA steep)