About Soham0707

Soham0707 · ‎02-02-2021

Thank you so much Ksharp. it's working.

Soham0707 · ‎02-02-2021

Thanks PeterClemmensen. I have more than 1000 datasets to copy based on the name. Is there any other way to do this without datalines or cards statement? I have provided an example that describes the scenario.

Soham0707 · ‎02-02-2021

Hello, I need to copy the dataset from one library to another but it is based on the prefix of the dataset name. For example; I have library “Libref_all” and I have below datasets in this library, Libref_all A_DM1.sas7bdat A_DM2.sas7bdat A_DM3.sas7bdat A_DM4.sas7bdat B_DM1.sas7bdat B_DM2.sas7bdat B_DM3.sas7bdat B_DM4.sas7bdat C_DM1.sas7bdat C_DM2.sas7bdat D_DM1.sas7bdat I want to move these datasets based on their names, like dataset having prefix “A_” should copy to “Libref_A” library, similarly “B_” should copy to “Libref_b”, “C_” should copy to “Libref_C” and “D_” should copy to “Libref_D”. Thanks in advance.

Soham0707 · ‎06-26-2020

Sorry for that.. This warning i got and output is not matching.. WARNING: In a call to the CATX function, the buffer allocated for the result was not long enough to contain the concatenation of all the arguments. The correct result would contain 5 characters, but the actual result might either be truncated to 1 character(s) or be completely blank, depending on the calling environment. The following note indicates the NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds left-most argument that caused truncation. NOTE: Argument 3 to function CATX(',',' '[12 of 50 characters shown],'OTHER '[12 of 160 characters shown]) at line 30431 column 14 is invalid.

Soham0707 · ‎06-26-2020

not working 😞

Soham0707 · ‎06-26-2020

Hello guys, I have below data set in which i want the values of reason in one record by subject & Visit description. Subject Visit_description Start_date End_date Reason Other_Reason 1 Assessment 1 6/26/2020 6/26/2020 CONVULSIONS 1 Assessment 1 6/26/2020 6/26/2020 DEHYDRATION 1 Assessment 1 6/26/2020 6/26/2020 FEEDING DIFFICULTY 1 Assessment 1 6/26/2020 6/26/2020 OTHER iiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiii 1 Assessment 2 6/27/2020 6/27/2020 IRREGULAR OR PERIODIC RESPIRATION 1 Assessment 2 6/27/2020 6/27/2020 IRRITABILITY OR AGITATION 1 Assessment 2 6/27/2020 6/27/2020 LETHARGY OR EXCESSIVE SLEEPINESS Output should be like below table Subject Visit_description Start_date End_date Reason Other_Reason 1 Assessment 1 6/26/2020 6/26/2020 CONVULSIONS,DEHYDRATION,FEEDING DIFFICULTY,OTHER iiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiii 1 Assessment 2 6/27/2020 6/27/2020 IRREGULAR OR PERIODIC RESPIRATION,IRRITABILITY OR AGITATION,LETHARGY OR EXCESSIVE SLEEPINESS

Soham0707 · ‎06-04-2020

Thank You Jagdishkatam..

Soham0707 · ‎06-04-2020

Thank you Andreas_Ids

Soham0707 · ‎06-04-2020

Thank you so much Draycut..

Soham0707 · ‎06-04-2020

Hello guys, hope you all are doing well. Here is one task i need your help, I am creating one dataset below, data a; input subjid cd$ d; datalines; 2006 XY8 1 2006 XY8 1 2006 ABC 0 2006 EFG 0 2006 HIJ 0 2007 XY8 1 2008 ABC 0 2008 EFG 0 2008 HIJ 0 ; run; so the query is, if CD variable contents XY8 value then i want to flag that whole subject. for more clear understanding please look at below table. I want output as below, Desired output: SUBJID CD D FLG 2006 XY8 1 Y 2006 XY8 1 Y 2006 ABC 0 Y 2006 EFG 0 Y 2006 HIJ 0 Y 2007 XY8 1 Y 2008 ABC 0 2008 EFG 0 2008 HIJ 0 Thanks In Advance...

Soham0707 · ‎01-09-2020

Hi team, Thank you for all your support and guidance for previous help. I need help guys. can anyone tell me how to create folder in windows environment (@ specified path) by using sas programming? Thank you in advance. :):)

Soham0707 · ‎11-28-2019

Hello Guys, I have below dataset : a b c 1000 1 C 1 - 605 1000 2 C 2 - 457 1000 3 C 3 - 457 1000 4 C 4 - 457 1000 5 C 5 - 457 1000 6 C 6 - 457 1001 1 C 1 - 606 1001 2 C 2 - 455 1001 3 C 3 - 455 1001 4 C 4 - 455 1001 5 C 5 - 455 and output dataset should be like : a b c d 1001 6 C6 - 457 C1 - 605 C2 - 457 C3 - 457 C4 - 457 C5 - 457 C6 - 457 1002 5 C5 - 455 C1 - 606 C2 - 455 C3 - 455 C4 - 455 C5 - 455 can any one suggest program for this ?

Soham0707 · ‎11-25-2019

Thank you so much ...

Soham0707 · ‎11-25-2019

yes

Soham0707 · ‎11-25-2019

Hi Guys, I need one minor help. Below is my input data; 802,803 803,804 60,61 817,818 817,818,819 810,811,812 55,56 55,56,57 I want output like below; 803 804 61 818 818,819 811,812 56 56,57 I want to remove data comes before first comma. How can I do this.

Online Status	Offline
Date Last Visited	‎05-05-2022 06:40 AM

Re: Copy dataset from one library to another based on dataset name pre...

Re: Copy dataset from one library to another based on dataset name pre...

Copy dataset from one library to another based on dataset name prefix

Re: sas programming

Re: sas programming

sas programming

Re: conditional programming

Re: conditional programming

Re: conditional programming

conditional programming

Re: Copy dataset from one library to another based on dataset name pre...

Re: Copy dataset from one library to another based on dataset name pre...

Re: Copy dataset from one library to another based on dataset name pre...

Re: Copy dataset from one library to another based on dataset name pre...

Re: conditional programming

Re: How to export all dataset present in work library to an excel file

Re: Copy dataset from one library to another based on dataset name pre...

Re: Copy dataset from one library to another based on dataset name pre...

Copy dataset from one library to another based on dataset name prefix

Re: sas programming

Re: sas programming

sas programming

Re: conditional programming

Re: conditional programming

Re: conditional programming

conditional programming

create folder in windows by using SAS

Concatinate multiple values in one variable

Re: i want to remove data comes before first comma

Re: i want to remove data comes before first comma

i want to remove data comes before first comma