About thenycguy

thenycguy · ‎10-31-2022

I am trying to access an EXCEL spreadsheet via proc import. I am using Windows 10. How do I access the Excel if, in File Manager, it is listed as This PC/Downloads/The Data_100302022 with an extension of Microsoft Excel Worksheet? My goal is to bring the data into SAS for processing. Thank you!

thenycguy · ‎11-23-2021

Second_step is take data and produce about 10 lines of output per 1 line read in. It does not. Why is this code not producing results? Data Second_step (keep =drawdate pbnum num1of2 num2of2); Set First_step(keep= Drawdate num1 num2 num3 num4 num5 pbnum multinum obs=2) ; array numsdrawn {6} num1 num2 num3 num4 num5 multinum; length num1of2 num2of2 8; do I=1 to 4; num1of2 = numsdrawn(I) ; put @10 'NUM1of2 =' num1of2 2. @; do J = numsdrawn(I+1) to 5 ; num2of2 = numsdrawn(j); put @25 'num2of2=' @35 num2of2 2. @40 "J=" +2 J 2.; output; end; end; Run;

thenycguy · ‎10-28-2015

Hi all! How are SAS people finding jobs in the Northeast?

Online Status	Offline
Date Last Visited	‎12-08-2023 07:52 AM

Accessing an Excel Spreadsheet with proc import

Arrays which do not produce

Job Hunting

Accessing an Excel Spreadsheet with proc import

Arrays which do not produce

Job Hunting

SAS Analytics Explorers