About a13

a13 · ‎09-03-2018

I want to compare two datasets from different libraries, basically i want to look for values in the datasets which are different. Please help me write the query. I am confused between using except corr and except all.

a13 · ‎08-28-2018

Code data total_sales; input Date mmddyy10. +2 Amount comma5.; datalines; 09/05/2000 1,382 10/19/2000 1,235 11/30/2000 2,391 ; run; Output 1 14858 382 2 14902 235 3 14944 391

a13 · ‎08-27-2018

code: %LET iterations = 5; %LET winner = Lance Armstrong; DO i = 1 to &iterations; TITLE "First: &winner"; log: 1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 72 73 %LET iterations = 5; 74 %LET winner = Lance Armstrong; 75 DO i = 1 to &iterations; __ 180 ERROR 180-322: Statement is not valid or it is used out of proper order. 76 TITLE "First:" &winner; WARNING: The TITLE statement is ambiguous due to invalid options or unquoted text. 77 78 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 91

a13 · ‎08-27-2018

Yes, removing Cars.dta from path worked fine. Thank you. 🙂

a13 · ‎08-27-2018

LOGS: OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 72 73 74 /* %let dirdata="/folders/myfolders/CARS.csv"; */ 75 libname libsas '/folders/myfolders/CARS.dta'; ERROR: Library LIBSAS is not in a valid format for access method RANDOM. ERROR: Error in the LIBNAME statement. 76 /*1*/ 77 /* data snow.snowfall; */ 78 data libsas.ecars; 79 set sashelp.cars; 80 where Origin='Europe'; 81 run; ERROR: Libref LIBSAS is not assigned. NOTE: The SAS System stopped processing this step because of errors. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds 82 proc print data=libsas.ecars; ERROR: Libref LIBSAS is not assigned. 83 run; NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE PRINT used (Total process time): real time 0.00 seconds cpu time 0.00 seconds 84 85 86 87 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 100

a13 · ‎08-27-2018

I am getting the errors mentioned in the screenshots while writing the program. I am using the SAS Studio via Oracle VM Virtual Box, so I don't have the path available for specifying the libname, I'm exporting the Cars table into my folders and then using that path. Please help me on how to specify the path.

Online Status	Offline
Date Last Visited	‎09-05-2018 07:53 AM

comapre cols

Date format not stored properly

Statement is not valid or it is used out of proper order.

Re: Libref is not assigned

Re: Libref is not assigned

Libref is not assigned

Re: Libref is not assigned

comapre cols

Date format not stored properly

Statement is not valid or it is used out of proper order.

Re: Libref is not assigned

Re: Libref is not assigned

Libref is not assigned