About Cyndia

Cyndia · ‎04-18-2012

In an existing dataset, is there a way to change a column of dates in the format of "mm/dd/yyyy" to character format of "mmddyyyy"? thanks.

Cyndia · ‎04-16-2012

the datasets are already in a library. I tried to make the code to UNION ALL the datasets in my library, but encountered errors. libname temp 'c:\test'; run; /* create a list of the datasets */ filename indata pipe 'dir C:\all_datasets /b'; data work.list; length fname $60; infile indata truncover; input fname $60.; call symput ('num_files',_n_); run; /*using a DATA _NULL_ step, we can now read the data set names in our database and save them in macro variables */ data _null_; set work.list; call symput('DataSet'||left(_n_),memname); run; /* DataSets: View containing all data sets for concatenation */ proc sql noprint; create view DataSets as select cats(libname,'.',memname) length=65 format=$65. as table from dictionary.tables where libname='temp' and memname like _& /* my dataset names are like this _384_abc_* not sure of this line */ ; quit; /* Variable mapping for output data set (="want") */ data mapping; attrib ID_number length=$15 label='ID Number' First length=$25 label='First Name' ... ; call missing(of _all_); stop; run; /* create concatenation code and write it to temporary file */ filename alldata temp; data _null_; /* file print;*/ file alldata; set work.list end=last; if _n_=1 then do; put @1 'proc sql;' /@3 'create table want as' /@6 'select * from mapping' ; end; put @6 'union all' /@6 'select * from ' table /* got message "variable table is uninitialized, why? */ ; if last then do; put @3 ';' /@1 'quit;' ; end; run; /* include temporary file so that code gets executed */ %include alldata;

Cyndia · ‎04-16-2012

Yes, UNION ALL is a good method to concatenate multiple datasets that have the same attributes and the same order.

Cyndia · ‎04-16-2012

UNION ALL seems to do the job well. Thanks!

Cyndia · ‎04-13-2012

sorry...i meant variable names instead. i try to append all datasets that have different variable names. not labeling issue.

Cyndia · ‎04-13-2012

thank you Ksharp. I meant variable names, not variable labels. let me try it.

Cyndia · ‎04-13-2012

Sorry, I meant variable names are all different. andreas_lds is right about the mix-up.

Cyndia · ‎04-13-2012

so the final appended dataset can become? VAR1 VAR2 VAR3 ----------------------------------- Cindy 15 101 Kenny 10 102 ... Liz 13 103 Harry 17 104 ... i can label all variables after appending all datasets. any suggestions? thanks.

Cyndia · ‎04-13-2012

Hi, I need to PROC APPEND a few hundred datasets, but the variable names in all datasets are different. is there a way to remove all variable names so they all become VAR1, VAR2, VAR3...VAR50? dataset 1 looks like this: name age ID ------------------------ Cindy 15 101 Kenny 10 102 ... dataset 2 looks like this: firstname yrs Identification ------------------------------------ Liz 13 103 Harry 17 104 ... there is a problem with PROC APPEND when variables are named differently. is there a way to remove all variable names from all datasets, so all variables become Var1, Var2...only? Thanks!

Cyndia · ‎04-13-2012

is there a way to remove all variable names from all datasets, so all the names would become VAR1, VAR2... for every dataset? so PROC APPEND and "data final; set..." will not require renaming every field in every dataset? we have hundreds of datasets with abbreviated names that don't even spell the same way.:smileyshocked: i made a correction. it's about variable names, not variable labels. sorry.

Cyndia · ‎04-13-2012

Shiva, it looks like you provided two options. one is "proc append", another one is using "data final; set..." both methods require to rename over 50 fields one by one. in my case, there are over a few hundred datasets to rename because all of them have different labels...different spelling, abbreviated differently, e.g. fruit, frt, frut, etc. weight, wt, wgt, w. etc. wonder if there are other ways to accomplish that. Thanks you. I will try it tomorrow.

Cyndia · ‎04-13-2012

Reeza, so the base dataset is "class1" in your example? and "AGE GROUP" will be the label for the final dataset named class1? i don't have access to try it now, but will try tomorrow when i have access. thanks.

Cyndia · ‎04-12-2012

Hi! Here is the challenge. There are many datadets with about 50 columns in each dataset. Every dataset has over thousands of records. e.g. one of the datasets looks like: produce weight bags ------------------------------------ carrots 10 500 potatos 5 200 garlic 2 100 ... another dataset looks like (note the variable names are not the same as the above dataset): fruit wt. containers ----------------------------------------- apples 15 100 pears 9 20 ... After appending, the result should look like this: produce weight bags ------------------------------------ carrots 10 500 potatos 5 200 garlic 2 100 ... apples 15 100 pears 9 20 ... question: What is the best way to proc append lots of large files that have different variable names? i read about appending, but none address the variable naming issue yet. Thanks!

Cyndia · ‎04-11-2012

The solutions you provided turned out to be great. They work seamlessly for the text files without extra spaces. How did you learn SAS macro? I am going to learn macro next. Any book(s) you would recommend? Big thanks for all

Cyndia · ‎04-06-2012

thanks, Jay. i read the pdf doc "A Macro for Reading Multiple Text Files" and was able to get the list of the files, but had trouble getting the rest of the code to work. will try it.

Online Status	Offline
Date Last Visited	‎09-01-2015 07:11 AM

Re: removing first unwanted/non alphabet characters in a column

removing first unwanted/non alphabet characters in a column

Re: consolidating columns

Re: consolidating columns

Re: consolidating columns

consolidating columns

Re: creating additional columns with proc sql

Re: creating additional columns with proc sql

creating additional columns with proc sql

how to re-format dates

changing from a date format "mm/dd/yyyy" to character format "mmddyyyy...

Re: how to remove all variable names from datasets

Re: how to remove all variable names from datasets

Re: proc append lots of datasets that have different names for variabl...

Re: how to remove all variable labels from datasets

Re: proc append lots of datasets that have different labels for variab...

Re: how to remove all variable labels from datasets

Re: how to remove all variable labels from datasets

how to remove all variable names from datasets

Re: proc append lots of datasets that have different labels for variab...

Re: proc append lots of datasets that have different labels for variab...

Re: proc append lots of datasets that have different labels for variab...

proc append lots of datasets that have different names for variables

Re: convert large number of text files into SAS all at once

Re: convert large number of text files into SAS all at once