Importing a large CSV file and getting Insuffcient Memory

[SamMad]

Kurt,
Ok understood and thank you for your suggestive next steps in learning SAS. I will start to dive into the DATA Steps Processing. I do want to share that that most of my data will come from somewhat *normalized* sources within the org. But the way I am thinking is that If the file comes with repeat values and converting them into fact table and dimension tables on SAS similar to how we have SQL Set up with FACT and DIMENSION tables. Will that type of schema work in SAS? or is it even recommended or used by others in the SAS community?

Second QUESTION of the day:
Majority of my Data will come from SQL Server and that's where the problem exists for me. I don't have a direct login to SQL Server using windows authentication instead of we use the CyberArk tool. It provides a temporary password to login to SQL Management Studio and login using those domain accounts . I haven't been able to find a way on how to use the SQL Connection through SAS.
In my SAS Software, I do have SAS/ACCESS Interface to Microsoft SQL Server. I have at least 50 Tables sitting in SQL Env that I would like to set the SAS program to import /convert them to SAS data formats. Has anyone successfully tested CyberArk tool and using its pwd to link to SQL Server ?

[AlanC]

I don't use CyberArk (never heard of it) but a quick perusal says they have a REST API (CyberArk AIM) to retrieve the temp password. Use PROC HTTP to access the REST API, get the creds, pass it as macro to the SQL Server connection. Suggested approach.

[Reeza]

If you're going to split into fact/dim do you have Data Integration Studio or just Base SAS?

[TomKari]

First of all, I recommend that you post different questions as a separate post, instead of including it under an already-answered one. A lot of people just look for unanswered questions, and this one appears to be answered.

In terms of your CyberArk question, I recommend that you put in a track with SAS technical support. My experiences with them have been really good, and they've got the technical people who can work with you to figure this out (or, sadly, to conclude that it can't work out. I didn't find any statement that SAS is compliant with CyberArk, or vice-versa.)

Also, if they need to get into a discussion with CyberArk to improve interoperation, that's the level where it should be done.

Check with your SAS administrator whether you should submit the track yourself, or if someone else in your organization manages this.

Tom