I need a help in formatting only the date fields in source while creating a SAS dataset. I have 90-100 fields in excel workbook, I want to format all the date fields to date format since date fields are getting converted to char/numeric formats   libname xlsFile XLSX "/usr/path.xlsm"; PROC SQL; create table work.SASdataset1 as (select * from excel_table); run;   ... View more

I need to modfiy my dataset based on specifc variables values. Given below is the dataset Please share your thoughts on this   Logic: Consider only the highlighted portion of the current dataset and drop the remaining variable values for creating a new dataset   Current dataset: COLUMN1 COLUMN2 COLUMN3 TEAM CLASS DEPT CUST1            YES AGE                                    45 MANA2           YES AGE_1                                 60 EMPLOY3      NO AGE_2                                  90 LOC GEO STATE   Expected dataset  COLUMN1 COLUMN2 COLUMN3 CUST1            YES           45 MANA2           YES           60 EMPLOY3       NO            90   ... View more

I am finding difficulty in assigning column name variables to array list. I am trying to create a new dataset with column lable name in a field(NEW_COLUMN1) and column value(NEW_COLUMN2) in another field. Given below is the code which I have tried   data work.dataset_new; set work.dataset_created; LENGTH NEW_COLUMN1 $ 100; FORMAT NEW_COLUMN2 6.; Array char {*} _character_; Array num {*} _numeric_; do i = 1 to dim(char); NEW_COLUMN1 = vlabel(char{i}); NEW_COLUMN2 = (char{i}); end; do i = 1 to dim(num); NEW_COLUMN1 = vlabel(char{i}); NEW_COLUMN2 = (char{i}); end; run;   Actual_dataset: COLUMN1 COLUMN2 COLUMN3 COLUMN4 COLUMN5 COLUMN6 COLUMN7 COLUMN8 COLUMN9 101                   102           103            104            105               106              3            22             55               Expected dataset NEW_COLUMN1       NEW_COLUMN2 COLUMN6_label              106 COLUMN7_label                  3 COLUMN8_label                22             ... View more

I need a help in transposing a dataset without transposing a column in the data . Transpose the label names instead of column names in the dataset since column names are truncated due to length restriction in SAS.    I have tried transpose dataset with copy and by commands but I am not able to retrieve the exacts results. I have upload a document to have a view of Current and expected dataset.   ... View more