About Smitha9

Smitha9 · ‎11-04-2020

Hi, I have a dataset which has duplicates and I will be removing the duplicates and want to report the record of the observations before and after removing the duplicates. Is there a code which I can do all together(before and after duplicates) thank you in advance.

Smitha9 · ‎11-03-2020

Hi, I have a variable name format Chicago Michigan Boston Ohio New dataset has the following variable name: Chicag Michigan Bostor Ohid I need to compare this dataset with the above formatted variable name and report the errors. Can I code this one? thank you in advance

Smitha9 · ‎11-03-2020

I receive the SAS dataset

Smitha9 · ‎11-03-2020

I will be getting the dataset everyweek which contains specific varaibles. I have the check the errors and report it. Example: Dataset has a variable names: CustomerID CustomerAge CustomerDOB Purchase Type Model 1111 70 10/20/1990 Cartel Eco X The errors I need to check with the above dataset: 1. Check the order of the variables of the dataset. Make sure the order is exactly like above. 2. Check the spelling of the variable names. 3. Any missing values flag it and report. 4. Check the CustomerAge if negative and if negative flag it. thank you in advance.

Smitha9 · ‎11-03-2020

Hi, this is an example I gave. My dataset has around 4 variables. Lets say if we have A B C D. This dataset gets new values everyweek and gets formatted everyweek. I need to check the order of the variable names are correct and if there is a problem with the order of the variable names I need to flag it. thanks

Smitha9 · ‎11-03-2020

Hi, I have a dataset which includes the variable names: A B C D the above dataset need to format once in a week. Everyweek I have to check the order of the variables A B C D If D comes first or the order changes I need to flag it. The order must be A B C D order. Can I know the code for this. thank you in advance. -Smitha

Smitha9 · ‎11-03-2020

Variable names.

Smitha9 · ‎11-03-2020

Hi, I have a variables list A B C D Everytime when I get the data and formatted. I need to check the order is correct. If D comes first then I need to flag it. The code needs to check the order of the variables "A B C D" how can I do that? thank you in advance. -Smitha

Smitha9 · ‎09-08-2020

ID Want 1 11 1 11 1 11 2 12 2 12 3 13 4 14 5 15 I have an ID which has numbers upto 5 and I want create a new variable starting with 11 and should correlate with variable ID ( example if ID=1 then the want=11) can you help me with this. there are repetitive numbers as well. 5

Smitha9 · ‎07-30-2020

Hi, I have a data example: ID 1 20 345 4654 I want to make the above ID to 5digits by filling the initial digits with Zero. Example: ID 00001 00020 00345 04654 can anyone help me with this? thank you in advance

Smitha9 · ‎07-29-2020

Hi, I have a dataset ID 2000032 2000072 2000092 I want the dataset: ID 0003 0007 0009 I want to remove first 2digits and last one digit. Can anyone help in this. thank you

Smitha9 · ‎07-22-2020

Hi, I have repetitive ClassID and I want to give seperated ID per classID. ClassID ID 1 1 1 2 1 3 2 1 2 2 2 3 I want create ID's like above using the classID. can anyone help me with this? thank you in advance

Smitha9 · ‎07-07-2020

I created Random ID's lets say: 34567,45678,62398,72345,56183,26532 SO the first 3 I already took it for CheckID. But I want the remaining 3 randomID assigned to S.NO. I want like this below: ID checkID S.NO 1 34567 2 45678 3 62398 72345 1 56183 2 26532 3

Smitha9 · ‎07-07-2020

So I created 99999 randomID's and saved it. I am taking the randomID's from the saved ones to assign checkID. ID checkID S.NO 1 34556 2 45678 3 67873 1 2 3 I want to fill these checkID from the randomID continue.

Smitha9 · ‎07-07-2020

Hi , I have dru-26-12345 pru-26-56743 I want to change 26 to 34 dru-34-12345 pru-34-56743 please let me know. thank you

Online Status	Offline
Date Last Visited	‎03-11-2025 07:45 PM

format date with underscore

Age

formatting to mm-dd-yyyy HH:MM

Left join conditions

Re: SQL to SAS Code

SQL to SAS Code

Re: numeric Date change the format

numeric Date change the format

date format with dashes

date and time format

Re: dateformat

report number of abservation before and after removing the duplicates

compare the variable name and find the errors if any

Re: check the errors and report it

check the errors and report it

Re: check the order of the variables

check the order of the variables

Re: check the order of the variables

check the order of the variables

same ID

fill the digits with zero

remove last one digit and first two digits from a number

serial ID

Re: random ID

Re: random ID

replace