Hello @u63641135 , You must create your subfolder under Files (Home) not sasuser.v94. From the screen shot you provided, it looks like you are trying to create a folder under sasuser.v94.    Make sure Files (Home) is selected when you try to create your new subfolder.   Good Luck!   ... View more

@DaveAus  You're welcome!  ... View more

why the error is being shown in the pgm Hello! As indicated already by the others: Your program cannot find the file under the path and name you have provided in the code.  When looking at the log message it seems that you try to use a windows path on a unix machine (where sas runs). That is, you need to make the file available to sas first and than use the filename under which sas sees the file.  In other words: You need to upload the file to the sas machine (or use some shared folders) so that you find it listed in SAS Studio. And the properties of _that_ file (again via SAS) reveal the path and filename you need to use in your in your program. --fja ... View more

Hello,  I agree with @PaigeMiller, a few more details are needed because these details are important. For example, has a library been established for SASDATA before the DATA step is submitted? The assumption is that it has been established, but if not, the first ERROR that you will get is ERROR: Libref SASDATA is not assigned. If a library has been assigned for SASDATA, then the question becomes, is the SET statement supposed to be;  SET SASDATA.TWO;  (and does that exist) or are there two WORK data sets WORK.SASDATA and WORK.TWO and the SET statement is supposed to be SET SASDATA TWO; thus referencing the two temporary data sets?  I can't really tell from the tips that were provided. After that, it depends from that point on whether there are two data sets WORK.SASDATA and WORK.TWO and if so, @ballardw's response is on point!    If you wish to try this for yourself, here is a sample program that I wrote to test out the code. It assumes SASDATA library an be established, it assumes you have access to c:\ (C: drive) on your PC if you are submitting the program code in Windows. If not, replace the location in the LIBNAME statement to point to a location (in quotes) that exist on your computer and that you have write access to. Also, it assumes that the SET statement in the original code is correct to reference two data sets SASDATA and TWO > set sasdata two;     The sample program below creates the SASDATA library, and creates the two temporary data sets SASDATA and TWO before the original program can be submitted.     libname sasdata 'c:\';   data two;    set sashelp.cars;    if _n_=1 then      do x=1 to 5;         output;      end; run;   data sasdata; set sashelp.cars(obs=2);    do x=1 to 5;       output;     end; run;   data sasuser.one two sasdata.three;    set sasdata two;    if x = 5 then output sasuser.one;    else output sasdata two; run;   Good Luck! ... View more

Hello All, By default, the only special character a SAS variable name can include is _ (an underscore). However, you can use special characters like #'s as part of the SAS variable name if you use a SAS name literal (Example: 'dr_address##1'n) and the VALIDVARNAME system option must be set to ANY (options validvarname=any;). This will allow the use of non-standard characters as part of the variable name.    Here is an example using SAS Name literals in a SQL query, since the original question posted included a SQL query. You can also use SAS Name literals to create variables in a DATA step.    You can copy, paste this code and submit it in a SAS environment to see the results:   options validvarname=any;   proc sql; create table nonStandardNames as    select make, model, invoice, mpg_city,          '1234 SAS Campus Dr.' as 'dr_address##1'n,          'Cary' as 'dr_address##2'n,          'NC' as 'dr_address##3'n ,          27513 as 'dr_address##4'n    from sashelp.cars    where mpg_city >40;      title "Non-Standard Names";    title2 "Using SAS Name Literals 'dr_address##'n ";      select make, mpg_city, 'dr_address##2'n, 'dr_address##3'n       from nonStandardNames; quit;   proc contents data=nonStandardNames; run;     ... View more

Hello, To reinforce your learning of SAS Programming language/code, not point and click , you may want to consider taking the FREE SAS Programming 1 course where creating SAS libraries and new variables are topics that are addressed in the course along with many other. You can find the free e-learning here. ... View more

Your requirements are contradictory, if you want a data set proc tabulate is not the right approach, proc transpose is (solution shown by @PeterClemmensen).    Wanted to avoid proc freq. Is there a way to do this via proc tabulate?     Sas data set ... View more

Updated Q&A now available!   ... View more