About RahulG

RahulG · ‎09-27-2016

Go to this link http://support.sas.com/documentation/cdl/en/lrcon/62955/HTML/default/viewer.htm#a000780367.htm Search for "Character Comparisons" on the web page. You would find documentation on =: operator

RahulG · ‎09-27-2016

I have a macro called "mymacro". When I am calling it, it works well, but I want to find where this macro code is actually saved? Is there any way to find it out.

RahulG · ‎09-27-2016

To be very specific Proc options option=SASAUTOS;run;

RahulG · ‎09-23-2016

data have; a=202; label a ="temp new"; b=102; label b="temp"; c=302; label c ="var c"; run; proc contents data =have out=contents;run; proc sql; select name into :var_list separated by ' ' from contents where label ? 'temp'; quit; %put &var_list; data want; set have; drop &var_list; run; In the above code I am dropping columns that has temp in their label.

RahulG · ‎09-22-2016

I have to test many base sas code. And each sas code sets some option, create macro varaibles, libname, filename. Once I test one code then I have to close the base SAS session to reset all option. Is there any way to reset the session without closing the BASE SAS session.

RahulG · ‎09-22-2016

suppose I add some folders to SASAUTOS then execute PROC OPTIONS;RUN; I do not see the folder name in the log .

RahulG · ‎09-22-2016

Is there any way to find out what all folders being added to SASAUTOS at any point of time?

RahulG · ‎09-21-2016

I am struggling with macros. I have four folders having marco code in .sas file. Folder names are folder1, folder2, folder3, folder4. I want to make macros present in these folder available in my session. I written below mentioned code. Please suggest filename MYMACROS( 'C:\folder1', 'C:\folder2', 'C:\folder3', 'C:\folder4' ); option APPEND=SASAUTOS= (,MYMACROS);

RahulG · ‎09-15-2016

The error message itself guide to check many things. Please verify all those points with your platform administrator. I can make out from Messgae that it is not able to make contact with metadata server. Thats why it is asking you to check whether server is up? Do double check host name and port number.

RahulG · ‎09-15-2016

data bikes1; infile "/folders/myfolders/austin.txt" dlm='09'x; ; length Country $14 Bike $13 Model $10 Units 4 Price 6 TotalSales 7 ; informat Price dollar6. TotalSales dollar7.; input Country Bike Model Units Price TotalSales ; run; proc print data=bikes1 noobs; run; Made two changes 1. format changed to informat 2. input statement I removed all the format.

RahulG · ‎09-15-2016

Refer to this post. http://support.sas.com/kb/35/613.html

RahulG · ‎09-15-2016

Share your Error message.

RahulG · ‎09-11-2016

@Reeza I want to learn how this count in where clause works. What I understand Count(*) ( Aggregate function ) works with group by and having clause.

RahulG · ‎09-09-2016

Have you listed right set of column in business key tab. I am guessing ACCOUNTID should be listed in business key

RahulG · ‎09-09-2016

First two options highlighted in yellow should help you.

Online Status	Offline
Date Last Visited	‎03-22-2019 01:32 PM

Re: SASVA -Text box - how to replace (missing) with 0

SASVA -Text box - how to replace (missing) with 0

Create multiple dataset from source dataset

Re: DI Studio - using programming or scripts to check in / out

Re: Excluding a foreign key in SAS DIS

Re: Duplicate Rows After Left Join

Re: Newbie here! Question about a proposal using SAS! :)

Re: SAS macro query

Re: Cant find newly created dataset

Re: "Library name is not assigned" PLEASE HELP

Re: Regarding Best use of Virtual Lab time

Re: PROC SQL how to add 2 columns from 2 different tables

Re: Create multiple dataset from source dataset

Re: Create multiple dataset from source dataset

Re: Newbie here! Question about a proposal using SAS! :)

Re: What are the ranks for communities.sas.com and how many posts do y...

Re: PROC SQL - DROP statement in a join - Discrimination between t1 an...

Re: Word wrap in SAS Enterprise Guide Program Editor

Re: Newbie here! Question about a proposal using SAS! :)

Re: Splitting dataset dynamically using macro

Re: where is the documentation of " variabel in: ( .... )"?

Macro source code

Re: Add macro code available to the session

Re: Delete variables by label criteria

BASE SAS session reset

Re: Add macro code available to the session

Re: Add macro code available to the session

Add macro code available to the session

Re: SAS Enterprise guide is not connecting to Metadata server

Re: Missing Dollar Values Far Right Side

Re: Strange Warning Message When Accessing a Dataset Through Data Step

Re: SAS Enterprise guide is not connecting to Metadata server

Re: Filter on the basis of subcategories

Re: New columns dont show up in SCD Type 2 -> Detect Changes

Re: New columns dont show up in SCD Type 2 -> Detect Changes

SAS Community Nordic