About almmotamedi

almmotamedi · ‎02-23-2016

Thank you so much

almmotamedi · ‎02-22-2016

Its simply like this: column1 column2 A B B C C D I would like to create the New_column1 as below: New_column1 A D (Because, A and D are not repeated/duplicate in the 2nd column.)

almmotamedi · ‎02-22-2016

Hi SAS users, I have two columns with the same type character values. I just want to check if there is any duplicate between thease two columns (when I say duplicate, I don't mean duplicate at each row; I mean any repeated value in both columns regardless of the order.) Could you please help with it? Thank you

almmotamedi · ‎02-19-2016

Thank you

almmotamedi · ‎02-19-2016

Hi SAS users, I am trying to match merge two data set having two common variables as below (here is a small portion of the dataset for simplicity): -------------------------------------------------- Dataset1: variable1 variable2 a 10 a 15 -------------------------------------------------- Dataset2: variable1 variable2 a 15 --------------------------------------------------- After merging, my output is like this: Merged_Dataset: variable1 variable2 a 10 a 15 ------------------------------------------------------- However, I expect the final output to be like below: Desired_Dataset: variable1 variable2 a 15 Could you please help?, the code I used is as below: data Merged_Dataset; merge Dataset1 Dataset2 ; by Variable1 Variable2; run;

almmotamedi · ‎02-16-2016

Thank you, in fact this is what had happended: Removing one extra character (') from each variable, and then using concatenation. C_ST =compress(C_ST,"'"); C_DSTRB_AREA =compress(C_DSTRB_AREA,"'"); N_RSK =compress(N_RSK,"'"); New_Variable = trim(C_ST) !! trim(C_DSTRB_AREA) !! trim(N_RSK) ;

almmotamedi · ‎02-12-2016

Its in fact : New_Variable = trim(variable 1) !! trim(variable 2) !! trim(variable 3)

almmotamedi · ‎02-12-2016

I am creating a new variable combining three different variables (all are CHARACTER) with the function below within a DATA Step. The result is a CHARACTER variable with $15. infile "/v_share/ali/sas_dataset/Calculations_Occupancy" linesize = 300 firstobs = 2 DSD ; Informat variable 1 $3.0 variable 2 8.0 . . input variable 1 $ variable 2 . . New_Variable = variable1 !! variable 2 !! variable 3 ; run; How do I change/modify the New_Variable legth to be $12 in my output?

almmotamedi · ‎02-12-2016

Hi SAS users, I am trying to combine dozens of csv files usng a wildcard code (INFILE, INFORMAT, INPUT). Although I don't get any error for my code, I get a warning that makes me concerend. Looking at the log and my csv files, it seems that (at least part of the issue) is due to inconsistant data type in some rows (see the screenshot below). Now, my question is how to ask SAS to delete/remove those rows (having inconsistant data type) while running the program? Thank you for help,

almmotamedi · ‎02-12-2016

I think I found another source of problem. Please see my attached screen shot. It shows one of my csv files .. Now, my question is how to ask SAS to DELETE any non-consistant row (with the specified data type/format) while running the code?

almmotamedi · ‎02-12-2016

Nice! I ran a test code (with only couple of variables), with NO warning infile "/v_share/ali/abcd/sas_dataset/Oct-08-2015/Calculations_Secondary_*" linesize = 300 firstobs = 2 eov = eov DSD ; Informat C_ST $3.0 C_DSTRB_AREA $5.0 N_RSK $7. COT00503D_SRVY $10.0; input @ ; if eov then do ; eov = 0 ; delete ; end ; input C_ST $ C_DSTRB_AREA $ N_RSK $ COT00503D_SRVY $; run; And I got excited! 🙂 However, when I add the other variables, I get the warning again. I am reading through the log again ...

almmotamedi · ‎02-12-2016

I think I found the cause of problem !! , it seems that every Note occures exactly for the first row of my new file (in the wildecard code). In fact, the code cannot recognize that the first row of each new file is a "header". Asuuming that it is the issue, could you please advise how to modify the code?, how to revise my INFILE statement to recognize the headers?

almmotamedi · ‎02-12-2016

Here is the what I did: I imported only one (of dozens) file using DATA IMPORT WIZARD into SAS. Then, I checked how SAS specified numeric or character types to each variable (column). Next, I wrote the wildecard code and I applied the same type (character, or numeric) for my variables. Since I had so many variables, I did this shortcut (if its a shortcut!) instead of using data dictionary.

almmotamedi · ‎02-11-2016

I run my code (Data STEP: INFILE, INFORMAT, INPUT) to combine dozens of csv files without any error. However, I get a warning as below: WARNING: Limit set by ERRORS= option reached. Further errors of this type will not be printed. When I check my log, I see these NOTES: (these are just 3 of 352 notes I get, but the NOTES are mostly similar) NOTE: Invalid data for VARIABLE1 in line 2234110 133-136. RULE: ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+----9----+----0 2234110 '13,'IN99,'000001,2/1/1999,,,,10/7/2014,1,1,X,3,3,,1,1,1,N,N,,G,0,0,15120,15120,15120,15120,15120,E, 101 ,,P,5382100000,1,3780,Floor,X,,,None,,,,,,,,,|,,,15120,15120,40,40,,40,40 173 NOTE: Invalid data errors for file '"/v_share/ali/SCOPES/sas_dataset/Oct-08-2015/ScopesCalculations_SecondaryConstruction_*"' occurred outside the printed range. NOTE: Increase available buffer lines with the INFILE n= option. . . Could you please give me some hints?, where should I start to fix this?, should I be worried about this at all? Thank you

almmotamedi · ‎02-11-2016

Thank you

Online Status	Offline
Date Last Visited	‎04-26-2016 01:04 PM

Re: Comparing same variable from two datasets

Re: Comparing same variable from two datasets

Re: Comparing same variable from two datasets

Re: Comparing same variable from two datasets

Re: Comparing same variable from two datasets

Re: Comparing same variable from two datasets

Comparing same variable from two datasets

Re: How to combine (not merge) two data sets?

How to combine (not merge) two data sets?

Re: Expansion from rows to columns?

Re: Converting date to Character

Re: How to compare values in two columns regardless of the row orders?

Re: Match Merging By Two Variables

Re: Match Merging By Two Variables

How do I write a macro to...import multiple text files that have the s...

How does "bypass data cleansing process" work in the Import Data task?

Re: How to compare values in two columns regardless of the row orders?

Re: How to compare values in two columns regardless of the row orders?

How to compare values in two columns regardless of the row orders?

Re: Match Merging By Two Variables

Match Merging By Two Variables

Re: How to modify variable length which has already been set?

Re: How to modify variable length which has already been set?

How to modify variable length which has already been set?

How to remove inconsistent data rows?

Re: Notes or Warning?

Re: Notes or Warning?

Re: Notes or Warning?

Re: Notes or Warning?

Notes or Warning?

Re: INFORMAT: How not to read (') ?