I am a bit confused by what you mean when you say (in reference to SET) 'allow it to work on another SAS data set with lots of names.'  It is the same data set (I'musing data lines), but there are 2 more names within the data lines. that need catx. Does your statement about SET still apply? Thank you for clarifying.    ... View more

Also, a follow-up question: How do I do this for more than one name?  ... View more

Thank you! I guess I miscounted. The output came out as "Taylor,Daniel"- how do I get a space in between the comma and the D? ... View more

I have tried:  data WORK.stjohns; FirstNm = 'Daniel'; LastNm = 'Taylor'; length Name $ 12; Name = catx(',', LastNm, FirstNm); put _all_; run; It gave me nothing in my new variable. I am looking for Firstnm='Daniel' , Lastnm='Taylor' and want Name='Taylor, Daniel'.  ... View more

Yes, this is my original file. The goal of using this file within the project is to use PROC TRANSPOSE to take it from a wide dataset to a long one, remove the word 'FIPS' from the front of each of the observations containing a FIPS code, and convert that variable from character to numeric. I will eventually merge it with another dataset.  ... View more

I am working with SAS on a Mac, and I am using the free SAS On Demand for Academics. I have only used this computer when working on this project, and have run the code and viewed the files fine.   Additionally, when I ran the code I switched  libname coimpt xlsx "c:\temp\poverty.xlsx"; For my actual CoImpt libname:  LIBNAME CoImpt XLSX "&CourseRoot/CDPHE Study/Data/1_Source/poverty.xlsx"; And it still did not function correctly. When I download the excel file from SAS and open it on my computer, it looks like it should. When I view the data within SAS, it looks like it should. However, when I tried to run any kind of code on it, it only shows me one variable: _NAME_. Everything else does not appear, no matter what the code is. ... View more

The single variable is _NAME_ ... View more

I have checked all of these things, and it is still not working. I cannot figure out why this would be the case ... View more

Thank you for all of your help! I really appreciate it.  ... View more

Here is the log based on your provided code. It is as you predicted. Also, yes, the sheet is also named poverty in the excel file. 1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 68 69 LIBNAMECoImpt XLSX "&CourseRoot/CDPHE Study/Data/1_Source/poverty.xlsx"; NOTE: Libref COIMPT was successfully assigned as follows: Engine: XLSX Physical Name: /home/u63571562/BIOS6680_2023/CDPHE Study/Data/1_Source/poverty.xlsx 70 71 DATA Poverty; 72 SET CoImpt.Poverty; 73 RUN; NOTE: The import data set has 0 observations and 1 variables. NOTE: There were 0 observations read from the data set COIMPT.Poverty. NOTE: The data set WORK.POVERTY has 0 observations and 1 variables. NOTE: DATA statement used (Total process time): real time 0.02 seconds user cpu time 0.02 seconds system cpu time 0.00 seconds memory 4694.50k OS Memory 36628.00k Timestamp 11/06/2023 12:56:28 AM Step Count 413 Switch Count 2 Page Faults 0 Page Reclaims 1106 Page Swaps 0 Voluntary Context Switches 21 Involuntary Context Switches 0 Block Input Operations 0 Block Output Operations 160 74 75 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 85   ... View more

Thank you for the suggestion. My data looks just like it should, with all the data intact, so I'm unclear why it is not producing my desired results. ... View more

Thank you for the response. When I run this code, this is my log (1 warning and 3 errors). I guess a better question is: since I have already made the mistake of overwriting my code within SAS, how do I fix it? 1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 68 69 *Convert from wide to long using PROC TRANSPOSE*; 70 libname coimpt xlsx "c:\temp\poverty.xlsx"; NOTE: Libref COIMPT was successfully assigned as follows: Engine: XLSX Physical Name: c:\temp\poverty.xlsx 71 72 data work.poverty_wide; 73 set coimpt.poverty; ERROR: File COIMPT.poverty.DATA does not exist. 74 run; NOTE: The SAS System stopped processing this step because of errors. WARNING: The data set WORK.POVERTY_WIDE may be incomplete. When this step was stopped there were 0 observations and 0 variables. WARNING: Data set WORK.POVERTY_WIDE was not replaced because this step was stopped. NOTE: DATA statement used (Total process time): real time 0.00 seconds user cpu time 0.00 seconds system cpu time 0.00 seconds memory 2798.03k OS Memory 31092.00k Timestamp 11/05/2023 11:54:48 PM Step Count 244 Switch Count 0 Page Faults 0 Page Reclaims 652 Page Swaps 0 Voluntary Context Switches 0 Involuntary Context Switches 0 Block Input Operations 0 Block Output Operations 8 75 76 libname coimpt clear; NOTE: Libref COIMPT has been deassigned. 77 78 proc transpose data=work.poverty_wide out=work.poverty_long(rename=(_name_=Fips) drop=_label_); 79 id _name_; 80 run; NOTE: No variables to transpose. WARNING: The variable _label_ in the DROP, KEEP, or RENAME list has never been referenced. NOTE: There were 0 observations read from the data set WORK.POVERTY_WIDE. NOTE: The data set WORK.POVERTY_LONG has 0 observations and 1 variables. NOTE: PROCEDURE TRANSPOSE used (Total process time): real time 0.00 seconds user cpu time 0.00 seconds system cpu time 0.00 seconds memory 977.34k OS Memory 28964.00k Timestamp 11/05/2023 11:54:48 PM Step Count 245 Switch Count 2 Page Faults 0 Page Reclaims 104 Page Swaps 0 Voluntary Context Switches 10 Involuntary Context Switches 0 Block Input Operations 0 Block Output Operations 264 81 82 proc print 83 data = work.poverty_wide; 84 run; NOTE: No observations in data set WORK.POVERTY_WIDE. NOTE: PROCEDURE PRINT used (Total process time): real time 0.00 seconds user cpu time 0.00 seconds system cpu time 0.00 seconds memory 497.34k OS Memory 28704.00k Timestamp 11/05/2023 11:54:48 PM Step Count 246 Switch Count 0 Page Faults 0 Page Reclaims 18 Page Swaps 0 Voluntary Context Switches 0 Involuntary Context Switches 0 Block Input Operations 0 Block Output Operations 0 85 proc print 86 data = work.poverty_long; 87 run; NOTE: No observations in data set WORK.POVERTY_LONG. NOTE: PROCEDURE PRINT used (Total process time): real time 0.00 seconds user cpu time 0.01 seconds system cpu time 0.00 seconds memory 743.28k OS Memory 28964.00k Timestamp 11/05/2023 11:54:48 PM Step Count 247 Switch Count 0 Page Faults 0 Page Reclaims 52 Page Swaps 0 Voluntary Context Switches 0 Involuntary Context Switches 0 Block Input Operations 0 Block Output Operations 0 88 89 proc contents data=work.poverty_long; 90 run; NOTE: PROCEDURE CONTENTS used (Total process time): real time 0.02 seconds user cpu time 0.02 seconds system cpu time 0.00 seconds memory 1965.65k OS Memory 29224.00k Timestamp 11/05/2023 11:54:48 PM Step Count 248 Switch Count 0 Page Faults 0 Page Reclaims 99 Page Swaps 0 Voluntary Context Switches 2 Involuntary Context Switches 0 Block Input Operations 0 Block Output Operations 8 91 92 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 102 ... View more

For the project, I cannot pivot anything in excel. I am to use PROC TRANSPOSE to do this in SAS. I wrote code for this and it worked fine, until problems in original post occurred.  ... View more