I import data from a csv to use proc format on it. I am using my college data regarding the subjects we chose. Here, we had put abbreviations instead of the full name and since I was learning about proc format, I thought "why not?". Here is the code for what I did along with the data copied from csv sys_no sub1 sub2 sub3 sub4 1, DL, SAS, Big Data analytics, Stock Market Operations 3, DL, SAS, Big Data analytics, Stock Market Operations 4, DL, SAS, Big Data Analytics, Stock Market Operations 27, DL, SAS, Big data analytics, Stock Market Operations 12, DL, SAS, Big Data Analytics, Stock Market Operations 24, Dl,SAS, BIG DATA ANALYTICS, STOCK MARKET 23 ,dL, sas, BIG DATA ANALYTICS, STOCK MARKET Yes it is in comma and I used this code to import it: PROC IMPORT OUT=Student DATAFILE="/home/Student.csv" DBMS=CSV REPLACE; GETNAMES=YES; RUN; data B; set work.student; format sub1 $upcase.; rename sub1=subA sub2=subB sub3=subC sub4=subD; run; I noticed that the upcase doesn't work is I put format below the rename (of course I changed the name when using format) which I resolved, but I don't understand why this doesn't work: proc format; value $subA 'DL'='Deep Learning'; run; Here, the 'dL' and 'Dl' are not uppercased even though when I check it, they're upper cased before the proc format. I found out that I must do this instead of using the format $upcase. : data C; set B; subA = upcase(subA); run; I am new to SAS and would like to know what error I made
... View more