Getting error when trying to get data from the sharepoint -Please help   FILENAME website HTTP 'https://tset,com/Shared%20Documents/people_counts.xlsx'; data file; n=-1; infile website recfm=s nbyte=n length=len; input; file "C:/test/Summary.xls" recfm=n; put _infile_ $varying32767. len; run;   ERROR: Unauthorized to retrieve URL. Use the debug option for more info. NOTE: UNBUFFERED is the default with RECFM=N. ... View more

Here is the code i have this issue on lot of my programs. How do i resolve this i added ls =256.   ods excel options(sheet_name='test' absolute_column_width="20,8"); options nodate pageno=1 ps=60 ls=256; proc report data=cloud.fruits; run; ods excel close; ods listing close;   ERROR: The width of cloumn name is not between 1 and 256. Adjust the column width or line size. NOTE: This affects LISTING output. ... View more

i am trying to import CSV file from my local to SAS. The data includes in one of the column ' Description' with below long text with comma and special chars.   ' The purpose of this application is to deliver a consistent and repeatable process that demonstrates maturity, comparable with  basis. The capabilities will include: Training & exercise management, crisis management, keep business resiliency program artifacts up to date (such as risk assessments for availability, '   proc import datafile=C:\SAS\Report.csv" out=mydata dbms=CSV replace; delimiter=','; GUESSINGROWS=32767;   The import breaking the Description text into multiple cells and creating multiple rows for one row data. Please help me I am trying below options   1. Delete description column before import. I don;t use the Description column in my report 2. Trim Description text before import     Thank you     run; ... View more

want to create a script to import csv file from the windows server using username and password. How can i do this? ... View more

i have the following data, the sort results different from the SAS order by sort. Looks like '-' variable sort first in the SAS code - Please help.   Code: proc sql; Create table lib.fruits as select Name, calories,Fat,carb,protein from lib.fruits_data order by upper(Name) asc; quit;   result: fruits  Calories Fat Carbs Protein AH-LP Banana 69 0.4 17.6 0.8 AH Banana 69 0.4 17.6 0.8 Cantalope 27 0.2 6.5 0.7 CANTALOPE/GREEN 27 0.2 6.5 0.7 MA-MAS Cherry 42 0.6 9.7 0.7 MAC-Cherry 42 0.6 9.7 0.7 Peach 36 0.1 9.4 0.6 Strawbery 24 0.3 5.8 0.5 Watermelon 24 0.3 5.5 0.5   Expected sort same as excel :   fruits  Calories Fat Carbs Protein AH Banana 69 0.4 17.6 0.8 AH-LP Banana 69 0.4 17.6 0.8 CANTALOPE/GREEN 27 0.2 6.5 0.7 Cantalope 27 0.2 6.5 0.7 MAC-Cherry 42 0.6 9.7 0.7 MA-MAS Cherry 42 0.6 9.7 0.7 Peach 36 0.1 9.4 0.6 Strawbery 24 0.3 5.8 0.5 Watermelon 24 0.3 5.5 0.5 ... View more

i have data like below   request parent number 123        234      789 123        234      545     want to merge like request parent number 123 234 789/545   how to code this?   ... View more

i want to create a table similar to below, for an id multiple and unique summary descriptions and the total count. Is it possible?       id summary summary cnt total_ct 123 Oranges 1 2   Grapes 1   345 blueberry 1 3   Banana 2     Apple 1   ... View more

i have files on my local windows machine. i download everyday. i run the sas code from the unix sas. How do i get the files from the windows to unix. ... View more